API & Apps framework

I would consider that I have a pretty hefty monday.com script that is creating, moving, updating, etc. around 8k items. I occasionally run into errors indicating that my new board was not created correctly. Normally if I just run the script again, it’s fixed. I’d assume this is just due to latency. I’ve also put time.sleep() functions throughout my script to make sure I am not hitting any limits. I’ve had a couple successful runs. However, I recently ran into this error: [Errno 10054] An existing connection was forcibly closed by the remote host. Through stack exchange and other community platforms, it seems that this is actually due to being connected to monday’s API for too long??? My script is taking on average about 2 hours to run. Sometimes my computer will “fall asleep”, could this be an issue? Has anyone else come upon this error or have any suggestions? Currently trying this method to hone down on where the error might be coming from, or if it’s consistent. try: r = request

With the new API - how do I return the contents of the subitems column? My old query does - but haven’t worked out how to update the new query? OLD: query { boards(ids: " & Board & ") { items { id, name, updated_at, group { title }, columns: column_values { title, text } } } } NEW: column is empty… query { boards(ids: " & Board & ") {items_page (limit: 500) {items {id, name, updated_at, group {title} column_values {column{title} text …on MirrorValue {display_value} …on BoardRelationValue {display_value}}}}}}

Hello! It’s exciting to hear about the Monday Code platform, but I’d really like to clarify its status at this time. I have seen in various places: “Access is restricted to select developers who can connect a limited number of apps per account for the time being” and “Currently available only for integration type features”. It’s not clear how to become a “select developer” or what the roadmap is for expanding the functionality that can be covered within Code. In general, what’s the level of “readiness” of Code for a marketplace app? Thank you for any insights! Dan

I’ve got a query that I am running, in which there are a large amount of Mirror columns. Previously, I was able to fetch all of this data using the text field. However, introducing unravelling MirrorValue increases the time of this request from 2 seconds to 7.5 seconds while still only querying a single column. It looks like this continues to compound with more data and columns. The data stored in the MirrorValue is required to resolve the value of the column. Am I doing this completely wrong? This seems like a massive regression with the new API. In addition, since the pagination requires a cursor from the previous response, this drastically increases the net time to paginate through a board as concurrent queries are not possible. In addition, it doesn’t look like I can actually grab the text values of Dropdowns at all with this new system. Old Query (2 seconds): "{boards(ids:[BOARD_ID]){items (limit: 50, page: 1) {name, group(){title} column_values(ids: [mirror1, dropdown, shift_days

I’m building an integration and have the need for a settings page for the integration. Where do you recommend that settings page is added? I noticed there’s an Account Settings View that can be added to an app. I was trying to add a settings page there using a custom URL from my server, but am having issues with authentication. I noticed that JWT is not used for that page, but instead a session token is passed to the page. Trying to use the Monday SDK and setting this token with monday.setToken(sessionToken) leads to a “Not Authenticated” response once I try and make an API call with monday.api(MY_QUERY). If you recommend I use the Account Settings View for an apps settings, how should I authenticate with my server so I only show the settings relevant to that user? Another option I’ve seen is using a Board View, but then the page is tied to a board, which doesn’t seem to make sense from an app settings perspective, since the integration isn’t board-specific.

Hi everyone, Where I work, we’ve been using Monday to manage our projects, but we’re encountering a recurring issue with the complexity limit of 5M. We have approximately 40 boards containing thousends of items and subitems, and as we’re in the process of setting up a data warehouse, we find ourselves needing to query the entire information regularly throughout the day. However, every time we make these queries, we encounter an error stating that the complexity budget is exhausted, and we have to wait for a 60-second reset. We’ve tried several approaches to address this issue, including making the queries more efficiently and experimenting with Make.com, but the problem persists. Waiting for the reset is not a desirable solution for us. So, my question to the community is: Is there a way to bypass the complexity budget? Perhaps by creating different apps and querying through them? Any help or advice would be greatly appreciated. Thanks

Hi, I was using the 2023-07 API version, the type of the number field was “numeric”, then when I upgraded to the 2023-10 version, this time it started to appear as “numbers”. There is nothing in the API changelog about when this situation changed. Can you clarify this situation? (Also, when I examine my previous user records, it appears that the numeric field used to contain numbers (2020, 2021…)) Thanks

