Skip to main content

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

  • February 5, 2024
  • 4 replies
  • 246 views

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
    }
]```

4 replies

  • Author
  • New Participant
  • February 5, 2024

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.


Matias.Monday
Forum|alt.badge.img
  • monday.com Team Member
  • February 6, 2024

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


graceg
  • monday.com Partner
  • February 8, 2024

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.


Matias.Monday
Forum|alt.badge.img
  • monday.com Team Member
  • February 8, 2024

Hello there @graceg,

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

Cheers,
Matias