🔦 Feature: Allow using values from has-many child tables in webhooks

[djmaze]

Please confirm if feature request does NOT exists already ?

• I confirm there is no existing issue for this

Describe the usecase for the feature

Sometimes you need data from a linked child table when a webhook is triggered. E.g. when you want to dynamically send an email to the user who is selected in a has-many field and the connected "user" table contains the email address.

(many-to-many connections could also be interesting, but not in my case.)

Suggested Solution

Just include all fields from all has-many fields in the webhook payload.

Currently, for a field name user we have the following in the payload:

"data": {
  "nc_tesc__user_id": 1
}

Instead, it should be (example):

"data": {
  "user": {
     "Id": 1,
     "name": "foo",
     "email": "foo@bar.com"
  }
}

Additional Context

No response

[dstala]

Webhook logs now has user field info & has-many fields (with display value)

{
  "type": "records.after.update",
  "id": "605cfc76-a3dd-4318-bf0f-9983671d0418",
  "data": {
    "table_id": "mvoj7d70chofbwc",
    "table_name": "Country",
    "previous_rows": [
      {
        "Id": 1,
        "Name": "bcd",
        "Notes": null,
        "Assignee": null,
        "Status": null,
        "Collaborator": null,
        "date": "2024-02-28",
        "Notes 2": null,
        "nc_order": 1,
        "Users": [
          {
            "id": "us7239k0m38q0jj6",
            "email": "ameesha@nocodb.com",
            "display_name": "Ameesha@Noco",
            "meta": null
          }
        ],
        "CreatedAt": "2025-02-04 10:55:58+00:00",
        "UpdatedAt": "2025-02-04 11:54:08+00:00",
        "City 5": [
          {
            "Id": 1,
            "Name": "London"
          },
          {
            "Id": 4,
            "Name": "Mumbai"
          },
          {
            "Id": 5,
            "Name": "Delhi"
          }
        ],
        "City": 0,
      }
    ],
    "rows": [
      {
        "Id": 1,
        "Name": "bcd",
        "Notes": null,
        "Assignee": null,
        "Status": null,
        "Collaborator": null,
        "date": "2024-02-28",
        "Notes 2": null,
        "nc_order": 1,
        "Users": [
          {
            "id": "us7239k0m38q0jj6",
            "email": "ameesha@nocodb.com",
            "display_name": "Ameesha@Noco",
            "meta": null
          },
          {
            "id": "usa4wdnfp97ogsfq",
            "email": "pranav@nocodb.com",
            "display_name": "Pranav C",
            "meta": null
          }
        ],
        "CreatedAt": "2025-02-04 10:55:58+00:00",
        "UpdatedAt": "2025-02-04 11:54:08+00:00",
        "City 5": [
          {
            "Id": 1,
            "Name": "London"
          },
          {
            "Id": 4,
            "Name": "Mumbai"
          },
          {
            "Id": 5,
            "Name": "Delhi"
          }
        ],
        "City": 0,
      }
    ]
  }
}