Happy Business Starts Here

How to use incrementalTime parameter to correctly fetch data via AQuA

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 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
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 √

View solution in original post

2 REPLIES 2
Highlighted
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 √

View solution in original post

Highlighted
Advanced Tutor

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

Except when you are on AWS, in that case it wants UTC vs. Pacific time. Our Dev and Training environments are NOT on AWS so we pass pacific time, our QA and Production Zuora environments ARE on AWS so we have to pass UTC.

 

We have a config flag with tells our code to convert to pacific if necessary (true in our dev/trn environments) as we store the last successful run time in UTC, which we use on the next AQuA job run and pass in as the incrementalTime.