Error 422 - 7 fails sending to Airtable API

Ask a question
1

Hey Groovers

Noob to Parabola, seems cool as… except exporting the data out.

Pulling Google Analytics pageviews in, trying to send to my Airtable. Get the following error 422 Entity Error no matter what I try.

{
  "error": {
    "message": "Invalid request: parameter validation failed. Check your request data.",
    "type": "INVALID_REQUEST_UNKNOWN"
  }
}

My request body is: (page views is a string in Airtable)

{
      "fields": {
        "Memberstack ID":"{Memberstack ID}",
        "page views":"{Pageviews}"
      }
    }

My sent request. The page view column in Airtable is pre-populated with “1” just so its not blank. I didn’t want to risk using PUT

{
  "data": {
    "fields": {
      "Memberstack ID": "601a1668ca30f00004346280",
      "page views": "10"
    }
  },
  "headers": {
    "Authorization": "Bearer *****APIKEY******"
  },
  "method": "PATCH",
  "url": "https://api.airtable.com/v0/app**************/Nodes"
}

Would love some help please. I’ve killed 7 credits on this already and its my first go!
PS - I only need to send the pageviews. I was just adding “Memberstack ID” to help it all line up or find the right record to update?!

Cheers
~Capt’

2

After scouring every dark recess of the internet… I discovered a PATCH needs a record id.
Adding {id} after the API endpoint URL worked!

I’m sure this is obvious to pro’s but how the heck is a noob supposed to know this stuff?! Some better docs or tutorials would be welcomed.