Happy Business Starts Here

Highlighted
Valued Scholar

SOAP API 500 Error

Hello,

 

We are trying to make an SOAP API call with below reqest, and Zuora is returning an 500 error with out any details. Is there a way we can check, whats wrong with the request or why the call failed ?

 

*Session token has been replaced in the below request.

 

<?xml version="1.0" encoding="UTF-8"?><soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ns1="http://object.api.zuora.com/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ns0="http://api.zuora.com/"><soapenv:Header> <ns0Smiley FrustratedessionHeader><ns0:session> ****************Session**Token********</ns0:session> </ns0Smiley FrustratedessionHeader> </soapenv:Header> <soapenv:Body><ns0:create xmlns:ns0="http://api.zuora.com/"><ns0:zObjects xsi:type="ns1:Export" xmlns:ns1="http://object.api.zuora.com/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"><ns1:Format xmlns:ns1="http://object.api.zuora.com/">html</ns1:Format><ns1:Name xmlns:ns1="http://object.api.zuora.com/">BILLRUN</ns1:Name><ns1:Query xmlns:ns1="http://object.api.zuora.com/">select Invoice.InvoiceNumber,Account.AccountNumber,account.name,InvoiceItem.AccountingCode,Invoiceitem.UOM,InvoiceItem.ChargeAmount,Invoiceitem.Unitprice,InvoiceItem.Id,InvoiceItem.ChargeName,InvoiceItem.ChargeDate,Invoiceitem.Quantity,Account.SAP_Customer_Number__C,Account.BusinessUnit__c,Account.Currency,InvoiceItem.TaxAmount,invoiceitem.taxcode,SoldToContact.Country,SoldToContact.Address1,SoldToContact.Address2,SoldToContact.PostalCode,soldtocontact.city,soldtocontact.state,Invoice.InvoiceDate,Invoice.Status,Invoice.DueDate,Invoice.Amount,invoice.id,invoice.sourceid,invoice.source,BillToContact.Address1,BillToContact.Address2,BillToContact.Country,BillToContact.PostalCode,BillToContact.State, product.SKU from invoiceitem where invoice.sourceid =&apos;BR-00000645&apos;</ns1:Query><ns1:Zip xmlns:ns1="http://object.api.zuora.com/">false</ns1:Zip></ns0:zObjects></ns0:create></soapenv:Body> </soapenv:Envelope>

8 REPLIES 8
Zuora Alumni

Re: SOAP API 500 Error

Hi!, Typically this would mean a timeout, are you querying a large amount of data?



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

Valued Scholar

Re: SOAP API 500 Error

Hi RogerC,

 

Thank you for the reply, but this query has only little data and the same query works from an another system.

 

We are reimplementing this in a new system and have the issue in the New system, but works in the old system.

 

Regards,

Pranay

Zuora Alumni

Re: SOAP API 500 Error

Thank you, I checked with our API expert and he thinks it may be caused by SOAP syntax error as you said query seems fine.



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

Valued Scholar

Re: SOAP API 500 Error

Thank you Roger, Can we know whats wrong with the SOAP Format as both the calls look same from old and new systems.

Zuora Alumni

Re: SOAP API 500 Error

let me have an API specialist take a look and update you.



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

Zuora Alumni

Re: SOAP API 500 Error

can you attach the query as a text file?

 

thanks!



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

Zuora Alumni

Re: SOAP API 500 Error

also, in a private message, please send me your tenant id, the endpoint, and the verbose HTTP request and response headers

 

thanks again!



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

Valued Scholar

Re: SOAP API 500 Error

Hi Adam,

 

We have been working on different solutions and got back to this a bit late, I have sent you the details as Private Message.

 

URL - https://apisandbox.zuora.com/apps/services/a/55.0

 

 

We see the failures in below timeframe.

 

Date

Time

16/10/2017

 11:30:36 PM

16/10/2017

 04:00:33 AM

16/10/2017

 11:00:44 PM

17/10/2017

 07:00:22 AM

17/10/2017

 10:00:36 PM

18/10/2017

 04:00:46 AM

19/10/2017

 09:00:12 PM

19/10/2017

 07:01:00 AM

20/10/2017

 10:00:29 PM

21/10/2017

 07:00:30 AM

21/10/2017

 04:00:28 AM

21/10/2017

 09:30:05 PM