General

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

Hi, I am trying to update a column on my board - it is a number. I am using the change_column_value endpoint in the API and Python. Here is my code: def updateColValue(self, boardId, itemId, colId, value, mondayToken): dictHeader = {'Content-Type': 'application/json', "Authorization":self.mondayToken} mondayURL = "https://api.monday.com/v2" try: mutation = f"{{ change_column_value(board_id: int(boardId), item_id: int(itemId), column_id: colId, value: value) {{ id }} }}" payload = f"{{\\"query\\":\\"mutation: {mutation}}}" response = requests.request("POST", mondayURL, headers=dictHeader, data=payload) print(response.status_code) print(response.reason) except Exception as e: print (f"{cm.WARNING}There was an error running a column update:\\nColumn: {colId}\\n{e}") I keep getting a 500 error returned. I suspect it is because my query formatting is not correct. Would appreciate any help. I was using this Q&A as a guide: 'change_

Hello- I have a HTTP call that posts values in a column/ item each time it runs. Right now it is just a text name. So it comes in as John Doe, the next time the call runs I want to add “Patty Roe”. So the cell would contain “John Doe, Patti Roe”. Is there anyway to do this with out getting the current contents of the cell, then when adding to the cell include the current contents plus the new? Secondly, if I change the column from a text to a people column can I ADD people there? Thank you!

Hello people, I’m Sanjeev Mansotra, pursuing a course as I want to learn App development for my further career. I am dedicated to continuous learning and staying updated with the latest advancements in the field of technology to deliver innovative and sustainable solutions. I have keen interest in coding, so please help which all programming languages should I learn to develop apps? I’m new to this community, waiting for responses!

While I’m pretty late to the party, I’ve finally found the time to update an app that is using the API that would have broken with the 2023-10 changes specifically to items_page and pagination. At first glance it is a nice addition, however upon closer inspection I realized my fairly fast method for getting all the items in a board will no longer work. Before, I would spin up a worker pool and start handing out page fetch requests to the workers. I could do perhaps 8 simultaneous page fetches, with each page having its own error tracking and retry logic. Any page that came up empty or less than the limit signaled the whole worker queue to finish up or abandon any pages greater than the “last page” that was discovered. This was fairly elegant and sent minimal junk requests (a few pages past the last could happen). With the new system, it looks like there is absolutely no way to fetch pages in parallel any more, being entirely locked into the serial interface of waiting for the next c

Hello Community, I am thrilled to announce that I’ve recently developed a new Google Workspace add-on, one that’s intended to enhance your productivity and simplify your data management. Do you often find yourself manually adding items elsewhere whenever a new row of data is added to your Google Sheet? What if that process could be automated? Say hello to my new add-on, automatically generate a new item whenever a new row is added to your Google Sheet. This add-on is perfect for users who regularly update their sheets and need those changes to reflect elsewhere without the hassle of manual data entry. It’s designed to be user-friendly, seamlessly integrating with your existing Google Workspace and requiring minimal setup. Once the add-on is installed, it will monitor your specified Google Sheet for new entries, and as soon as a new row is detected, it will immediately create a new item. I would love for you to try it out and share your experiences. I’ll be actively seeking your feedba

Hey there, hope all is well! Am a little new to Monday Dev and GraphQL! I’ve looked at the new docs regarding the new items_page api. However, I did not see anything about Creating or Mutating an Item using this new API. Am I missing something? How do we go about creating/mutating an item using the items_page? I did see under Items “If you’re getting items… use items_page”, I’m guessing items_page is only for retrieving info since it says “getting”? Here’s a link of docs I’ve read overmonday API docs Cheers!

Go beyond the limitations of native automation with a new app from the ScriptRunner team: Advanced Automations for monday.com! This new app provides you with the freedom to craft custom scripts in TypeScript or JavaScript, and enables complex task automation without the need for costly single-purpose apps or manual workarounds. Our all-in-one scripting tool gives you total control over the monday.com API, delivering a cost-effective solution backed by the acclaimed ScriptRunner team. Because using multiple, low-code solutions for automation is so 2023 ! 🚀 Try Advanced Automations for monday for free here: monday.com: Apps Marketplace

I’ve encountered with a few strange moments in work with activity log (for short mention — AL). The first moment: Sometimes i get delay between changes in item and corresponding events in AL. Our app uses AL as source of the true for item’s state and makes changes in the app state after changing some items. But these changes appear in AL with delay. Occasionally the delay can be very long. It can be measured in minutes or tens minutes. It’s very sad. But this isn’t the main pain in ass. The second moment: When i move items between groups in the board, the appropriate event from the pair of events for moving in activity log doesn’t exist. For example, there is an event move_from_group (1) but there isn’t an event move_into_group (2) or vice versa. But a very happy moment awaits us in the future. After repeating request i get the second event but don’t receive the first event. And same behavior occurs with series ordinal updates in item’s values — two equals requests with same paramet