Happy Business Starts Here

Highlighted
Support SME

Re: How to export the deleted data using AQuA API?

Zuora stores this result as a csv file and can be downloaded programmatically using this API https://www.zuora.com/developer/api-reference/#operation/GET_Files

AQuA result csv files older than 72 hours are automatically purged from the system. https://knowledgecenter.zuora.com/Central_Platform/API/AB_Aggregate_Query_API/BE_AQuA_Job_Finder

Highlighted
Honor Student

Re: How to export the deleted data using AQuA API?

Thanks Yong. Is there a way to get the results in Json or XML format? I see that the ZoqlExport gives back data in CSV format only.

Highlighted
Support SME

Re: How to export the deleted data using AQuA API?

I'm afraid both AQuA and Data Query are async, so you can only get the result in csv format based on the current design. The sync query can get the result in json, but it doesn't support export deleted records. https://www.zuora.com/developer/api-reference/#operation/Action_POSTquery