API Export to Airtable via Parabola.io

[Tim_Nugmanov]

Hey everyone! Trying to figure how to to get data from MongoDB to Airtable. Out of all the connectors/automators, Parabola seems to be the one to do the trick. However, on the final “API Export” step I am running into difficulties. I am non-CS, so maybe I am missing something super silly :grinning_face_with_sweat:

Parabola asks for the following:

1. Request Type
2. API Endpoint URL
3. Body
4. Max Requests per minutes
5. Authentication Type
6. Bearer Token

Here’s what I did:

1. Opened the Airtable API page for the corresponding base.
2. Copied the Endpoint URL from the top of the cURL interface
3. Copied the snippet of code starting after "fields": into the Body

{
    "User ID": "{id}",
    "First Name": "{first}",
    "Last Name": "{last}",
    "Email": "{email}",
    "Business ID": [
      "{business}"
    ]
  }

4. Inserted the Parabola values with {} (all strings)
5. Found my API key and put that into the Bearer Token

Testing things in Parabola works. However, when I publish the flow and run it, I get a 422 – Unprocessable Entity Error and

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

I can also expand the “sent request” field and get this (this is the first row of my data in my Parabola table)

{
  "data": {
    "Business ID": [
      "5dbcb541adf60933fa4730b5"
    ],
    "Email": "juandps@bookifi.co",
    "First Name": "Juan",
    "Last Name": "Palacio",
    "User ID": "5dbcb541adf60933fa4730b4"
  },
  "headers": {
    "Authorization": "Bearer I REMOVED THIS"
  },
  "method": "POST",
  "url": "https://api.airtable.com/v0/appj2Cs7cuXPBRDbP/Users"
}

Does anyone have tips any solving this? Thank you in advance!

[Bill_French]

@Tim_Nugmanov,

I’m pretty sure the issue is this data payload -

Doesn’t a post require an array of records and a fields node?

[Tim_Nugmanov]

Hi Bill :wave: Thank you for your response. Thanks for the tip. That made it work. Have you had success with exporting in linked records? I get this error on Parabola. Confirmed that the record does indeed exist.

  "error": {
    "message": "Value \"5dbcb541adf60933fa4730b4\" is not a valid record ID.",
    "type": "INVALID_RECORD_ID"
  }
}

[Bill_French]

That ID in the error is not a record ID. It means your code is not passing the right ID.

[Tim_Nugmanov]

Oh got it! Thanks. Turns out “linked” columns in Airtable don’t use the user defined value to identify the record. They use the auto-generated Record ID.