AnsweredAssumed Answered

From Boomi, using the Zuora connector, how can we filter on a null value? Zuora requires an unquoted null to be passed in the filter, but Boomi adds quotes.

Question asked by RajeevSingh5801 on Aug 11, 2013
Latest reply on Aug 22, 2013 by Adam Arrowsmith
     From Boomi, using the Zuora connector, how can we filter on a null value?  
      
     Zuora requires an unquoted null to be passed in the filter, but Zuora adds quotes.  Ie.
     Invoice.TransferredToAcccounting =’null’ (won’t work – not a valid value in the picklist)
     Invoice.TransferredToAccounting=’’ (won’t work – not a valid value in the picklist)
     Invoice.TransferredToAccounting=’No’ (Won’t work – not a valid value in the picklist)
     Invoice.TransferredToAccounting=null (will work)
      
     Specifically, this is an issue when we try to query Invoice.TransferredToAccount because the default value of ‘No’ is actually null on the record.  

Outcomes