Happy Business Starts Here

Highlighted
Support SME

How to use incrementalTime parameter to correctly fetch data via AQuA

Use case: Client created an amendment on 3/12/2017 5:35:00 AM EDT, but the incremental sync they run 30 minutes after failed to capture it.

 

Sample AQuA batch query:

 

POST https://www.zuora.com/apps/api/batch-query/

"format":"CSV",
"version":"1.2",
"project": "Incremental Test",
"partner": "xxx",
"encrypted":"none",
"incrementalTime": "2017-03-12 3:35:00",
"queries":
[
{ "name":"Subscription",
 "query": "select Id, RenewalTerm, ServiceActivationDate, Status, SubscriptionEndDate, SubscriptionStartDate, PreviousSubscriptionId from Subscription", 
"type":"zoqlexport",

"deleted": {
"column": "deleted",
"format": "Numeric"
}
}
]
}

 






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

1 REPLY 1
Support SME

Re: How to use incrementalTime parameter to correctly fetch data via AQuA

 

 Resolution: The incrementalTime parameter does not support timezone conversion, it's currently handled in Pacific time. For the query to work, make sure to convert the incrementalTime value to Pacific time in the AQuA requests. 

 


Referenced article: https://knowledgecenter.zuora.com/DC_Developers/T_Aggregate_Query_API/B_Submit_Query/e_Post_Query_wi...






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