Skip to content
Attempting an API c...
 
Notifications
Clear all

Attempting an API call to Airtable for new table creation, but callin.io is unable to parse the JSON

5 Posts
2 Users
0 Reactions
3 Views
noor_dab
(@noor_dab)
Posts: 3
Active Member
Topic starter
 

I'm developing a workflow that monitors records in an Airtable table. Each time a new record is added, the workflow lists bases, finds the base matching the name from the record, and then creates a new table within that base. My current issue involves errors that don't seem logical on the final API call. I've placed my JSON string in the body of the API call, but I keep encountering an error stating [422] Could not parse request body. I've reviewed my JSON multiple times but can't identify any errors, and I've followed the API documentation precisely, yet nothing works!
Here are some screenshots from my workflow:

 
Posted : 20/02/2024 4:19 pm
samliew
(@samliew)
Posts: 293
Reputable Member
 

Welcome to the callin.io community!

Could you please copy the JSON and paste it here in this forum?

I'd like to help you verify if it's truly valid using https://jsonformatter.org/

You will also need to format the JSON code correctly, otherwise, it might get jumbled and become invalid:

  • Either add three backticks ``` before and after the code, like this:

    ```
    JSON content goes here
    ```

  • Or use the format code button in the editor:
    Screenshot_2023-10-02_191027

 
Posted : 20/02/2024 5:30 pm
noor_dab
(@noor_dab)
Posts: 3
Active Member
Topic starter
 
{
    "name": "{{3.`ORDER #`}}",
    "fields": [
        {
            "type": "singleLineText",
            "name": "Order number"
        },
        {
            "type": "singleLineText",
            "name": "UPC/SKU"
        },
        {
            "type": "singleLineText",
            "name": "WU"
        },
        {
            "type": "singleLineText",
            "name": "Item description"
        },
        {
            "type": "singleLineText",
            "name": "Condition"
        },
        {
            "type": "number",
            "name": "Original QTY"
        },
        {
            "type": "currency",
            "options": {
                "symbol": "$"
            }
        },
        {
            "type": "singleLineText",
            "name": "Tracking"
        },
        {
            "type": "singleLineText",
            "name": "Shipment ID"
        },
        {
            "type": "currency",
            "options": {
                "symbol": "$"
            },
            "name": "Total Total original retail"
        },
        {
            "type": "number",
            "name": "of units"
        },
        {
            "type": "singleSelect",
            "options": {
                "choices": [
                    {
                        "name": "Shoes",
                        "color": "pinkBright"
                    },
                    {
                        "name": "Active Wear",
                        "color": "cyanBright"
                    },
                    {
                        "name": "General Merch",
                        "color": "purpleBright"
                    }
                ]
            },
            "name": "Type"
        },
        {
            "type": "number",
            "name": "Shoes QTY"
        },
        {
            "type": "currency",
            "options": {
                "symbol": "$"
            },
            "name": "Shoes Total"
        },
        {
            "type": "number",
            "name": "Active wear QTY"
        },
        {
            "type": "currency",
            "options": {
                "symbol": "$"
            },
            "name": "Active wear Total"
        },
        {
            "type": "currency",
            "options": {
                "symbol": "$"
            },
            "name": "General Merch Total"
        },
        {
            "type": "number",
            "name": "General Merch QTY"
        }
    ]
}
 
Posted : 21/02/2024 11:50 am
samliew
(@samliew)
Posts: 293
Reputable Member
 

Everything appears to be in order. There should not be any problems.

Kindly ensure there are no extraneous spaces preceding or following the initial and final brackets.

For issues of this nature, reaching out to support directly via contacting support often facilitates a quicker resolution. Support personnel have access to your specific account details, scenario configurations, scenario logs, server-side logs, as well as internal tools and resources, enabling a more comprehensive investigation than what is available to you. Furthermore, sharing sensitive details about your situation may not be appropriate for a public forum discussion.

You can initiate a new ticket, or if you encounter difficulties logging in, you can also contact support through the contact form on the website.

Should you successfully resolve your issue with the assistance of support, we would still appreciate hearing about it! Sharing your solution within the forum can be beneficial to others encountering similar challenges.

 
Posted : 21/02/2024 11:56 am
noor_dab
(@noor_dab)
Posts: 3
Active Member
Topic starter
 

Hi there, thanks for getting back to me. I've actually gone through all those steps. I even reached out to Airtable support because all other API calls are functioning correctly, except for this specific one. This is despite the fact that my implementation aligns perfectly with the documentation. I'll be sure to keep you updated on any progress. Thanks again!

 
Posted : 21/02/2024 2:01 pm
Share: