Happy Business Starts Here

Zuora Staff

[AQUA] Existing AQuA Query Failure


Problem Statement: The exact same query that was used in the AQuA call works perfectly fine in a standard call. This used to work and stopped working suddenly, do you have any insights?

Solution: The reason the query failed is because one of the fields used in it has been deprecated in the new WSDL.

 

  • Option 1: By specify the API version, the call will always work
{
  "FORMAT": "CSV",
  "VERSION": "1.2",
  "NAME": "TEST",
  "PARTNER": "TEST-SBX",
  "PROJECT": "CHEESBURGER",
  "QUERIES": [
    {
      "APIVERSION": "72.0",
      "NAME": "AMENDMENT",
      "QUERY": "SELECT ID,AUTORENEW,CODE,CONTRACTEFFECTIVEDATE,CREATEDBYID,CREATEDDATE,CUSTOMERACCEPTANCEDATE,DESCRIPTION,EFFECTIVEDATE,INITIALTERM,NAME,RENEWALTERM,SERVICEACTIVATIONDATE,STATUS,SUBSCRIPTIONID,TERMSTARTDATE,TERMTYPE,TYPE,UPDATEDBYID,UPDATEDDATE FROM AMENDMENT",
      "TYPE": "ZOQL",
      "DELETED": {
        "COLUMN": "DELETED",
        "FORMAT": "NUMERIC"
      }
    }
  ]
}

 

  • Option 2: Refer to the Knowledge Center article below for list of deprecated fields:



Supporting Documentation: https://knowledgecenter.zuora.com/BC_Developers/SOAP_API/X_Deprecated_SOAP_API_items



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

Tags (3)