Skip to main content
Solved

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

  • February 28, 2024
  • 4 replies
  • 141 views
C
Forum|alt.badge.img+2

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.

Best answer by CarboneQuebec

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

    4 replies

    TheTimeSavingCo
    Forum|alt.badge.img+31

    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?

    Adam, Airtable Consultant - thetimesaving.company
    C
    Forum|alt.badge.img+2
    • CarboneQuebec
    • Author
    • New Participant
    • February 29, 2024

    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?


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

     

     

    C
    Forum|alt.badge.img+2
    • CarboneQuebec
    • Author
    • New Participant
    • February 29, 2024

    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.

     

     

    C
    Forum|alt.badge.img+2
    • CarboneQuebec
    • Author
    • New Participant
    • Answer
    • February 29, 2024

    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

    Terms & ConditionsAccessibility statement