Hubdb RESTful API - filter by "path"

Developer Support APIs & Integrations
1

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
ABlore_0-1681209822229.png1448×195 19.4 KB

…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

2

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

3

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