API & Apps framework

Hey folks - I’m currently working on updating an integration to work with the new 2023-10 API (from the 2023-07 version). Everything seems reasonably straightforward, but I’m getting caught specifically on the create_column mutation, and on the ColumnType change in particular. Formerly, I was able to send a string with the column type, but now I can’t, of course, because the type is changed. However, I can’t figure out a way to actually send a ColumnType in a way that the API likes (i.e., not in a string format). I’ve specified that the type in my mutation is ColumnType!, but how do I actually gain access to the members of that enum, preferably without using the SDK (which I’m currently not using)? Right now, I can’t seem to find examples in typescript of people doing this mutation dynamically, without hardcoded values. Has anyone run into this problem?

Hi! Im working as a consultant and have a case where im going to extract data from the monday API. But before I can start the project, the customer want to make sure that their daily work in by monday won´t be affacted by the api calls. So the question is, will API calls affect the performance of their monday platform?

Hi, It is solved now 🙂 . I was trying to update the value of a “connect boards” column in my board. I have already created the column in the board, and it is already connected to the other board. When I run this query, the response is succesful and all the column values are updated except for the connect boards. query = 'mutation ($myItemName: String!, $columnVals: JSON!) { create_item (board_id:' + str(main_board_id) + ', item_name:$myItemName, column_values:$columnVals) { id } }' vars = {'myItemName': customer_inv.get('company_name'), 'columnVals': json.dumps({'text0': row['hubspot_id'], 'connect_boards': {'item_ids': [int(companies_contactDB.get(row['hubspot_id']))]}, 'connect_boards0': {'item_ids': [int(bullride_companies.get(row['hubspot_id']))]} if bullride_companies.get(row['hubspot_id']) else '',})} data = {'query': query, 'variables': vars} monday_headers = {"Authorization": APIKEY, 'API-Version': '2023-1

I have a warning WARN: retrying connection to the server (attempt)... in quickstart-react anyone has the same problems? Can I do something? Or can I only wait?

Hey, im trying to create a query where i can get the item coulms_values. i have the item id and board it, and i would like to get the columnes value. and if one of the cell are linked to other board , i would like to get the item id in the other board is it possible? i think it called : linkedPulseId? query = f""" query {{ items (ids:[{item_id}]) {{ id name column_values {{ text id value type }} }} }} i tired this, but its only giving me the value , and i dont see the linked cell name and item id. i used to use but its not working any more. query = f""" query {{ boards(ids: [{board_id}]) {{ items(ids: [{item_id}]) {{ id name column_values {{ title text }} }} }} }} """

Hi Community! Mark your calendars for the end of this month as we have an exciting event lined up just for you. Join us for a MeetApp community session dedicated to the Marketplace and Developers Framework Roadmap. In this session, you will have the opportunity to hear from not just one, but four of our product managers who will present our grand plans and upcoming releases. Curious about what the near future holds for the marketplace? We invite you to join us and discover the exciting developments in store for our platform. Don’t miss out on this exclusive event! Register here See you there!

I’m having trouble setting up my work PC for working on my Monday app. I’ve had no troubles working on it at home. I was told that I had to get our IT company to install everything - I walked him through it as he controlled my computer remotely (the blind leading the blind). This is Windows 11 Business. From one of their administrator accounts he installed Node.js, which came with npm. He ran npm install -g @mondaycom/apps-cli which seemed to work fine. I couldn’t test anything at the time as work was busy so it’s a few hours later now. I just tried running mapps init and mapps help but I get the following error: mapps : The term 'mapps' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again. At line:1 char:1 + mapps help + ~~~~~ + CategoryInfo : ObjectNotFound: (mapps:String) [], CommandNotFoundException + FullyQualifiedErrorId : Com

I don’t understand how to know what column types to pass. I would think it would be this list: GraphQL API But doesn’t seem to always be the case? There are vars for a create_item mutation: let vars = { "myItemName": name, "columnVals": JSON.stringify({ "website": { "url": website, "text" : website}, "deal_stage" : {"label" : stage}, "date_added5" : {"date" : today}, "description" : {"text" : description}, "connect_boards" : {"item_ids" : [founderID]}, "deal_owner" : {"personsAndTeams" : [ {"id" : dealOwner, "kind" : "person"} ] } }) I only was able to figure out that “website” (a link type) should be passed “url” from asking on this forum. Now I face the same issue with “description”, which is a text field. Here is the error: {"error_code":"ColumnValueException","status_code":200,"error_message":"invalid value, please check our API documentation for the correct data structure for this column. https://developer.monday.com/api-refe

Why am I not receiving the itemId when I click a button from an automation? [0] { [0] blockKind: 'action', [0] inboundFieldValues: { boardId: #########, columnId: 'text', targetColumnId: 'files' }, [0] inputFields: { boardId: ########, columnId: 'text', targetColumnId: 'files' }, [0] recipeId: #######, [0] integrationId: ####### [0] } ... [0] { boardId: #######, columnId: 'text', targetColumnId: 'files' }

A group has these expandable “Unterelemente” (subelements, i.e. a full sub-table attached to each item). I would like to query/mutate these subelements but I am unable to get the full schema of the sub-thing (Generally I find it difficult to retrieve the full schema of a specific board/group with really all IDs, titles, formats etc such that one can thereafter access each value). The following query is what got me at least the row names of the sub-table, but it lacks the column ids/names (hence I don’t know how to access them). query = ''' query { boards(ids: %s) { groups(ids: %s) { items(ids: %i) { name column_values { text value type title } } } } } ''' % (board_id, group_id, item_id)

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?