API & Apps framework

Hello I’m trying to get through graphql the lookup values represented in a mirror column. The returned value is null, for which I asume lookup columns need to receive the parent id of the connected board in the query, but I’m not sure how to elaborate on that. { boards(ids: 3072864141) { items { id name column_values(ids: ["mirror"]) { value } } } }

Hi, I I have ran the following Python script and received a message: {“data”:{“add_file_to_column”:{“id”:“639126111”}},“account_id”:7384772} But in the item Files column the file is not displayed. Here is the script: import requests url = “https://api.monday.com/v2/file” payload={‘query’: ‘mutation ($file: File!) {add_file_to_column (file: $file, item_id: 1455154608, column_id: “files”) {id}}’} files=[ (‘variables[file]’,(‘Board_Subitems.txt’,open(‘C:\\MyData\\Monday\\Files\\Board_Subitems.txt’,‘rb’),‘text’)) ] headers = { ‘Authorization’: ‘XXX’, } response = requests.request(“POST”, url, headers=headers, data=payload, files=files) print(response.text) I would appreciate some help. Thanks!

Hi, I am looking for some help writing script for monday.com where I need to change multiple items & their connected column values. I have got to a point where I need support on writing and executing the script in monday.com. thank you

do we have pagination support both “page” and “limit” for Workspace, Group, Item, Column and Column Values in a single query (GraphQL)???

