General

Hi there, We’re looking to use make.com (formerly integromat) to duplicate a group including items and updates. Seems the duplicate_group() mutation does not include updates which is super frustrating as we’re having to use updates for task descriptions due to the lack of a ‘task description’ field. Is there anyway to duplicate a group either through the API or otherwise and include the updates? We have integromat using the API to duplicate an item so worst case could we create a monday.com automation to duplicate the group when a new item is created? Thanks all, tried support first but they directed me here! Cheers Noel

We’re building a search tool that allows our customers to search for Monday.com Workspaces and Boards, as well as results from other software tools all in one place. I was hoping to learn if there is a Monday.com sandbox environment that allows us to test user-level permissions. The only information I had seen was on this discussion. Is there a way for us to test user-level permissions without an enterprise account?

Hi , when i am using the change_column_value with C# code with below string : string query = "{"query" : "mutation { change_column_value(board_id: " + boardId + “, item_id: " + itemId + " , column_id: \\"” + columnId + “\\", value: \\"” + value + “\\") { id } }"}”; it is working but when i am using the change_multiple_column_values with C# code below string : string query = "{"query" : "mutation { change_multiple_column_values(board_id: " + boardId + “, item_id: " + itemId + " , column_values: "{ \\"” + columnId1 + “\\" : \\"”+ columnValue1 + “\\",\\"” + columnId2 + “\\" : \\"” + columnValue2 + “\\"}") { id } }"}”; so its not updating the data and give the error The request was successful but contained no data so please if i am wrong so please correct me .

Greetings from the dystopia of nested backslashes. I hope to save you some trouble even if I myself am not fully free of it. Many Monday posts exist; however translating them into something executable for Google Apps script has not been obvious, which is unfortunate because Google Script is among the most accessible ways for casual users to leverage the Monday API for small tasks. Getting started is as easy as typing script.new into your browser address bar and following the prompts. Key insights thus far on Monday / Google Sheets integration: Across Monday boards, Column IDs vary for the exact same Column Name. No fetchColIDFromName kind of function exists; thus you’ll need to loop all columns and match on the expected name. The code block is not rendering properly in this venue, so please see getColIDFromName here Google Apps Script expects the word “payload” instead of “body” (see working examples at mondayintegration/monday.gs at main · bridge2ai/mondayintegration · GitHub) passi

Hi Everyone, I’m trying to use the API to input a url generated from on board elements into a link column in python. I’ve C&P’d my query as you can see the url and text for the link column are variables I’m unsure how to actually write the query so that the API understand what I’m sending. query = 'mutation ($boardID:Int!,$itemID:Int!,$colID:String!,$linkVal: JSON!) { change_multiple_column_values(item_id:[$itemID],board_id:[boardID],column_values:$linkVal)}' vars = { 'boardID':boardID, 'itemID':itemID, 'colID': colID, 'linkVal': { 'colID': {'url': itemURL, 'text': itemName} } } Full Code: boardID= myBoardID query = 'query ($boardID:Int!) {boards(ids:[$boardID]){items {id name}}}' vars={ 'boardID': boardID } data = {'query': query, 'variables': vars} r = requests.post(url=apiUrl, json=data, headers=headers) # make request itemsInjest=r.json() itemsDict=itemsInjest['data'] itemsVal=itemsDict['boards'] itemsURL = []

IN the output “{"query":"query { boards (ids: 2211958476) {owner{ id } columns { id title type }}}"}” I have one of the column { “id”: “people”, “title”: “CD”, “type”: “multiple-person” } with type “multiple-person” I need example how to write update this column [cURL Examples for API] like as examples on the (cURL Examples for API v2 :))

I build a Monday integration that gets data from an external source every day. When I use this integration on my own boards they work fine, but when I integrate the integration on the board of the company im working for the board won’t update and I get the error: "Permission Denied! Your token doesn't grant access to boards:write" The integration that the error returns is “Import data - Integration” (red underline in the screenshot). I checked the permissions for the full application I’m building. As you can see in the screenshot below I have the boards:write permission activated (blue arrow). So my question is: How could I get rid of this error? Is there a separate user permission that needs to be activated? Or am I missing something else? Thank you in advance!

Lately, I have a persistent problem caused when I try to upload data to a Monday Board via the GraphQL API. I know a similar problem when reading a board’s content, and using the “limit” param to overcome it. However, it happens not for reading content, but writing to the board. When I try to render a json response as I used to do for the past months, I receive an HTML snippet with the following strings: "cf-error-details cf-error-504"> <h1>Gateway time-out</h1> <p>The web server reported a gateway time-out error.</p> <ul> <li>Ray ID: XXX </li> <li>Your IP address: XXX </li> I use the following query to upload data: "mutation ($myItemName: String!, $columnVals: JSON!) { create_item (board_id:" + board_id + ", item_name:$myItemName, column_values:$columnVals, create_labels_if_missing: true) { id } }" Update: Likely I had to use group_id as well, as documented here: https://api.developer.monday.com/docs/items-querie

