Troubleshooting Input Data Errors in Column Fields
what value do I have to enter in input data I am entering here column field but it shows an error
what value do I have to enter in input data I am entering here column field but it shows an error
When entering data in the input field, follow these JSON formatting rules to avoid errors: 1. For text/string values:
• Always use double quotes around both the key and value
• Example: "name": "John"
2. For numbers:
• Use quotes for the key, but not for the number value
• Example: "age": 30
• Exception: If you have numbers with trailing zeros (like 0004), put them in quotes
3. When using dynamic column values:
• Include quotes around the dynamic column tag for string values
• Create a Formula column first if you need to combine plain text with dynamic valuesHere's a correct example: LBKS{ "name": "John", "age": 30 }LBKSIf you're still having trouble, you can validate your JSON format using JSONLint.
Sources:
HTTP API integration overview | Documentation | Clay University
FAQ: Why am I seeing the "failed to parse body" error when using the HTTP API enrichment?
Is that what you were looking for?
but here I have to enter column field what should I enter her
The value you should enter depends on the data type you've selected for your column. Here are the supported data types and their corresponding values: • Text: Any text or string input• URL: Valid web links• Checkbox: True/false values• Select: Choose from predefined tags• Number: Numerical values only• Date: Date and time values• Currency: Monetary amounts• Email: Valid email addresses• Image from URL: Image URL linksMake sure to follow these formatting rules: • For text/string values: Use double quotes• For numbers: No quotes needed (except for numbers with trailing zeros)• For dynamic column values: Include quotes around the dynamic column tagIf you're still getting errors, check that there are no extra spaces or hidden characters in your input. Sources: Table columns overview | Documentation | Clay University HTTP API integration overview | Documentation | Clay University
Was that helpful?
{
"error": {
"type": "invalid-input",
"message": "Cannot parse input JSON body: Unexpected token 'h', "http://www"... is not valid JSON"
}
}
this error I am getting
Based on your error message, it looks like there's an issue with JSON formatting in your input. Here's how to fix the "invalid-input" error: 1. Make sure all text keys and values are surrounded by double quotes
2. Check for proper JSON syntax:
• Use commas to separate key-value pairs
• Remove any trailing commas
• Ensure proper placement of brackets
• Remove any extra spaces or hidden charactersHere's the correct JSON format to follow: LBKS{ "key": "value", "another_key": "another_value" }LBKSTo troubleshoot: ** Copy your JSON into a text editor to check for hidden characters
** Use a JSON validator like JSONLint to verify your format
** If using dynamic column values, make sure they're properly quotedCommon mistakes to avoid: ** Missing quotation marks around text
** Extra commas where they shouldn't be
** Improperly formatted special characters
Sources:
HTTP API integration overview | Documentation | Clay University
FAQ: Why am I seeing the "failed to parse body" error when using the HTTP API enrichment?
Was that helpful?
what is correct format
Here's the correct JSON format for input data: 1. For text/string values:
• Use double quotes around both keys and values
• Example: {"name": "Sam"}
2. For numbers:
• Use quotes around keys, but not around number values
• Example: {"age": 30}
• Exception: Numbers with trailing zeros (like 0004) need quotes
3. For dynamic column values:
• Include quotes around the dynamic column tag for string values
• Example: {"email": "##{{email field}}"}Common formatting rules: ** Use commas to separate key-value pairs
** Remove any trailing commas
** Ensure proper placement of brackets
** Avoid extra spaces or hidden charactersHere's a complete example: LBKS{ "name": "Sam", "age": 30, "email": "[sam@clay.com](mailto:sam@clay.com)" }LBKSIf you're still getting errors, try pasting your JSON into a validator like JSONLint to check the format.
Sources:
HTTP API integration overview | Documentation | Clay University
HTTP API with JWT authentication | Documentation | Clay University
FAQ: Why am I seeing the "failed to parse body" error when using the HTTP API enrichment?
Was that helpful?
but here I have to map column from where it fetch data and send to apify .
When mapping column data to send to Apify, follow this JSON format in the Input Data section: 1. For column tokens (dynamic data from your Clay table):
• Keep the key in quotes
• Do not put quotes around the column token itself
• Use the ##{{column name}} syntaxHere's the correct format: LBKS{ "email": ##{{email field}}, "name": ##{{name field}} }LBKSMake sure to: ** Use proper JSON formatting with curly braces
** Include commas between key-value pairs
** Keep the keys in quotes
** Don't wrap the column tokens (##{{...}}) in quotes
Sources:
Apify integration overview | Documentation | Clay University
Run Apify Actor with Apify
Was that helpful?
ok Here I have to map person linkedin URL column here is the column name - person_linkedin then write according to the column