How to Update, Run, and Extract Specific Columns from a Table via API.

Guy M.

·

Is there a way to both update a table, run specific coloums, and extract a specific coloum via an API?

✅1

14 comments

· Sorted by Oldest

Clay Team
APP
·
·
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 😉
Clay Team
APP
·
·
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
Clay Team
APP
·
·
currently this is not possible inside clay but I think this can be created through an API, but I am not 100% sure
Clay Team
APP
·
·
please check this API video:
Clay Team
APP
·
·
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?
Clay Team
APP
·
·
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
Clay Team
APP
·
·
probably a webhook
Clay Team
APP
·
·
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
Clay Team
APP
·
·
ant to extract the results automatically the http API
Guy M.
·
·
ok, thanks

Clay Team
APP
·
·
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 😉
Clay Team
APP
·
·
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
Clay Team
APP
·
·
currently this is not possible inside clay but I think this can be created through an API, but I am not 100% sure
Clay Team
APP
·
·
please check this API video:
Clay Team
APP
·
·
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?
Clay Team
APP
·
·
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
Clay Team
APP
·
·
probably a webhook
Clay Team
APP
·
·
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
Clay Team
APP
·
·
ant to extract the results automatically the http API
Guy M.
·
·
ok, thanks