General

Hi, I have a board with a column "relations" where the column value is an array of ids I want to set the value of another column "relation_count" based on how many ids are in “relations” value. relations is changed -> set relation_count I wonder if and how to set an automation of that nature.

Hey Monday community, I would like some feedback on this gql query import { gql } from 'graphql-request'; export const GET_VOLUNTEERS_GROUPED_BY_LANGUAGE = gql` query GetVolunteersGroupedByCanSpeakLanguage( $boardId: ID! $groupId: String! $langColId: ID! $capacityColId1: String! $capacityColId2: ID! $limit: Int ) { boards(ids: [$boardId]) { groups(ids: [$groupId]) { items_page( limit: $limit query_params: { rules: [ { column_id: $langColId, compare_value: [null], operator: is_not_empty } { column_id: $capacityColId2, compare_value: [8], operator: lower_than } ] order_by: [{ column_id: $capacityColId1, direction: asc }] } ) { items { id

When I listen “events” by SDK, and then change column values for different types of columns - the “change_column_values” always triggers as it should, but except for the column with type = “name”. Is it a bug or how can I do it in another way? Method I use: monday.listen('events', callback)

The festive season is here, but your workload hasn’t gotten the memo! To assist you in balancing holiday tasks, New Year’s resolutions, and work obligations, we’ve handpicked the top 9 Monday.com apps designed to make this holiday season a breeze Would love to hear your thoughts! Enjoy​:snowman:🍧 blog.sundae.so

Hi team! There is any option to retrieve all the forms urls of an account through the api? or in any other way? Thanks!

Hi there, I’m working on the Timeline column. To implement a function in my app, I need to get the item by timeline column with a specific day, a specific time time range. I had tested some cases, and monday.com API already supports so well with operator: between. See: items_page( limit: $limit query_params: {rules: [ { column_id: $timelineField, compare_value: ["2023-11-19", "2023-12-02"], compare_attribute: "START_DATE", operator: between }, { column_id: $timelineField, compare_value: ["2023-11-19", "2023-12-02"], compare_attribute: "END_DATE", operator: between } ], operator: or } ) However, it doesn’t seem working well on greater_than_or_equals, greater_than, lower_than_or_equals, and lower_than. It still works fine with other defined compare values such as "TODAY" , "TOMORROW",. But what I need is a special day. so this is the query I

I am coding an api in C# .net. Here is a query I send to Monday.com which works just fine and retrieves the items: {“query”: "{boards (ids: 5493163446) { items { id name state } } } "} I have patterned create_item after that but all of these seven mutations result in a Server Error 500. This is my first create so I could use some basic help, for example, do I need to use the word query or just mutation and is the mutation in quotes or curly braces, etc. I have removed any column values to try and simply the query as much as possible - could it be complaining because there are no column values, just the name? {“query”: "mutation: create_item (“board_id”: 5493163446, “group_id”: “new_group”, “item_name”: “This item imported programmatically”) " { id } } {“query”: "mutation {create_item (“board_id”: 5493163446, “group_id”: “new_group”, “item_name”: “This item imported programmatically”) } " { id } } {“query”:“mutation { create_item (board_id: 5493163446, group_id: “new_group”, item_name:

Hey folks, I want to say the sandbox is an AMAZING tool in exploring and composing my queries. I am attaching here a screenshot showing a minor css bug where in use cases like my own where I want a bit nuts with the amount of queries a scroll bar appears and then using it is a bit hard as the querybuilder window overlaps a bit with its position. Here’s a proposed fix:

Hi, It seems as though there has been a change with the monday-sdk-js library or integrations recently. We have been using the openItemCard action to open item cards for various items. monday apps framework We use this sometimes in board views, sometimes in dashboards, and sometimes in item views. We’ve noticed that currently the openItemCard action is only working when this is called within a board view, and for an item that exists on the current board. For all other scenarios when the action is called on either a dashboard, an item view, or requesting an item from a related board we get the following error. { "res": { "method": "execute", "data": { "success": false, "message": "Item <item_id> is not in the context of the current board undefined" }, "requestId": "..." } }

Hi, I have one query, in migration guide of 2023-10 it is written that “Migrate apps to use the API correctly”, so we are using monday.com platform only so any change required in app here from our end? Reference link:monday API docs

Hi everybody, On a board, we have a column with 3 values for example red; green and blue. Users can only select one value. Now we want to add a new value “pink” to our list value using the playground . Is there a simple way to add this new value and not update an item with this new value with create_labels_if_missing option !? And how to delete a value from a column list ? For example i do not want blue value anymore. Thank you

Hello, I noticed in the documentation (Mirror) that you can include a fragment in your query, as shown in the example: query { items(ids: [1234567890, 9876543210]) { column_values { ... on MirrorValue { column id } } } } However, when attempting to retrieve information with the fragment on a Mirror column that is not connected to a board, an error is returned: { "error_message": "Internal server error", "status_code": 500 }

The new API version (2023-10) now only gives a summarized version of the time-tracking log. It does not give individual users.

We are ‘citizen developers’ and new to Monday. We created two simple python API calls this spring that were working perfectly to return a really small board - until a week (or so) ago. Now we’re trying to update and running into issues. We got the call working for the simplest of our calls - the one where we don’t need mirrored column values, etc. But implementing the fragments for the display_value for data from a mirrored board is problematic. We have tried a multitude of variations in different versions in both the developer and the regular API playgrounds. Our current non-working version of the query looks like: query { boards (ids: 4304082965) { name id description items_page { items { name column_values { … on MirrorValue { display_value } } } } } } } What are we missing?

I would appreciate some details on the various filters supported for the date type column.monday API docs "TODAY", "TOMORROW", "YESTERDAY", "THIS_WEEK", "ONE_WEEK_AGO", "ONE_WEEK_FROM_NOW", "THIS_MONTH", "ONE_MONTH_AGO", "ONE_MONTH_FROM_NOW", "PAST_DATETIME", "FUTURE_DATETIME", "UPCOMING", "OVERDUE", "DONE_ON_TIME", "DONE_OVERDUE", "$$blank$$" What does `“$$blank$$” mean? / How is it used? How is "OVERDUE", "DONE_ON_TIME", "DONE_OVERDUE" used? The date column does not seem to have this information. If you use a filter like “TODAY”, how is the comparison done? Like does it find all date values within the “today range” for the user’s specific timezone or all “today” values in UTC? Is there any way to filter with a specific date or date and time. Like query_params:{rules:[{column_id:"date1",compare_value:["2023-11-16 05:00:00"],operator:any_of}]

Hello, I am currently in the process of moving all the boards for one of our clients from the American server to the European server. Unfortunately, in this scenario, the “Cross account copier” cannot assist. Therefore, I am using an integration via N8N using the Monday.com API. Unfortunately, I am facing an issue—I would like to transfer the updates for all items. The creation and assignment to items are successful, but unfortunately, the person assigned at the start of the update is not the same when it arrives on the European server. This is because the API does not provide the option to change the user with their email or ID. The update is automatically assigned to me. Do you have any ideas to suggest for allowing the assignment of the update to someone other than me, whether it’s by their ID or email? Thank you in advance for your responses. Best regards, Delépine Tom.

Hello! I have two connected boards trying to connect one item in board1 with multiple items from board2. I’m using apiVersion = “2023-10”. First of all, I tested this mutation in playground, and everything worked: mutation{ change_multiple_column_values(item_id:123456, board_id: 123456, column_values: "{\\"link_to_another_board\\" : {\\"item_ids\\" : [123457, 123458, 123459]}}") { id } } But, when I try to implement this code into my Python script, there are some issues with strings, backslashes, and variables. I only have 2 variables: # The int, contains items id from board1: new_item_id = r2.json()['data']['create_item']['id'] print(f'New item id: {new_item_id}') --> New item id: 123456 #The list of items from board2, which must to be linked with item above: print(f"linked_items: {linked_items}") --> linked_items: [123457, 123458, 123459] Now, I need to make ‘mutation query’. First, lets declare a variables for GraphQL schema: graph_var_id = {"item_id": int(new_it

Hi, This query below keeps failing despite numerous variations of date formats. I am running this in the app playground. Would appreciate some advice to understand what the right format is. mutation SetVolunteerInRequesterItem { change_multiple_column_values( item_id: 1317064012 board_id: 1317064001 column_values: "{\\"date42\\": \\"{\\\\\\"date\\\\\\": \\\\\\"2023-11-30\\\\\\", \\\\\\"time\\\\\\": \\\\\\"08:00:00\\\\\\"}\\"}" ) { id } move_item_to_group(group_id: "new_group73364", item_id: 1317064012) { id } } throws: { "error_code": "ColumnValueException", "status_code": 200, "error_message": "invalid value, please check our API documentation for the correct data structure for this column. https://developer.monday.com/api-reference/docs/change-column-values", "error_data": { "column_value": "{\\"date\\"=>\\"{\\\\\\"date\\\\\\":\\\\\\"Tue,\\", \\"time\\"=>\\"28\\"}", "column_type": "DateColumn" } }

Hello! I’m trying to integrate Companies House into my Monday.com board, so that it fetches account year ends, confirmation statement dates, and up to date addresses. I’m new to this and can access Companies House API information, but can anyone point me in the simplest direction?

Hello, please check issues, When i have uploading file in client side to the monday board then getting cors error.

I see a few topics on this but they are closed to new replies. I would like to control the naming of columns in the subitem, so that I’m not dealing with the default ‘text’, ‘text5’, ‘text7’ in my query creation efforts. I can create columns in a parent item via the API and name it whatever I want using: mutation{ create_column(board_id: 1234567, title:"Meaningful Column Name", description: "Test Column Creation", column_type:status) { id title description } } but when I substitute the board id for the subitem board, I get a 500 Internal server error in the API playground. Is there a way to create subitem columns with meaningful ids?

Hello, I’m currently working on a dashboard widget based app for the marketplace and I’m struggling to get values from formula columns. Does anyone have experience with this?

I am running into a problem where while creating a column with a status type and creating the possible labels, some labels are not appearing. However, the return json shows they are there and the column summary also shows there is a value there. Any idea what may be causing this? Am I hitting some sort of limit? Note, I skip label 5 because monday.com sets label 5 as the default empty value. def create_columns(board_id, title, column_type, default_values=None): if default_values: vals_dict = {} for cnt, vals in enumerate(default_values): if cnt == 4: cnt += 1 vals_dict[cnt + 1] = vals status_values = {"labels": vals_dict} else: status_values = '' query = """ mutation ($boardId: ID!, $titleName: String!, $columnType: ColumnType!, $defaultValues: JSON) { create_column( board_id: $boardId title: $titleName column_type: $columnType defaults: $defa

Hey all! I have a question that maybe you can help. Im creating a code in python that basically uploads / updates some data in Monday. In short, i have 2 separate folders with CSV files. My python code accesses those files and populates my board. one folder’s CSVs have what populates the values of one group and the other folder’s CSVs have what populates the sub items of one value (e.g: Folder1 > toyota.csv, nissan.csv, bmw.csv. Folder2> toyota-specs.csv, nissan-specs.csv, bmw-specs.csv). my board groups names are : Toyota, Nissan, BMW. in the toyota.csv column0 are several models of toyota cars. everyday this toyota.csv is renewed automatically with same or less or new models. i need my code to list all the items of the toyota group (or any other that is being checked), and compare column0 entries with the api json response of what the group already has as values. If theres something new i need to add it on monday and take the new id in order to use it for future updates. if so

Hi I need to query the items of a couple of boards for an internal system and to run some reporting on it. There is one board in particular that I receive the “500 Server Error: Internal Server Error for url: https://api.monday.com/v2” on some items but not all items. If I remove the column_values from the query, I am able to query all items. If I keep the column values, I am able to query some items but not all, even if I just query the name and id in column_values, it doesn’t work. Any ideas on what could be causing this issue?