Unkown Parse Error from Make.com formatted api request (200: Parse error on \"columnId\")

I am getting a Parse error but there is not enough detail to understand what is wrong (or rather I do not know how to read the parse error.)

What does [1,124] mean? Is this the character locations of the first values inside of the { } in my JSON?

This is the error I am receiving:

[200] [{"message":"Parse error on \"columnId\" (STRING) at [1, 124]","locations":[{"line":1,"column":124}]}]

This is what make.com/integromat is sending to the Monday API.

[
    {
        "name": "Matthew Abbitt",
        "boardId": "5781678528",
        "groupId": "new_group95877",
        "columnValuesToChange": [
            {
                "columnId": "email_1",
                "columnValue": {
                    "text": "mabbitt@abbitt.com",
                    "email": "mabbitt@abbitt.com"
                }
            },
            {
                "columnId": "email_2",
                "columnValue": {
                    "text": null,
                    "email": null
                }
            },
            {
                "columnId": "text",
                "columnValue": "AAMkAGRkMTMxMWViLTYxNjUtNGUwMi05NjRlLTkyODcxZTM4YjMxZgBGAAAAAAAMUdYHUYXtQqhmM18QKTl5BwA98myFT6X-T6gS9Y3tlLQxAAAAAAEOAAA98myFT6X-T6gS9Y3tlLQxAALlQYckAAA="
            },
            {
                "columnId": "email_3",
                "columnValue": {
                    "text": null,
                    "email": null
                }
            },
            {
                "columnId": "text9",
                "columnValue": "Newport News"
            },
            {
                "columnId": "text76",
                "columnValue": "USA"
            },
            {
                "columnId": "phone_1",
                "columnValue": {
                    "phone": "(757) 599-3335",
                    "countryShortName": "US"
                }
            },
            {
                "columnId": "phone_2",
                "columnValue": {
                    "phone": null,
                    "countryShortName": "US"
                }
            },
            {
                "columnId": "text79",
                "columnValue": "23606"
            },
            {
                "columnId": "text1",
                "columnValue": "VA"
            },
            {
                "columnId": "text81",
                "columnValue": "11835 Fishing Point Drive, Suite 106"
            },
            {
                "columnId": "text25",
                "columnValue": "Landowner"
            },
            {
                "columnId": "dup__of_suffix",
                "columnValue": "Abbitt Management LLC"
            },
            {
                "columnId": "dup__of_company",
                "columnValue": null
            },
            {
                "columnId": "text0"
            },
            {
                "columnId": "dup__of_home_street20",
                "columnValue": null
            },
            {
                "columnId": "dup__of_home_street9"
            },
            {
                "columnId": "phone_3",
                "columnValue": {
                    "phone": null,
                    "countryShortName": "US"
                }
            },
            {
                "columnId": "phone_4",
                "columnValue": {
                    "phone": null,
                    "countryShortName": "US"
                }
            },
            {
                "columnId": "dup__of_home_state",
                "columnValue": null
            },
            {
                "columnId": "dup__of_home_street2",
                "columnValue": null
            },
            {
                "columnId": "text5",
                "columnValue": null
            },
            {
                "columnId": "text2",
                "columnValue": "Senior Propoerty Manager & Land Development"
            },
            {
                "columnId": "dup__of_first_name",
                "columnValue": "Abbitt"
            },
            {
                "columnId": "dup__of_first_name1",
                "columnValue": ""
            },
            {
                "columnId": "phone_5",
                "columnValue": {
                    "phone": null,
                    "countryShortName": "US"
                }
            },
            {
                "columnId": "long_text"
            },
            {
                "columnId": "text819",
                "columnValue": null
            },
            {
                "columnId": "text819",
                "columnValue": null
            },
            {
                "columnId": "text10",
                "columnValue": null
            },
            {
                "columnId": "text21",
                "columnValue": null
            },
            {
                "columnId": "dup__of_home_street",
                "columnValue": null
            },
            {
                "columnId": "text3",
                "columnValue": null
            },
            {
                "columnId": "dup__of_last_name",
                "columnValue": ""
            },
            {
                "columnId": "text7",
                "columnValue": "Senior Propoerty Manager & Land Development"
            },
            {
                "columnId": "link",
                "columnValue": {
                    "url": null,
                    "text": ""
                }
            }
        ],
        "create_labels_if_missing": false
    }
]```

Update and the main issue:

I do not always get this error. It sometimes does go through. This is on the same settings in make.com too.

What I am noticing is sometimes make.com will have missing values for items I had previously filled in and saved. Very much confused on why when I open up the ‘create item widget’ these previously saved values would disappear.

Hello there @SolU_Admin,

Would you be able to please fill this form so our team can take a look into this? Please include a screen recording showing your entire Make.com scenario, its configuration and the data being passed from Make to monday.com

You can use Loom for that. It is free.

Looking forward to hearing from you via the form!

Cheers,
Matias

1 Like

I am getting the same “Parse error on columnId” messages as well, when trying to update column values. One column resolved for no apparent reason, but I can’t get it to update any other columns.

Hello there @graceg,

Please fill this form so our team can take a look into this and help you!

Cheers,
Matias

1 Like