Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Re: API Export to Airtable via Parabola.io

1407 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Tim_Nugmanov
5 - Automation Enthusiast
5 - Automation Enthusiast

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!

4 Replies 4

@Tim_Nugmanov,

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

image

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

image

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.

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.