Happy Business Starts Here

Highlighted
Zuora Staff

How to query Category field under Product object?

Problem Statement: In our Product Catalog, we set values for Category (e.g. Base Products, Add On Services, Miscellaneous Products) but when attempting to query it via API, it always returns DefaultCatalog as its value, how can I get the value we set?



If you found my answer helpful, please give me a kudo ↑
Help others find answers faster by accepting my post as a solution √

1 REPLY 1
Zuora Staff

Re: How to query Category field under Product object?

Solution: this is currently a known issue please refer to SUB-4149 article. Ideally, we would refactor our Product Catalog to address this issue, in the meantime here's a workaround you can consider:

 

Use a Custom field that will 'act' as ProductCategory and when this field is set with value and queried, it should return the expected value. Additionally, this custom field will be exposed in Data Source Export or Export ZOQL.


Supporting Reference(s):

 

http://knowledgecenter.zuora.com/BC_Developers/SOAP_API/E1_SOAP_API_Object_Reference/Product#Field_D...

 

Known Issues



If you found my answer helpful, please give me a kudo ↑
Help others find answers faster by accepting my post as a solution √