Troubleshooting Undefined Responses in Perform Search for Data Enrichment

Jordan R. · 2025-03-25 23:29:14.450162+00

I am using the Perform Search to enrich some data. It is fairly basic trying to get accurate websites for some cities, but I am getting a fair amount of "undefined" responses. The logic I am using is fairly simple. What would cause the outcome to be undefined?

Troubleshooting Undefined Responses in Perform Search for Data Enrichment | Clay

Channeled
APP
·
·
There could be several reasons for "undefined" responses when using the Perform Search feature: 1. Insufficient or incorrect input data: Ensure you're providing a clear Google search query. 2. Language or country settings: Check if you've specified the correct language and country for your search. 3. API limitations: The Google Custom Search JSON API might have restrictions or rate limits affecting your results. 4. Query formatting: Make sure your search query is properly formatted, especially if using dynamic columns. To troubleshoot further, could you share the exact JSON you're using for the search? This would help identify any potential formatting issues.
Sources: Perform Search with Google | Clay.com Perform Search with Google

Jordan R.

{
  "answerBox": {
    "title": "Marion CountyIndianapolis / County",
    "answer": "Marion County"
  },
  "search_results": [
    {
      "title": "Marion CountyIndianapolis / County",
      "answer": "Marion County"
    }
  ],
  "related_searches": [
    {
      "query": "Indianapolis city balance indiana official website phone number"
    },
    {
      "query": "Indianapolis city balance indiana official website login"
    },
    {
      "query": "Indianapolis city balance indiana official website employment"
    },
    {
      "query": "Indianapolis city balance indiana official website 2022"
    },
    {
      "query": "Indianapolis city balance indiana official website 2020"
    },
    {
      "query": "Marion County, Indiana property search"
    },
    {
      "query": "indiana.gov mycase"
    },
    {
      "query": "indiana.gov login"
    }
  ],
  "link_to_google_search": "https://www.google.com/search?q=Indianapolis%20city%20(balance)%20Indiana%20official%20website&hl=en&gl=us",
  "results_returned_count": 1
}

Channeled
APP
·
·
Based on the JSON you provided, it appears that you're not getting "undefined" responses. The JSON shows a successful search result for Marion County. However, if you're experiencing "undefined" responses in other cases, it could be due to: 1. Insufficient or incorrect input data in your search query 2. API limitations or rate limits 3. Formatting issues in your search parameters To troubleshoot further, could you share an example of a search query that's resulting in "undefined" responses? This would help identify any potential issues with your input or formatting.
Sources: Perform Search with Google | Clay.com Perform Search with Google
Jordan R.
·
·
But it is in the actual table
Channeled
APP
·
·
There could be several reasons for "undefined" responses in your table when using the Perform Search feature: 1. Insufficient or incorrect input data in your search query 2. API limitations or rate limits 3. Formatting issues in your search parameters To troubleshoot, try these steps: 1. Double-click the row with "undefined" results. If it shows "waiting for its inputs," click "re-run this cell." 2. Toggle the auto-update off and on again, then accept the run prompt to update all rows. 3. Check your Body section for formatting errors, ensuring keys are in double quotes and separated by commas. To help further, could you please copy and paste the JSON you're using for the search into the chat?
Source: HTTP API integration overview | Documentation | Clay University
Jordan R.
·
·
https://app.clay.com/workspaces/336509/workbooks/wb_K2jcy6KSjxq6/tables/t_Vh4NTNhVKTPa/views/gv_8xcr4kWKq8x2
Jordan R.
·
·
This occurred on 1,178 records of 32,037
Jordan R.
·
·
Also happened in this table for 39/3,102 records
Jordan R.
·
·
https://app.clay.com/workspaces/336509/workbooks/wb_5f8WozzX8ah5/tables/t_jdpg8SjGxNGJ/views/gv_aWpoNkNoBiJx
Summiya B.
·
·
Jordan R.
Jordan R.
·
·
Why did the search work for over 95% off cases and not those?
Summiya B.
·
·
check space is missing only in first 2 inputs rest of them have spaces
Summiya B.
·
·
if you remove spaces between all of them it willl show error for all of of them
Jordan R.
·
·
I’m confused. Nothing changed on my end running on the whole file
Jordan R.
·
·
So, it doesn’t make sense that some would fail and some wouldn’t

33 comments