General

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

Hi Community, How to get subitems id columns in the playground any suggestions.

I have an issue with our app subitems template, I can’t replicate that in developer tho I’m using the published build. Any ideas what I can do? The problem is related with the workflow of presenting the options. If you want the specifics when deleting a subitem from a template, in developer I get the save template button and then the button option to apply the template. In prod, when I delete a subitem, I just get the apply template button. I can’t replicate that in developer even using published version.

Hello! Is there any way to make a query and check if there is any active Webhooks on a board I got? In the documentation I only found ways to create Webhooks (which I do) and delete Webhooks, but I would like to make a query and check if there are any active Webhooks so I don’t create them again if they exist. Anybody knows? 🙂 Thanks a lot!

Hello! Something strange happens when my webhook receives some data from Monday. It gives me the wrong board id. This is the board id I’m getting: When actually the board id is: 2167071773 When I’m trying to put the board id I got from the web hook in the url, it redirects me to the correct board id. Thanks! 🙂

Hello, i’m trying to build an API call to get all time tracking information about all boards and all items to use them for a more detailed controlling. But currently I am faced with the problem of filtering out all the zero values. My Code: query queryname { boards { name items { id name column_values (ids: "zeiterfassung") { id value } } } } The result i get: "data": { "boards": [ { "name": "Board 1", "items": [ { "id": "2268502411", "name": "Subitem", "column_values": [] } ] } { "name": "Board 2", "items": [ { "id": "2066324479", "name": "1.Introduction to Sales Professional (15min)", "column_values": [ { "id": "zeiterfassung", "value": "{\\"running\\":\\"false\\",\\"duration\\":19800,\\"startDate\\":1642092461,\\"additional_val

Hi There, TLDR: I’m having trouble with the monday OAUTH redirect_uri (post client authorization) as the monday system does not forward the state field as per the documentation. Currently the Oauth flow setup I have is as follows User is directed to the Monday app authrization page where the user clicks Authroize and approves the app’s scoped permissions: https://auth.monday.com/oauth2/authorize?client_id=<our apps client id>&state=<nonce generated by our system>&redirect_uri=https://<our app> Note: When this authorization page loads I can see the url changes to a new format i.e.: https://<subdomain>.monday.com/oauth2/authorize?oauth_payload_token=<jwt formatted token> I can see the jwt token when decoded clearly contains the state nonce that was passed to monday, suggesting it has been received (for the avoidance of any doubt that it has not). When the User clicks Authorize they are redirected to the redirect_uri however monday passes the state

Monday App Post At Carbon Web, we are a team of Monday.com enthusiasts who have always struggled with the ability to manage our client communication, service requests, and support from within Monday.com. With Ticket Booth, our Monday.com app, we were able to bring together many powerful features that Monday.com has to offer. By doing this, our team was able to eliminate the need for a 3rd party ticketing system all together! The first powerful feature Ticket Booth has to offer is a customizable board view called Tickets. Tickets view allows you to see Monday.com boards and pulses in a whole new way. With these highly customizable views, your Monday.com pulses will become tickets that hold all your client issues and requests. Take a look at how we viewed our ticket overview board before and after the Tickets view was installed. Before Tickets View After Tickets View BUT THAT’S NOT ALL! Tickets view also can provide a detailed display of all client communication and requests. We ac