.png){kind=logo}
Troubleshooting Webhook Data Reception Issues in Clay
Any idea why a webhook would not receive data? This is the table, if I use the webhook.site I get the response but when I use the Clay webhook the response does not arrive…
The data must be sent as JSON body and it must be a POST requst
Tomi F.··Hello Andrei! It looks like that link is no longer working. As Muhammad mentioned, if the webhook is not sending data as JSON and formatted as a POST request, the table will not be able to show it. Are you able to confirm these are both the case? If it is and it still does not work, let us know and we can look into it further.
Bo (.··Hey, thanks for reaching out Andrei - Let's go back a bit; What are you trying to achieve here? It looks like both api are successfull but the last one has a cell size limit issue and also that the body seems to be formated in HTML not JSON! Typically what you would need here is JSON response but also less than 8000 characters. That could be done by specifying which fields to return. Let me know more here so i can help :) https://downloads.intercomcdn.com/i/o/w28k1kwz/1243529615/92fb7dd988b105bd14bcf6be76ec/CleanShot+2024-11-07+at+_15NqT0UVTi%402x.png?expires=1731003300&signature=b92ad589977d4bcdd3e677c5ba2bc232f69d0ba5e68ce994ea9cb4f0b434fc67&req=dSIjFcx8lIdeXPMW1HO4zf8K6tKjHals5R62gz4YNBgvB%2B%2F%2B2TXldRoaqJCB%0AeOBw%0A
The second API call is just to confirm that the job was done, which meant I should see it in the webhook. Why are you saying it’s formatted as HTML? I took the response from webhook.site and I put it into a JSON beautifier/validator and it validated it as a JSON…But that could explain the problem… The field to return does not necessarily help because most of the response is one field, “body”..
- Bo (.··
Here's why: Curious what are you trying to achieve here? Let's try to find another way together instead :) https://downloads.intercomcdn.com/i/o/w28k1kwz/1243557875/700388ae97652717d16d7265e7e7/CleanShot+2024-11-07+at+_397SDwMwB7%402x.png?expires=1731005100&signature=376cd7f1a6ac8c665ed832d344f0b8003a22e0221bfc3e806e4424f9b6b90bf4&req=dSIjFcx7molYXPMW1HO4zaLokugVzbY7WJino6uIoV7imHi%2BDBufo6QdXeio%0Ayqx1%0A
Yeah, but that’s part of the “body” which is part of a json… Isn’t the same condition for the initial API call that says cell limit exceed? Or is that able to process the response even if it’s not a JSON? Bottom line I’m trying to scrape a page with a scraper :)
- Bo (.··
It does looks like the data is actually passing, you might be right here but the cell size is also the issue. If the data exceeds the 8,000-character limit per cell, it can’t be displayed. When scraping the website there's no way to truncate this?
Yeah. the cell size is an issue with the normal API call, but shouldn’t be with the webhooks? No way to truncate this, at least not right now.
- Bo (.··
All cells in our tables—including those receiving data from webhooks, API calls, or any enrichments—have an 8,000-character limit. Unfortunately, this limit can’t be increased. Here’s a video with more details: Video Link. I would try to find a way to truncate the results in some ways! You could maybe send it to google sheet instead and then fix it in google sheet then do a lookup. For example: You can make a Google Sheet receive webhooks using Google Apps Script. Write a script to create a doPost() function, which handles incoming webhook data. Then, publish the script as a web app, granting access to anyone. This provides a unique URL that can be used as the webhook endpoint. The incoming data can be saved directly to the sheet. And from there you can use this to looks parts of it: [App: Article Inserter] Let me know if you have any questions!
Oh, oke, I was under the impression that you could put more into a webhook cell vs the rest 😬 Got it then, thanks a mil for the explanations! 🙏