Hey all! We’re building an app that triggers notifications from the server side. We are using the graphql create_notification mutation, passing the user’s id, target_id (board_id) and text. As a token, we use one that is generated using the authorization flow. The notification’s text is showing as expected, but the title shows the user’s name and logo, instead of the App’s name and logo: Is it possible to use the App’s name? After all the action was made in the background by the App, and not by the user. Thanks!

Does anyone know if you can layer an external map onto of a Monday.com map? In Monday.com we have a map displaying all jobs to be scheduled and we have a seperate GPS tracking app showing the locations of our technicians I would love to be able to put the GPS app onto of the Monday.com map

Let me (re)introduce the Excellent Team rollup apps in this full (35 min) instruction video. Rollup Multiple Boards aggregates information from detail boards into real monday.com columns. The detailed boards are created from the master board based on monday.com templates. With the available integrations you can summarize almost any column form your detail board(s). Each item in the master board represents an entire detail board. With filtering you can easily define which items (default is ALL) from the detail boards are used in the master board. The RAG traffic light status column let you define the rules when a detailed board’s overall status is Red, Amber of Green. This is an existing app (over 500 customers). Rollup Subitems is a our latest app and aggregates subitem data into the parent item. This is a good alternative if you don’t want to use the standard “Show summary in parent” option because you have items that doesn’t have subitems and you want to enter the information directl

Hello, I apologize if this is already common knowledge, but I was unable to find an example of this in my search of the community. Essentially, I attempted to use the “items_by_column_value” query, utilizing the users’ Id as the “column_value” argument. I realize that the column value of a “person” column type is JSON, thus zero results. Please correct me if I am wrong, but there is no way to utilize wildcards in the argument. Is there an example of querying items by user?

Hi all, I am new to monday.com and also to GraphQL, so I had to figure everything from scratch. Currently I am developing app, where I need to upload file to specific database column. Columns looks like this: files_1 : { id: "files_1", text: "https://something.monday.com/protected_static/ID/resources/ID2/image.jpg", title: "Dedication Image", type: "file", value: (JSON.stringify value of text...) } When I want to access photo and display it on web, I need to query with assetID and then I receive publicURL. That was for querying. What I need is upload file from web to monday.com I triend every single solution that I had in mind or I found on google, but nothing helps me. Here is my function for uploading picture: var formData = new FormData(); formData.append("query", `mutation addFile{add_file_to_column (item_id: 3286592696, column_id: files_1, file: ${file}) {id}}`); formData.append('map', '{"image":"variables.file"}'); formData.ap

Hello every one, I need some help please. I use a simple board, an item is assigned to a group of person. This is the structure : {“name”:“Thing to do”,“column_values”:[{“id":“person”,“type”:“multiple-person”,“text”:"user1@mydom.com, user2@mydom.com”},{“id”:“status”,“type”:“color”,“text”:“Done”},{“id”:“timeline”,“type”:“timerange”,“text”:“2022-09-19 - 2022-10-01”},{“id”:“texte8”,“type”:“long-text”,“text”:“Good job”}]} I managed to folow the QuickStart PHP Api Guide and populate the main Label, the status and the last “text8” label. But I can’t manage to populate the timeline column and most of all, the person column. I think there is something about Person ID (I managed to find all the IDs). I tried this : $headers = ['Content-Type: application/json', 'Authorization: ' . $token]; $query = 'mutation ($myItemName: String!, $columnVals: JSON!) { create_item (board_id:XXXXXXXXX, item_name:$myItemName, column_values:$columnVals) { id } }'; $vars = ['myItemName' => 'Thing to do', 'co

Hi all, I was using the api in bubble.io and can’t seem to edit the column values within the call. Here is the POST call {“query”:“mutation { create_item (board_id: 3188858191, group_id: “topics”, item_name: “”, column_values: “{“what_is_your_first_name_” : “value”}” ,) {id, name, column_values {id, title, value}}}” } if i remove the column_values section it works fine and if I make a separate call just to change an existing items columns, that works too but I can’t seem to get it to function when making a create_item call. error message: “message”: “Parse error on “what_is_your_first_name_” (STRING) at [1, 99]”, “locations”: [ { “line”: 1, “column”: 99 } ]

Hi, I am using the below query to retrieve all the updates, the below query throws an error as well as response. Is this an expected behavior? { updates(page: 12, limit: 100) { assets { created_at file_extension file_size id name uploaded_by{ birthday } original_geometry public_url url url_thumbnail } } }

Hi all, definitely not a developer here just trying to learn more about the API as I have a meeting coming up with several developers and don’t want to appear a total idiot… Just wondering if somebody can share with me or point me to a list of all the column types available via the API? (Create, update, read). I have seen “it’s in the API docs” posted in several support threads but despite searching for quite some time can’t find it anywhere. I’m hoping some kind person out there can point me in the right direction. Cheers, Patrick

Choice Number: 3896 Pay Load: { “query”: “mutation ($boardId: Int!, $companyName: String!, $columnVals: JSON! ) {create_item (board_id: $boardId, item_name: $companyName, column_values: $columnVals) {id}}”, “variables”: {“boardId”:2364371628, “companyName”:““test23LastOne””, “columnVals”: “{“phone”:”“7169084086"”,“text”:““test23LastOne””, “text4”:““test23LastOne””, “long_text”:““test23LastOne””, “status4”:“Website Form”,“email”:{“text":""test23LastOne@test.com” “,“email”:""test23LastOne@test.com” “}}”} } Url: https://api.monday.com/v2 Webhook Id: 10 Webhook Name: MarketoToMonday Request Type: http_post Step ID: 3630 Source: Marketo Flow Action Response: {“errors”:[{“message”:“No query string was present”}],“account_id”:6562763} Person ID: 3238884 Response Code: 200 Here is my code: { "query": "mutation ($boardId: Int!, $companyName: String!, $columnVals: JSON! ) {create_item (board_id: $boardId, item_name: $companyName, column_values: $columnVals) {id}}

