General

Hi All, I’m trying to pull info from Monday and display a list of job numbers and connected clients. When I query the board I’m using: boards (ids: 111) { items { id name column_values { id text title } } } } The results to show: { "data": { "boards": [ { "items": [ { "id": "project_number", "name": "project name", "column_values": [ { "id": "subitems", "text": "", "title": "Subitems" }, { "id": "connect_boards", "text": "Client Name", "title": "Client" }, { "id": "rep", "text": "11586", "title": "Job No" }, { "id": "timeline", "text": "2022-02-24 - 2022-02-24", "title": "Project Co

I’m trying to upload files from an IOS app I am making. No matter how I approach the GQL POST to /v2/file upload, I get 400 “Unsupported query”. When researching this issue I found this other community post which resolved the issue by updating their postman. So following that lead I have tried making the gql request using 3 different frameworks: using apollo-ios graphql client manually building the gql request using urlsession manually building the gql request using alamo fire. For all of those approaches everyone has the same result of 400 “Unsupported query”. Are there any ways for me to get more debug information on this error, so that I can get a more specific idea of what I need to address? Any help with debugging or exploring this problem would be greatly appreciated!

There is no retrieve subitems GraphQL API, we can retrieve subitems using retrieve item. Also, there is no pagination support for subitems. It is always retrieve all the subitems. Considering this, Is there any limit on the number of subitems for each item in the board? Regards, Prashanth

URL: https://jetbrains-league.monday.com/v2 Request example: POST /v2 HTTP/1.1 Host: jetbrains-league.monday.com Authorization: xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx Accept: application/json Content-Type: application/json {"query": "{ boards(){id name description state workspace {id name} board_kind}}"}

We are currently looking for query column to get all the available columns in the board with metadata to enable user to provide those column values while creating the item. Our flow is as below: Retrieve column Retrieve column definition Create item along with column_values where we wanted to allow user can provide value based on the column definition. Currently the type we are getting from retrieve columns is not matching with [Column Type Reference](https://api.developer.monday.com/docs/guide-to-changing-column-data) provided in API documentation. For example type name is there and there is no Column Type Reference for name. Also, if type is color then there is no Column Type Reference for color, similarly for others. Is there any way to retrieve each column type definition for say if the column is color there retrieving definition of the color type? Regards, Prashanth

Currently there is no direct retrieve support for workspaces in the GraphQL API. We can retrieve workspaces only using retrieve boards. Is there any way user can get the workspace id in the monday.com application UI? Regards, Prashanth

Hello! I am running what I believe to be a simple mutation and I cannot get it to work, I keep getting { “error_message”: “Internal server error”, “status_code”: 500 }. I have tried both the change_multiple_column_values and change_column_value approaches. Searching the forums, I have seen folks say this can be caused by a malformed request string but I am unable to see that. Help is appreciated. mutation { change_multiple_column_values( board_id: 2588471113, item_id: 2643558945, column_values: "{\\"connect_boards30\\":{\\"item_ids\\":\\"2643558944\\"}}" ) { id } } This is generated programmatically from this: let mutation = `mutation { change_multiple_column_values( board_id: 2588471113, item_id: ${createdSubItemId}, column_values: ${JSON.stringify(updatedColumnValues)} ) { id } }` Of note: My board_id references a sub_items board if that makes a difference. I have tried the query both in my code and directly on the Monday.com

Currently there is no GraphQL API to retrieve groups. The retrieve groups only possible with retrieve boards. Also, there is not pagination support for groups when retrieving groups using boards. Is there any limit on number of groups for each board? Regards, Prashanth

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