Updating Rows via API: Exploring Webhooks and HTTP Queries

Theo N. · 2024-12-05T18:23:09.217Z

Do we have a way to update a given row with the API? context: In my table I have a column that uses the clay "HTTP API POST" action. The action send an HTTP query to my server and updates the rows. I'd like to be able to keep updating the rows even after receiving the first HTTP query. Is there a webhook system with the row IDs I could use somewhere?

Updating Rows via API: Exploring Webhooks and HTTP Queries | Clay

12 comments

· Sorted by Oldest

Channeled
APP
·
·
Yes, you can update rows after the initial HTTP API POST action using the auto-update feature. When you set up your HTTP API column, you can enable auto-update which will automatically update the row whenever new data is added.You can also control when updates occur by: 1. Using the auto-update toggle (on by default for new rows) 2. Setting conditional run criteria using formulas to specify when the column should updateNote that if you disable auto-update, you might encounter stale data issues. Sources: HTTP API - Clay University HTTP API with JWT Authentication - Clay University
Theo N.
·
·
Is there a way to have this run more like a cronjib? The server need to trigger the update the clay column on it owns, not when clay requests it. for example if a user becomes a inactive we want to automatically mark it has such in clay without having to to daily repetitive tasks
Channeled
APP
·
·
Yes, you can use Clay's webhook functionality to automatically update your data based on external triggers. Webhooks allow Clay to receive data automatically from other applications whenever specific events occur.Here's how to set it up: 1. Click the "+ Create New" button on your Clay home page 2. Find the "Other" section and select "Import data from Webhook" 3. Choose your target table 4. Copy the generated webhook endpoint 5. Use this endpoint in your external system or automation toolThis way, your external system can send updates to Clay whenever needed (like when a user becomes inactive), and Clay will automatically update the corresponding rows. The data is sent via HTTP POST requests in JSON format, enabling real-time updates without manual intervention. Sources: Import Data to Clay Using Webhooks Webhooks - Clay University
Channeled
APP
·
·
Looks like you're still looking for help. We're escalating this over to our support team and someone should be in touch soon. In the meantime, feel free to include any other information that may be helpful in solving your issue!
Theo N.
·
·
It seems that the webhook updates all rows & columns, but I only want to update 1 column for a given row ID
Tanvi R.
·
·
Hi Theo, thanks for reaching out! Do you mind sending the link to the table so we can take a look? https://downloads.intercomcdn.com/i/o/1171717996/ac7729f84b426e1d0358af02/image.png?expires=1733428800&signature=f6cbbcbf01ee1795714a679df58784ae3460cb6c047257ec03a0f8fa86e15c0a&req=dSEgF85%2FmohWX%2FMW1HO4zYTywSj4BJ8e2BKsam%2FhVPtxEw%3D%3D%0A
Theo N.
·
·
Tanvi R. This one for example https://app.clay.com/workspaces/9888/tables/t_k4jp44oAkR6w/views/gv_KUCXMHzFe4ke
Theo N.
·
·
I'd like to automatically update "page views" based on what happens on the server for a given row
Tanvi R.
·
·
Got it Theo, and where do the "Page views" come from?
Tanvi R.
·
·
Right now, it's not possible to update only one column programatically. The only columns that update instantly are Apify, Phantombuster, or webhook table source columns. Curious if you could build a webhook tableusing Zapier/Make.com to trigger a new row in this table and automatically update the page view with this latest information?
Theo N.
·
·
I'll have a look thanks!
Channeled
APP
·
·
Hi Theo N.! This thread was recently closed by our Support team. If you have a moment, please share your feedback:

Channeled
APP
·
·
Yes, you can update rows after the initial HTTP API POST action using the auto-update feature. When you set up your HTTP API column, you can enable auto-update which will automatically update the row whenever new data is added.You can also control when updates occur by: 1. Using the auto-update toggle (on by default for new rows) 2. Setting conditional run criteria using formulas to specify when the column should updateNote that if you disable auto-update, you might encounter stale data issues. Sources: HTTP API - Clay University HTTP API with JWT Authentication - Clay University
Theo N.
·
·
Is there a way to have this run more like a cronjib? The server need to trigger the update the clay column on it owns, not when clay requests it. for example if a user becomes a inactive we want to automatically mark it has such in clay without having to to daily repetitive tasks
Channeled
APP
·
·
Yes, you can use Clay's webhook functionality to automatically update your data based on external triggers. Webhooks allow Clay to receive data automatically from other applications whenever specific events occur.Here's how to set it up: 1. Click the "+ Create New" button on your Clay home page 2. Find the "Other" section and select "Import data from Webhook" 3. Choose your target table 4. Copy the generated webhook endpoint 5. Use this endpoint in your external system or automation toolThis way, your external system can send updates to Clay whenever needed (like when a user becomes inactive), and Clay will automatically update the corresponding rows. The data is sent via HTTP POST requests in JSON format, enabling real-time updates without manual intervention. Sources: Import Data to Clay Using Webhooks Webhooks - Clay University
Channeled
APP
·
·
Looks like you're still looking for help. We're escalating this over to our support team and someone should be in touch soon. In the meantime, feel free to include any other information that may be helpful in solving your issue!
Theo N.
·
·
It seems that the webhook updates all rows & columns, but I only want to update 1 column for a given row ID
Tanvi R.
·
·
Hi Theo, thanks for reaching out! Do you mind sending the link to the table so we can take a look? https://downloads.intercomcdn.com/i/o/1171717996/ac7729f84b426e1d0358af02/image.png?expires=1733428800&signature=f6cbbcbf01ee1795714a679df58784ae3460cb6c047257ec03a0f8fa86e15c0a&req=dSEgF85%2FmohWX%2FMW1HO4zYTywSj4BJ8e2BKsam%2FhVPtxEw%3D%3D%0A
Theo N.
·
·
Tanvi R. This one for example https://app.clay.com/workspaces/9888/tables/t_k4jp44oAkR6w/views/gv_KUCXMHzFe4ke
Theo N.
·
·
I'd like to automatically update "page views" based on what happens on the server for a given row
Tanvi R.
·
·
Got it Theo, and where do the "Page views" come from?
Tanvi R.
·
·
Right now, it's not possible to update only one column programatically. The only columns that update instantly are Apify, Phantombuster, or webhook table source columns. Curious if you could build a webhook tableusing Zapier/Make.com to trigger a new row in this table and automatically update the page view with this latest information?
Theo N.
·
·
I'll have a look thanks!
Channeled
APP
·
·
Hi Theo N.! This thread was recently closed by our Support team. If you have a moment, please share your feedback: