General

Hi all, As there isn’t a built-in connector, I’ve spent a few weeks creating a Power Automate flow to pass Microsoft Forms data into Monday via the API. I’ve used a lot of people’s posts and research, plus a lot of trial and error, but finally have a working version which I hope some people may find useful. I won’t cover the Forms part of the flow, as there’s plenty of info about that, but there’s very little out there about using the HTTP connector to call the Monday API suite. Unfortunately the HTTP connector is Premium, so you’ll need a license. Starting with a simple one - I needed the person who submitted the form to be on a People column on the Monday board. The API needs a User ID, but all I have is an email, so I need to get all the users, then find the one I want: Then a Parse JSON action with the following Schema: { “type”: “object”, “properties”: { “data”: { “type”: “object”, “properties”: { “users”: { “type”: “array”, “items”: { “type”: “object”, “properties”: { “email”: {

I make a query: {"query":"query request($limit:Int $page:Int) { boards(limit: $limit, page: $page) { id name columns {id title settings_str} groups { id title } }}","variables":{"limit":100,"page":1}} I get a successful response. Among response data I have “groups” section. This section started exactly like this: "groups":[{"id":"flexible_staffing_of_georgia","title":"Flexible Staffing of Georgia"} Afterwards I try to create item. In query below I have replaced real data on “…”. In real case there placed correct data. {"query":"mutation request($boardId:Int! $groupId:String $name:String $column_values:JSON) { create_item (board_id: $boardId, group_id: $groupId, item_name: $name, column_values: $column_values) { id } }","variables":{"boardId":...,"groupId":"flexible_staffing_of_georgia","name":"...","column_values":"{\\"...\\":1000}"}} In the end I get response with 404 code which says: {"error_code":"ResourceNotFoundException","status_code":404,"error_message":"Group not found","error_

Introducing Pitch Your App: Present Your App and Get Feedback from monday.com ’s Marketplace team Here’s your chance to make your app, or app idea, a success on monday.com’s Marketplace! Through our Pitch Your App initiative, you’ll present your app’s features, benefits, and use cases to product marketing and engineering experts at monday.com. (Think Shark Tank—but much friendlier.) Following your pitch, our team will provide up to 15 minutes of feedback, giving you insights, ideas, and advice you can use to make your app or idea more marketable, useful, and popular.It’s just one more way we’re helping monday.com’s app developers succeed. Here’s how it works: You’ll have 5-10 minutes to pitch your app, using a presentation or pitch deck as a visual aid with approximately ## slides. You’ll need to be concise and clear, covering only the most vital aspects of your app! To get the most from your pitch, remember to focus on: The problem or problems your app solves. How does your app solve

Is it possible to get the folder names in the main workspace via the API? I’ve tried the following, and none seem to work: The following two queries return no data: query { folders (workspace_ids: "null") {id name}} query { folders (workspace_ids: -1) {id name}} The following query returns all the folders in all workspaces: query { folders (workspace_ids: null) {id name}}

The Sentence location seems to have moved to Workflow blocks from recipes dialog. I am building a recipe that says When Status changes, read from and . I just want to pass the ID’s of these columns to my URL. How do I instruct Monday to grab the ID of the columns? per documentation, I am supposed to pass the KEY as well but now, the complete object is selected. Is the ID automatically passed?

Monday.com is now promoting that its Jira integration supports two-way sync, which is a different kind of integration than having custom triggers/actions to achieve a similar result. This is described on a dedicated page: https://support.monday.com/hc/en-us/articles/9308935981458#configuring_two_way_sync. There’s a nice animation, as well: https://support.monday.com/hc/article_attachments/9027156678546(image larger than 4 MB) AFAIK, it’s not possible to create integrations like this for an average developer like myself. For cases when you want to sync a Monday board with an external system, it seems more robust to have a single integration that simply achieves this, over having a custom action (to update the external system) and a custom trigger (to receive updates from the external system). I’m wondering about the timeline for building such integrations as part of an app. My use case is to sync Monday.com with our own systems, using a custom app. Is there a plan for making this availa

Hi team! We want to build an integration that will ask the user for an API key (to a 3rd party). We saw for example the scenario of Twilio that open this screen after trying to create the first receipt. My question is how can we redirect the use to such a screen? I know the option of “Authorization URL” in the app feature page, but it doesnt seems like open a nice page like you did with twilio. Can you please spread me some light? Thanks in advanced!

Hello All, I currently have the below graphQL query which extracts all items in board. Please note in the below example that the board id is not a real board. The cursor is also not a real cursor. { boards(ids: 123456789) { items_page (limit: 500, cursor: "fhakahdfyiewhalfhdsanhdfsfwefewwfeM" ) { cursor items { name column_values { column { title } text } } } } } I have about 700 items in the board. The items_page has a maximum limit of returning 500 items. I previously used the above query to return all the remaining items (after the 1st 500). However today, we encountered the below message "error_code": "CursorException", "status_code": 200, "error_message": "CursorExpiredError: The cursor provided for pagination has expired. Please refresh your query and obtain a new cursor to continue fetching items", "error_data": {} } For our specific use case, we are not looking to r

Hey guys! I’ve been working on implementing the board item menu feature in my application. However, I’m having trouble figuring out how to retrieve the selected board item ID. I’ve gone through the documentation for both the Listen SDK and the API, but I’m still uncertain about the exact steps to obtain the item ID. Could someone please point me to the right direction? Any assistance would be greatly appreciated! monday apps framework

Hi! Is there a way to call items_page sorting by a column using desc direction and bring the non-null (non-empty) items first? In this query I’d like to return in this order [8, 4, null] instead of [null, 8, 4].

Hi Everyone, I found a couple of other threads that seem to be asking this same question, but they have been closed and do not offer a solution or a workaround. I’m wondering if there is a way to write a graphql query for the items on a board that meet criteria for two different columns. The “items_by_multiple_column_values” query allows us to query two different values for one column, but I need to query results that have one value for 1 column AND one value for another column. If this can’t be done with a single query, how might one achieve a similar result? Thanks in advance for your help! -max

Hi, I seem to be struggling with a very simple query that I can’t seem to get to execute without giving me a 500 error. Below using test query everything executes as normal. When I try to execute a query with quotation marks in the query and use the escape characters the app returns 500 error. I have tried removing the escape characters and obviously that throws an error. Any insight as to what this issue could be would be much appreciated. var testQuery = "{\\"query\\":\\" {boards(ids:5146042481) {id}}\\"}"; var fullQuery = "{\\"query\\":\\" {items_page_by_column_values(board_id: 5146042481 columns: [{column_id: \\"name\\", column_values: \\"DDNL05\\"}]) {cursor items{id}}} \\"}"; The below code does work in the API playground as well: { items_page_by_column_values( board_id: 5146042481 columns: [{column_id: "name", column_values: "DDNL05"}] ) { cursor items { id } } }

Hi! I am updating my codes considering the new version of the API. However, something very odd happened. Versions 2023-10 and 2024-01 did not load any data in mirror columns for the boards: 5087161303 5074524960 5082043087 5074430711 5074427222 5124516984 5124256345 5124251433 5124243595 5124213277 5123837747 4988499062 5124220711 5087402995 5074527029 5082045015 5074431667 5074428913 5096754394 5096743547 5096751022 5096733887 4993087356 My domain on Monday is http://fractaledu.monday.com/. It tried to retrieve data using the value field, however, this dimension was null too. Version 2023-07 is retrieving data normally, but I know that column_values_v1 will be deprecated. So, this is why I am very worried about this. Here is an example of one of my queries: {“query”: “{ items (ids: 5208402082 ) { id name column_values { column { title } text } } } }”} Thanks for your support.

Hi there, I’m having some issues loading app static resources using monday tunnel. (@mondaydotcomorg/tunnel). When the app is being loaded, the .js files are getting “206 Partial Content”. If I create a ngrok tunnel, it works perfectly. Do someone know if the tunnel service is having some issues? Thank you. Regards, rmrodrigues.

Hi All, Have a two part question here. 1st part: I’m looking at the Postman request examples provided by Monday. Specifically for the latest API version I see POST requests that will change values for items. I am wondering if there is a GraphQL query that will automatically update all items in any given board. Either a delta update or a full replace (even if some items weren’t updated). e.g. Sample board: client hours manager status Client A 10 john online Client B 4 sarah offline let’s say that I want to change the managers, hours, etc… so it’s now client hours manager status Client A 222 ken online Client B 11 wendy online Is there a GraphQL query that will update all items for the board? Ideally I don’t have to specify which columns to update as well. 2nd part is what’s the best method to push updates to a Monday board from another system/platform? e.g. using a webhook to push a CURL request? e.g. using Google Sheets and an integration (e.g. Zapier, Integro

Hi Monday Team, Need some on custom automation trigger, I have event based trigger When the column changes to the Started, custom automation send a post request to the url configured in my custom action. I’m able to get the board id , item id but i need board name / item name is it possible to get in payload or should i include API to get those details.

The new items_page in the API contains multiple ways to filter the date column. I noticed that it’s not possible, as far as I can tell, to filter the date where it’s greater than a specific date. Is this functionality available, but just not documented? I guess it might be possible by misusing the “between” operator and setting the end date sometime very far in the future. Though I’m guessing there may be a better way of doing this. In addition, I’m a bit confused what the “PAST_DATETIME” and “FUTURE_DATETIME” compare values mean. Thanks in advance for the advice!

Hi, I’m trying to update the board-relation value in an item. The column id I want to update is: ‘boards_verbinden9’, and it’s type is: ‘board-relation’. The item_id = ‘1281247162’ the contact_id (item_id from the item in the other board I want to connect it to) = ‘1281240291’ The query I’m using in Python is: query = ' mutation ($myItemID: ID!, $columnVals: JSON!) { change_multiple_column_values (item_id: $myItemID, board_id: 1274270217, column_values:$columnVals) { id } }' vars = {'$myItemID': item_id, 'columnVals': json.dumps({ "boards_verbinden9": f'{{"linkedPulseIds":[{{"linkedPulseId":{contact_id} }}]}}' })} data = {'query': query, 'variables': vars} monday_headers = {"Authorization": API-KEY, 'API-Version': '2023-10'} monday_apiUrl = "https://api.monday.com/v2" r = requests.post(url=monday_apiUrl, json=data, headers=monday_headers) r = r.json() And the error I’m obtaining is: {'errors': [{'message': 'Variable $myItemID of type ID! was provided invali

I’m using the function below to submit a new registration but it always fails if I uncomment out the email entry. All the other fields are being passed over to monday without issues, just stuck on email right now and would appreciate any help. function send_to_monday($userr) { $board_id = xxxxxxxxxx; $api_key = ''; $query = 'mutation ($item_name: String!, $column_values: JSON!) { create_item (board_id: '.$board_id.', item_name: $item_name, column_values: $column_values) { id } }'; $column_values = array( // Column values ); $variables = array( 'item_name' => $userr['fio'], 'column_values' => json_encode([ // 'email'=> ['email'=> $userr['email']], 'text0'=> $userr['magent'], 'text5'=> $userr['country'], 'text50'=> $userr['town'], 'text43'=> $userr['port'], 'text3'=> $userr['skype'], 'text10'=> $userr['about'], 'phone'=> $use

I would like to know if it is possible to display an information message using the monday.execute("notice", {..}) and add a href link into the information message.

Hi guys, I’m new to Monday.com and I’m investigating if I can call API to add comment to a task. I couldn’t find out answer from searching. So is it impossible ? Can someone help me with docs ?

According to the below article, rules and operators are specified separately:monday API docs From what I am understanding, you provide a list of rules to filter by as an array, and the overall operator between the rules. Is it possible to specify multiple rules and operators between rules? For example to apply a filter like the below in GraphQL: (name = ‘test’ AND status=‘done’) OR (otherColumn=‘0’) Or can you only resolve filters with only one type of condition between all rules (either AND or OR)?

With the ability to chat inside monday - Lucid is the #1 charting application and is now available on monday.com with chatting capabilities. Download link - Lucid Hub Using the Lucid Hub app, you can embed your charts and chat right into your: ✅ Board views ✅ Custom Objects ✅ Dashboard views ✅ Items Views. In addition, you can easily chat on your documents and charts and stay in sync with your entire team. Keep designers, developers, and the rest of your team in sync! Unlike sharing screenshots and exports, the app will embed a live version of your design which updates in real-time to reflect changes made in the Lucidchart and Lucidspark files - no manual updates required. To get started: Share your Lucid file URL Copy the link Paste it into monday.com binatica.com

We aren’t seeing any data come through for account_max_users or account_tier in the webhook for installs or free trials This information would really help us score these leads and understand revenue potential Thanks

hi guys, I am using the new Items page by column values API. I see that email is not one of the supported types. Just wondering how I should lookup an item based on an email address? thanks, Kevin