.png){kind=logo}
How to Update, Run, and Extract Specific Columns from a Table via API.
Is there a way to both update a table, run specific coloums, and extract a specific coloum via an API?
Hey hey! Can you drop the URL for your table here? (if applicable) 🫶 Don't worry, only admins will be able to open your table 😉
Hi, thanks for getting in touch! I think this automation can be created through and API
Guy M.··can you elaborate? I didn't find a way to pull back the data directly from clay
currently this is not possible inside clay but I think this can be created through an API, but I am not 100% sure
please check this API video:
HTTP API integration Quick video on how HTTP API works: https://www.loom.com/share/114ff06973bd4ed7985b32fa031be867 -Bonus! troubleshooting example of failed body parse issues: https://www.loom.com/share/678e4c40e8c14894a6cd53948176e434
- Guy M.··
This requires me to build a server that will receive Clay's requests, no? Can't I POLL the table instead from a client?
Not yet, the shared tables feature still on beta and even with that I think it won't be possible for only one column, but maybe combining that with the write to table enrichment can pull that column as long as the the table is shared with you, but there is also one extra probrem which is that schedulled runs are not possible yet (this would need a trigger custom builded in the API)
- Guy M.··
so what kind of automatic way do I currently have to feed the table with data and then extract the results?
- Guy M.··
programatically/automatically
probably a webhook
Here's a video showing a few automations you can set up in Clay (webhook example in the first few minutes of this video): https://youtu.be/yw5paDolwTQ?feature=shared
ant to extract the results automatically the http API
- Guy M.··
ok, thanks