Default HubSpot HubDB Columns for Dynamic Table

[cives]

Hi there, i'm having an issue with a HubDB table. In the table settings i've enabled API access & dynamic page creation. Through my API, I am able to update every column except for the standard ones; page path (hs_path) and page title (hs_name).

Request: {"values": {"member_name": "5 Star Towing LLC","hs_path": "5-Star-Towing-LLC"...

The error response I get back is

"status": "error", "message": "No such column with name or id `hs_path` in table `120089663` for row `0`",

I know I am using the correct field names, and the settings are enabled correctly. I even requested all of the table fields using a V3 script and hs_path and hs_name do not show that way either.

Any guidance? Thanks in advance!

[Tariqqq]

---

@cives wrote:

Hi there, i'm having an issue with a HubDB table. In the table settings i've enabled API access & dynamic page creation. Through my API, I am able to update every dentist column except for the standard ones; page path (hs_path) and page title (hs_name).

Request: {"values": {"member_name": "5 Star Towing LLC","hs_path": "5-Star-Towing-LLC"...

The error response I get back is

"status": "error", "message": "No such column with name or id `hs_path` in table `120089663` for row `0`",

I know I am using the correct field names, and the settings are enabled correctly. I even requested all of the table fields using a V3 script and hs_path and hs_name do not show that way either.

Any guidance? Thanks in advance!

---

It's likely because the dynamic page creation feature hasn't been fully enabled. Even if you've turned on API access, these special columns only appear when the "Enable creation of dynamic pages using row data" option is selected in the table settings. To fix this, go to your HubDB table in the HubSpot portal, open the Actions menu, and select Manage Settings. There, make sure the dynamic page creation feature is enabled and save the settings. Once this is done, the hs_path and hs_name columns should be automatically added to the table schema. You can confirm this by exporting the table or checking the schema using the HubDB API. After that, you should be able to update these fields via the API using their correct names.

[kosalaindrasiri · Accepted solution]

Hey @cives,

It fails with "No such column", because hs_path isn’t a user-defined column. It’s derived from the row slug and internal system mappings.

Set path and name via dynamic_page_data: When creating or updating a row for a dynamic page, you need to define,

"dynamic_page_data": {
  "page_path": "5-star-towing-llc",
  "page_title": "5 Star Towing LLC"
}

https://developers.hubspot.com/docs/guides/api/cms/hubdb 

Regards,

Kosala

[cives]

@kosalaindrasiri this did clear the error out, however the path and title columns are still not being updated. We are not updating rows, the table contents is emptied and then added back in nightly.

Based on the below, am I missing anything?

Request: {
  "values": {
    "member_name": "Sample Auto Repair LLC",
    "address": "123 Main Street",
    "city": "Sampletown",
    "state": "ST",
    "zip": "12345",
    "phone_number": "555-123-4567",
    "primary_contact_name": "John Doe",
    "primary_contact_email": "johndoe@example.com",
    "staff_count": 10,
    "member_type": [
      {
        "name": "Non-Franchised",
        "type": "option"
      }
    ],
    "manufacturers": [],
    "member_category": [
      {
        "name": "Repair Shop",
        "type": "option"
      }
    ],
    "services": [
      {
        "name": "Inspection Station",
        "type": "option"
      },
      {
        "name": "Used Car",
        "type": "option"
      },
      {
        "name": "Repair Shop",
        "type": "option"
      }
    ],
    "join_date": 1359676800000,
    "geo": {
      "type": "location",
      "lat": 40.0000000,
      "long": -75.0000000
    },
    "web_url": "sampleautorepair.com",
    "uh_id": 123
  },
  "dynamic_page_data": {
    "page_path": "sample-auto-repair-llc",
    "page_name": "sample-auto-repair-llc"
  }
}