topic Re: Monday.com connector in Workato Pros Discussion Board

Monday.com connector

Ilan — Mon, 03 Jul 2023 11:48:59 GMT

hi all

i have a valid token but cant establish a connection without "column values" which i cannot figured.

is someone familiar with the Monday connector?

advanced thanks

Re: Monday.com connector

chris-wiechmann — Mon, 03 Jul 2023 12:03:40 GMT

Hi @Ilan,

Can you please explain in more detail, what do you mean, that you can't establish a connection without "Column values", as at the connection time, the columns shouldn't matter?

Thanks,
Chris

Re: Monday.com connector

Ilan — Mon, 03 Jul 2023 13:06:54 GMT

Chris, thank you for reaching out.

in the connector dialog b

ox i have three mandatory fields

1. Board ID

2.Column ID

3. Column value

I allready have 1 and 2 , but icant finf 3.Column value

Re: Monday.com connector

chris-wiechmann — Mon, 03 Jul 2023 13:33:41 GMT

Hi @Ilan,

This action: "Get Item by column values" is supposed to return items from a certain board, that have a specified value. Like a search operation.

In that field "Column value" you have enter (or use a data-pill) the search term you would like to search for.

Cheers,
Chris

Re: Monday.com connector

Ilan — Mon, 03 Jul 2023 14:03:47 GMT

do you have an example of a data pill or search term?

can i use a wildcard?

Re: Monday.com connector

thomas — Mon, 03 Jul 2023 16:24:48 GMT

HI Ilan,

I found the API docs for this value: https://developer.monday.com/api-reference/docs/column-values-v2. Under Implementation, they include an example. Does this help?

Best

Re: Monday.com connector

chris-wiechmann — Tue, 04 Jul 2023 07:50:14 GMT

Hi @Ilan,
Assuming, you have a column in your Monday.com board, that contains a certain status (e.g. Done, Open, In progress, etc.).
Now, depending on your use-case, you set the Workato Action Column-Value to the status (e.g. "Open") you want to search items for.

Cheers,
Chris