Monday Internal Server Error - Connecting to Typeform via Integromat

[adriennelt (Adrienne Todd)]

Hello!

I’m trying to set up an integration between Monday and Typeform using Integromat. I want to have each form submission automatically create an item, mapping the responses to the questions to individual columns in Monday.

When I run the scenario, I get a 500 Internal Error message on Monday’s side.

Here is the GraphQL query that’s being sent:

mutation { create_item (board_id: 1196492688, , group_id: “new_group29179”, item_name: “1x A4 high definition (suitable for printing) full page about Celonis EMS”, column_values: “{ "dup__of_owner": Bart Marissen, "email": {}, "dropdown": Demand Generation, "files": {}, "long_text": {"text":"It will be a 1 page A4 high def advertisement in the institute for internal auditors magazine. It can be a standard A4 add about the EMS or other ‘global’ add topic. So nothing new needs to be created if we already have this ready. Please make it high definition, suitable for printing."} }”) { id } }

Would love some direction/help! Thank you!

[Helen]

Hi @adriennelt, welcome to our community!

Just from a quick glance I’m not able to spot anything wrong with the query that’s being sent.

Do you mind including a screenshot of your setup for this module? Feel free to white-out any sensitive information, or send it to me via DM if you’d like.

Is the scenario running for other boards? Or do you always get a 500 error?

Thanks for walking me through it~

[adriennelt (Adrienne Todd)]

Continuing the discussion from Monday Internal Server Error - Connecting to Typeform via Integromat:

Here is the Typeform Output Bundle as well:

Typeform Output Bundle

[
{
“landing_id”: “x7e8yd00dakbj6l34zx7e8ykw0j2werf”,
“token”: “x7e8yd00dakbj6l34zx7e8ykw0j2werf”,
“response_id”: “x7e8yd00dakbj6l34zx7e8ykw0j2werf”,
“landed_at”: “2021-04-14T09:20:37Z”,
“submitted_at”: “2021-04-14T09:24:15Z”,
“metadata”: {
“user_agent”: “Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/89.0.4389.114 Safari/537.36”,
“platform”: “other”,
“referer”: “Discover Typeform, where forms = fun”,
“network_id”: “e62d4b9c73”,
“browser”: “default”
},
“calculated”: {
“score”: 4
},
“answers”: [
{
“field”: {
“id”: “VULSTaWleDbt”,
“ref”: “b44b0460-ac13-4d0c-8aba-f0da57593a36”,
“type”: “short_text”
},
“type”: “text”,
“text”: “Bart Marissen”
},
{
“field”: {
“id”: “okDTjsoIf2ej”,
“ref”: “6e0ef54d-5c6a-423c-b983-64df775c8d6e”,
“type”: “short_text”
},
“type”: “text”,
“text”: “1x A4 high definition (suitable for printing) full page about Celonis EMS”
},
{
“field”: {
“id”: “W3tqiqaXzJXY”,
“ref”: “8d85e9c55cb45a48”,
“type”: “multiple_choice”
},
“type”: “choice”,
“choice”: {
“id”: “X48XvOMlcr6t”,
“label”: “Demand Generation”
}
},
{
“field”: {
“id”: “cXIGhsUMTaOM”,
“ref”: “cd1ec41c-a518-408e-8a6f-b17d235caf3b”,
“type”: “multiple_choice”
},
“type”: “choice”,
“choice”: {
“id”: “Yta4ctzuGtCs”,
“label”: “Design”
}
},
{
“field”: {
“id”: “klEubqj0nNpn”,
“ref”: “9feb6354f4c037e6”,
“type”: “multiple_choice”
},
“type”: “choices”,
“choices”: {
“ids”: [
“ZQYrbnleE50Q”
],
“labels”: [
“Flyer / One-Pager”
]
}
},
{
“field”: {
“id”: “FDBNzOhQZrGy”,
“ref”: “1214451e3dd62f65”,
“type”: “date”
},
“type”: “date”,
“date”: “2021-04-22T00:00:00.000Z”
},
{
“field”: {
“id”: “28Ob3ry6XNkr”,
“ref”: “b9fe9c32-a5bc-49d2-88f6-de69ec8dd25d”,
“type”: “rating”
},
“type”: “number”,
“number”: 4
},
{
“field”: {
“id”: “Q3xGoNJNB8cr”,
“ref”: “051fe918-8764-4db5-b1be-ac30877fcd5b”,
“type”: “long_text”
},
“type”: “text”,
“text”: “It will be a 1 page A4 high def advertisement in the institute for internal auditors magazine. It can be a standard A4 add about the EMS or other ‘global’ add topic. So nothing new needs to be created if we already have this ready. Please make it high definition, suitable for printing.”
}
],
“mappable_answers”: {
“b44b0460-ac13-4d0c-8aba-f0da57593a36”: “Bart Marissen”,
“6e0ef54d-5c6a-423c-b983-64df775c8d6e”: “1x A4 high definition (suitable for printing) full page about Celonis EMS”,
“8d85e9c55cb45a48”: “Demand Generation”,
“cd1ec41c-a518-408e-8a6f-b17d235caf3b”: “Design”,
“9feb6354f4c037e6”: [
“Flyer / One-Pager”
],
“1214451e3dd62f65”: “2021-04-22T00:00:00.000Z”,
“b9fe9c32-a5bc-49d2-88f6-de69ec8dd25d”: 4,
“051fe918-8764-4db5-b1be-ac30877fcd5b”: “It will be a 1 page A4 high def advertisement in the institute for internal auditors magazine. It can be a standard A4 add about the EMS or other ‘global’ add topic. So nothing new needs to be created if we already have this ready. Please make it high definition, suitable for printing.”
}
}
]

