General

Hi, I want to get all the Board IDs via API my account sees on monday.com. However some of them are missing. I have an API-key, and I use the query: ‘query {boards () { name id }}’ I got around 25 IDs back, but my Workspaces got far more than that. What could be the problem?

In the error code docs, the UserUnauthorizedException is misspelled as UserUnauthroizedException. This misspelling is also present in the error_code when the API returns an error corresponding to that exception. It looks like it’s been that way for a good bit judging by past posts that mention the error with the misspelling (dating back to October 2020). Is this intended to remain in the event that it breaks others’ flow(s)? Not that I can’t just check for either spelling on my end.

Hi, When retrieving Hour column via API, the text field of column_values is always formatted in 12h format. I would expect it to be formatted based on configured format. Example API response, where hour column is configured to 24h format and hour_1 to 12h format: { "id": "hour", "text": "05:00 AM", "value": "{\\"hour\\":5,\\"minute\\":0,\\"changed_at\\":\\"2021-12-12T22:09:27.203Z\\"}" }, { "id": "hour_1", "text": "12:00 PM", "value": "{\\"hour\\":12,\\"minute\\":0,\\"changed_at\\":\\"2022-03-05T15:02:04.517Z\\"}" } Would it be possible to get text value formatted based on configured format? Thanks, Lubos

Does anyone have an example on how to parse the following response using C#? I was able to just Json My end goal is to get the json string into a list to create a file with. Thank you for any assistance! { "activity_logs": [ { "data": "{\\"board_id\\":2165785546,\\"group_id\\":\\"new_group2051\\",\\"is_top_group\\":false,\\"pulse_id\\":2165787062,\\"pulse_name\\":\\"Tyler\\",\\"column_id\\":\\"email_address\\",\\"column_type\\":\\"email\\",\\"column_title\\":\\"Email Address\\",\\"value\\":{\\"column_settings\\":{\\"includePulseInSubject\\":true,\\"ccPulse\\":true,\\"bccList\\":\\"\\"}},\\"previous_value\\":{\\"email\\":\\"tyler@email.com\\",\\"text\\":\\"tyler@email.com\\",\\"changed_at\\":\\"2022-02-15T21:18:48.297Z\\",\\"column_settings\\":{\\"includePulseInSubject\\":true,\\"ccPulse\\":true,\\"bccList\\":\\"\\"}},\\"is_column_with_hide_permissions\\":false,\\"previous_textual_value\\":\\"tyler@email.com\\"}" }, { "data": "{\\"board_id\\":2165785546,\\"grou

What would be the GraphQL syntax to retrieve all data in my account - boards, IDs, items, subitems, anything else in the account?

I am trying to list by API the apps installed in my Monday account. Looking at the network, I see the call to the backend is: https://slug.monday.com/apps with the cookie as the authentication method. This works great for me. Now I am trying to do the same on behalf of an app. I created an app, and gave it all permissions at Set Up Permission Scopes. I can’t get any response using the app token I got. What I tried to do instead, is running the graphql at https://api.monday.com/v2/ with the query: query { apps { created_at } } but then I got: { "errors": [ { "message": "Permission Denied! Your token doesn't grant access to apps:read" } ], } When trying to add apps:read to the consent link, I get: {"error":"invalid_scope","error_description":"Invalid scope param"} Is there any other way to list the apps?

