Overview
Zuora's applications automate billing, commerce, and finance operations.
Exporting documents
Tray's Zuora connector allows the creation of files from ZOQL queries. There are two steps to this process. Step 1 - Create an export request Use the Create Export operation to run a ZOQL query and generate a file. The connector will execute the query and will output an Export ID:
\{
"Success": true,
"Id": "2c92c0f8610dde85016122ed1cf810cd"
\}
Step 2 - Attempt to retrieve the export
The export can take some time. More complex queries will take longer for the export to run. Use the Attempt Export operation to send a request to retrieve the file that has been exported. You will need to provide the Export ID that was returned when you sent the Create Export request.
If the export has yet to complete you will get a playload like the one below. Note that the ready field is false. You can use a Boolean Connector to check whether the export has completed yet.
{
"ready": false,
"file": null,
"response_data": \{
"Zip": false,
"Encrypted": false,
"Query": "select * from RevenueScheduleItem",
"UpdatedDate": "2018-01-23T04:10:20.000-08:00",
"UpdatedById": "2c92c0xxxxxxxxxxxxxxe7d3f01482c",
"Status": "Processing",
"CreatedDate": "2018-01-23T04:10:20.000-08:00",
"Format": "csv",
"CreatedById": "2c92c0fxxxxxxxxxxxxx1e7d3f01482c",
"Id": "2c92c0fxxxxxxxxxxxxxxxxxed1cf810cd"
\}
}
Once the export has completed the ready field is set to true and a URL for downloading the file is returned:
{
"ready": true,
"file": \{
"name": "2c92c086610ddd8e016122ed25b35ad9.csv",
"url": "https://workflow-file-uploads.s3-us-west-2.amazonaws.com/3256fbc3-0a68-4xxx-xxxx-xxxxb3c5f0a1?Expires=1516795854&AWSAccessKeyId=AKIxxxxxxxxxxBQ&Signature=EhXxxxxxxxxxxxxxmcui%2BTvI0zyg%3D",
"mime_type": "text/csv",
"expires": 1516795854
\},
"response_data": \{
"Size": 422,
"Zip": false,
"Encrypted": false,
"Query": "select * from RevenueScheduleItem",
"UpdatedDate": "2018-01-23T04:10:22.000-08:00",
"UpdatedById": "2c92cxxxxxxxxxxxxx1e7d3f01482c",
"Status": "Completed",
"CreatedDate": "2018-01-23T04:10:20.000-08:00",
"Format": "csv",
"FileId": "2c92c0xxxxxxxxxxxx2ed25b35ad9",
"CreatedById": "2c92cxxxxxxxxxxxxxx11e7d3f01482c",
"Id": "2c92c0xxxxxxxxxxed1cf810cd"
\}
}
Step 3 - Process the file
Use another connector to process the saved file. If you have saved the file as a CSV you can use the CSV Connector to process the results.