Welcome to the new monday developer community
-
Recently active
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?
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:
Already have an account? Login
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.