Happy Business Starts Here

Highlighted
Zuora Alumni

[AQuA] Why does this query works with SOAP API but not AQuA?

Question:

 

I have a query that that queries the Account object. It works with SOAP API but the exact same query failed AQuA API. Why is that?

 

SOAP Query:

 

 

<API:QUERY>
   <API:QUERYSTRING>SELECT ID, BILLTOID FROM ACCOUNT</API:QUERYSTRING>
</API:QUERY>
{
   "FORMAT": "CSV",
   "VERSION": "1.1",
   "NAME": "XXXX",
   "ENCRYPTED": "NONE",
   "PARTNER": "XXXX",
   "PROJECT": "XXXX",
   "QUERIES": [
    {
       "NAME": "XXXYYY",
       "QUERY": "SELECT ID,BILLTOID FROM ACCOUNT",
       "TYPE": "ZOQLEXPORT",
       "APIVERSION": "59.0",
       "DELETED": {
       "COLUMN": "MYDELETED",
       "FORMAT": "NUMERIC"
        }
    }

  ]

}

AQuA Query:

 

 



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 Alumni

Re: [AQuA] Why does this query works with SOAP API but not AQuA?

Solution:

 

The reason why the SOAP call works but the AQuA doesn't, is that the Account object isn't the same between them. For the SOAP call, it is querying a SOAP API Account Object. When using the same query on AQuA, it is querying the Account Data Source. The Account Data Source for AQuA is a pre-joined object with additional fields such as Bill To contact and Sold To contact. Therefore, when querying AQuA with:

"select BillToId from Account" will fail
"select BillToContact.Id" will work

 

 

Supporting Reference:

 

SOAP Account Object: https://knowledgecenter.zuora.com/BC_Developers/SOAP_API/E1_SOAP_API_Object_Reference/Account

 

AQuA Account Data Source: https://knowledgecenter.zuora.com/CD_Reporting/Data_Exports/Z_Data_Source_Reference/Account_Data_Sou...



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