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!

[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"
  }
}

[kosalaindrasiri]

Hey @cives,

Even if your API logic is perfect, HubSpot won’t add or recognize hs_path/hs_name unless the dynamic page feature is turned on inside the HubDB table settings.

Please refer Dynamic Pages Using HubDB doc and enable the dynamic page feature on HubDB.

Once that setting is switched on, everything should work as expected.

Hope this helps!

[cives]

I do have the dynamic feature enabled. See screenshot. Will not specifying metadata cause an issue?

[kosalaindrasiri]

Mmm @cives 🤔,

Your table settings are correct, no need to set the metadata fields unless you want additional SEO control. 

And honestly, based on everything you've shared, your setup looks correct.

Try a simple one-row test with a unique page_path and verify it shows up using the GET rows endpoint. That’ll narrow it down fast.

👉 I’d recommend reaching out directly to HubSpot Support with your table ID and example API payload. They can check logs on their side and confirm if something’s silently failing.

Sorry I couldn’t be more help here, but I realy hope you get it sorted quickly. Please loop back if you find anything interesting, always happy to learn and help where I can 😊

Regards,