Cannot figure out what's wrong with JSON

Ask a question
1

Hi everyone! I’m trying to use API export to Airtable and I have everything set up. I cannot spot an error on this code:

{
  "records": [
    {
      "fields": {
        "First Name": "{First Name}",
        "Last Name": "{Last Name}",
        "Unsubscribed": "{unsubscribed}",
        "Status": "{status}",
        "Opt in": "{OPTIN_TIME}",
        "Confirmation": "{CONFIRM_TIME}",
        "Last Changed": "{LAST_CHANGED}",
        "Notes": "{NOTES}",
        "Email": "{Email Address}"
        ]
      }
    }
  ]
}

Can it be something related to the fact that I’m trying to export 10,000+ records?

2

Hello Temirlan,

It looks like there are a few extra closing braces at the end of your request body. See below for the corrected version:

{
   "records":[
      {
         "fields":{
            "First Name":"{First Name}",
            "Last Name":"{Last Name}",
            "Unsubscribed":"{unsubscribed}",
            "Status":"{status}",
            "Opt in":"{OPTIN_TIME}",
            "Confirmation":"{CONFIRM_TIME}",
            "Last Changed":"{LAST_CHANGED}",
            "Notes":"{NOTES}",
            "Email":"{Email Address}"
         }
      }
   ]
}
1 Like
3

Thank you so so much!

3 Likes