General

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 {d

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

Good day Monday Community, We at Trix Solutions are please to announce the official release of our Moncli v1.2 Python client! With this release, we have achieved parity with ALL features available via the Monday.com API. New features include (but are not limited to): Add and remove a user from a workspace. Add and remove teams from a workspace. Change simple column value on an item. Change the title of a column. Change the name of an item. Retrieve a subitem’s parent item. Location and Dependency column values are now supported. Support for all Webhook event types We look forward to engaging with the community regarding issues, feedback, or additional features that they wish to see moving forward. Please feel free to reach out to me a

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 (

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

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 ?

Hello Everyone! We have created a detailed video tutorial on how to export monday.com data to Power BI. https://www.youtube.com/watch?v=rpWepnJxrwI You can enhance your reporting efficiency and attain a more profound understanding of your team’s productivity with Power BI Connector monday.com: Apps Marketplace We hope this tutorial will make your work easier and be useful. Excited to hear your thoughts!

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

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']

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:

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 inc

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 w

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