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": s

      "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 👋 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 👋 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.

Reply


Terms & Conditions