Unable to use table data sent to Go High Level - or actually reference it in the payload. can we edit payload format in baserow?

Are you using our SaaS platform (Baserow.io) or self-hosting Baserow?

Self-hosted

If you are self-hosting, what version of Baserow are you running?

Self hosting - Version 1.30.1

If you are self-hosting, which installation method do you use to run Baserow?

Hosting on Coolify, which is docker based.
Coolify Version v4.0.0-beta.373

What are the exact steps to reproduce this issue?

Video Explaining Issue: Automate My Practice - 23 January 2025 | Loom

My Goal is update a contact field in Go High Level with the baserow location data
(Database_id Table_id Row_id) so i can keep the two systems in sync.

I am trying to send a webhook to Go High Level if any field changes in baserow.

Webhook is setup to trigger with any field change.
Webhook gets triggered.
However in the payload, the only fields that I can reference are:

{
“table_id”: 608,
“database_id”: 132,
“workspace_id”: 112,
“event_id”: "f29c8e42-8d0b-4e4e-9874-0b20b42953

I dont understand how i can actually use the field data sent through, even though its coming through in the payload, GHL cannot reference it (its showing up as red instead of green)

So must i edit how the payload data is sent?

Thanks for any advice.
I included a video above and screenshot referencing my issue.

Attach screenshots, videos, or logs that demonstrate the issue.

Hi @dev,

I’m sorry to hear the webhooks are not working for you with Go High Level.

I’m not familiar with that tool, so I might be missing something, but from a quick look at their documentation, it seems like you can’t really use values inside an array. Unfortunately, we don’t currently have an option to change that in Baserow, so I’m not sure what to suggest here.

@frederikdc is our expert in this field, do you maybe have any advice here?

What i mentioned above would be my preferred method of doing this ^^ but as a secondary option, would it be possible to send the webhook to N8N first, then change the data structure so high level can reference it?

So i see that its possible to send headers with keys. I was hoping i could reference the variables and just put them in the headers + value. but i dont know how to format them to achieve this.

Header = id
Value = {{id}}

Header = email
Value = {{email}} or {{field_5678}}

something like that? how can i reference the values or fields like this?

would it be possible to send the webhook to N8N first, then change the data structure so high level can reference it?

Yes I think you should be able to use N8N to adjust the data in the format you want.

I was hoping i could reference the variables and just put them in the headers + value

Unfortunately those are static headers at the moment, we cannot create references to other values in there.

The only option I see here is indeed using a tool like n8n that receives the original webhook from baserow, maps the items array into individual objects and sends that payload to the HighLevel platform