Webhooks Payload Is Loaded Into a Single Column Instead of Multiple Columns

Issue

Webhook event data isn't unpacked into multiple columns. Instead, the entire raw payload appears in a single column.

Environment

Webhooks

Resolution

To resolve this issue, configure the source application to include the following HTTP header in every webhook request:

Content-Type: application/json

Cause

The issue occurs when the incoming HTTP request doesn't contain the Content-Type: application/json header. When this happens, we can't identify the payload as JSON and instead treat it as an unstructured string, loading it into a single column.