API & Apps framework

I’m posting this for the Monday.com customers who are using Power BI to connect to Monday.com. I attended a webinar last week that discussed the changes to the Monday.com API that will be released in October of this year. The syntax used in the query from the code found here → Outdated – Loading GraphQL data (monday.com API v2) into PowerBI · GitHub will need to be updated. I forked a copy of the code created by @dipro and updated the M language code to work with the new API. If you want to continue to use the 2023-07 version of the API you will need to modify your current Power BI Query to include the API-Version you wish to use. Currently the first bit of your code might look like this: let Source = Web.Contents(“https://api.monday.com/”, [ RelativePath=“v2”, Headers=[ #“Method”=“POST”, #“Content-Type”=“application/json”, #“Authorization”=“<your_personal_token_here>” ], The API migration document says that the 2023-07 version of the API will still be the default once October

A query as below returns None for the updated_at field. query { complexity { query } items(ids: [''' + ", ".join(item_ids) + ''']limit: 100) { id name updates{ id updated_at created_at creator { name } } } } Below is the example of the response. It returns None for the ‘updated_at’ field. {'data': {'complexity': {'query': 147}, 'items': [{'id': '5819716479', 'name': 'AAA', 'updates': [{'id': '2919516548', 'updated_at': None, 'created_at': '2024-02-29T05:22:16Z', 'creator': {'name': 'XXX'}}, {'id': '2883433180', 'updated_at': None, 'created_at': '2024-02-22T05:14:13Z', 'creator': {'name': 'XXX'}}, {'id': '2659876831', 'updated_at': None, 'created_at': '2024-01-09T14:35:26Z', 'creator': {'name': 'XXX'}}]}]}, 'account_id': 16259805 } The query above has been working well for a while

We use Monday to be able to track a majority of our projects, we then use Excel’s Power Query to link with the Monday API, to pull the information and be able to generate and fill templates using Mail Merge. With the recent Monday API update we have been unable to pull full subitem information due to the 500 limit. Has anyone found a solution to this problem? Are there any plans from Monday to create a solution to this issue in the near future?

We’re helping Monday customers to integrate with other tools such as Jira. We just discovered, then when a customer changes fields like “Status” or “date” change it does not update “updated_at”. This means, that our tool is not able to pick up any change. So the sync is not possible. Is there a way to use the API to get this change in any other way? We need to be able to reflect the change in another tool. It looks like now only adding a comment or changing text fields can be added to “updated_at” and integrated. It doesn’t make any sense. Help needed 🙂

Hi, I want to build an APP that through custom actions I will make all kinds of API requests back to my monday after I have done manipulations. Everything works as it should. For such API requests I need my API KEY, My question is - if I want to give access to the application to additional monday accounts, do I have to get the API KEY from them or is there another way? There are many apps I see in the market that have their own automations, and I didn’t give them my API KEY. Thank you

Is there a way to add a new view for automations? I would love to be able to add a wizard in automations/integrations set-up for some upcoming applications we are building.

Hello. I wanted to look into developing an app based on the ideas board. Two of the ideas mention writing a Search and Replace app for boards and workdocs. I’ve also noticed that Monday.com already has a very powerful search facility that seems like an ideal starting point for doing a search and replace app. Ideally there would be a way to extend the search facility, so I turned on the Chrome web developers tools to see what’s happening under the hood when we do a search on Monday.com. When it does a search it makes an XHR request of the form monday.com/search/cross_board?q=item. This search endpoint is not officially mentioned on the API or SDK. My questions are: Can we make use of an undocumented endpoint like the one mentioned above? Will there be plans to extend the API to allow for a general search? If no to the above questions, can I be cheeky and ask for the graphql and js code that is used to make the search facility work

Hi community! How can i build page like this? https://view.monday.com/4015407657-9dff8a88ed4926a3d6faddc75a4732f9?r=use1&_ga=2.251141956.377695695.1707829531-1570320680.1681387388 Thank you for any help

Hello, I created a new app with an integration feature. I created a receipt using a build-in trigger and a custom action which I created (I put in the custom action a URL of external system as an end point). Now, the app was connected to the relevant board. When I am making a change in the board data, the trigger is fired, but I am getting an error message: “your automation has failed due to an authorization issue” . And from the other hand, I don’t see any activity in the endpoint side… What can cause the authentication issue ?

I’m trying to figure how how to do the below filter using Monday API. I do not see how to filter out results where there is not a match: { items_page_by_column_values( limit: 50, board_id: BOARDID, columns: [ { column_id: "checkbox", column_values: ["1", "t", "true"] }, { column_id: "text1", column_values: ["false", "", null] }, { column_id: "text97", column_values: ["false", "", null] }, { column_id: "date0", column_values: [--IS NOT EMPTY--] } ] ) { cursor items { id name column_values(ids: ["date4", "text", "text4", "text5", "text9", "text8", "date", "text1", "text94", "date0", "checkbox", "text97", "text45", "text90"]) { id value } } } }

Is there a way to create a new workdoc from a template in specific workspace and folder?

via API I can add webhook for this event “change_specific_column_value()” and I can set in config columnId, but how can I set also specific value of this column? Thanks.

I followed the steps for Integrations Quickstart and added the out-of-the box recipe to my board. But it gives the following error on my CLI - “TypeError: Cannot read properties of undefined (reading ‘items’) [0] at Object.getColumnValue (D:\\Monday.com Apps\\quickstart-integrations\\src\\services\\monday-service.js:18:26) [0] at process.processTicksAndRejections (node:internal/process/task_queues:95:5) [0] at async executeAction (D:\\Monday.com Apps\\quickstart-integrations\\src\\controllers\\monday-controller.js:13:18)”

right now clicking on settings in my app item view does nothing. how do i enable the react UI that gets poped up when we click settings.

I found this piece of code in the Github Example app - I have manually added the redirect_uri here, earlier it was not there. Here is the corresponding GithubAuthManager - This one had the redirect_uri from before. Without the redirect_uri on mondayAuthManager, i was not getting redirected back to the backtourl, but when i added it, i was successfully redirected. So why was there no redirect_uri in the out-of-the box code, am I missing something?

Hi , I have attempted various methods to insert a variable as the value for a column, the “text39” column as shown in the Mutation query below, but I have been unsuccessful so far. Any help on this one mutation ($myText: String!) { create_item ( board_id: 415144386, group_id: “emailed_items12303”, item_name: “Subject”, column_values: “{"dropdown99": "7", "dropdown": "", "dropdown9": "18", "text39": " $myText ", "status4": "0", "text26": "staff response to", "additional_info": "This is the addional info", "text27": "Rec_no" }” ) { id } } i have tried "text39": $myText . Didn’t work tried "text39": ${myText}. Didn’t work . Doing all this from postman and variable is defined { “myText”: “Test text” }

I followed the exact steps mentioned in Quickstart - Integrations but it was throwing some errors. I made the following changes in the code and it worked - Changed $itemId: [Int!] to $itemId: [ID!] in the getColumnValue function and changed mutation change_column_value($boardId: Int!, $itemId: Int! … to mutation change_column_value($boardId: ID!, $itemId: ID! Is there any guide in the documentation covering the different types of variables available and which variables use which types? Also, what is the ! after the type of variable? Does it mean that the variable can be NULL?

Hello, Problem: using the “long_text” field in Monday.com with external automations (such as with Make.com or Zapier) is difficult. Often the long-text field can’t be read, for instance, if using the “Search Items in the Monday.com Board by Column Values” and then sending the long-text information to another module. Instead, you need to write an “Execute a GraphQL Query”. Solution: To the information in the long_text field to another module in Make.com, here’s what to write using the “Execute a GraphQL Query”: query { items (ids:{6127608317}) { column_values (ids: ["long_text", "long_text_2"]) { id value text } } }```

[09:28:23.548] DEBUG: * Domain: https://monday-apps-ms.monday.com * [09:28:24.521] DEBUG: api_service res: GET: https://monday-apps-ms.monday.com/api/apps - 200 ? Select an app 10131502 | New App [09:28:27.356] DEBUG: api_service res: GET: https://monday-apps-ms.monday.com/api/apps/10131502/versions - 200 ? Select an app version 10201448 | 1.1.0 | New App | draft [09:28:28.633] DEBUG: push code to appVersionId: 10201448 ⠋ Build asset to deploy [09:28:28.666] DEBUG: Directory path not provided. using current directory: /Users/brett/work_projects/mo⠋ Build asset to deploy › Building asset to deploy from "/Users/brett/work_projects/monday-code-quickstarts/quickstart-go" directory [09:28:28.667] DEBUG: create_archive - Check directory exists directoryPath: "/Users/brett/work_projects/monday-code-quickstarts/quickstart-go" [09:28:28.668] DEBUG: ignore_files_for_archive - Searching for .mappsignore file [09:28:28.669] DEBUG: ignore_files_for_archive - Searching for .gitigno

Hello, I am encountering an issue with my flow in Make which is creating an item on 2 different Monday boards: The item and the reference is created on the first board, but on the 2nd board is created only the item and not the reference. The reference is always empty. Do you know what could be the reason? Maybe something related to permission? Thank you.

Is there a way to securely access third party API from frontend (Monday views/widgets)? I mean, is there some feature from Monday SDK that I allow me to make a request to a third party API from frontend without exposing the API key? This would involve a way to store the API key on app installation and SDK use it on third party api requests. If there’s not, I would have the API key static on my code and use Axios, but this would expose the API Key.

Hi All, To make a long story short, I find Monday.com reporting and 3rd party apps to be incredibly lackluster. The data I want to gather and manipulate is in the Activity Log, but exporting that to excel gives me way more data than I want, so I want to customize what I pull. Which is how I arrived here. Below is my command in linux, minus the key (for obvious reasons). The only return I get is {} from Monday.com instead of the data I want. I know I haven’t put more filters on the command yet. I wanted to see what it pulls first before filtering. Can anyone assist? Does the cookie need to be changed? If so, where do I gather that data? I’m using the example command provided on Monday.com for cURL. curl --location --request POST ‘https://api.monday.com/v2’ \\ –header 'Authorization: ’ \\ –header ‘Content-Type: application/json’ \\ –header ‘Cookie: __cfduid=d4512e647bd3dd90706f5673d6041f7c51618840981’ \\ –data-raw '{“query”: "query { boards (ids: 1476816006) { activity_logs (from: "2022-

Hey, I want to build an automation where I link 2 items that are in 2 different boards and when I update a certain field > the corresponding field is also updated (they must have the same title). What is the best way to do this? I use make.

Hello developers! Have you subscribed to our developers’ YouTube channel yet? We have a wealth of valuable content waiting for you. Subscribe now to access: Informative tutorials and guides Insider tips and tricks Updates on the latest features and enhancements A lot of Dipro’s magic videos you all know and love. Subscribe today!

Hi all, We’re struggling in implementing monetization for our very first app, and need very basic guidance on how to implement monetization in our code. Can someone help us please? Thank you!