Happy Business Starts Here

Allow passing in the end time on the AQuA API job

Highlighted
Valued Scholar

Allow passing in the end time on the AQuA API job

We use the stateless mode of AQuA API and pass in incremental time.


We had a bug in our code so we had gaps in our previous end time and incremental(Start)Time of our next run so we didn't get data with updated dates in those time ranges. We fixed the bug, but how to get historical data via AQuA?

 

 We expected and wanted to pass in both an incremental(Start)Time and and endTime so we could get the necessary data. Please enhance the AQuA API to allow this. If we had this it would have been as simple as passing in incrementalTime and endTime 83 times (because we had 83 gaps) with the same json request we currently use. 

 

Instead, we had to write 83 queries for each of 30 caches (so 240 queries) that ended up looking like this:

 

"name": "Account-01",

"query": "select DefaultPaymentMethod.Id as DefaultPaymentMethodId, BillToContact.Id as BillToId, SoldToContact.Id as SoldToId, * from  Account where updatedDate >= '2020-07-15T12:22:40-00:00' and updatedDate <= '2020-07-15T12:23:00-00:00'",

 

"name": "Account-02",

"query": "select DefaultPaymentMethod.Id as DefaultPaymentMethodId, BillToContact.Id as BillToId, SoldToContact.Id as SoldToId, * from  Account where updatedDate >= '2020-07-16T10:22:40-00:00' and updatedDate <= '2020-07-16T10:23:00-00:00'",

 

etc....