API & Apps framework

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.

mutation { mut1(...) {...} mut2(...) {...} ... } If I execute multiple mutations in the same request, assuming mut1 succeeds and mut2 fails, will the API roll back the changes made for mut1? So if one fails, all fail? Or will the changes from mut1 be kept? From the GraphQL specification, if I understand correctly, mutations are executed sequentially, and there is no information in case of failures. I did find that the Hasura GraphQL engine rolls back the changes, but I wanted to ask if this is also the case for Monday.hasura.io " If multiple mutations are part of the same request, they are executed sequentially in a single transaction. If any of the mutations fail, all the executed mutations will be rolled back."

With addiing complexity I get that the query is 3095, which is still okay no? { “data”: { “complexity”: { “before”: 10000000, “query”: 3095, “after”: 9996905, “reset_in_x_seconds”: 60 }, With the following next page: query{ next_items_page( cursor: “MSwzODY4Mjc4NDMwLDhfaWxtVTJhQWVqLS1IMjl3dE0tQiw0MjMsMix8MzI3ODM3ODYwMw” ) { cursor items { id column_values { column { id title type } value text } column_values { ... on MirrorValue { column { id title type } display_value text } } } } } I get an error response 🙂 { “errors”: [ { “message”: “Failed to fetch”, “stack”: "TypeError: Failed to fetch\\n at https://monday.com/nhp/_next/static/chunks/d310b1ebcb21564b607af0377ef0e1240c79bee0.dd6c8b0f89ced6ba8a82.js:1:13303\\n at https://monday.com/nhp/_next/static/chunks/pages/_app-11ac16eedf3cc32ce5ee.js:1:30591\\n at o (https://monday.com/nhp/_next/static/chunks/pages/_app-11ac16eed

Hi, struggling to use Graph API for basic stuff. I can create new items in a board using long hand query mutation, but the same query wont work when using column_values. This works fine { "query": "mutation ($boardId: Int!, $itemName: String!){create_item(board_id: $boardId, item_name: $itemName, column_values: \\"{\\\\\\"text\\\\\\":\\\\\\"a text value\\\\\\"}\\"){id}}", "variables": { "boardId": 12345, "itemName": "new item" } } But when i try convert column_values to a variable, it doesn’t work, 500 Internal Server Error. { "query": "mutation ($boardId: Int!, $itemName: String!, $columnValues: JSON!){create_item(board_id: $boardId, item_name: $itemName, column_values: $columnValues){id}}", "variables": { "boardId": 1234, "itemName": "new item", "columnValues": { "text": "some text" } } }

We are working through our transition to the 10-2023 API changes and have hit a dead end. Our previous use of the item_by_column_values uses the state = “active” argument to retrieve only active items for from a board. Is there any way to add this filter to a query utilizing the new item_page_by_column_values now that the state field is no longer an argument.