API & Apps framework

I’m really struggling with syntax and formatting in google app script. As a baseline, this works for creating an item on a board: const BASE_URL = 'https://api.monday.com/v2'; const dealBoardId = '5533299122'; //Deals board in the test workspace function createMondayDeal() { let query = 'mutation ($myItemName: String!, $columnVals: JSON!) { create_item (board_id:' + dealBoardId + ', item_name:$myItemName, column_values:$columnVals) { id } }'; let vars = { "myItemName": "Hello, Best Deal!", "columnVals": JSON.stringify({ "deal_stage" : {"label" : "New"}, "status9" : {"label" : "1"}, }) }; var response = UrlFetchApp.fetch("https://api.monday.com/v2", { method: 'post', headers: { 'Content-Type': 'application/json', 'Authorization': API_KEY, 'API-Version' : '2023-04' }, payload: JSON.stringify({ 'query': query, 'variables': JSON.stringify(vars) }) }) However, expanding to include a link fails:: This f

I’m creating an app to share with my clients. It is working except that the Monday docs that I have included in my workspace are not showing up when installing the app on another account. The boards show up fine, but the document templates are not.

Hi, I have these two methods, that are made to, with retreived data, push data into a board on monday using C#. When these two methods are called, they are surrounded with a try catch: private string FormatDataForMonday(List<ResultItem> databaseData) { string mutationTemplate = @"mutation { create_item (board_id: bID, item_name: ""Test"", column_values: {JSON_DATA} ) {id} }"; string mutationQuery = mutationTemplate.Replace("bID", boardId); var formattedData = new { items = databaseData.Select(dataItem => new { Site = dataItem.Site, EwqPn = dataItem.EwqPn, }).ToList() }; // Serializing the entire formattedData, including both Site and EwqPn string jsonFormattedData = Newtonsoft.Json.JsonConvert.SerializeObject(formattedData.items); mutationQuery = mutationQuery.Replace("{JSON_DATA}", jsonFormattedData); return mutationQuery; } public async Task<string> QueryMondayApiV2(string query) {

Hello! We are developing a recipe, that is supposed to send a message when an item’s status changes. We want to allow a user to customize a message by using the content of the board item’s fields (for example, “Name”): Something in the vein of template variables: “Hello, {{first_name}}, how are you?” Is that possible? How should the recipe be configured to allow selecting of item fields in the text input of the recipe? Thanks!

Here is the example query. { items(ids: "123123123") { column_values { ... on BoardRelationValue { linked_item_ids } ... on DependencyValue { linked_item_ids } } } } There is a problem here because according to the schema linked_item_ids on BoardRelationValue is of type [ID!] and DependencyValue is ID!. This means the two fragments cannot be used together technically. Although in an practice it works because the two column types never overlap. The real problem is the return values: { "data": { "items": [ { "column_values": [ { "id": "connect_boards", "type": "board_relation", "linked_item_ids": [ "555555555" ] }, { "id": "dependency", "type": "dependency", "linked_item_ids": "[555555555]" } ] } ] } } You will notice, BoardRelationValue returns [ID!] in conf

