Clay Icon

Handling Webhook Delays for ID Lookup in Tables: Solutions Needed

ยท
ยท

Im having 2 tables. One is receiving a webhook, which can take 30 seconds to receive, because some data needs to be generated. Once the webhook have been received im getting an ID Then I have another table where I run "Lookup multiple rows" and I'm searching for that ID in the other table. The problem is it takes 30 secs to get the ID of the webhook, so when i do lookup of the ID it always fails, because i didn't get response directy in the first table. Any idea how to solve this?

  • Avatar of kushagra
    kushagra
    ยท
    ยท

    Use write to another table as soon as the ID is fetched instead of looking up in the other table?

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    For your webhook synchronization scenario, here are two approaches you can consider:1. Use Passthrough Tables: โ€ข Set up your webhook-receiving table as a Passthrough table โ€ข This will ensure all enrichment processes (including receiving the delayed ID) are completed before the data is processed further โ€ข Clay automatically waits 60 seconds before reviewing rows for processing, which should accommodate your 30-second webhook delay 2. Implement Timing Controls: โ€ข When setting up your webhook integration, you can configure appropriate timeouts and delays โ€ข Add a delay between the webhook receipt and the lookup operation that matches or exceeds your typical 30-second processing time โ€ข This helps ensure data is fully processed before attempting lookupsFor optimal results, you should set timing delays that match the amount of time your data takes to enrich. You may need to experiment with different delay values to find the right balance. Sources: Configuring your table settings | Documentation | Clay University What is Webhooks? | Clay Send Data from Google Sheets to Clay Using a Webhook

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    Yes, you can use "Write to Other Table" to transfer the ID data as soon as it's received from the webhook. This approach would work better than looking up the data, as it allows you to:1. Transfer specific column data directly from your webhook table to another table 2. Map individual values between tables without needing them to be in list formatTo set this up:1. Select your destination table 2. Skip the list mapping step by entering "/" 3. Map the webhook ID column to the corresponding column in your destination tableThis should resolve your timing issue since the data will be written to the second table as soon as the webhook ID is received. Sources: Write to Other Table with Clay Labs Write to table integration overview | Documentation | Clay University

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

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