API & Apps framework

Considering there is no retrieve workspaces option and we can only retrieve workspaces as part of boards. Is there any limit on the no. of boards for each workspace. If there is limit on the no. of boards per workspace that would help in retrieving all the workspaces with less number of iterations on the boards. Regards, Prashanth

We are using monday.com boards and we are adding columns to boards. As per the API documentation for [Create column](https://api.developer.monday.com/docs/columns-queries-1#create-a-column) there are 30 predefined types provided and user of the API can add new column of type from this 30 predefined types. What is the behavior on UI for same instance with same plan. Is the UI will also contains only this 30 predefined types or any addition to predefined types? If UI supports more types than predefined 30 types, is it possible to retrieve them in retrieve columns? If it is possible then how the types will be shown in retrieve response if it is not part of predefined type then how it will be handled while creating column value using API. Regards, Prashanth

Due to another team requiring us to populate data in SmartSheet, I am trying to come up with a way to copy the latest Update for an item into a text field for exporting to SmartSheet. Currently, the people on the team cut and paste the latest comment into a text column. At this time, we can use any 3rd party integration tools. I’ve confirmed I can query updates(limit: 1) {text_body} and pull the last update for any item. I’ve confirmed I can update a text field with a value. Is it possible to use GraphQL in one motion and query for the text_body from the Update and mutate copy the text to a custom column? While retrieving data Store item # and last update text_body to variables Update the custom text field with text_body (would actually like to concatenate with created_at) where item # is … Run until no more data is being retrieved -or- do it all in a single mutation query? Thanks!

We are using the Monday.com GraphQL APIs for our client implementation and currently we have objects like boards, groups, items etc. Wanted to know what is the frequency of the change in object and operations in Monday.com APIs. Also, how the version management is happening to support specific version of the monday.com GraphQL schema in the client implementation. Regards, Prashanth

I am trying to query to get a list of user_ids who have permission to access a Workspace. I dont see how this can be done. I dont see it in the workspace object or users. Is there a way to do it? thanks

i got this empty array but that item placed in my board 😒 please help me to solve this??? ‘items_by_column_values’ => array ( ),

Hello there, I successfully followed the api quickstart tutorial. However when I proceed the last PHP example, my new item is created, but four times. Why? Is it related to a specific board setting? Thanks Here is the code ($options and $board_id are defined earlier in the code) $headers = ['Content-Type: application/json', 'Authorization: ' . $options['api_key']]; $query = 'mutation ($myItemName: String!, $columnVals: JSON!) { create_item (board_id:'.$board_id.', item_name:$myItemName, column_values:$columnVals) { id } }'; $vars = ['myItemName' => 'Prospects1', 'columnVals' => json_encode([ 'email' => ['email'=>'zzzz@zz.fr', 'text'=>'zzzz@zz.fr'] ])]; $data = @file_get_contents($options['api_end_point'], false, stream_context_create([ 'http' => [ 'method' => 'POST', 'header' => $headers, 'content' => json_encode(['query' => $query,'variables'=>$vars]), ] ])); $responseContent = json_decode($data, true); echo json_encode($responseCo

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/bin/python “/Users/bruce/PycharmProjects/MondayCom/Weekly Update.py” Query 4 {‘errors’: [{‘message’: ‘V

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":ZZZZZ} Same query, different board working fine: query kpn{ boards (limit: 1, ids: YYYY) { activity_logs (limit: 9999,from: "2022-04-01T00:00:00-03:00", to: "2022-04-02T23:59:59-03:00", column_ids: "time_tracking") { id event data } } } Result print: Can you help me identify

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