Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Feb 05, 2020 09:14 PM
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:
Here’s what I did:
"fields":
into the Body{
"User ID": "{id}",
"First Name": "{first}",
"Last Name": "{last}",
"Email": "{email}",
"Business ID": [
"{business}"
]
}
{}
(all strings)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!
Feb 06, 2020 08:20 AM
I’m pretty sure the issue is this data payload -
Doesn’t a post require an array of records and a fields
node?
Feb 19, 2020 05:29 PM
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"
}
}
Feb 20, 2020 04:19 AM
That ID in the error is not a record ID. It means your code is not passing the right ID.
Feb 20, 2020 11:13 AM
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.