Clay Icon

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…

  • Avatar of Muhammad S.
    Muhammad S.
    ·
    ·

    The data must be sent as JSON body and it must be a POST requst

  • Avatar of Tomi F.
    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.

  • Avatar of Andrei B.
    Andrei B.
    ·
    ·

    I tested with webhook.site and this is the reply that’s coming. Looks like a JSON in a POST request…

  • Avatar of Bo (.
    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

  • Avatar of Andrei B.
    Andrei B.
    ·
    ·

    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”..

  • Avatar of Andrei B.
    Andrei B.
    ·
    ·

    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 :)

  • Avatar of Bo (.
    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?

  • Avatar of Andrei B.
    Andrei B.
    ·
    ·

    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.

  • Avatar of Bo (.
    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!

  • Avatar of Andrei B.
    Andrei B.
    ·
    ·

    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! 🙏

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    Hi Andrei B.! This thread was recently closed by our Support team. If you have a moment, please share your feedback:

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    Thank you so much for sharing your feedback Andrei B.!