Premature end of file error using Zuora connector to extract data from Zuora system.

Document created by Nikita_nandakumar on May 27, 2015Last modified by vreddy on Mar 1, 2016
Version 2Show Document
  • View in full screen mode
A scenario where the customer is using the Execute operation to get the data from Zuora using Export ZOQL.They are  trying to define a criteria in the where clause,but  Boomi returns an error message stating 'Premature end of file'.
The error is caused by the where clause used in the Zuora operation. Please check and verify if the syntax of the  where clause is defined correctly per the links below :

 

Zuora Object Query Language (ZOQL) :
https://knowledgecenter.zuora.com/BC_Developers/SOAP_API/M_Zuora_Object_Query_Language

 

Export ZOQL Select Statements :
https://knowledgecenter.zuora.com/BC_Developers/SOAP_API/M_Zuora_Object_Query_Language/Export_ZOQL/A_Select_Statement

 

Export ZOQL Filter Statements :
https://knowledgecenter.zuora.com/BC_Developers/SOAP_API/M_Zuora_Object_Query_Language/Export_ZOQL/F_Filter_Statements

 

A list of pre-joined Objects that Zuora supports is detailed in the link below :
https://knowledgecenter.zuora.com/BC_Developers/SOAP_API/M_Zuora_Object_Query_Language/Export_ZOQL

 

For instance,

 

For the following where clause,

 

RatePlanCharge.Id != '${Id}'

 

Please note that you would need to define an element in the request profile to match with the Id element in the where clause.
1 person found this helpful

Attachments

    Outcomes