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?
Use write to another table as soon as the ID is fetched instead of looking up in the other table?
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
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