General

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?

Hi there, whenever I create a item within a board the automations will automatically execute. But if I use the API to add a new item, the automations won’t be executed at all. Is there a way to run the automations when adding a new item using the API? Kind regards, Rik

Hi guys, I am trying to get some items of my team which are overdue using the following query: query { items_page_by_column_values (limit: 50, board_id: 4001269428, columns: [{column_id: “timeline”, column_values: [“PAST_TIMELINE”], compare_attribute: [“START_DATE”]}, {column_id: “priority”, column_values: [“Low”, “High”, “Medium”]}, {column_id: “people”, column_values: [“xxxx”,“xxxx”,“xxxx”,“Meir Peleg”,“xxxx”,“xxxx”, “xxxx”]}, {column_id: “status”, column_values: [“Waiting for xxxx”, “Working on it”, “No Started Yet”]}]) { cursor items { name creator { email } } } } What’s worng?

Hi, I can’t understand why my code is working on my staging site / staging monday board but not in the live environment. The request is exactly the same format for both environments but live is not processing the request. The API is not returning ANYTHING - usually it would send me back a syntax error or some reason the request didn’t work… So HOW do you debug an API query if the Monday API returns nothing to the caller??? EXAMPLE (working) [28-Nov-2023 03:48:09 UTC] {“query”:“mutation {addMembership : create_subitem (parent_item_id:5559740500, item_name: "Membership Renewal - Stripe", column_values: "{\\"item\\" : \\"Member Advantage\\",\\"amount\\" : \\"20\\",\\"date0\\" : \\"2023-11-28\\",\\"order_name\\" : \\"blep blep\\",\\"email\\" : {\\"email\\" : \\"blep@blep.com\\" , \\"text\\" : \\"blep@blep.com\\" }}") { id } }”} [28-Nov-2023 03:48:09 UTC] Response-----> [28-Nov-2023 03:48:09 UTC] Array ( [data] => Array ( [addMembership] => Array ( [id] => 5580876159 ) )

I can insert an item if it looks like this $mutationQuery = 'mutation { create_item( board_id: ' . $boardId . ', group_id: "' . $groupId . '", item_name: "' . $cursus . '" ) { id } }'; but when i try to insert any value to another column i always get an error, am i doing something wrong?. this the code i have $mutationQuery = 'mutation { create_item( board_id: ' . $boardId . ', group_id: "' . $groupId . '", item_name: "' . $cursus . '", column_values: { "lange_tekst": { "text": "'.$cursus.'" } } ) { id } }'; this is my full code if you want to know if ($_SERVER["REQUEST_METHOD"] == "POST") { $token = 'MY_API'; $apiUrl = 'https://api.monday.com/v2'; $headers = ['Content-Type: application/json', 'Authorization: ' . $token]; $cursus = 'lolinit'; $boardId = '5554649549'; $

Hey, I want to build an integration between my software and MONDAY. My goal is to report working hours on projects in my system, and make an API call to update the MONDAY. I don’t really know the method with GRAPHQL, I wanted to know if there are other options? Any request I can send in POSTMAN in raw and not in Graphql? Thank you

I use the following query: query {next_items_page (cursor: “cursor_string”, limit: 50) {cursor items {id name column_values {id value …on MirrorValue {display_value} }}}} the query works as expected if we neglect the term “…on MirrorValue {display_value}”, but returns an internal server error 500 when included. Is there a way that I can make this work?

Trying to use the API to return email address(es) for any people columns for a given item. It would seem that “email” is not a valid field for “persons_and_teams” and I am only able to get the ID/s. I’m assuming there is a way to accomplish this using variables or nesting queries, but I just haven’t learned enough about QraphQL yet 🙂 It would also be nice if there was a way to filter the returned data to only show people columns that are not empty. That filter only seems to work on items page, but couldn’t figure out how to make that work with just one specific item. (there are 5 people columns on the board, and typically not all of them are set) Was hoping someone could point me in the right direction for any work arounds to accomplish this! Thanks, Matt

Hello community, I am working on a software in react/node, and I was wondering if it is possible to create a contact person or lead through an integration in our software. If this is possible, could you please direct me to the correct place in the docs, since I can’t seem to find it. Thank you in advance!

Attempted to create a Feature but encountered an error while executing this command: npx @mondaydotcomorg/monday-cli@latest scaffold run ./ quickstart-react -t item-view-10114722 CLI execution and console output (results): npx @mondaydotcomorg/monday-cli@latest scaffold run ./ quickstart-react -t item-view-10114722 Starting scaffolding process Repository was downloaded successfully Copying the directory Started injecting data to .env file Finished injecting data to .env file Installing packages. It can take a few moments Node modules were installed successfully Running the project monday-react-quickstart-app@0.0.1 start npm run stop && concurrently “npm run server” “npm run expose” monday-react-quickstart-app@0.0.1 stop kill-port 8301 && kill-port 4049 && kill-port 4040 0 process was killed 0 process was killed 0 process was killed [0] [0] > monday-react-quickstart-app@0.0.1 server [0] > react-scripts start [0] [1] [1] > monday-react-quickst

so i want to build an integration type app and i was following the guides online and then suddenly this happend. So basically i copied the npx thing in my cmd and then it started some process but when it said [nodemon] starting node ./src/app.js it was just stuck. I thought it’s just taking awhile but it has been 2 hours and nothing is happening.

Hi all, We are importing with the API account using the country field. An error occured when we tried to inject the “RE” code “La réunion” or “Reunion island”. We found the country code comes on the Monday API documentation from the following URL : Country This URL redirect to the following JSON file : http://country.io/names.json the “RE” code exists in this file but the API refuses it. When we try to type this country on a board, the country doesn’t exists. Is it a bug because of the accent “é” ? Is this country recently hidden ? Is the JSON is outdated ? If other countries are in the same case, can you give us a list of these ? Thank you for your help

Hello good morning. a general question. I would like to be able to see and read information about creating an app in the item view. The information I have found so far has not been enough. If there is a guide or a step by step it would be the most ideal. thanks in advance.