Hi, I’m using Zapier to automate certain tasks on my board. However, for the past few days, I’ve encountered an issue with a straightforward automation: ‘Specific Column Value Changed in Board in monday.com’. When I perform a test trigger in Zapier, I receive the following error: Unable to pull column value changed events Please reload the page. If the issue persists, troubleshoot error or contact Support. Error code: Error while retrieving: The app returned “@font-face{font-family:Roboto;font-style:normal;font-weight:500;font-display:swap;src:url(data:font/woff2;base64,…”. @font-face{font-family:Roboto;font-style:normal;font-weight:500;font-… I attempted the same automation on a different board, and it works, indicating that it’s a board-specific issue. Does anyone have any idea what might be causing this? Any help is appreciated.

Hi, When cards status changed from yet to work to any other status, the changes are not reflected on the status receiving from sending request through API playground (eg: last_changed). Even though status is changed for many task the changed_at field in status key is showing null. { "id": "4*5*4*5*4*", "name": "Collection Banner", "created_at": "2023-02-27T20:21:03Z", "column_values": [ { "title": "Planned Effort", "value": "\\"1\\"", "text": "1" }, { "title": "Status", "value": "{\\"index\\":9,\\"post_id\\":null,\\"changed_at\\":null}", "text": "Delivered" }, {

Hey developers! In order for workspace templates to work in all regions, it needs to be exported. This process is happening while promoting a version to live, and only if the app is public. This behavior actually created a bug that when first publishing an app (making it public), the workspace template would not work in other regions because when the version got promoted, the app was still “private.” In order to fix this issue, we added the following message and changed the behavior so that when publishing an app, it’ll re-promote the live version in order to export the template.

Hey there, I am developing a connection between some Service and Monday.com. I am using mutation - create_item to create a new item. my ‘column_values’ is a JSON format through the use of json.dumps() columns[‘’] is a dictionary where the value is the Column Id and the key is the payload from the Service On Line 65, I am trying to trying to set the field as someone based off their UserId and it is not working. What is wrong with the Syntax? When I run this, I do not get an Error, just get a normal GraphQl response but no updates on the board Note* I do have other fields below line 65 and they are either Text/Date which is showing up on the board as expected. This suggests there’s a Syntax Error Any suggestions? Here is some of the documentations i’ve read over GraphQL API Cheers!

My understanding is that sub items are simply just another board that you can query. At least, that’s the way it used to be before January 15th. Has that changed? I am using the following query which, if my understanding is correct, should return all all columns and all rows of the board { boards(ids: BOARD_ID) { items_page(limit: 100) { cursor items { id name column_values { text column { title } } } } } } It kind of works. When I use the board ID for a subitem board, it returns all of the columns and rows. However, not all of the columns have data. It appears that only four columns aren’t importing data values. If I didn’t need the values from one of the columns, I wouldn’t really care. I use this to import data into Power BI. I’ve already checked out Howard Bouk’s Power BI import here: Using Power BI to retrieve boards using Cursor-based pagination - #28 by Matias.Monday I am familiar enough with Power BI that I’m comfortable importing main boards and subitem boards separate

Hey, I´m trying to get an element name by its “id”. Basically a very straightforward task but I cant make it work. The “items_page_by_column_values” cant seem to find by “id” like so: { items_page_by_column_values (board_id: 1324701454, columns: {column_id:"id", column_values: "ID OF THE ITEM E.g. 5823583"}) { items { id name } } } …doesnt return my element and this one does find the element but doesnt give me the name of my element…super annoying… query { items(ids: ID_OF_THE_ELEMENT) { column_values { column { id title } id type value text } } } How to retrieve an element NAME by its id??!?

Is there a way to integrate OneDrive with Monday whereby all files/documents uploaded on a board gets uploaded in OneDrive too? I’m having troubles connecting it using Make or Zapier! Would be nice if someone had the same issue and found a solution!

I ran this query: { boards(ids: my-board-id) { columns { id title } } } As expected, that gave me a list of columns with their id & title. Among those columns are: { "id": "name", "title": "Name" }, "id": "contact_phone", "title": "Phone" }, { "id": "contact_email", "title": "Email" }, I assumed I could then run a query like: { boards(ids: my-board-id) { items_page { items { name contact_phone contact_email } } } } But it tells me I cannot query “contact_phone” and “contact_email” on type item. So I have no idea how to retrieve the contact’s name, email, and phone from that board. I’ve spent the last couple hours looking through the documentation but can’t find anything, so here I am. Thanks in advance.

Hello, So im using api to write some batch of tests results. I have board with two groups: latest and history. When im starting new test batch I used to move all my items from latest group to history. Since today im getting this error: b’{“errors”:[{“message”:“Field 'items' doesn't exist on type 'Group'”,“locations”:[{“line”:6,“column”:5}],“path”:[“query”,“boards”,“groups”,“items”],“extensions”:{“code”:“undefinedField”,“typeName”:“Group”,“fieldName”:“items”}}],“account_id”:x}’ Thanks in advance

Hello. I am trying to fetch an item along with its subtasks and their column values. Currently, this does not seem to be supported Is there a way in which I can fetch the subitems’ column values along with its parent in the same query?

Hello there! I’ve read API docs but couldn’t find anything about it. Am I missing anything? Could you kindly guide me where I can get more info about it?

Hi, as a developer of Monday.com integrations, we are experiencing significant performance issues in using the 2023-10 API with specific regards to Mirror item display values. Below is an example of a typical query we might run within our integrations, which is followed by the next_items_page query to fetch the remaining items. query getItems($columnIds: [String!]) { boards(ids: []) { items_page(limit: 100) { cursor items { id name column_values(ids: $columnIds) { id type text value … on MirrorValue { display_value } } group { id title color } } } } } The info below shows the response times we are getting from the Monday.com 2023-10 API based on the number of mirror columns present in the query. 15 native columns, 0 mirror columns - 5 seconds 15 native columns, 1 mirror column - 15 seconds 15 native columns, 2 mirror columns - 25 seconds 15 native columns, 3 mirror column - 30 seconds 15 native columns, 4 mirror columns - 42 seconds 15 native columns, 5 mirror columns - 48 seconds Thes

I have created a query to pull two specific columns from a specific item. When I run the query in the playground it works as expected and I can see the results I am after in the results section. However, when I run the exact same query from Postman I get two error messages ("No such type DropdownValue, so it can’t be a fragment condition; also receive this same error for the TimeTrackingValue column). Here is the query I am running { items(ids: [12345678]) { id name column_values(ids: ["property", "duration"]) { ... on DropdownValue { id text } ... on TimeTrackingValue { id started_at duration history { started_user_id started_at ended_at created_at } } } } } Does anyone know why the query works fine in the playground and not in Postman?

Hi all, A colleague in another organisation (on another Monday.com instance) has created a set of boards which I’d like to import into our workspace. I’m aware there’s a few ways to skin that cat, but I wanted to try getting them to package it as an app, which they’ve done. It’s not been shared on the marketplace, but it has been published and I’ve got the link. I can install the app on our Monday.com instance with no issues. However when I come to actually add the app to a workspace it fails. I get a red toast notification saying “Sorry for the inconvenience, we couldn’t implement the solution” and no further guidance. I am an admin with full permissions, and I am the owner of the workspace the app is being installed into. I have uninstalled and reinstalled the app and get the same notification every time. Can anyone help me to troubleshoot? Knowing whether to look at the settings of our own Monday.com or at the org which created it would be a great start!

What api can update dependency lag and create this modal:

Hello together, it is possible to change the group name of the subitems. Tried it using API. There is some success, but the group name is still retained. Are there other approaches to this? Thank you very much.

Hi, is there a way to call external app to run based on a click or a status change, i don’t need any info exchange, just need it to run and jump to the front window

The below query stopped working for text fields. It was working before the latest API version upgrade. I am using the API version: 2023-10 query { boards (ids:xxxxxxx) { items_page ( query_params: { rules: [ { column_id: “custom_text_field”, compare_value: [“541”], operator: contains_text }, ] }, ) { items { name id group { id } column_values { id text type } } } } }

Noticing this strange behaviour on my app. The filter and search options disappear as soon as the app loads! Please help

Hey all, I’m using the API connector to call multiple items to a board on my Monday account. The text values are loading but not the dropdown items, telephone number, nor the file uploader. Here’s my POST call: { “query”: “mutation { create_item ( board_id: 5805558084, item_name: “<Current_User's_first_name> <Current_User's_last_name(s)>”, column_values: “{ "texto7":"<Current_User's_address>", "ciudad":"<Current_User's_city's_Display>", "dropdown2":"In the afternoon", "tipo_de_problema52":"Community", "long_text":"<DescribeIncidences's_value>", "Documentos":"<LinkUploadFiles's_value>", "texto8": null, "tel_fono": null}”) { id, name, column_values { id, value } } }” } In bold is the dropdown item that I’ve been playing around with for hours and no luck. I’ve tried dozens of different ways, like putting in the status/label IDs (1: Madrid, 2: Barcelona, 5: Not listed, 19: Valencia), overriding them and more. As for the other dropdown options, I temporar