Hello everyone ! I’m looking for a solution to this problem : I want to read directly in a number column a value from a Json file while knowing the associated key of this Value. Exemple : My API call > https://api.snowtrace.io/api?module=account&action=tokenbalance&contractaddress=0x....&address=0x....&tag=latest&apikey=MyKey The API return : {“status”:“1”,“message”:“OK”,“result”:"19043221718329235974770 »} And I want to fill my number column with the value associated to result key. Then I need to make an automation to refresh value on demand. Is it possible to build this kind of parsing tool directly in monday table column ? Thanks in advance for your help. Regards

let’s say I have a board like below, I want to update the Status column based on the item id. I want to update the text of Customer Status column if a matched item id was found. In this case, the text ‘Active’ will be change to ‘Inactive’. How to do it python? I tried: query = ‘mutation ($columnVals: JSON!) { create_item (board_id:1234, item_name:12345, column_values:$columnVals) { id } }’ vars = { ‘columnVals’ : json.dumps({ ‘status3’ : {‘text’ : ‘Inactive’} }) } data = {‘query’ : query, ‘variables’ : vars} r = requests.post(url=apiUrl, json=data, headers=headers) jsondata = r.json() print(jsondata) board item info: “boards”: [ { “name”: “myboard”, “id”: “1234”, “description”: “”, “items”: [ { “name”: “12345”, “id”: “1234567”, “column_values”: [ { “title”: “Subitems”, “id”: “subitems”, “type”: “subtasks”, “text”: “02342” }, { “title”: “Customer Status”, “id”: “status3”, “type”: “color”, “text”: “Active Customer” }] } ] } ]

when we trying to retrieve sub item(board id is of subitem board) we observed first subitem has parent_item id as null in this query { boards(ids:[1234]){ items { id, name, subitems{ id name } parent_item { id } } } }

I want to pull all board Ids and corresponding ItemIds and its columns.I have list of BoardIds with me.So when I try to loop below query through list of board Ids its giving result for the first board id of the loop takes and showing same data for all the board Ids. Query- { boards(ids: $(vboardsId)) { id name columns { title id type } groups { title id } items { id name group { id } column_values { id text title value }}}} Where - $(vboardsId) variable of for loop which providing board Ids Is it so once we hit the query ,api takes some time to refresh or something as I have traced the loop and boardId its working fine but result is same for all

Hi devs, is this policy correct? https://developer.monday.com/apps/changelog/clarification-on-retry-policies-for-webhooks-and-custom-actions As far as I can see in our tests, when a non-200 HTTP status is returned, monday retries every 30 secs for 10 times, then stops.

Hi all, I am trying to get column IDs on GAS (google apps script) with the code below. But I am getting an error with below. Could you please help me out? Thank you! function getBoardDataClicked() { // This function is run when the “Get Board Data” button is clicked const boardId = getBoardId() // Get board-specific group data from Monday.com and set it to sheet: const boardName = getAndSetData(boardId, ‘groups’, ‘A6’) // Get board-specific column data from Monday.com and set it to sheet: getAndSetData(boardId, ‘columns’, ‘D6’) // Set board name to sheet: setboardName(boardName) // Redetermine column widths: autoResizeColumns() } function getAndSetData(boardId, type, startCellAddress) { // This function gets board-specific data from Monday.com and set it to sheet. // The type of the retrieved data is specified by the “type” parameter. // “startCellAddress” determines the location in which the data is to be pasted on the sheet. // Make HTTP request: const resData = getData(boardId, ty

Hi, How to know if user is a viewer on board/dashboard view (client side- react) when app is loading? Basically I would like to display a proper “missing permissions” message instead of the app display, in case it’s a viewer. Code sample will be great. Thanks Roi