API & Apps framework

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 } }

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

Hello, I updated the Data Clean view app with a feedback link and a know more link. I did this in a minor version and made it live. However the view is not updated, on multiple accounts, after a vigorous* cache refresh. Any idea why? Thanks, Laurent vigorous: * I pressed very strongly on my keyboard keys.

Hi, I am trying to use item mapping for a column that contains images. I have tried different things but it doesn’t work, its also not specified in the documentation. Does anybody have any experience with this or can suggest a workaround? Thanks in advanced. EDIT: Added more detail Essentially I am trying to send to an external API a text column and an image column when a particular date/time in another column in the same row expires. I created a recipe but found here a way to map the data far calls from monday.com to external apis. I mapped the first text field as described in the docs but I am having trouble mapping the image.

The type of field “replies” on Updates is “Replay”. what are the fields of this type (“Replay”)?

I’ve notices that there are inconsistencies in the documentation for the create_group and duplicate_group mutations, and I’m trying to understand what the reality is: In the create group mutation, the API lists group_name (!string) as the name of the group. In the duplicate group mutation, the API lists group_title (string) as the title, and group_id (!string) as the “unique identifier”. In the other 2 mutations (archive, delete), only group_id is listed. So I’m trying to understand what exactly group_name, group_title and group_id are and what they are used for. Is one of these a typo, does one serve the same purpose as another? Or is there really a unique purpose for each one of them, and if so, what is it?