API & Apps framework

Hi I wonder if anyone has connected to monday`s API from PowerBI, and want to share a step by step… I dont want to dev a API in the middle to translate. Thanks /Jo

Where can I find information on date and text formatting codes/tokens for Monday.com, as used in the formula functions FORMAT_DATE and TEXT, specifically? I was able to find some date formatting tokens here: Tokens for date/time formatting Help Docs | Integromat Help Center, but these listed tokens do not 100% match Monday.com’s token functionality. I have not found anything regarding text formatting tokens.

Hi there, just a quick question. Everything is in the title! I did not see anything like this in API V2. Seems strange in my opinion, so please answer this post if you know a way!

I am using change_multiple_column_values mutation for updating column values but while updating the “week” column value through API, I am continuously getting internal server error, it is blocking development. Can anyone please clarify what is wrong with the following query. mutation{change_multiple_column_values (board_id:xxxxx,item_id:xxxxx,column_values:"{\\"week\\":{\\"week\\":{\\"startDate\\":\\"2020-12-12\\",\\"endDate\\":\\"2020-12-19\\"}}}") {id}} Thank you.

Hi there 👋, I’m working on an App that should check if if the maintenance of a site was done on time. For instance, a task is planned for 10am. If it is 10:15am and nobody went on site, we should send an email to the project manager to say: “you should send someone else”. We can’t wait for the next day. How would you do that?

Looks like Workspace Templates beta is out for Apps! Looks pretty straightforward but we do have a couple of questions: What are the recommended dimensions for screenshot thumbnails and other images, for the upcoming Marketplace listings? Does the video link have to be a Cloudinary link? Or can we use YouTube or Vimeo instead?

Hey, The api session didn’t broadcast and now the current as well. Is it happening to others? Thanks, Ronen

Hello, I’m trying to see if I can replace some code and diminish requests by using integrations. Basically, if any column changes, I now send a webhook, then I have to query the item for a specific column value that is a unique id that is the same in multiple other applications and is used to identify the item across the company. So what I would like to know, is if there’s anyway to create a custom action that would send a webhook with this column value so I can save a request. I managed to replicate the webhook integration but couldn’t find a way to select the text of another column when any column changes. I tried the columnValue from recipe but I could not manage to select anything and import to board. I hope this makes sense to someone, Thanks,

I’m posting queries (that I know are correct) to “https://api.monday.com/v2” using “fetch” in Javascript. Method, headers and body are all good. But only my first post works (it returns what it should). I can’t post more than one. The next one (milliseconds later) returns a 500 error. I’ll be needing to sequentially post hundreds. Here’s the code: fetch(“https://api.monday.com/v2”,{ method: ‘post’, headers: {“Authorization”: “<%=strToken %>”, “Accept”: “application/json”, “Content-type”: “application/json”}, body: myJSON}) .then( function(response) { if (response.status !== 200) { console.log('Problem! Status code: "+ response.status); return; } response.json().then(function(data) { console.log(data); }); } ) .catch(function(err) { console.log('Fetch Error: ', err); }); I’ve also tried with a simple request, using: oRequest = new XMLHttpRequest(); oRequest.open(“POST”,“https://api.monday.com/v2”, false); oRequest.setRequestHeader(“Authorization”, “<%=strToken %>”); oReq

Hi builders, I share this because it took me some time to figure out how I could connect 2 apps to the same backend code on my server. I had build one app with several integrations and was looking for a way to split these features so that every feature is part of its own app. But also wanted the “old” sithuation (one app / multiple features) to work. On the backend I did not want to copy/paste code so the requirement was that APP1 (with feature XYZ) could use exactly the same code as APP2 (with the same feature XYZ). Off course APP1 and APP2 had different signing secrets and client ids. Not to hard to decide in code which client ids, client secrets and signing secrets you need to use. The hard part is to know (in your backend) which app sends the request to your server. There is no such thing as an appId (yet). 🙂 So, I thought, let’s make use of a “appCode” and put it in the run URL path (and off course the (un)subcribe paths if you are using custom triggers). Now we can distin

Is the API Try it yourself window being monitored? Perhaps if I knew what your server was actually seeing it might make it easier for me to fix my posts to the API.

Hi, I’m observing some real strange behaviour as part of a custom Monday integration we have created for internal use. We"re using the V2 API to write group and items onto a board. Let me outline the architecture first: Read data from Monday board X and aggregate that data into an object Put the aggregated object on a queue Read the aggregated object from the queue and for each item from the queue do the following 3a. Create a Group 3b. Insert items into that group What we notice is that in some cases, the create group mutation is executed, you briefly see the group appearing on the Monday board. We even get a group id for the created item (it’s november46256 for example). But once we try to insert items into the group, the group suddenly no longer exists. When refreshing the Monday board, the group indeed just ‘disappears’. I cannot consistantly reproduce this, sometimes it works flawlessly, sometimes it doesn’t. Is there any transactional concept on a mutation that we need to be aw

Can some explain to why this plain vanilla JS returns a 401 error? fetch(“https://api.monday.com/v2”,{ mode: ‘no-cors’, method: ‘post’, headers: {“Authorization”: sToken, “Content-type”: “application/json”, “Accept”: “application/json”, “Access-Control-Allow-Origin”: “*”, “Access-Control-Allow-Credentials”: “true”}, body: JSON.stringify(sQry)} ) Both sToken and sQry are correctly assigned beforehand.

I have set up my WooCommerce + Monday. Com API keys but when I go to add “when an order is created, create a new item and sync …” it gives me an error message of “couldn’t update automation”. What can I do?

While running this don’t get any errors, just empty request value_json<-toJSON("{'index':3}") request_form<-paste( 'mutation {change_column_value ( board_id: 347384734, item_id: 34239483, column_id: "status", value:',value_json,' ) { id } }',sep = '') Wrote random ids Here’s function to process my request, maybe something wrong with it. GQL <- function(query, ..., .token = NULL, .variables = NULL, .operationName = NULL, .url = url){ pbody <- list(query = query, variables = .variables, operationName = .operationName) if(is.null(.token)){ res <- POST(.url, body = pbody, encode="json", ...) } else { auth_header <- paste(.token) res <- POST(.url, body = pbody, encode="json", add_headers(Authorization=auth_header), ...) } res <- content(res, as = "parsed",

Hi, Can anyone please tell me how to exclude columns in my POST request? This will get all the columns for that board and item: { boards(ids: 690783129) { items(ids: 732774573) { column_values { id text } } } If I change it to include: column_values(ids: column1,column2,column3) I can get only the one I want, but is there a way to exclude columns I don’t want? So I can run the query and it will only get columns 1 and 3, and will exclude 2. Thanks heaps, Matt }

Hello, I’m a complete newbie with GraphQL in general, and barely familiar with the monday API and monday boards in general. I’ve been tasked with extracting the item names using the API, but without the sub-items. By using the query {boards{items{name}}} I’m getting a mixed list of both items and sub-items, all under the key “items”, without any way to distinguish which one is which. Is there a way to filter out sub-items using a simple query? Thanks for any help! 😀 P.S. If that’s a common question, please accept my apology, as I don’t even know which keywords to use…

on the webhook update_column_value when a dropdown column changes I get the value of the column as ``` value: { chosenValues: [ [Object] ] } is there any documentation on what is that Object?