I would like to use a Monday Dashboard to display some metrics linked to a board. With GraphQL I can create the board, add a group, add sub-items and the values that I want to display in metrics. But currently, in the Dashboard I have to add widgets one by one, link them to sub-items etc… Is it possible via a Mutation to create Widgets (Charts, Numbers, etc.) directly with GraphQL?

Before to add a new line in a board with a people column I need to verify if the user exist on Monday otherwise it fails. I got team list, but found no way to know which team is attached with a board. Is it possible ? How to get this information ?

I want to insert a newline and a tab in a long_text field using the API from my C# program. I have tried , “\\r\\n”, “\\n” and “\\u21B5” but they are either rejected or do not cause a linebreak. Kind of weird cause when I look inside Monday.com items I see they store it as \\n. Something downstream has decided to reject control chars. How do I accomplish this?

Hi - over several weeks I have tried to update the 2 lovely all-purpose queries I have been using for all of my PowerBI reports against monday.com. I am now pulling the last of my hairs out… I am not an expert query writer and am just getting frustrated now! I had 1 query for all items in a selected board and 1 query for all sub-items (and then related them in Power BI). I just need all-purpose queries that will handle 500-1000 items, give me the contents of the subitem column and give me MirrorValue and BoardRelationValue data… I need the whole query, not just the GraphQL - so that I can drop into a Power BI dataflow. THIS WAS MY ITEMS QUERY… let Key = “”, Board = “”, Source = Web.Contents( “https://api.monday.com/v2”, [ Headers=[ #“Method”=“POST”, #“Content-Type”=“application/json”, #“Authorization”=“Bearer " & Key ], Content=Text.ToBinary(”{““query””: ““query { boards(ids: " & Board & “) { items { id, name, updated_at, group { title }, columns: column_values { title, te

Hey monday.com community! 🙌 We’re excited to announce that Autoboost is now widely released with some amazing new features! 🤩 We have released the mirror columns! We can use the subitem values in the item! We can copy the group summary value and use it! To top it off, our free plan has been updated to include 250 free monthly operations. Get started with Autoboost in the Marketplace now and automate your processes! 🎉

I have been using Monday.com Audit Logs API token for almost 2years and we have use this Audit Log API token in a script we run which saves these logs from Monday.com to AWS s3. This API token automatically got deleted on its own. When you go to Monitor by API section in Audit logs, we cannot even edit or delete this token ourselves. So how did this token get deleted? is it possible that this happened due to an admin deactivation? if yes, why did it only happen in Production and not in Sandbox? I have confirmed with Development team that tjere is no auto refresh option available so why did this happen? if i wish to Regenerate a new token, how do i do that, given there’s no option to delete or edit the audit log api token?

When I create a new board in the API it always defaults to the main column being called Item. Is there a way to specify that I want a board which manages Tasks or Projects instead? (Mimicking the behavior of the UI which asks when you create a new board.)

I have been using Monday.com Audit Logs API token for almost 2years and we have use this Audit Log API token in a script we run which saves these logs from Monday.com to AWS s3. This API token automatically got deleted on its own. When you go to Monitor by API section in Audit logs, we cannot even edit or delete this token ourselves. So how did this token get deleted? is it possible that this happened due to an admin deactivation? if yes, why did it only happen in Production and not in Sandbox? I have confirmed with Development team that tjere is no auto refresh option available so why did this happen? if i wish to Regenerate a new token, how do i do that, given there’s no option to delete or edit the audit log api token?

Hey friends! I noticed something strange recently with my app’s board view- it refreshes itself after it’s initial load. About a second after its initial load, the iframe is given the same query params except for the sessionToken and refreshed- this causes a (very annoying) refresh/flicker of the board view UI. It’s possible I’m responsible for this, but as a test, I deleted all the code from that app and returned an empty view, and the 2nd call with a different session token still happened. Anyone else experiencing this? Any thoughts or ideas where I could dig to find out more? Thanks!

I’d like to do some analysis from the Activity Log on our account. I can navigate to the export of that for a set time frame, but the spreadsheet returned doesn’t provide the “item ID” number that would allow me to group activity for a given item. Is there a way to include the “item ID” field in the download? Can that be done using the API query?

Hi there! I’m struggling with a parse error in a query that is very similar to other queries that work properly and I can’t understand what’s wrong. I’m using Python. Here’s an exemple of working code: def check_monday_card(service: str, account_id: str, region: str, start_time_monday: str) -> Optional[str]: check_card_query = 'query($ids: ID!){boards (ids: [$ids]){ items_page (limit:50){ cursor items { id name column_values { id text value }}}}}' check_card_details = {'ids': board_id } query_data = {'query': check_card_query, 'variables': check_card_details} check_request = requests.post(url=MONDAY_API_URL, json=query_data, headers=headers) check_response = check_request.json() page_cursor = check_response['data']['boards'][0]['items_page']['cursor'] items = check_response['data']['boards'][0]['items_page']['items'] for item in items: item_id = item['id'] item_name = item['name'] item_account = item['column_values'][0]['t

Looking for some aid or suggested alternate solution on how to use the API to move/convert an item within a group, to a subitem within the same group. Have: Wanted: Current Workflow: I have been successful with taking the name of the group and creating an additional item within its group. For example: I have also been successful with creating the subitem in Group One, however, the columns do not transfer over. I’d like to avoid this methodolgy since it requires me to first query and format the group data to be fed into “create_subitems”. Seems like a very redundent method. (Note, the printed column_values in the code do not match the picture. Just an example). def create_subitem_for_item(item_id, sub_item_name, column_values): query = """ mutation ($itemId: ID!, $subItemName: String!, $columnValues: JSON) { create_subitem ( parent_item_id: $itemId, item_name: $subItemName, column_values: $columnValues create_labels_if_

Hi, When you use monday.storage.instance, where can you see the actual storage? tried to look for it in the inspect->Application->storage… for debugging… but didnt found any of the key-value pairs we stored… Thanks

Is there a way to query a particular column to see how many files are attached there?

Hey there, while developing custom actions I’m currently facing the following issue: It seems for me that there is no way when my application receives the event to distinguish whether: The event is a retry by monday servers because the first try took too long or had an invalid status code as response. From the docs: “If your server responds with any other status, or doesn’t respond within a minute, the monday platform will retry calling your endpoint every minute for 30 minutes .” The user triggered another event without changing any data (e.g. by pressing a button twice) Why is that important? Lets say i have a custom action that increments a product quantity in a foreign system but takes 2 minutes to complete. Each press of a button should increment the quantity by one. Now its impossible for me, to distinguish: Did the user click the button again or was it just a retry by monday? Yes, I could prevent retries by just sending a status 200 on the first received request. But then I

Hey devs! I’m building an app that uses custom field mappings, but I’m experiencing a browser hang/crash. I have an app where in the recipe, the user is given a dynamic list of items as a response from my server, and based on what was selected from that list, will be presented with a custom mapper modal. I’m experiencing two things: In the very simple case where there is just one field to map, the modal is presented and doesn’t crash, but the textfield isn’t populated with the mapping choice I made, it just looks empty. The system seems to be mapping it though, because I can click done and when the automation runs, I get the value that was mapped. In the more complex case where there are 5+ items to map, the modal opens and the loading gif is shown, but my browser hangs and crashes my browser tab. The fact that the simple case is working gives me hope that I have the payload structure correct, but I’m not sure where to go from here, or what more information I can give to help dia

Hi there, I’m creating an item with a date with UTC timezone with the Monday API. My profile timezone is UTC. However, when I examine the item created in the Monday dashboard, the date field is not UTC. You can see the query and images below. Could you please check it and let us know how to fix it? { "query": "mutation($values:JSON) {create_item(board_id: 1159054932, group_id: \\"topics\\", item_name: \\"Task 3\\", column_values: $values) {id}}", "variables": { "values": "{\\"date4\\":{\\"date\\" : \\"2023-08-27\\", \\"time\\": \\"18:00:00\\"}}" } }

I’m trying to run this code to update column values on an existing item by its ID, but I’m getting this error: List dimension mismatch on variable $id and argument item_id ([ID!] / ID) My ID is an INT so not sure what I’m doing wrong here. $id = 5543373657 $new_service_level = "Digital"; $new_monthly_rate = "$250"; $query = 'mutation ($id: [ID!], $columnVals: JSON!) { change_multiple_column_values (board_id:XXXXXXX, item_id:$id, column_values:$columnVals) { id } }'; $vars = [ 'id' => $id, 'columnVals' => json_encode([ 'status' => ['label' => $new_service_level], //Service Level 'text17' => $new_monthly_rate //Monthly Bill Rate ])]; $data = @file_get_contents($apiUrl, false, stream_context_create([ 'http' => [ 'method' => 'POST', 'header' => $headers, 'content' => json_encode(['query' => $query, 'variables' => $vars]), ] ])); $tempContents = json_decode($data, true);