Home

Clay Announcements
Clay Support
Discuss Anything
Feedback & Requests
GTM Career Advice
Introduce Yourself
Member Spotlight
Share Content and Events
Share Full-time Jobs
Share Part Time Jobs
Share Tables, Tools, and Workflows

Community Guidelines

Explore Events
Learn Clay here
Clay Cup

Powered by Tightknit

Using Splat Operator in Clay for API Payload Columns | Clay

Using Splat Operator in Clay for API Payload Columns

·May 16, 2025 11:17 PM·

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

· Sorted by Oldest

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