Happy Business Starts Here

is there any possibility to pass the in condition in Aqua API

Highlighted
New Student

is there any possibility to pass the in condition in Aqua API

 

Hi Team,

 

As part of our requirement we need to get multiple subscriptions from the subscription table using Aqua API. Is there any option to pass multiple subscription ids  as an input and get the subscription info for that subscription ids, 

 

Typically we can achieve that using   IN  operation  in normal sql. Trying to find some  function to achieve  that   or any other alternate web services to achieve our functionality

 

Thanks,

Bapiraju K

1 REPLY 1
Highlighted
Zuora Staff

Re: is there any possibility to pass the in condition in Aqua API

There is no 'in' operator in Export ZOQL but it does support an 'or' operator, so you could go something like:

select id, name

from subscription

where id = 'abc123' or id = 'abc124' or id = 'abd125'

 

Definitely not as clean as the 'in' but hopefully get the job done.

More details here:

https://knowledgecenter.zuora.com/DC_Developers/SOAP_API/M_Zuora_Object_Query_Language/Export_ZOQL/F...