General

I’m working with a large monday board with many items. I would like to fetch the latest 30 items appended to this board. Is there a way to do this with the current API? I am aware of the limit keyword, but this returns the first n items instead of the latest ones. Unfortunately, I am now forced to fetch the whole board which can easily take the Monday API up to 20 seconds.

I want to create a high level, overview of my project as the main page in Monday. If you’re familiar with Asana’s main portfolio page, that’s what I want to replicate. Somewhere where anyone can get an overview of a project’s current status, timeline, summary of the project goal, as well as quick access to key links and documents. Is there a way to make this that I’m not aware of?

HI All, In our Outlook integration we open an OAuth window to connect with monday, and it fails on IE11 on Windows 7 (Microsoft was kind enough to let us know) please see below : Is there a way to fix this?

Im starting my first steps, and i dont see how can i create a item and upload a file in the same line. Can anyone help me here.

Hello, I would like to know how I can construct a url to a board from the board id. My app queries monday.com and allows the user to select the board using the monday.com API. At the moment this is the query we are using: query: `query { boards (${options || ''}) { name description id workspace_id } }`, Since I have the board_id how can I construct a url so that I can link the user to the specific board? I have tried https://monday.com/boards/${board_id} but this generates a broken link

While creating a Monday API to connect our server to Monday board, I want to create an item with values for each colums. Problem : it works for every colum except for the rating one. I 've tried many syntax but no one works. The official doc at https://api.developer.monday.com/docs/rating doesn’t help. Does anybody know how to do it ? Here is the code : $column_values = [ 'name' => 'xxxxxxxxxx', 'person' => '20985745', 'status' => '14', // 'classement' => '5', // 'classement' => '5/5', // 'classement' => "{\\"rating\\":1}", // 'classement' => "{\\"rating\\":1\\"}", // 'classement' => "{rating:1}", // 'classement' => rating:1', // 'classement' => {'rating:1'}, // 'classement' => "{\\"rating:1\\"}", // 'classement' => 'rating 1', 'classement' => 'rating\\:1', 'date' => '2021-09-01 16:30:00', 'texte' => 'Bonjour', 'statut_1' => '1', 'personnes' => '20791487', 'lien_internet' =

Hi, I’m trying to create new items, providing column values. Everything it’s fine, except with link (url) columns. Can anybody tell me how to add a link field? I know that a link field has 2 subfields (“web address” and “text to display”), so I suppose that I have to provide an object with both values, but I cannot find any example in the documentation. What should be the proper way to add the link field: mutation { create_item (board_id:111111, item_name:“test3”, column_values: “{"link": "www.test.com"}” ) { id } }

Hello everyone! Excited to share the release of Tolstoy in the monday.com app marketplace! Tolstoy allows people to create interactive videos to better engage their audiences, creating asynchronous, face to face conversations. Besides providing people with the ability to create personalized conversations, Tolstoy videos also collect and qualify lead information; and now you can sync our data with monday.com! With our integration, Tolstoy makes it easy to automatically update your teams whenever new leads come in, or existing leads take some kind of action. Our monday.com users who have downloaded the Tolstoy app are already seeing success, check out our case study to see how the Homiee team increased lead submissions and reduced their homepage bounce rate with Tolstoy. What we’re so excited about is how versatile Tolstoy can be. From automating Customer Success Management, to onboarding, recruitment, and more people are using Tolstoy and seeing success in so many ways. You can even ch

