@Emmanuel Thank you! How do I query for it when I consider it as a single text? Meaning, Product-1: Make = "BMW,Lexus.Volkswagen,Ford,KIA" Product-2="BMW,Ford,Hyundai,Honda" I may want to find all the products that are applicable to BMW and Ford. In general, using SQL we can write a query like "select * from products where Make like '%BMW%Ford%' ". Q1. what is the best way to achieve this type of scenario's in Zuora? I think only leading or trailing % is allowed in Zuora. Q2. Using the API https://rest.apisandbox.zuora.com/v1/action/query we can retrieve the entire product catalog. Say, I want to retrieve the entire product catalog whose Make is 'BMW' or 'Ford' etc. How do I achieve this? Individually getting a product, product rate plan, rate plan charges and associated features is being a big headache. Thank You!
... View more