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) :


Export ZOQL Select Statements :


Export ZOQL Filter Statements :


A list of pre-joined Objects that Zuora supports is detailed in the link below :


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