Happy Business Starts Here

Zuora Support Moderator

Using AQuA stateful mode for more than one extract sessions

Question:

 

We'd like to use a number of separate queries in stateful mode, but if we keep changing the objects (e.g. first extract on Account, second extract on Invoice object), it keeps resetting the session, and executes full extracts instead of delta extracts. How do we keep separate extract sessions?



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
Zuora Support Moderator

Re: Using AQuA stateful mode for more than one extract sessions

Answer:

 

A session is identified by the ProjectId and the PartnerId, these are the unique session identifier together. Since ProjectId is basically free text, all we need to do is pick separate ProjectIds for the individual queries, so each can have their own sessions.

 

Examples for two separate sessions using the same PartnerId, note the different ProjectId:

 

 

{
"format" : "csv",
"version" : "1.1",
"name" : "Example",
"encrypted" : "none",
"useQueryLabels" : "true",
"partner" : "viktortest",
"project" : "AccountSession",
"dateTimeUtc" : "true",
"queries" : [ {
"name" : "Account",
"query" : "select Id,name from account",
"type" : "zoqlexport"
}]
}

{
"format" : "csv",
"version" : "1.1",
"name" : "Example",
"encrypted" : "none",
"useQueryLabels" : "true",
"partner" : "viktortest",
"project" : "InvoiceSession",
"dateTimeUtc" : "true",
"queries" : [ {
"name" : "Invoice",
"query" : "select Id,invoicenumber from invoice",
"type" : "zoqlexport"
}]
}

 

Supporting references:

https://knowledgecenter.zuora.com/DC_Developers/T_Aggregate_Query_API/BA_Stateless_and_Stateful_Mode...



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