.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ā¦
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
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.
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ā..
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 :)
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.
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! š
