# Pull products by category or sub\_category
**URL:** https://integration.keap.com/t/pull-products-by-category-or-sub-category/73301
**Category:** API Q&A
**Created:** [December 5, 2019, 8:32pm UTC](https://integration.keap.com/t/pull-products-by-category-or-sub-category/73301 "2019-12-05T20:32:58Z")
**Posts on this page:** 7
**Page:** 1
### Author:  [@Marcos\_Centeno](https://integration.keap.com/u/Marcos_Centeno)
#### Post date: [December 5, 2019, 8:32pm UTC](https://integration.keap.com/t/pull-products-by-category-or-sub-category/73301/1 "2019-12-05T20:32:58Z")
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](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?
---
### Author:  [@Leopoldo\_Mojal\_IV](https://integration.keap.com/u/Leopoldo_Mojal_IV)
#### Post date: [December 16, 2020, 2:10am UTC](https://integration.keap.com/t/pull-products-by-category-or-sub-category/73301/2 "2020-12-16T02:10:12Z")
> [@Marcos\_Centeno](#):
>
> ions as to how to get the category/sub\_category to show up?
I have the same problem. Can someone from Keap, reply?
---
### Author:  [@Leo\_Lutz](https://integration.keap.com/u/Leo_Lutz)
#### Post date: [November 12, 2021, 8:19am UTC](https://integration.keap.com/t/pull-products-by-category-or-sub-category/73301/3 "2021-11-12T08:19:22Z")
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?
---
### Author:  [@JustinGourley](https://integration.keap.com/u/JustinGourley)
#### Post date: [November 12, 2021, 7:29pm UTC](https://integration.keap.com/t/pull-products-by-category-or-sub-category/73301/4 "2021-11-12T19:29:59Z")
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.
---
### Author:  [@JustinGourley](https://integration.keap.com/u/JustinGourley)
#### Post date: [November 19, 2021, 12:55am UTC](https://integration.keap.com/t/pull-products-by-category-or-sub-category/73301/5 "2021-11-19T00:55:37Z")
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.
---
### Author:  [@Leo\_Lutz](https://integration.keap.com/u/Leo_Lutz)
#### Post date: [January 19, 2022, 11:49pm UTC](https://integration.keap.com/t/pull-products-by-category-or-sub-category/73301/6 "2022-01-19T23:49:23Z")
Thanks for starting the process @JustinGourley. Any progress on getting this?
---
### Author:  [@JustinGourley](https://integration.keap.com/u/JustinGourley)
#### Post date: [January 20, 2022, 4:04pm UTC](https://integration.keap.com/t/pull-products-by-category-or-sub-category/73301/7 "2022-01-20T16:04:48Z")
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.