I am using an automation to send records to AI table using Send HTTP Request.
One of the fields in AITable is a number. When I try and add a number like below it works fine:
{
“records”: [
{
“fields”: {
“Location”: “Spain”,
“AA Number”: 1,
“Full Name”: “Ben Jones”
}
}
]
}
But when I bring the number from a record like below I get - Body must be a valid JSON object
{
“records”: [
{
“fields”: {
“Location”: “Spain”,
“AA Number”: <%= JSON.stringify(_actions.act0ji5Npq4XruEGRw5ggBzF.records[0].cells.fldwLmcTAeaOg3vhuowr5nLx) %>
}
}
]
}
If I add it quotes it does not have the error about being valid, but AITable complains that it is not a number so will not add the record.
UPDATE With the Body must be a valid JSON object I can run test and it works fine, it just will not let me save the automation part.
Any ideas anyone?