Hi, I am retrieving the json code from API successfully from the board selected but cannot manage to parse the data using PHP $responseContent = json_decode($data, true); Specifically, I get the below result from above: {“name”:“Subject Name”,“column_values”:[{“id”:“subitems”,“type”:“subtasks”,“text”:“”},{“id”:“email4”,“type”:“email”,“text”:“”},{“id”:“text8”,“type”:“text”,“text”:“”},{“id”:“long_text”,“type”:“long-text”,“text”:“”},{“id”:“person”,“type”:“multiple-person”,“text”:“John Doe”},{“id”:“status”,“type”:“color”,“text”:“New”},{“id”:“time_tracking”,“type”:“duration”,“text”:“1244:02:22”},{“id”:“creation_log”,“type”:“pulse-log”,“text”:“2022-08-22 13:08:10 UTC”},{“id”:“date”,“type”:“date”,“text”:“”},{“id”:“text5”,“type”:“text”,“text”:“”},{“id”:“requestor_email3”,“type”:“text”,“text”:“”},{“id”:“formula9”,“type”:“formula”,“text”:“”},{“id”:“files”,“type”:“file”,“text”:“”},{“id”:“item_id”,“type”:“pulse-id”,“text”:“3dffdf99”},{“id”:“dropdown”,“type”:“dropdown”,“text”:null

Is anyone aware of a way to update a single column with a new value for all items in a board, with a small number of GraphQL mutations? I don’t see anything suitable in the GraphQL API without having to make N mutations, one for each item in the board, which I’d like to avoid if possible. I wonder if anyone else has hit this problem and has come up with any creative solutions (Formula columns etc)? The create_column defaults option would be one option here, however it does not appear to work, and I see from GraphQL API: Hide columns (& general defaults) that it is recommended not to use it and “it is under revision at the moment”.

We have a board of “kits” I want the ability for our staff members to checkout kits. I would like to have a form with a dropdown where they can choose an available kit. So I am wondering, is it possible via the API to change the labels of a status column? This would help me get the functionality that I desire.

Is there a way for me to export a board to Excel through the API? Have the file passed to the requesting app, rather than downloading automatically? We have boards that we reuse each day, with a group at the top that always stays there, and the other groups get archived at the end of each day. We export all the boards to excel before archiving groups, to have a record of what happened each day. We then have a folder on the hard drive for each day, and move the excel files into it. I’ve just gotten Make.com set up to do some other things for me, and have started wondering if there’s a better solution, first for automating the export/archive process, and also possibly storing the excel files somewhere online where its easier to look through them. I realize I can grab all the data in a board and place it somewhere else, but wonder if that’s not just reinventing the wheel when the Export to Excel option alrea

Hi! I’m trying to build a test integration but keep getting the same error when running the scaffold command in my commandline: “error: unknown option -t”. Any idea how to troubleshoot this? Node version is 16.16.0, NPM 8.14.0.

Hello everyone, I’m trying to figure out the best way to detect whether an item has changed since the last time i have looked at it via the GraphQL API. This is my situation, I am synchronizing a number of records between a SQL database and Monday. On the SQL side I have a field that contains the hash of the record content at the last time the record was synced to Monday and one dynamically changed with the hash as the record currently stands. This way i can easily compare the current status and determine if some change has occurred. I am looking for a similar method on the monday side. Of course I can store the current hash when writing to monday via API. I am looking for an easy way to detect any subsequent changes (without having to load all items and generate/compare hashes). Any idea? Has anyone solved this problem already? How? Thank you in advance.

{ "query":"{mutation(myItemName: String){ create_item (board_id:2364371628, group_id:XXXXXX, item_name:\\"New Leads\\", column_values: $variables) { id } }", "variables": {"email":"test2@test2.com","firstName":"test2", "lastName":"test2", "companyName":"test2", "phoneNumber":"1234567890", "message": "here is a sample message"} } I’m trying to pull lead data from Marketo and send it into Monday.com via a webhook but can’t figure out how to write the correct query? I’ve added my key to headers so I know it is working. “New Leads” is the group Name but not sure how to get the Group ID. What else am I missing and how do I fix the query? The error I am getting is: { "errors": [ { "message": "Unexpected end of document", "locations": [] } ], "account_id": 6562763 }

Hello! I’m working on a bash script to perform multiple automations in monday. The script is already able to create boards, create groups, create items in the correct group… the only thing missing now for me is to enter a value into a specific column for a new created item. Can someone maybe help with this? I’m new to the monday API or GraphQL API in general. This line of code works to create an item and I know the ID of the column I want to add a value in is “numbers”. What would I have to add to this line to do this? curl --location --request POST ''https://api.monday.com/v2'' --header 'Authorization: '$APIKey'' --header 'Content-Type: application/json' --header 'Cookie: __cfduid=d4512e647bd3dd90706f5673d6041f7c51618840981' --data-raw '{"query": "mutation { create_item (board_id: '$boardID', group_id: '$buildingPhaseID', item_name: \\"TEST ITEM\\") { id }}"}' Thanks in advance for your help with this!

I am new to Monday and wish to use data from external resources or databases to fill tables in dashboards on monday. Can anyone guide me through this or at least point me to the right direction?

Hello, I didn’t find the way to change the state of an item. My goal is to find an item in the recycle bin and move it to a new group in a board… thanks

Hi all, Random question I’m hoping someone may be able to help with. Our firewall team are currently trying to establish a connection between a Power BI on-premise server and the Monday.com API. They have opened up the firewall to allow 104.16.11.42, but are seeing denies on 20.190.159.64 and 40.126.31.71. Could someone please confirm if these IPs are part of api.monday.com/v2? Just need confirmation of the IP’s we should be whitelisting to establish the connection. Many thanks, Rich

For those that are familiar with JS/CSS, there are ways to hide specific elements on a website. On Chrome, specifically, I’ve had my team use the following extension:chrome.google.com I then added the following CSS .monday-board-subsets-tabs .monday-board-subset-item-v2:nth-child(2) { display: none; }``` This makes it so that the **second HTML Div / view** gets hidden. I did this because I have an overview set as default... Now this code clearly hides the main table view for everyone. Not sure if an app can be made to apply this conditionally based on each user but the Chrome extension itself allows you to enable/disable the functionality. I manually set this up on each team member's computer so they don't have access to the main view. I'd like to see Monday have this as an

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 expe

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 it

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).

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 } }" U

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: