Setting up an HTTP API step to send data to a Webhook from Attio (CRM).
My issue is that I have a number column called "Employee Count" and I have inserted it into the body of the API call like this (see screenshot).
But unfortunately when trying to Parse the JSON data from the webhook on the Attio I get this error message: Parsed value for employee_count expected to be "number", instead got "string"
So Clay is sending the employee count data as string. How can I send it as a number type?
To send the "employee_count" field as a number in your HTTP API request body, remove the quotation marks around the dynamic variable for that field. Your JSON should look like this:
{
"employee_count": ##{{Employee Count}}
}
Numbers in JSON must not be enclosed in quotes. If you still see errors, copy and paste your JSON here so we can help troubleshoot further. [1] [2]
not really I get this error in Clay if I do that: Failed to parse body input: Unexpected token '#', ..."e_count": ##48471, ""... is not valid JSON while parsing '{"recordID": "ccab23b8-28c9-46f5-a22c-95'
If you still need help resolving the JSON formatting issue, I’m here to assist. Would you like to share more details or your current JSON setup so we can troubleshoot further?