Pull products by category or sub_category

API Q&A
1

When pulling products using the REST API, I am getting “sub_category_id: 0” even though they do have a category and sub_category

This is an example

“products”: [
{
“id”: 95,
“sku”: “”,
“url”: “https://api.infusionsoft.com/crm/rest/v1/products/95”,
“status”: 1,
“sub_category_id”: 0,
“product_name”: “Savings Plan (not advertised)”,
“product_desc”: “”,
“product_price”: 35,
“product_short_desc”: “$35/month. Download Speeds: 3 Upload Speeds: 1 Suitable for basic internet functions such as social media, internet, and browsing”,
“subscription_only”: false,
“product_options”: ,
“subscription_plans”:
}
]

Any suggestions as to how to get the category/sub_category to show up?

3 Likes
2

I have the same problem. Can someone from Keap, reply?

3

It looks like this is still an issue almost 2 years later.
Is there going to be any action on this?
Do I have to continue using the legacy API just for this?

4

Hey Leo,

Thanks for bringing this to my attention. I have logged this as a bug and will get back to you with an ETA once our engineers have assessed the necessary fix.

1 Like
5

Quick update on this reported defect:

  • We currently have an engineer doing research on potential solutions for this. When I have more information or an ETA available I will make sure to update the thread again.
6

Thanks for starting the process @JustinGourley. Any progress on getting this?

7

The reason this field was returning all 0s is because it is deprecated and no longer actually being used within the DB. This is due to products now being able to belong to more than 1 category (a change made years ago).

The current immediate work around for this is to use the XmlRpc API and reference the ProductCategoryAssign table to find what categories a product belongs to.

Rather than make a breaking change to the v1 API and adjust the field type, or add a new field (adding to the confusion) I am going to be working alongside our e-com team to produce the Rest V2 product API endpoints. This work is still in its planning/design stages, so I do not have an ETA for release of the endpoints yet, but will make sure to update this thread once it is available.

1 Like