Using Splat Operator in Clay for API Payload Columns

·

Is there the equivalent of a splat operator in Clay? Use-case: you get an API payload and you want to automatically write out every field in the payload as a new column in Clay (no manual selecting items "add as column"). Is it possible to do in the same table vs having to write to a new table?

1 comment

Channeled
APP
·
·
While we don't have a direct equivalent to a splat operator, we do have a feature called "write to table" that can help you achieve a similar result. When using an HTTP API integration, you can select which parts of the API response you want to add as columns to your table. Here's how you can do this: 1. Set up your HTTP API integration. 2. In the "Define field paths to return" step, you can specify which parts of the API response you want to retrieve. 3. Then, in the "Choose data to add as columns to table" step, you can select which data from the enrichment you'd like to add as columns. Keep in mind that there's a limit of 70 columns per table, with up to 30 (or 40 with a waterfall) being action or integration columns. If you need more columns, you might need to write to a new table.
Sources: Table columns | Documentation | Clay University HTTP API integration overview | Documentation | Clay University Write to Other Table | Documentation | Clay University