[Helen]

Hi @adriennelt,

Thank you!! This is super helpful.

My assumption here is that the issue could be related to the columns you’re selecting, and the data you’re attempting to pass into these columns.

For instance, are you making sure that the column Ids are those from your column dropdown menus after turning on Developer Mode in your monday.labs area? I just want to double-check that you’re getting the right column Id.

Additionally, I’m afraid you wouldn’t be able to pass a text value into a Files column. These would need to be local files.

Lastly, any dropdown values you send will need to be pre-existing in your board.

Could any of these be why you’re seeing an error?

[adriennelt (Adrienne Todd)]

Hi!

I went through your list - and successfully go rid of the 500 error!! BUT, another error popped up.
I:

• added drop down options to Integromat for proper mapping.
• Turned on Developer Mode and confirmed that mappings are accurate.
• I’m not sure why text was trying to go into the files column, but I reviewed that as well.

Here is the new error:

Let me know what other information I can send!

[Helen]

Hi @adriennelt!

Hmmm strange. I’m not sure that I’m familiar with this error message to be totally honest. It seems it might be an error on the Integromat side.

If you re-create this scenario in a whole new scenario, does the same issue occur?

[adriennelt (Adrienne Todd)]

Hi Helen!

Will try that now. One question: I’d like to map the person that submitted the form to the “Requester” field. I can select Person or Teams to map if I do the Map option- Would I then have to select/add each person who could potentially show up?

If I don’t do the Map function, I’d select the mappable answer “What’s your Celonis email address?” - Could that be one source of the issue?

!

[Helen]

Hi @adriennelt,

I don’t think so! You would just need to pull in the attribute from Typeform that would be holding the information of whomever submitted the form (it should be one of the highlighted options in the popup menu from your screenshot).

Are you able to see such a field?

[adriennelt (Adrienne Todd)]

Yep! That’s an option.

I recreated the scenario from scratch and I’m still getting an error But I removed the Requester (“dup_of_owner”) and the scenario works - I’ll keep tinkering!

One new question though ( ).
The scenario ran successfully, but it passed through all the values from the two dropdown menus - not only the ones that I selected in my test.

If I delete the labels in Integromat, the scenario breaks again with this: * The operation failed with an error. Function ‘stringifyColumnValues’ finished with error! Cannot read property ‘map’ of undefined (so the labels should be there).

One field is multi-select in Typeform and one field only lets you select one option. Thank you!

[Helen]

Ahh okay! I think this might be because “dup_of_owner” isn’t a viable column ID? I imagine it would be something like “people4,” or “text3” depending on what column type you’re attempting to map your Typeform data into.

Regarding the mapping of all the labels, I think this is because you manually typed out all of the options in your “dropdown3” column:

Instead, if you map the answer instead, using one of the black highlighted options, that will only pull in the labels selected with your test Typeform entry.

I’m also curious to about this column ID entry:

Is the “1. Mappable Answers:” supposed to be in the column ID section?

Thanks!