API & Apps framework

Eventually from running a query, I want to update a column with a next text value by referencing a board ID and item ID. I can pass variables into my mutation as a String!. I can’t figure out how or if I can pass numbers for the board ID and item ID. If tried Int!, Number!, etc. Is the possible? If so, what is the variable type? Code below shows me trying to pass the board ID through as a variable. Code vars4 = { ‘boardID’: ‘2383442606’, ‘itemID’ : ‘2632247819’, ‘columnID’ : ‘text90’, ‘updateTxt’ : ‘hello world’} query4=‘mutation ($boardID: Int!, $updateTxt: String! ) {change_simple_column_value (board_id:$boardID, item_id:2632247819, column_id: “text90”, value:$updateTxt) {id}}’ data = {‘query’ : query4, ‘variables’: vars4} r = requests.post(url=apiUrl, json=data, headers=headers) # make request print(“Query 4”) print(r.json()) Error /Users/bruce/PycharmProjects/MondayCom/venv/bi

I’m trying to find any items where the item name doesn’t match a list I have on my server, ie someone has manually added something that shouldn’t be there. I would expect to do this with a negation query along of: item[‘name’] not in [‘bob’, ‘fred’, ‘harry’] or get a list of unique item names which I could then compare on the server and then use to pull the data from the board, something like: DISTINCT item[‘name’] I can’t find any negation or distinct functions to the API. Are there any? (I suppose that I could create a status field and then query the labels, but I really don’t want to use a status field as it isn’t appropriate)

Hi! I noticed that when getting the assets (files) of an item through the graphQL API, we only get the files uploaded through the column but not the ones uploaded on the item file gallery. Is there a way to retrieve this files using the API?

Hello We are developing an API to update some column values based on another internal tool we are using. We noticed that the mutation requires both BoardID & ItemID and were wondering, since the itemID is unique in the platform, why is the boardID also required? I am asking as we need to run another query each time to fetch the boardID based on the itemID so I am trying to see if there is a way to optimize our script without this additional query to fetch the boardID. Thank you! Linda

Hey Monday, Do you have a manual about how to activate the option of making outgoing calls from your system using my extension in my PBX? Thanks.

Hello I followed the advice from Change timeline when dependent items rolls back earlier - #2 by timlittletech. To have my dependent items dates flow. I believe I followed the instructions correctly but nothing I do will flow the dates.

Hi devs, I see that there’s a “When an update is created” trigger that calls an action as soon as a new update is added to an item. It doesn’t seem to work with replies to existing updates. Can you confirm? Is there a way to trigger the “when an update or a reply is created” event? Thanks.

Not sure when this happened (or was announced? I am not finding it here). But the built-in trigger “column changes” for monday apps now supports subitems, like the webhook trigger does. This is big, i would have expected an announcement of it 🙂

I was thinking it would be beneficial to change the API to only require either the Lat and Long or the Address. When we use Monday’s boards normally, you can put in the address and it will populate the lat and long fields automatically. Why can’t it do that when we use a mutation to change the location column? Is there an easy way to find the Lat and Long from a given address using another websites API? I’ve found both Bing and Google Maps requires a billing account to do this. Any thoughts on this from others?

Hi All, Is there any way to add custom object along with it’s structure other than using predefined objects in monday.com? Also, is there any way to add custom columns in the board other than predefined types? Regards, Prashanth

Hi All, In GraphQL API documentation we don’t see any reference for filter operators and we can see only filtering using arguments. Is there any filter operators supported by monday.com GraphQL or not if supported kindly share the reference link for documents along with some working examples. Regards, Prashanth

How do I use the API to set a timeline column type value as a milestone? I can set the the from and to with the API but there is no milestone option. If I manually mark a timeline value as a milestone through the website, then I update the date using the API it remove the milestone flag. https://api.developer.monday.com/docs/timeline

Hi, I was wondering if there is a field in API which show the board type: ‘overview’, ‘board’, ‘doc’. I’ve tried to play with the explorer and read the documentation, but IO wasn’t able to find anything. Please help me to understand how it’s possible to understand the board tpye. Thank you, Nairi

Hi All, Whenever we are creating board, the board is getting created with some predefined structure with predefined columns. Is there any way to find the columns which are default and which are added by user later? Regards, Prashanth

Attempting to call this in the API 🙂 {“query”:“mutation ($boardId: Int!, $columnVals: JSON!, $itemId: Int!) { change_multiple_column_values (board_id: xxxxxx, item_id: xxxxxx, column_values: {"nick_name":"test123"}) { id } }”} I get the error {“errors”:[{“message”:“Parse error on "nick_name" (STRING) at [1, 154]”,“locations”:[{“line”:1,“column”:154}]}],“account_id”:xxxxxxx} What am I doing wrong ?

I am working a custom action that is passing columns to a backend. I don’t want to query for all columns but I am running into an issue. The issue is I am not able to send more than 6 columns in a custom action block. I am using the id in the backend to query the item to get the values. the board could have 15+ columns and I only need to send 7-8 of them. I am getting this error in the console when I go to update my action, any help would be greatly appreciated.