I am trying to create a custom recipe that accepts a message as part of the user input. When I receive the event on my server, it looks like this: { payload: { blockMetadata: null, inboundFieldValues: { boardId: 700512087, itemId: 700512094, message: 'Here is the update: {pulse.text} {pulse.name}{board.name}{user.name}{pulse.group}{pulse.person}{pulse.status}{pulse.date4}' }, inputFields: { boardId: 700512087, itemId: 700512094, message: 'Here is the update: {pulse.text} {pulse.name}{board.name}{user.name}{pulse.group}{pulse.person}{pulse.status}{pulse.date4}'

The column values are updated successfully when I run the following mutations in Playground. But when called in code, these same mutations throw Graphql Validation errors. All board scope permissions are set. works in playground ☑️         doesn’t work in code ❌ const query1 = `mutation { change_column_value (board_id: 726291451, item_id: 726291453, column_id: "status", value: "{\\"index\\": 1}") {id}}` const query2 = `mutation { change_multiple_column_values (board_id: 726291451, item_id: 726291453, column_values: "{\\"url\\":\\"urlVal0\\",\\"name1\\":\\"nameVal0\\"}") {id}}` // also no good const val = {"index": 1}; const query = `mutation { change_column_value (board_id: 726291451, item_id: 726291453, column_id: "status", value: ${JSON.stringify(val)}) {id}}` ❔

I need a way to determine how long a task has spent in a specific status. what is the best way to get this information from API?

I’m writing an app to synchronize our SugarCRM with a Monday board. All is working as expected, but sometimes one query to update a people column is failing with an error 500. The query is: mutation { change_multiple_column_values ( board_id: 165483237, item_id: 724910374, column_values: “{"people":{"personsAndTeams":[{"id":5428485,"kind":"person"}]}}” ) { id } } When using a different user id, all is working as expected. It seems that the user 5428485 is a Team Member, but not not a Board Member. If I add this user to the Board Member list, all is working as expected. How to check if a user is a Board Member before updating the column? How to add a user as a Board Member, either Member or Guest? Thanks for your help.

I built a Monday connector for DOMO and it worked perfectly. Yesterday, it failed with the error “Your API token is incorrect.” Does this mean the token expired? I regenerated a new one in Monday Admin - but that fails with the same error. What should I try to fix this issue? Thanks!

Not sure what’s wrong this query: “{"query" : "{items_by_column_values(board_id: XXXXXXXXX, column_id: "text0", column_value: "XXXX") { id name column_values{id text value} }}" }” I’m looking to retrieve items based on the value (“XXXX”) of a specific field (text0). No errors, but no results either. And the items with those values most certainly exist. Something wrong with this query?

Hi there 👋🏼, We use the “special” file API route to send an image to a board in our integration. Sometimes, this could take up to 1 minute to update. I also saw during the workshop that the dev team had the same problem. Is it something that you plan to improve? The user could think than nothing happens when it is slow.