SerpAPI Integration Issue: Fetching Ad Data with Clay

·

Having an http api issue with serperapi. -->We’re using the SerpAPI integration in Clay to fetch ad data using advertiser IDs, but it’s only pulling results for one hardcoded ID (4809) across all rows, instead of dynamically inserting each row’s ID. The setup works correctly when tested manually, so it seems like Clay isn’t passing the variable properly to the API request during batch runs. loom video

3 comments

Clay
APP
·
·
When using column tokens in the HTTP API body, ensure you're not wrapping the variable values in quotes. The correct format is: { "advertiser_id": ##{{your_id_column}}, "other_field": "value" } - keep the key in quotes but don't wrap the column token value in quotes. Could you copy and paste your current JSON configuration from the HTTP API column so I can help troubleshoot the specific formatting issue?
Sources: HTTP API with Clay HTTP API integration overview | Documentation | Clay University Run Apify Actor with Apify
Muhammad S.
·
·
change this method from GET to POST and see the magic, plus feel free to rotate your api key
Clay
APP
·
·
To help troubleshoot your SerpAPI HTTP configuration, could you copy and paste your current JSON configuration from the HTTP API column? This will help identify any formatting issues that might be preventing the dynamic variable insertion when switching from GET to POST method.
Source: HTTP API integration overview | Documentation | Clay University