Hi there, I’m using Postman to build out all of our API calls before coding them. I need to add a value to just one column while creating an item. However, I’m receiving a Parse error when sending the request. Is it escaped wrong? Thanks for anyone that can help! Here’s what the request body looks like: { “query”:“mutation { create_item (board_id: 12345, group_id: "Test board", item_name: "item_name", column_values: "{\\"text\\": \\"company_datetime\\" }" { id }”}

Hi, With our app we deploy it will multiple automations and a few sample items. In the template boards locally they are all there but when deployed the automations and items disappear. Any idea?

Hi all, Wondering if you experience the same. In a custom trigger I have defined the subscribe / unsubscribe endpoints. When the user makes a change to the recipe monday will go through the unsubscribe and then subscribe events. All works fine until my endpoint send a non-200 status from my unsubscribe endpoint. Monday will fail obviously, no problem. Any successive call monday make to my unsubscribe endpoint for that recipe contains an empty payload. I am discussing this with the appsupport team but wanted to know if you experience the same. Look like this bug is introduced in the weekend of July 24.

First off, the following closed thread is related and it would have been nice to comment there: Date format of activity_log.created_at field monday Apps & Developers Hi, I’m building an integration and I cannot see how to convert the activity_log.created_at field from an integer to a date. Cannot find anything in your KB, nor online in general. An example of a returned “date” field is “15905438472681046”, which corresponds to approx May 28th 2020 (give or take a few days) The number is too big to be Unix Epoch. Thanks I’m doing the same, querying and parsing activity_log queries. I’ve validated that the following Python/Pandas code converts Monday.com Unix timestamps correctly: import pandas as pd pd.to_datetime(16155031105053254 / 10000000, unit='s') >> Timestamp('2021-03-11 22:51:50.505325312') But the following also works: pd.to_datetime(16155031105053254 / 10000, unit='ms') >> Timestamp('2021-03-11 22:51:50.505325312') pd.to_d

I’ve noticed when using change_multiple_column_values with a column that doesn’t exist, instead of registering an error or simply doing nothing, it creates that column and populates it. How do I prevent this? I want to make sure that only existing columns are updated.

I have created a custom app in order to use a custom workspace template. I have created a sample workspace template as a feature in my app and installed the app to my organizations Monday.com account. However, I cannot find the workspace anywhere. Where does the workspace template appear?

I’m trying to create a custom trigger but I can’t put it in the frame, I haven’t used this tool much could someone help me? trigger: action: When I try to add to the frame I can’t.

Hey there, I’m having some trouble creating an item with a numeric column value. No matter what formatting I try, I get an error that says I am using an incorrect data structure for that column. Code and error response is below. Any tips appreciated! query6 = 'mutation ($myItemName: String!, $columnVals: JSON!) { create_item (board_id:BOARD_ID_HERE, item_name:$myItemName, column_values:$columnVals) { id } }' vars = { 'myItemName' : 'Hello everyone!', 'columnVals' : json.dumps({ 'numbers1' : {'value' : '25'} }) } data = {'query' : query6, 'variables' : vars} r = requests.post(url=apiUrl, json=data, headers=headers) numbers1 is the ID of the column in question. I’ve also tried the following formats in place of that line: 'numbers1' : {'value' : "25"} 'numbers1' : {'value' : 25} 'numbers1' : {'value' : "\\"25\\""} Every time I get the same error: {'error_code': 'ColumnValueException', 'status_code': 200, 'error_message': 'invalid value, please check our API documentation for the

Hi everyone, Since a couple of days we are receiving (we think) incorrect data using the GraphQL API for Monday. Or atleast the behaviour is not as expected. We are trying to query items inside of a specifc group and we want to retrieve the updates that are linked to each item. We are using the following query: query { boards (ids: 294306894) { name state groups (ids: new_group) { title items { id name updates { id creator_id } } } } } We do get updates but instead of each item having its own array of their own updates, every item has an identical array containing all updates from different items. Also adding item_id to the properties list for the updates we do see different ids which indicate the updates in the list are not just the updates for the item. I can’t remember this was the normal behaviour and

Hello! my code return one error when execute query. Using o monday playground that is query: mutation { change_simple_column_value (board_id: 1320360890, item_id: 1537903846 , column_id: "lider3", value: "{\\"email\\"=>\\"gabriellaselbach@gmail.com\\", \\"text\\"=>\\"gabriellaselbach@gmail.com\\"}") { id } } Here is code in Nodejs using graphql query --> mutation ($board_id: Int!, $item_id: Int!, $column_id: String, $value: String) { change_simple_column_value (board_id: $board_id, item_id: $item_id, column_id: $column_id, value: $value) { id } } variables { board_id: 1320360890, item_id: 1537903846, column_id: 'lider3', value: 'gabriella.staniecki@nodo.cc' } errors: [ { message: 'Nullability mismatch on variable $column_id and argument column_id (String / String!)', locations: [Array], fields: [Array] }, { message: 'Nullability mismatch on variable $value and argument value (String / String!)', locations

My authorization request is as below auth.monday.com and i have set my redirect uri to https://fc7f6898f266.ngrok.io/monday/test on monday platform (i have only one redirect uri set for my app) My problem is when I run the authorization request from the postman it shows me an error { "error": "invalid_request", "error_description": "Invalid redirect_uri" } Please help me out on this.

We’re using Subitems to track resources assigned to items on our boards. We’re using the API to pull everything into an external portal. We need a way to tie the subitems back to their parents, so we’ve set up mirror columns in the subitems, tied to their parent. The process is working, but populating the subitems’s mirror column is manual - user has to click on the field. We can’t find a way to automate it. Is there a way to do this programmatically via an app? Or is there an automation available that we’re not aware of?

Hi, last time I checked about this it seemed that things were quite limited with subitems, so I’d like to get a current answer. It’s my understanding that there’s now a create subitem method. To get all subitems for a board, you must first query all items in a board to retrieve the subitem IDs, and then query the subitem IDs (no way to directly query all subitems in a board). To modify a subitem, you can modify it like you would a normal item, correct? Thanks in advance.

Hi! Today the monday API request that I was using to get subitems broke, every new item that is using subitems, will not have a group id like “subitems_of_PARENT_ITEM”, but instead all group ids = “topics”. This is my API request: The GROUP_ID_FOR_PARENT_ITEM var below is something like “subitems_of_XXXXX” (with the exact item ID to use, I am inputting XXXXX to select ONLY subitems of a specific item) query { boards (ids: BOARD_ID_SUBITEMS) { groups (ids: GROUP_ID_FOR_PARENT_ITEM) { items { id name } } } } This works fine for my old items but suddenly new items added to my group will have all GROUP_ID_FOR_PARENT_ITEM = ‘topics’ now. Did you change the API? If so, any way I can now narrow down easily the subitems response only to subitems belonging to a specific item ID? Thanks, Lorenzo

Hi! What is the best way to retrieve all boards within a workspace? When querying for boards one cannot filter on workspace, and the Workspace type does not list the boards it contains. Any idea? Thanks!

Hi team, Please assist or guide me how to connect Monday connect to PowerBI

Hi all We have just transitioned our Monday boards into a new tenant, that we now share with a sister company. I used the cross account copier and integromat to facilitate 90% of the work. The challenge however is that I now need to extract a number of files that have been uploaded into Monday using the pulse update functionality. Can anyone please shed some light on the most effective strategy that I can apply to extracting the files and uploading them into the new tenant, which we now access. I cant seem to find any related (productive) feedback on the best step to take, and which is the best technology to achieve that? Thank you