Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Invalid_records error

Topic Labels: API
5417 5
cancel
Showing results for 
Search instead for 
Did you mean: 
Marianna_Kerppo
4 - Data Explorer
4 - Data Explorer

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”
]
}
}
]
}

5 Replies 5
Ludovic_Moular1
5 - Automation Enthusiast
5 - Automation Enthusiast

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
6 - Interface Innovator
6 - Interface Innovator

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
5 - Automation Enthusiast
5 - Automation Enthusiast

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.

This might help -

same can you tell me how do it using postman