Configuring Supabase API for Row-by-Row Data Import into Clay

Hey trying to import rows directly using http API from supabase into clay to create and update live information. Its trying to pull the whole table into a cell which i understand but how if possible can it be configured to bring in the data row by row?

1 comment

Channeled
APP
·
·
To import and update data row by row from Supabase using Clay's HTTP API integration, you'll need to configure your API request carefully. Here's how: 1. Set up an HTTP API integration column in Clay. 2. Use a GET request to fetch data from Supabase. 3. In the API endpoint, include query parameters to limit and paginate results. 4. Use the "Field Paths to Return" option to specify which data you want to retrieve. 5. In the JSON body, reference dynamic variables using /column syntax for each row. If you're still having issues, please copy and paste your JSON configuration so we can troubleshoot further.
Sources: HTTP API with JWT authentication | Documentation | Clay University HTTP API integration overview | Documentation | Clay University HTTP API integration overview | Documentation | Clay University