Clay Icon
Join the Community
02 Bugs

Webhook Integration Caused Unintentional Deletion of Emails

Avatar of Skye S.Skye S.
·
·

I added a webhook to this table and mapped the emails being delivered to the webhook to the same column where all the other emails exist and it deleted all ~ 1615 other emails on the list above where the first webhook was sent

6 comments

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    This issue likely occurred because the webhook was mapped to an existing column containing emails, causing data overwrite. When setting up webhooks, it's important to:1. Create a new dedicated column for webhook data rather than using an existing column with data 2. Be mindful of the webhook payload structure and mapping 3. Consider the rate limits of up to 10 records per second with a maximum burst capacity of 20 recordsTo prevent data loss in the future:** Validate your webhook payload structure before going live ** Test the webhook setup with a small sample first ** Monitor webhook activity and responses ** Implement proper error handlingIf you need to recover the deleted data, you'll need to reach out to a human agent for assistance. Sources: Send Data from Google Sheets to Clay Using a Webhook What is Webhooks? | Clay Import Data to Clay Using Webhooks

  • Avatar of Arturo O.
    Arturo O.
    ·
    ·

    Hey Skye, thanks for flagging this! I've recently asked the team to consider CSV imports as a JSON source so data could be stored at a cell level just like other sources i.e. webhooks, where you click and extract the data. The default, since that's not currently the case for CSVs it's why mapping the data from a source column to static standalone columns would try to add the data from the JSON objects. Since you only have 1 row with a webhook but the rest are empty under it, the formula assumed those were empty and thus replaced the values accordingly. I'll share this as an example with the team and see if we can get this going. Your current workaround is definitely the best way to handle... merging the imported column from CSV and the value from the webhook into a final column.

  • Avatar of Skye S.
    Skye S.
    ·
    ·

    this makes sense, now that I know it’s easy to avoid so no big deal!

    :cat-jam:2
    :jammies:2
  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    Hi Skye S.! 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 Skye S.!