Happy Business Starts Here

Support SME

Why do I get INVALID_VALUE error when making CRUD: Create Export call?

Why do I get INVALID_VALUE error when making CRUD: Create Export call?

Sample request: 

Request:
POST https://rest.apisandbox.zuora.com/v1/object/export
Body:
{
 "Format": "csv",
 "Name": "test_Export",
 "Query": "SELECT CreditTaxationItem.Name, CreditTaxationItem.Jurisdiction, CreditTaxationItem.TaxRate, CreditTaxationItem.TaxRateType, CreditTaxationItem.TaxDate, CreditTaxationItem.TaxRateDescription, CreditTaxationItem.RefundAmount, CreditTaxationItem.Id, CreditMemoItem.Id, CreditMemo.Id FROM CreditTaxationItem WHERE CreditMemo.Balance = 0 AND CreditMemo.Status = 'Posted'"
}

Response:

{
    "Errors": [

        {

            "Code": "INVALID_VALUE",

            "Message": "You cannot use all of these objects in the same query: Account, CreditMemoItem, CreditMemo, CreditTaxationItem."

        }

    ],

    "Success": false

}

1 REPLY 1
Support SME

Re: Why do I get INVALID_VALUE error when making CRUD: Create Export call?

Some fields can only be used in a specific wsdl version. The full list can be found in https://knowledgecenter.zuora.com/DC_Developers/G_SOAP_API/Zuora_SOAP_API_Version_History

You will need to include X-Zuora-WSDL-Version in the header. It looks like: 

Pasted_Image_2019_5_15__10_23_AM.png

 

Reference: https://knowledgecenter.zuora.com/DC_Developers/BB_Export_ZOQL

https://www.zuora.com/developer/api-reference/#operation/Object_POSTExport