Welcome to the new monday developer community
-
Recently active
We’re having an issue with a widget we’re developing. We’re building a widget to show a view of all of our approaching deadlines for our active projects. The widget is consuming about 30+ boards. We’re using the settings panel to select which column represents the delivery date for each connected board because they aren’t always consistent. When I test the widget, the settings load fine, but when anyone else tests the widget it just comes in as an empty object. What users get in the dev console: What I get in the dev console: Any thoughts as to why our standard users can’t load the settings established by the dashboard owners?
Hi, Im facing something really weird during my api / ui tests. im getting all subitems from a board by board id and get a list of subitems. when trying updating them by change_multiple_column_value im getting success message on each, but I can’t see some of them in the UI although I got them via api. when trying access it by ui (paste the item id) Im getting message : This subitem is either deleted or belongs to a deleted board/group" how that can be happens? note - the state for each rule is active.
Hello Monday API Community, I’m currently working on a project where I need to retrieve the contents of all columns of a specific item, including various field types such as mirror and connected boards. My current approach involves making at least three separate API queries, but I’m wondering if there’s a more efficient way to accomplish this. First Query: I start with a basic query to fetch the dataset, like so: query { items (ids: XXXXXXX) { name, column_values { column { id title } id type text value } } } However, this returns null or empty values for mirrored or connected fields. Second Query: To retrieve mirrored field values, I use: query { items (ids:XXXXXXXXX) { column_values { ... on MirrorValue { id display_value text value } } } } Third Query**: Finally, for connected board fields, I query: query { items (ids:XXXXXXXXX) { column_values { ... on BoardRelati
I currently have several Formula columns that are using REPLACE(REGEXEXTRACT()) to pull strings from a long-form Text column. I want to use the results of these formulas to trigger automations which will move the Items to different Groups. Example: The long-form Text column is a mirror of the content of an incoming email that triggered the creation of the item. The email contains text such as: Brand: TH Region: NA Company: TH_USKS The brand, region, and company are a variable number of characters. The Formula column for Brand, for example, uses the formula REPLACE(REGEXEXTRACT({Email Content}, “Brand: [^\\s]+”), 1, 7, “”) → this would return “TH” for the above example. Since I am not able to use Formula columns within Automations, I am attempting to use General Caster to perform the formulas and cast the results to Text columns which can be used in Automations. It seems that General Caster does not support REGEXEXTRACT(). I don’t think I can use SEARCH() because the strings I’m looking
Has anyone attempted to develop an API or devise a method for exporting Monday.com activity logs in bulk for subsequent importation into Power BI for analysis? If so, I would greatly appreciate it if you could share the approach you took to achieve this. Thank you!
🚨Attention all developers! 🚨 On Jan 15, the 2023-07 API version will be deprecated. Any API request with version header 2023-07 will use 2023-10, and any request with no version header will use version 2024-1. You must take action before this deadline so your app’s features remain available for your valued customers. If you fail to implement the necessary changes for the new API version, your app may break and certain features may become inaccessible. We want to prevent disruption and ensure smooth experiences for both you and your users. As of now, you have 12 days to implement these changes. The clock is ticking, so please allocate the necessary resources and prioritize this update. We strongly recommend taking immediate action to avoid any inconvenience or potential negative impact on your apps’ functionality. If you have already started implementing the changes for the 2023-10 API version, we’d appreciate it if you could let us know by commenting on this post. It wi
Does anyone know a quick way to query for an item’s name using the item’s itemId and the boardId it exists in?
G’day Monday.com community! 👋 Today I’m excited to share the Reports by Screenful app for Monday.com, which won a Staff Picks prize in the recent Monday Apps Challenge! 🎉 The app is an easy-to-use business intelligence solution for monday.com, which allows you to create reports of your task data and share them via email or Slack. 👉 Click here to install the app! 👈 You can use the app by creating a board view to your table and choosing Reports by Screenful as the view. You can use it as a standalone app in the browser, but you must have the app installed on Monday first. If you have any questions or feedback — feel free to get in touch with us at support@screenful.com Have a nice day and happy reporting! ❤️
Hello, I can’t wrap my head around the new API syntax needed. I am just wanting to query the item by id and return its column values… The following syntax worked fine on the old API. {user: boards(ids: ‘id_here’) { items (ids: [‘id_here’]) { name id column_values { id title value text } } }'; I can’t seem to get a valid column_values query going now… I’ve looked through the docs and they don’t make sense to me… I think I am doing it right but just get errors back. Can someone please translate that old query above into a new, working format ? I know this is kind of lazy to ask like this but it’s really doing my head in… Thanks.
I’m migrating some code to the new 2023-10 api format, and the complexity of a query increated from 15049 to 354652 (more than 20 times) - this renders the integration useless, as my complexity budget is only 1m - meaning I can run this query twice a minute - and I need more than that. The query is a simple query of a single item with it’s sub items (has 4 sub items) Here’s the original query: query ($id: Int!) { complexity{ query } boards(ids: [2673923561]) { id name board_folder_id board_kind items(ids: [$id]) { id name column_values{ id title value } subitems { name id column_values { id title value } } } } } And here’s the same query after migrating it to the 2023-10 api structure - which costs 354652: query ($id: ID!) { complexity{ query } boards(ids: [2673923561]) { id name board_folder_id board_kind
I am using itemIds listener in my board view, as soon as i click on new task button, I get listener and in data I get itemIds, but one of the item id is ( -10 ), why am i getting such id, and is there any way of validating that a itemId is an actual valid item id, not any other number or string? or is there any way of removing that add task button from my board view. Example of itemIds listener data when clicked on add new task: [“itemId”, “anotherItemId”, …, -10 ] refer this image:
Demo - https://www.youtube.com/watch?v=P-qHV6kkyds ⬇️ Download link - All View Build and customize views for all of your sources and assets without ever leave monday. Categorized your sources however you want, that will perfectly fit your organization needs. Achieve brilliant views with just 2 minutes of setup! Usage Examples: 💡 Sources/Assets management 💡 Quick access to all of your tools 💡 Relevant docs and assets for each board/account 💡 Build Sales/Projects Onboarding 💡 Build Knowledge Base 💡 Social media content management 💡 HR Processes 💡 All of your forms in one place 💡 Categorize everything and many many more! Using the All View app, you can build your personal views right into your: ✅ Board views ✅ Custom Objects ✅ Items Views To get started: Choose View - Board View/Item View/Custom Object. Click Add Source or Add From Template. Insert Source name and details. Categoriz
import requests import json class MondayClient: def __init__(self, api_key): self.api_url = "https://api.monday.com/v2" self.headers = {"Authorization": api_key} def make_request(self, query): data = json.dumps({'query': query}) response = requests.post(self.api_url, headers=self.headers, data=data) return response.json() def create_item(self, board_id, item_name): query = f''' mutation {{ create_item (board_id: {board_id}, item_name: "{item_name}") {{ id }} }} ''' return self.make_request(query) def change_item_name(self, board_id, item_id, new_name): query = f''' mutation {{ change_column_value (board_id: {board_id}, item_id: {item_id}, column_id: "name", value: "{{\\\\"text\\\\": \\\\"{new_name}\\\\"}}") {{ id }} }} ''' return self.make_request(query) # Add more methods as need
Hi, I’m on migration of a lot of powerby using API Monday.com. And during my debugging and query’s rebuild (thanks a lot @hbouk ) i see that board_relation send data only if a query param is parsed. I have the same result with api playground Blockquote boards(ids:xxxxx) { items_page(limit: 100 query_params: {rules: [{column_id: “board_relation”, compare_value: , operator:is_not_empty}]} ) { cursor items { id name updated_at group { title } column_values { id text … on StatusValue { text } … on MirrorValue { display_value } … on FormulaValue { value } … on BoardRelationValue { display_value } column { title type } Result : “id”: “board_relation”, “text”: null, “display_value”: “12E4S2XD08 : CZ - ThinkCentre M70q Wifi - Gen3 (OS:Win)”, “column”: { “title”: “link to Subitems of JMS_Commande”, “type”: “board_relation” } }, { “id”: “mirror”, “text”: null, “display_value”: “WSEM00VA4H”, “column”: { “title”: “Mirror”, “type”: “mirror” } but if i query without qu
Hello everyone, I’ve recently joined Monday.com dev community, and I cannot figure out one important issue: In order to use SDK I need to initialize access token through mapps init command So, I’ve tried multiple options (local/global/with different access rights), and always getting the same log: INFO: ‘.mappsrc’ created (by the way with -l key .mappsrc is even automatically added to .gitignore) But the problem is, I don’t see the ‘.mappsrc’ file anywhere, as well as as soon as I try to use any feature (i.e. tunnel), I’m getting this error: Access token is missing, please run: “mapps init” What could be the issue? SDK added globally, as well as added to the project itself. Tried with template app as well as with react/next apps - same story all the time Dependencies: “@mondaycom/apps-sdk”: “^2.0.0” Also, to avoid asking another question, will ask here: The only why I need SDK, is to try to fetch the request details which board user is currently selected. Is it possible? App is a board
I’ve found that a duplicated board creates the groups within the duplicate with the same group Id’s. When querying both boards it can’t tell the difference between the groups due to identical ID’s. I just find it odd that the ID’s are identical when typically an ID is unique. Has anyone else run into this? I’m relatively new working with this API, so forgive me if I’m missing something obvious.
Hi, We are observing complexity issue with board graphQL api with minimal response properties and a limit of 10 records only. Is this an expected behavior?
Hello, I am trying to use the create_item webhook in my code. I have set up webhook validation and am successfully receiving the webhook payload. However, the problem arises as soon as I click on New Item to create an item on the board; the webhook gets triggered, but it provides empty columnValues . This is webhook payload I’m recieving. { "event": { "app": "monday", "type": "create_pulse", "triggerTime": "2024-01-07T05:37:32.618Z", "subscriptionId": 3189290, "userId": 53812717, "originalTriggerUuid": null, "boardId": 18356535, "pulseId": 1836594, "pulseName": "hello", "groupId": "topics", "groupName": "Group Title", "groupColor": "#579bfc", "isTopGroup": true, "columnValues": {}, "triggerUuid": "ksjjshosajsosasnas" // } } Is there any way after I fill every column value then only create_item event will trigger? I want column values of newly created item. Thanks.
Hi, Predefine column values for a customer into a column. So when they click a button, values from that column are used to generate an action. I.e. status column with “run test 1” “run test2” Any way to add this to custom features?
Hi , When I try to export subitems data along with board and group details , I am getting below error message. If I skip group or sub item info then I am getting results. Can you please let me know workaround for this one. Query has depth of 7, which exceeds max depth of 6. { boards(ids: 123) { id name groups{ id title items_page(limit: 50) { cursor items { id name subitems{ id name column_values { column { title } text value } } column_values { column { title } text value } } } } } } Thanks & Regards, Madhu Kolli
Hi, I need a query in which I can filter items by multiple dates. By example, I have an array of dates and I want to retrieve items where the column date4 is exactly that date. Because of that the trick with using between operator doesn’t work. As far as I know there are two queries for filtering items by column dates. Unfortunately non of them work properly. items_page_by_column_values. When I use this query the API returns only the first item. See example below: query { items_page_by_column_values ( board_id: 5600134463, columns: [ {column_id: "date4", column_values: ["2022-11-01", "2023-11-30", "2023-11-05"]} ], limit: 100 ) { cursor items { id name updated_at column_values(ids: ["date4"]) { id value text type } } cursor } } In my test board I have 3 items that have above listed dates (["2022-11-01", "2023-11-30", "2023-11-05"]) inside the d
Hello , I have very simple code using monday javascript sdk as below. import mondaySdk from "monday-sdk-js"; const token ="mytoken"; const client = mondaySdk(); client.setToken(token); client.setApiVersion("2023-10"); const res = await client.api( ` query listGroups($boardId:ID!) { boards(ids : [$boardId]) { groups{ id title } } }`, { boardId: "1835515014" } ); console.log(res) But i’m keep getting this error saying invalid value. { errors: [ { message: 'Variable $boardId of type ID! was provided invalid value', locations: [Array], extensions: [Object] } ], account_id: 20529253 } EDIT : I tested same graphql query using postman, it’s working fine there. If anyone can help me with this? Thanks.
Hi, Happy to discover Monday’s developpers community. I faced some issues on my firsts queries and i need your help. When i launch this query : “query { items_by_column_values (board_id: 508611278, column_id: “date”, column_value: “2019-02-06”) { id name } }” I received a warning “Replaced by Query.items_page_by_column_values since 2023-10”. But, when i tried the new one, i also received an error (I just copy an past the documentation sample (?)) : “query { items_page_by_column_values (limit: 50, board_id: 508611278, columns: [{column_id: “text”, column_values: [“This is a text column”]}, {column_id: “country”, column_values: [“US”, “IL”]}]) { cursor items { id name } } }” Error : { “errors”: [ { “message”: “Field ‘items_page_by_column_values’ doesn’t exist on type ‘Query’”, “locations”: [ { “line”: 2, “column”: 3 } ], “path”: [ “query”, “items_page_by_column_values” ], “extensions”: { “code”: “undefinedField”, “typeName”: “Query”, “fieldName”: “items_page_by_column_values” } } ], } Do
Hi, I’m using the query documented here to get items from a board that has a specific board_relation to another one. The following query: query_params: {rules: [{column_id: \\"connect_boards\\", compare_value: [\\"test123\\"], operator:contains_text}]} will try to get items by item name (i.e. items named “test123”). The problem is that this value is not unique and can be easily changed on the frontend. How can I get this same relation, but using the item id as the parameter?
We are using the monday API endpoint https://api.monday.com/v2 which is currently working fine without the breaking changes mentioned in new version 2023-10. However, when I implement the changes required for 2023-10, the query works fine from the playground on the monday.com developer center, however produces an error when I attempt to run the same query from Postman or from my web application. For example, one of the required changes is to use items_page for nesting group level items , whereas previously it was just items attribute under groups. But the error received when using items_page is as follows : “errors”: [ { “message”: “Field ‘items_page’ doesn’t exist on type ‘Group’”, “locations”: [ { “line”: 15, “column”: 7 } ], “path”: [ “query”, “boards”, “groups”, “items_page” ], “extensions”: { “code”: “undefinedField”, “typeName”: “Group”, “fieldName”: “items_page” } } ], The query request body being sent in the request is as follows : query { boards(ids: [414373342]) { id nam
Already have an account? Login
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.