API & Apps framework

Hi, I have a Google Sheet with file names and Monday pulseIDs. I am trying to write a script to cycle through the files and add them in Monday to the specific pulse. I have use the API many times from Google sheets and it works great. I have not been successful with files though. I have been trying to use my understanding of the typical structure, then reading posts on Monday community about uploading files and looking at other sources how to do similar things with GAS. I have not had luck yet. Here is what I have so far, it just returns an unsupported query erro: function testFile(){ var fileName = “Copy of Workspace files metadata (backup) - backup.pdf”; var url = “https://api.monday.com/v2/file”; var file = DriveApp.getFilesByName(fileName).next(); var boundary = “xxxxxxxxxx”; var data = “”; data += “–” + boundary + “\\r\\n”; data += “Content-Dispositio

I’m trying to test requests made to the Monday.com files API, and so far, I can’t any queries to successfully go through. I keep getting a 400: Unsupported query with all my attempts. Here’s what I have in Postman:

Hi, I just found out about the monday.com hackathon and would like to participate. It said that the registration period was in Sept., but can I still register and participate?

Hi. Monday.com has a lot of automation for cases (When a status changes to something). But I need to make the custom POST request with the changed item to a third party service. Is there any way to implement this automation? Thanks!!

Hi, I am working on a monday app integration,where a column change triggers an event and that event is sent to web url specified. I am receiving the event to url I have specified. Is there any way to identify from which account(account id) this event has been triggered from? I need this information as I have a custom requirement to identify which application has sent this event

Hi, I’m building a way to automate the duplicate and creation of group items in my monday board through Google Sheet and Appsscript. However, I’m facing a problem with Parse error on “-”, and I can’t seem to get rid of it even after trying to escape it from my variable. Some help here will be good. I’ve copied the code below with an example of the escapedFullProjectName variable function overviewGroupCreate(escapedFullProjectName){ //Create Monday board and tasks lists of it var escapedFullProjectName = xxx-1234 var mutation = ‘mutation{ create_group (board_id:’+overviewId+‘, group_name:’+escapedFullProjectName+‘) {id} }’; var response = UrlFetchApp.fetch(“https://api.monday.com/v2”, { method: ‘post’, headers: { ‘Content-Type’: ‘application/json’, ‘Authorization’: apiKey }, payload: JSON.stringify({ ‘query’: mutation }) }) var j

Can I use Bootstrap Library when developing Monday app?

How do non-admins get their personal API key? The API authentication documentation says: “Each user has their own API token, which grants API access to all the boards to which the user has access.” But the instructions just below that for accessing your tokens say the page for accessing API tokens is only available to admins. And that page only generates the user’s own API key — it’s not as if it allows admins to generate keys for other users.

If two people are using the same custom board (React App), how can we get information for each user? We want to figure out which one is a member of the workspace, and which is a guest? I wasn’t too sure how the board could access this info using the Monday sdk. Thanks!

From my app, I’m trying to trigger openItemCard from the Monday SDK. The default type “columns” throws an error that stops the trigger: What I am doing: Running monday.execute('openItemCard', { itemId: 123456, kind: "columns" }); or monday.execute('openItemCard', { itemId: 123456,}); throws an error in the Monday’s code: Uncaught TypeError: l is undefined l https://cdn7.monday.com/build/main-92c6af2e815f8ce30536.js:2 r https://cdn7.monday.com/build/vendors-8b983c6b8b35df3f7db5.js:2 dispatch https://cdn7.monday.com/build/vendors-8b983c6b8b35df3f7db5.js:2 openPulseCardAction https://cdn7.monday.com/build/main-92c6af2e815f8ce30536.js:2 r https://cdn7.monday.com/build/vendors-8b983c6b8b35df3f7db5.js:2 l https://cdn7.monday.com/build/vendors-8b983c6b8b35df3f7db5.js:2 value https://cdn7.monday.com/build/main-92c6af2e815f8ce30536.js:2 receiveMessage https://cdn7.monday.com/build/main-92c6af2e815f8ce30536.js:2 Running

Hello all, I’m having difficulties with clearing all files from a file column. I understand I should set clear_all to true when sending this request but where exactly should I all this variable? do I need to use the change_column_value method? should I send it to v2 or v2/file? I would be grateful if someone could share an example of the entire GraphQL query for clearing files. Thanks.

Hi! I am trying to create different subitems through a mutation, wiht information from different arrays. But it only creates one subitem from the first array’s info. Can someone tell me what its wrong with my code?: for (let i = 0; i < steps.getsubitems.$return_value.values.length; i++) { var data = { query: mutation ($parentitemid: Int!, $itemName: String!, $columnVals: JSON!) { create_subitem ( parent_item_id: $parentitemid, item_name: $itemName, column_values: $columnVals ) { id } }, variables: { parentitemid: 849540602, itemName: steps.nodejs_1.$return_value, columnVals: JSON.stringify({ “texto71” : steps.getsubitems.$return_value.values[i][1], “texto1” : steps.getsubitems.$return_value.values[i][2], “texto9” : steps.getsubitems.$return_value.values[i][3], “texto15”: steps.getsubitems.$return_value.values[i][4], “texto3”: steps

Hi All I was a winner for one of the prizes at the last hackathon. I haven’t received the prize yet and was wondering if there are others who are waiting or know anything about it. I spoke to the Monday team who said they’re looking into it. I’m sure everything’s fine but just wanted to check how is it with others. Thank you. Amit

Most of the tutorials I searched on the internet for integrations on monday.com is all about adding notification, sending event. Is there any tutorial for integrating third party apps like github account, zoom, gmail etc?.

Hello! This is my first post here as I just started working on a Monday.com app. My app is a board view. I was able to set up everything, and it works fine on the frontend. I have encountered a problem on the backend of my app. I’m able to successfully verify user sessionToken(obtained in the browser via await monday.get("sessionToken"), sent to backend, verified on the backend with jwt.verify(sessionToken, '...')). Now I would like to make use of monday.api on the backend, and no matter if I’m using monday.setToken or passing token in options to monday.api - I’m getting “Not Authenticated” error. I assume I did not understand something, any help/suggestions are appreciated. Thanks!!

Hello, I’ve been sending queries from a VBA macro in Excel, as I need to ensure my board is in sync with an excel file I get each week. I can’t figure out how to create a query with change_multiple_column_values. This is what I’m sending to the API and just get a 400 error. {“query”:“mutation { change_multiple_column_values ( board_id: XXXXXXXX, item_id: XXXXXXXX, column_values: “{"oppty_owner_name": "TEST NEW"}” ) { id }}}” Few questions: Do I have to have the “query”: or, can I just start with mutation? Can anybody tell me what’s wrong with the query? Thanks, Chris

I’ve been working on uploading a file to an item, and I’ve been receiving some cryptic errors from the API. Here’s my code snippet: return monday.api(` mutation addFileToColumn($file: File!) { add_file_to_column( item_id: ${itemId}, column_id: "${columnId}", file: $file ) { id url name } } `, { variables: { file }, }) where itemId is for sure an existing item (I do this immediately after creation), columnId is files, and file is a javascript File instance. I’ve seen [Released] File upload via Monday's SDK client side - #3 by pepperaddict, which seems like it might be a workaround. But I wanted to report this to see whether there’s something obvious I’m missing and doing wrong. Note I haven’t tried this in a non-d

Hey, I’m quite new to Monday.com’s API and I’m trying to insert a new item via C#. I’m using the code below, but when I execute it, I’m getting a 404 error. I went through the query part-by-part, and when I modify it to remove the {id} part, the code seems to execute without error, but doesn’t insert any records. I’m guessing the problem is the formatting of the query, but I just can’t seem to identify it. Does anyone have any suggestions? var query = @“{”“query”“: ““mutation {create_item(board_id: ########, group_id: "“test"”, item_name: "“John Doe"”) { id} }”” }”; var httpWebRequest = (HttpWebRequest)WebRequest.Create("https://api.monday.com/v2/"); httpWebRequest.ContentType = "application/json; charset=UTF-8"; httpWebRequest.Method = "POST"; httpWebRequest.Headers.Add("Authorization", _apiKey); using (var streamWriter = new StreamWriter(httpWebRequest.GetRequestStream())) {

Hi, I ran npm run build to build my project, then compressed it and uploaded build.zip to Monday.com. However, now, when I go to board view and select my app, I can’t see anything. There are no error logs either. What should I do? Kinda urgent since I want to create a demo video using my app for the hackathon. Any advice much appreciated! Thanks.

Hi there, So I have this strange problem: if I deploy my app from an URL and publish it, everything works correctly. If I upload a ZIP file via the form and serve that version from the monday.com cdn, it doesn’t render properly. As far as I can tell the files are being loaded correctly, but the app is not rendering. Serving the application from other providers, like Netlify works without problems. I have a suspicion it has something to do with React Router, which I use and which creates routes like /route1, /route2 etc, which need to be rewritten to index.html. I’m not sure if the default behaviour should be rewriting all and any URLs to index.html, but my feeling tells me yes, since it’s expected that applications should be SPAs.

I am trying to use the storage api to persist data across user sessions. I am using it as described in the documentation: monday.storage.instance.setItem(‘USER_123456_ROLE’, ‘BASIC_ROLE’); which returns a success message. However when I then use monday.storage.instance.getItem(‘USER_123456_ROLE’); it always returns value: null. How do I get this working? Thanks, Jake

My app is a workspace template with the main view as a dasboard written as a custom app. The dashboard works in the original workspace, but when I try to install the template into another account it’s broken. I don’t think it’s an issue with my app, because it switches from the monday “loading” icon to the blank screen which would indicate my app is launching (or my app’s loading icon).

Hi, How should I update columns values in Python. I tried different ways and got Error 500. This is one of formats I tried (where description is of Long Text type column): query_update = ‘mutation { change_column_value (board_id:, item_id:, column_id:“description”, value:“test update”) { id } }’ Thanks, Sima

Header structure works correctly, used it for a String query = ‘{ “query” : “{boards(ids:887415581){items(limit:20){id name}} }”}’; This call works in both Postman and SFDC apex. But when I make the call for mutation with the following string I apply JSON serialize : String colValue = ‘{"numbers_16":" 42","numbers":"5"}’; ** String str = JSON.serialize(colValue);** Now I added to the query for the call: String query = ‘{“query”:"mutation{change_multiple_column_values (board_id: 887415581, item_id: 887415649, column_values:’ + str +’ ){id}}"}'; String don = JSON.serialize(query); system.debug(LoggingLevel.FINEST , don);

Hi all, I’ve been wondering if someone might have an explanation for this: I’m using a simple python module to retrieve board data from Monday. The request I’m sending to https://api.monday.com/v2 is: query { boards (ids: SOME-BOARD-ID) { id name permissions tags { id name } groups { id title } columns { id title type settings_str } } } I’m getting all columns except for the one who’s type is board-relation. Weird thing is that if I paste this query to the API playground I do get this column. Any idea what causes this? Thank you in advance.