I’ve been trying to get the activity logs for a specifc board, but it always returns empty, but I have access to this board and I can see that there are logs on at least 1 pulse. The result is the same on Postman and on the API Playground. The same query on other board returns results as intended, so it seems like a problem only with this board: Activity logs on April 01: Query on this board with filter: query kpn { boards (limit: 1,ids: XXXX) { activity_logs (limit: 9999,from: "2022-04-01T00:00:00-03:00", to: "2022-04-18T23:59:59-03:00", column_ids: "time_tracking") { id event data } } } Result: {"data":{"boards":[{"activity_logs":[]}]},"account_id

Hey guys, around 10-12 years ago I designed in PHP however a lot has happened and now I’m looking at connecting to the API on Monday. I’m using the standard $query = ' query { boards (ids: 0000xxxxxx00000) { groups (ids: group_title) { items { id name column_values { id text title } } } } } '; $data = @file_get_contents($apiUrl, false, stream_context_create([ 'http' => [ 'method' => 'POST', 'header' => $headers, 'content' => json_encode(['query' => $query]), ] ])); $responseContent = json_decode($data, true); echo json_encode($responseContent); and its pulling all the data out but with no formatting at all - Can you point me in the right direction how to add tags etc after each line etc etc… Thanks in advance

Do you manually manage all the documents sent to various employees and departments? Do you spend a lot of time and energy in getting your documents sent and reviewed and still face compliance-related hassles? If so, we have a solution for you-DocBox Pro. DocBox Pro is a document compliance management system we have designed in collaboration with monday.com. DocBox Pro lets you automate the process of sending documents and getting them acknowledged and signed through automated workflows, which means you can focus on what matters the most-growing your business. DocBox Pro comes with a wide range of coveted features that enable users to easily share documents from their local drive, maintain a repository of original and signed documents, and track the status of documents in real-time. Key benefits that make DocBox Pro a must-have for your business: Complete automation to minim

I’m getting an error when running a query. The query works for 500 items, but when I jump up to 1000 items it seems to be giving some kind of error. I ran a complexity query just to be sure I wasn’t reaching any API limitations and it doesn’t appear that I am. I’m really not sure what is going on here. Please Help! It spits out this error sometimes. My board has 2800 items on it. The complexity when I query 100 items is 1420 and returns results. But when I up the limit to around 500 it gives me this error. I’ve tried this in the api playground as well as a custom written python script and both return the same error. I kept thinking my query was wrong, so I went to the playground but got the same problem. { "message": "Unexpected

Dear Team, I have successfully crated the connection string with Monday.com from Qlik rest connector . In POST request I am passing below query, which is working fine in Monday API developer {query{ boards { items{ id name } } }} BUT when I hit monday.com API from Qlik , I am receiving error message as’ “No Query String Present”’

I need to pull data from a group in my board. The condition is that I have to filter items in this group by a specific item column value. I could figure out how to get all items belonging to a group on a board using this query: {boards (ids:BOARD_ID_HERE) { groups (ids: GROUP_ID_HERE) {items (limit:2) { name created_at column_values{id title text} }}}} What would be the query for filtering the group items based on a column value?

I have noticed a couple of issues that may or may not be related. Issue 1: I have created a custom integration using the API to create items in Monday whenever a contract signed event webhook is fired from our proposal software. Most of the time it works fine. Occasionally though, the item will have blank entries in a few columns despite the API call returning a success code without an error message. To make it even more confusing, the activity log in Monday shows that the value was entered into the column, and no action appears after to indicate that it has been deleted or rolled back. To me this means there is either a bug that is preventing the item from displaying correctly, or the column value is being deleted without record of this happening in the activity log (undocumented roll back). If it is a roll back, this is a huge problem, because whatever is triggering the roll back is seemingly random, and is not consistent with any valid reason for rolling back an update (ie

We have a live app for monday.com and we are working on new version of this app. We need user to do Oauth to provide us with token for extra features(this is in draft). We never had Oauth before and in draft version was working fine with which ever url we provided in redirect uri I know of this caveat but it was not this issue because we never had Oauth or redirect uri Invalid redirect_uri error Now what happened recently is the auth stopped working always giving us Invalid redirect uri error. Then I added app_version_id to auth url and it worked. Questions: - Is this intended behaviour? When was this implemented? What do I need to make or change url for auth when we go live with this version does it include version id or not? this is very high priority please we are scheduled to launc

Hello, I’ve been able to modify a query to create a record and put in all the values. The issue is the filter has the text not showing. Is there a way to modify the Text of the column? This is an integration field with Pipedrive. "id": "pipedrive_deal", "title": "Pipedrive Deal", "value": "\\"1\\"", "text": "" My query to create the record: #mutation{create_item(board_id:####, item_name:“Test”, column_values:“{"text00":"Test Name", "text1":"IN", "pipedrive_deal":"1", "text7":"test", "pipeline":"Clients", "numbers":"1", "hours7":"Full-Time", "text3":"Practice", "text60":"null", "text0":"Undocumented", "Date4":"2017-09-03", "text9":"2017-09-03"}”) {id}}