I have looked through the Keap API documentation, but I couldn’t find a clear example or endpoint for fetching product categories. Can someone guide me on the correct API endpoint or method to retrieve product categories programmatically?
Try this:
XML
https://developer.keap.com/docs/xml-rpc/#data-query-a-data-table
https://developer.infusionsoft.com/docs/table-schema/#
I’d test it as:
XML Query a data table ProductCategory, with queryData set to ‘~>~0’ against the Id
<?xml version='1.0' encoding='UTF-8'?>
<methodCall>
<methodName>DataService.query</methodName>
<params>
<param>
<value><string>APIKEY HERE</string></value>
</param>
<param>
<value><string>ProductCategory</string></value>
</param>
<param>
<value><int>5</int></value>
</param>
<param>
<value><int>0</int></value>
</param>
<param>
<value><struct>
<member><name>Id</name>
<value><string>'~>~0'</string></value>
</member>
</struct></value>
</param>
<param>
<value><array>
<data>
<value><string>Id</string></value>
<value><string>CategoryDisplayName</string></value>
</data>
</array></value>
</param>
<param>
<value><string>Id</string></value>
</param>
<param>
<value><boolean>0</boolean></value>
</param>
</params>
</methodCall>```
1 Like
Thank you Jeff for your quick response,i want to get this product category and use it to filter products based on this. can you check screenshot attached
Use the script provided, you should be able to do that.
Thanks,
Jeff
Is it feasible to do that by using the Rest V1 API instead of the script above?
Hi @Archit_Arolkar,
The answer to your question is that only the XML-RPC API has support for this table.
You can download the Infusionsoft PHP SDK which will make it easier for you.
GitHub - infusionsoft/infusionsoft-php: PHP client library for the Infusionsoft API.
For your reference, REST V1 is no longer been updated, so you will not see it there.
REST V2 is still in development, although it will more likely be completed by the year 2030.