PATCH Request to Airtable using Node-RED gives "Could not find field "fields" in the request body"

[CarboneQuebec]

Hi, I don't have much experience with API requests. I am trying to understand how it all works. I am currently using Node-RED (visual Node.js) to process the requests. I was able to complete a GET request and i'm now trying to do a PATCH request to update data in Airtable.

I get the following error message when trying:

type: "INVALID_REQUEST_MISSING_FIELDS"

message: "Could not find field "fields" in the request body"

Here is the schema in question:

I am unsure where the API is expecting the request body.

Here is my test JSON:

{

    "fields": {

        "CCISF": 5,

        "CORAMH": 5,

        "RJCCQ": 5

    },

    "typecast": true

}

Do I have to include all fields present in the table or only those i wish to update with the PATCH request?

Thank you.

[TheTimeSavingCo]

You only need to include the fields you want to update in a PATCH request

Hmm, your JSON looks fine to me, hopefully someone else can spot something

For what it's worth, I used your exact JSON in Postman and it worked fine.  You have a `Content-Type` set as `application/json` right?

[CarboneQuebec]

Yes the HTTP Request node as a custom header with Content-Type application/json, see below:

[CarboneQuebec]

My guess is that I am not sending the JSON to the place the API is looking for it.

I have tried multiple things:

msg.req.body, msg.request.body, msg.body, msg.request, msg.req

The issue is that I don't know where the API is expecting the JSON.

Regards.

[CarboneQuebec · Accepted solution]

After Further investigations, It appears the request body was sent via msg.payload and not msg.req.body.

I was finally able to do my PATCH resquest.

Thank you