Happy Business Starts Here

How do you pass the result of a query to the next workflow step?

AlanH
Zuora Support

How do you pass the result of a query to the next workflow step?

Question :

How do you pass the result of a query to the next workflow step?


Answer :
Here is a sample workflow :

wf.png

First is an Export step that is retrieving subscription and account information.


The Export returns the columns :
Account.Id, Account.Name, Account.AccountNumber, Subscription.Id, Subscription.Name, Subscription.ContractEffectiveDate

The results of that Export go through an iterate step, which causes each row of the results to fire a callout. The callout is an api call to our system to generate an invoice for that particular subscription.
In the Callout step I specify the Liquid variables as {{Data.[column header]}}
For instance, the API endpoint I specify as :
https://rest.apisandbox.zuora.com/v1/accounts/{{Data.Account.Id}}/billing-documents/generate
The API body is :

api body.png

Here is the callout result :

WF request.png





If you found my answer helpful, please give me a kudo ↑
Help others find answers faster by accepting my post as a solution √