Skip to main content

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}"
    ]
  }
  1. Inserted the Parabola values with {} (all strings)
  2. 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!

@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,

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

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


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"
  }
}

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

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"
  }
}

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.

Terms & ConditionsAccessibility statement