Create Item - Array columns values not modified

Platform discussions monday apps & integrations
1

Hello there,

I am using the create item API route from Monday API V2.

When listing the values for my columns, on a new item in a board, only the item and title are added, no column values using the integromat connector (if that can help).

  • texte is a string
  • texte1 is a string
  • date is a date
  • date 7 is a date
  • timeline is a timeline field

Here is the request sent:

[
    {
        "name": "TEST CORP",
        "boardId": "583553907",
        "groupId": "topics",
        "columnValuesToChange": [
            {
                "columnId": "person",
                "columnValue": {
                    "personsAndTeams": [
                        {
                            "id": "11161799",
                            "kind": "person"
                        }
                    ]
                }
            },
            {
                "columnId": "texte",
                "columnValue": 1181186927
            },
            {
                "columnId": "texte1",
                "columnValue": "5455"
            },
            {
                "columnId": "date",
                "columnValue": {
                    "date": "2020-05-28",
                    "includeTime": false
                }
            },
            {
                "columnId": "date7",
                "columnValue": {
                    "date": "2020-05-29",
                    "includeTime": false
                }
            },
            {
                "columnId": "timeline",
                "columnValue": {
                    "to": "2020-05-29",
                    "from": "2020-05-28"
                }
            }
        ]
    }
]
2

Hey @tomgoirand – can you share a screenshot of the configuration in Integromat? The information above is raw Integromat configuration and I’m not super familiar with how it translates to the app. Would love to see a screenshot instead.

3

Here you go,

Capture d’écran 2020-06-01 à 10.39.03
Capture d’écran 2020-06-01 à 10.39.03413×535 34 KB

Capture d’écran 2020-06-01 à 10.38.35
Capture d’écran 2020-06-01 à 10.38.35419×935 67.4 KB

4

Hi @dipro are you still around?

5

Hi it works right now, the isue was related to the fact we stored the user id in SQL table which field was a varchar while monday is expecting integrer. The parsenumber added in integromat did the job actually.

1 Like
6

Hi @tomgoirand :wave:

I’m happy to hear everything is working as expected now, and thank you so much for sharing with us what the underlying issue was! :slight_smile: