Error Running Apify Action: Invalid Input JSON from Clay Integration | Clay

Error Running Apify Action: Invalid Input JSON from Clay Integration

Hi, I am running an apify action and the input from clay is just the website, I have also normalized the domain but I am getting the below error. When I am running the actor without the clay column and just the url, it is working. The integration failed to run { "error": { "type": "invalid-input", "message": "Cannot parse input JSON body: Bad control character in string literal in JSON at position 76 (line 2 column 75)" } }

6 comments

Channeled
APP
·
·
The "Bad control character" error indicates your JSON contains hidden or special characters that aren't properly escaped. This commonly happens when data from Clay columns contains line breaks, tabs, or other control characters. To fix this: 1. Check if your website/domain data contains hidden characters like line breaks or tabs 2. Copy your JSON input data into a text editor to spot hidden characters 3. Ensure all text values are properly escaped (e.g., use \" for quotes inside strings) Since you mentioned it works without Clay columns, the issue is likely in how the Clay data is formatted when passed to Apify. Can you copy and paste your JSON input data here so I can help identify the specific control character causing the issue?
Sources: FAQ: Why am I seeing the "failed to parse body" error when using the HTTP API enrichment? HTTP API integration overview | Documentation | Clay University Run Apify Actor with Apify
Hussain D.
·
·
Still not working , as soon as I replace the Clay refenced column, it is working
Bo (.
·
·
Hey - Do you mind sending the link (url) to the table so we can take a look?
(52 kB)
Hussain D.
·
·
Bo (. - https://app.clay.com/workspaces/453249/workbooks/wb_0sx8saqNYMyKAXYTgR8/tables/t_0sx9i1fgDBdnNjXCpCA/views/gv_0sx9i1fDwUKmUDPtcoZ
Hussain D.
·
·
Solar and Roofing Leads tab
Bo (.
·
·
Hey — I just tested it on my end and everything seems to be working fine. If you’re still running into the error, it might be that the website input from Clay is including hidden characters or formatting issues. Try trimming the input using a formula to clean it up, or double-check that the domain doesn’t have any unexpected line breaks or symbols. If it’s still acting up, feel free to share a quick screen recording — happy to take a closer look.