Invalid_records error

[Marianna_Kerppo]

Hello! I’m getting an error with sending a patch request. I’m getting the following errror:
{
“error”: {
“type”: “INVALID_RECORDS”,
“message”: “You must provide an array of up to 10 record objects, each with an “id” ID field and a “fields” object for cell values.”
}
}

I’m trying to send an array. I’ve checked my JSON formatting. Not sure what else might be the issue. Here’s the JSON I’m trying to send (with record IDs masked):
{
“records”:[
{
“id”:“recabc123”,
“fields”:{
“Reminder Days”:[
“recced456”,
“recefg789”
]
}
}
]
}

[Ludovic_Moular1]

Would anyone have a response here?
I have the same issue with a DELETE API request that gives the same type of error:

URL = https://api.airtable.com/v0/$databaseID/$tableName
payload = {
“records”:["$recID1","$recID2"]
};

→ error={message=“records” must be an array of up to 10 record IDs., type=INVALID_RECORDS}}

I did check that the record IDs were existing ones in $tableName.
I also checked with the following syntax:
payload = {
“records”:[{“id”:"$recID1"},{“id”:"$recID2"}]
};

What am I doing wrong here?

[acco]

Hey Ludovic,

I think the only similarity between your post and the OG is that this is the error Airtable gives when the API request is not valid.

In any case, are you sending along your request body as JSON? Looking at the docs, it appears that it’s expecting the body to be url encoded for DELETEs, yeah?

Best,
Anthony

[Ludom_Initiativ]

Does anyone have any answer here?
I’ve spent hours - if not days - on this, looking at dozens of forum posts and have never been able to perform a DELETE API call.

[Bill_French]

This might help -

How to use REST API to delete up to ten records at a time using Node.js library axios? API

I’m certain I cannot lend any assistance concerning PHP, but this is how it works well in javascript, specifically Google Apps Script. Note that there is no URL encoding required because record IDs are strings that need no such encoding to be properly executed in a URL command line. Ergo, a properly formatted batch request URL for three records looks like this: https://api.airtable.com/v0/app9cal9JNalRhtkx/Test%20Table?records[]=rec6LzaDnlc2zcoYO&records[]=recCCdy6JKlSxyGMC&records[]=recGxog35…

[Flame_Fire]

same can you tell me how do it using postman