I am trying to load a board including the subitems to the excel from Monday. I’ve used the following code to do so and recieved the following error: Code: [ Headers=[ #“Method”=“POST”, #“Content-Type”=“application/json”, #“Authorization”=“Bearer " & Key ], Content=Text.ToBinary(”{““query””: ““query { boards(ids: " & Board & “) { items { name, updated_at, group { title }, columns: column_values { title, text } subitems { name } } } }””}”) ] ), Data = Table.FromList(Json.Document(Source)[data][boards]{0}[items], Record.FieldValues, {“Title”, “UpdatedAt”, “Group”, “Columns”}), #“Monday” = Table.FromRecords(Table.TransformRows(Data, each List.Accumulate([Columns], [ Title = [Title], UpdateDate = [UpdatedAt], Group = [Group][title] ], (state, current) => Record.AddField(state, current[title], current[text]) ) )) Error: DataFormat.Error: There were more columns in the result than expected. Details: Count=4 Thank you in advance.

Is there a way to retrieve custom user defined fields from items in the API calls?

Hi fellow developers I am trying to get my head around this. I need to query all items and subitems in a given board. Due to the amount of items and the level of nesting the query will hit complexity very soon. I want to use pagination to query in smaller pieces but I have to wait for the next minute (reset of complexity) and I am using shortLivedTokens to access the API. If I just wait for 1 minute the shortLivedToken will not be valid anymore. At this moment the query takes place during the subscribe of an integration app with a custom trigger. I don’t see a way to “refresh” the short lived token as I can’t respond with non-200 (no retries will be done from monday). I can redesign in a way the query takes place in an action so I can respond with non-200 and wait for the retry (which will contain a new shortLivedToken). The challenge with that is to keep track of which page is required. Any ideas are welcome.

Hi, I am trying to duplicate 3 boards every 2 weeks (so not running into the limit) using python. Running the code does not yield any error but the board is not duplicated. Any ideas what I should do? def duplicate_board(board_id, name): query = 'mutation ($name: String!) { duplicate_board(board_id:'+str(board_id)+', duplicate_type: duplicate_board_with_structure, board_name: $name) {board {id} }}' vars = { 'name' : name } data = {'query' : query, 'variables' : vars} r = requests.post(url=apiUrl, json=data, headers=headers) # make request print(r.json())

Is it just me or the way Monday handles column ids is super difficult to manage? I have the graphql mutation running and every time I have to guess what is the columnId for the specific column I need to update. Not cool that I have to open the developer tools, inspect the network tab and then find the column id of my column. Isn’t there a way to avail this on the UI? I can’t find a way to create subitems’ columns which could have sold the issue but still a lot of overhead for what should have been a pretty single thing to have

I have a flat table with row data. From that, I want to create parent items and their respective subitems. I made up a store example. I want to track the things I receive for my store in a board where the item (parent) is the Box, and in it can be one or multiple different items (subitems). I’m looking for a starting point or suggestions- do I first create the items, store the parent item ids somewhere, then loop back and create the subitems for each? Or can I do it all ‘in one move’ as I iterate through the list. I’m actually working in VBA but Python code would be helpful too. Here’s a graphic: Thanks!

Hello, I have been seeing this a lot recently where zapier is changing statuses in monday to numbers and I am not sure why. I was wondering if anyone has seen this before?

How can I build a custom field with the nested options list like in the Gmail integration.

Background: We have integration which creates an item on the Monday board when action is created in our platform. It is using Graph QL API to achieve this. Use case: We want to populate people columns on the Monday with created by and assigned to users but we know only emails of these users. Problem: According to documentation the user ids should be provided to be able to populate “people” column value. https://api.developer.monday.com/docs/people The apps framework docs say that you can populate people fields by providing only emais. https://apps.developer.monday.com/docs/dynamic-mapping#examples-of-each-field-type Is there way to populate “People” column value by posting only user email?

Is it possible to merge two queries into one? I want to return the column values for “Name” and “Email_Address” where the column “batch_5” = “70”. this would be merging the queries for items_by_column_values and items? This is the query I have but it returns all the columns: query { items_by_column_values (board_id: 1234, column_id: “batch_5”, column_value: “70”) { name column_values { id text } } }

How can I print only the items in a board with the status marked as “Done” using Python? Here is my current code-> import requests import json import pprint apiKey = “MyApiKey” apiUrl = “https://api.monday.com/v2” headers = {“Authorization” : apiKey} query2 = ‘{boards (ids: 2257165976) { name items { name column_values {title value text} } } }’ data = {‘query’ : query2} r = requests.post(url=apiUrl, json=data, headers=headers) # make request pprint.pprint(r.json(), width=400)

Hello, I have been working with the Monday API with some success. I have run into difficulty with change_multiple_column_values. Here is the error: message: “Parse error on “: {” (STRING) at [1, 107]”, the character at 107 is a semicolon I have a working query in POSTMAN mutation { change_multiple_column_values (item_id: 22222222, board_id: 1111111111, column_values: "{\\"date4\\": {\\"date\\":\\"1993-08-27\\"},\\"text9\\": \\"Barney Rubble\\",\\"text0\\": \\"Corporate\\",\\"link\\":{\\"url\\" : \\"https://support.company.com/app/itdesk/ui/requests/109348000039391139/details#\\", \\"text\\":\\"Original Request\\"} }") { id } } So I took that POSTMAN query and escaped it to use in a C# console app {\\"query\\":\\"mutation {change_multiple_column_values (item_id: 22222222, board_id: 1111111111, column_values: \\\\\\"{\\\\\\"date4\\\\\\": {\\\\\\"date\\\\\\":\\\\\\"1993-08-27\\\\\\"},\\\\\\"text9\\\\\\": \\\\\\"Barney Rubble\\\\\\",\\\\\\"text0\\\\\\": \\\\\\"Corporate\\\\\\",\

When building plugins for CMS like Wordpress, we usually use localization to cater to bigger market opportunities, is there any guide / best practices to utilize localization when building a Monday Apps ?

Can anyone help me in finding the best monday.com developers for implementation?

Hi, I am trying to use the graphql API to add a file to a column. The query seems to work as I receive an asset ID in the response, but I don’t see the file in the item/column when I go on Monday.com. Furthermore when I query the asset to get the url and open it in my browser I see the following error : “SyntaxError: JSON.parse: unexpected character at line 1 column 1 of the JSON data”. Here is the request I am doing: curl --location --request POST 'https://api.monday.com/v2/file' \\ --header 'Authorization: SecretKey' \\ --form 'query="mutation add_file($file: File!, $item_id: Int!, $column_id: String!) {add_file_to_column (item_id: $item_id, column_id: $column_id, file: $file) {id}}"' \\ --form 'variables="{\\"item_id\\":2286426338, \\"column_id\\": \\"files\\"}"' \\ --form 'map="{\\"image\\":\\"variables.file\\"}"' \\ --form 'image=@"/home/gdacier/Documents/Myphoto.jpg"' Note that when I try to add the same file to an udpate using add_file_to_update it works : curl --location --req

Hello All, Is there a way to export a board with all the color fields and formatting using the API? From what I’ve read it seems I can only pull all the information via a query then create the excel file and format the fields using code. I want to make an API call that will give me the exported board as a file so I can upload it to Google Drive. Thanks for any help or ideas!

Hi all, I’m Noah, just some random dude on the internet and not a monday partner (yet?) 😛 I created a new app called “Gamify My Workflow” as part of the Monday hackathon. I built it because I wanted to mix my insatiable desire for more in-game lives with my desire to get work done! The app is actually a bit more than an app, it’s a gamification service. The current iteration allows users to earn in-game lives when they complete tasks (customizable via board recipes). With these lives, users are able to play a fun minigame “Battles!” written in Unity (with more games on the way). Effectively the app uses gamification to boost productivity. For now it’s fairly basic, but I plan on implementing a management dashboard/admin panel to allow for the creation of custom rewards (both in-game, and real-world), leaderboards, full customization of games, and a public API so those inclined can make their own games. This app is really meant to help those who struggle with motivation, we are

Use case: Our platform has 4 fixed states for action item and when we syncing changes from our side to Monday it works well because Status column can support any values even when they are not created. Problem: users want to have them mapped to specific status values in the Monday. e.g. “Paused” in our platform would be equal to “Stuck” in Monday etc. Does Monday provides such possibilities? Also we are considering to sync changes from Monday to our platform and it will be the same issue.

Hi guys, We have a problem, we think monday webhooks are down, no signal has arrived to our server , and automations does not work. Please help