# Hubdb RESTful API - filter by "path"

**URL:** <https://community.hubspot.com/t/hubdb-restful-api-filter-by-path/79053>\
**Category:** APIs & Integrations\
**Tags:** developer-tools\
**Created:** [April 11, 2023, 10:51am UTC](https://community.hubspot.com/t/hubdb-restful-api-filter-by-path/79053 "2023-04-11T10:51:54Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![ABlore](https://avatars.discourse-cdn.com/v4/letter/a/5f8ce5/32.png) [@ABlore](https://community.hubspot.com/u/ABlore)\
**Post date:** [April 11, 2023, 10:51am UTC](https://community.hubspot.com/t/hubdb-restful-api-filter-by-path/79053/1 "2023-04-11T10:51:54Z")

</div>

I am trying to integrate an internal system to Hubspot and the link between the two system is the PATH property in Hubdb.  
I have an established Hubdb table with lots of rows, and the PATH contains a GUID. Using the RESTful API to query this table, I can filter by any columns that have been added by our system admin…  
e.g. this Hubdb row…

 ![ABlore_0-1681209822229.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/c/a/ca533a99864a0f865ae1166542385cf9b92ffc93.png)

…I sucessfully retrieve in POSTMAN with a GET request to…  
{{BaseUrl}}/cms/v3/hubdb/tables/xxx/rows? **company\_name\_\_eq=Marshall**

However, if I try to retrieve the same record using the **path** column…  
{{BaseUrl}}/cms/v3/hubdb/tables/xxx/rows? **path\_\_eq=0d5df56198604491b78c001076891e86**  
…I get the error…

{

“status”: “error”,

“message”: “error when listing rows for table xxx for portal yyy: **Invalid filter column ‘path’**.”,

“correlationId”: “…”

}  
I know how to find it by HubSpot id, but that is of no use in this integration. Does anyone know how to filter by the **path** column using the RESTful API?  
Thank you

---

<div class="post-metadata">

**Author:** ![andreaska](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/andreaska/32/198312_2.png) [@andreaska](https://community.hubspot.com/u/andreaska)\
**Post date:** [April 11, 2023, 1:11pm UTC](https://community.hubspot.com/t/hubdb-restful-api-filter-by-path/79053/2 "2023-04-11T13:11:22Z")

</div>

Hi,

to filter/search via the page path attribute, you need to use the attribute name hs\_path. In your case, something like that:

`{{BaseUrl}}/cms/v3/hubdb/tables/{tableId}/rows?hs_path__eq=0d5df56198604491b78c001076891e86`

Cheers,

Andreas

---

<div class="post-metadata">

**Author:** ![ABlore](https://avatars.discourse-cdn.com/v4/letter/a/5f8ce5/32.png) [@ABlore](https://community.hubspot.com/u/ABlore)\
**Post date:** [April 11, 2023, 1:16pm UTC](https://community.hubspot.com/t/hubdb-restful-api-filter-by-path/79053/3 "2023-04-11T13:16:25Z")

</div>

Thank you for your quick response Andreas. Perfect, it works.