Knowledge Center

Knowledge Center > API > Aggregate Query API (AQuA) > Get Results Files

Get Results Files

This REST API retrieves the results in the specified file format. The AQuA results files are purged after 7 days.

Request

Environment Request
API Sandbox (US Data Center) GET https://apisandbox.zuora.com/apps/api/file/{fileId}
Production (US Data Center) GET https://www.zuora.com/apps/api/file/{fileId}
API Sandbox (EU Data Center) GET https://rest.sandbox.eu.zuora.com/v1/file/{fileId}
Production (EU Data Center) GET https://rest.eu.zuora.com/v1/file/{fileId}

Sample File Download

CSV Output File:

Accounting Period: ID,Accounting Period: Start Date,Accounting Period: 
End Date,Accounting Period: Fiscal Year,Accounting Period: Name,Accounting Period: Status
2c9082e8468d10b501468d93dc6301c0,03/01/2013,03/31/2013,2013,new3,Open
2c9082e8468d29a401468d2ab9150212,04/01/2013,,0,Open-Ended,Open

Curl Example

Curl request:

echo 
echo "============= Aqua File Download ===========" 
echo curl -i -k -u $USER_NAME:$PASSWORD -H "Accept:application/json" -X GET $BASE_URL/api/file/$FILEID

Sample file download:

Deleted,Account.Id,Account.CreditBalance,Account.Name,Account.Balance,Account.TaxExemptStatus,
Account.AutoPay,Account.Currency,Account.PaymentGateway,Account.PaymentTerm,Account.SalesRepName,
Account.TaxExemptIssuingJurisdiction,Account.TaxExemptEffectiveDate,Account.TaxExemptExpirationDate,
Account.TaxExemptCertificateType,Account.LastInvoiceDate,Account.Status,Account.TotalInvoiceBalance,
Account.CreatedDate,Account.UpdatedDate,Account.ParentId,Account.CustomerServiceRepName,BillToContact.Id,
SoldToContact.Id false,402881824835bb2a014835bf548801d5,0,REST-Test-1409651004494,0,,true,USD,,
Net 30,,,,,,09/01/2014,Active,0,09/02/2014,09/02/2014,,,402881824835bb2a014835bf548a01d6,
402881824835bb2a014835bf548d01d7 false,402881824835bb2a014835bf586201f6,0,REST-Test-1409651005494,0,,
true,USD,,Net 30,,,,,,09/01/2014,Active,0,09/02/2014,09/02/2014,,,402881824835bb2a014835bf586401f7,
402881824835bb2a014835bf586701f8 false,402881824835bb2a014835bf5c4a0217,0,REST-Test-1409651006497,0,,
true,USD,,Net 30,,,,,,09/01/2014,Active,0,09/02/2014,09/02/2014,,,402881824835bb2a014835bf5c4c0218,
402881824835bb2a014835bf5c4f0219

Last modified
19:03, 2 Aug 2017

Tags

Classifications

(not set)