API & Apps framework

Hi, The activity log api is not returning archive Items events. Below is the query: query($boardId:[ID!], ** $groupIds: [String], ** $limit: Int, $page: Int, ** $from: ISO8601DateTime, ** $to: ISO8601DateTime) { ** boards (ids: $boardId) { ** activity_logs(group_ids: $groupIds, ** ** from: $from, ** ** to: $to, ** ** limit: $limit, ** ** page: $page) { ** event ** data ** created_at** ** }** ** }** ** }** Some assistance would be highly appreciated.

I am unable to view the dashboard view setup page. Is the problem on my account or is the service not working right now?

Hello, Is it possible at all to search Monday via GraphQL query to make a query that returns partial matches for item name, using regex or wildcards in the search value? I am thinking of something like searching items with value “John*” and finding both “John Smith” and “John Doe” or am I restricted to finding only exact matches and there is nothing I can do about? Thanks

Hi, I have a workdoc, created from a template. Then I used an automation to replace the values inside the doc via API. Until there, all good. But then, when I do another mutation to update the values, something weird is happening in a specific table. Whenever I update via mutation the cells of this specific table, the value disappears from the table, I simply can’t see it. Tried updating the doc, leaving and returning, changing style, colors to see if it was because it was hidden somewhere, but I’m simply not finding it. And when I do the query, the value I did the mutation is there…So, it’s not an issue of wrong mutation, it’s more about not seeing it. Any idea how I can see them?

Hello monday team, I have created a custom widget, and I want to capture every changes on the filter. Tried the monday.listen filter but seems like it is only retrieving the value from the search field.

When sending this query to the API **query($boardId:[ID!], $groupId:[String], $limit: Int!) { boards (ids: $boardId) { groups (ids: $groupId) { items_page (limit: $limit){ cursor items { id name column_values { … on MirrorValue { display_value id } } } } } } }** I get Complexity Budget Exhausted error both in sandbox and production environments. I am trying to retrieve mirror items values. Running this query on the API playground there’s no complexity budget exhausted error. The limit is 200. I tried limits of 2, 5, 10, 50, 100 and even 1 still get the complexity budget exhausted error. Has anything changed when it comes to retrieve mirror items values?

I have this code in php thats worked well until version “2024-10” : $query = 'mutation ($file: File!, $update_id: ID!) { add_file_to_update ( file: $file, update_id: $update_id ) { id } }'; $response = Http::attach( 'variables[file]', file_get_contents($file->getPathname()), $file->getClientOriginalName() ) ->attach('query', $query) ->attach('variables[update_id]', $updateId) ->withHeaders([ 'Authorization' => config('monday.token') ]) ->post(config('monday.api_url')); But now in versions from “2024-10” the API returns this : [ { "message": "internal server error", "extensions": { "code": "INTERNAL_SERVER_ERROR" } } ] I have no more informations about why I’m getting this error and I can’t figure it ou

Given 5 emails, I’m looking to see which ones exists in which boards(and which ones don’t). I have 5 different boards that I need to search in with those 5 emails. Currenlty, I have some sort of linear search in place where I take one email, search across 5 boards. So for 5 emails its 5x5=25 api calls which results in a very slow response(yes I need the total response). I’m looking for suggestions to improve this so that I don’t get stuck in api calls for about a minute. Here’s what I’m exploring currently: Make 1 api call ber board, with all the email values passed at the same time query { items_page_by_column_values (limit: 50, board_id: 123456789, columns: [{column_id: "email__1", column_values: ["test@emial.com", "tes2t@emial.com", "test3@emial.com"]}]) { cursor items { id name column_values { id value } } } } This gives me fairly lower reponse time, but I’m curious to know if there is a way to only receive a certain number

Hello experts, I know it is a basic question but could I have help from you please? I am trying to create an item via API. It works if I copy the sample GraphQL code from the guide exactly (changed the board_id and group_id), but it doesn’t work if I change the column_values. What is missing my code? Thank you so much in advance. for example, it works: mutation { create_item (board_id: xxx, group_id: "xxx", item_name: "new item", column_values: "{\\"date\\":\\"2023-05-25\\"}") { id } } it does not work: mutation { create_item (board_id: 7772434243, group_id: "new_group29179", item_name: "new item", column_values: "{\\"text8__1\\":\\"システム\\"}") { id } } it also does not: mutation { create_item (board_id: xxx, group_id: "xxx", item_name: "new item", column_values: "text8__1":"システム") { id } } *column ‘text8__1’ is a custom column. I made sure the same issue with other default values. Referred: Items

Is there an option to get the user timezone?

I’ve been using the following to create an item on a board: export const createItem = async (variables: any, shortLivedToken: string) => { const monday = mondaySdk(); monday.setToken(shortLivedToken); const query = ` mutation createItem ( $board_id: ID! $group_id: String! $item_name: String! $column_values: JSON! ){ create_item ( board_id: $board_id, group_id: $group_id, item_name: $item_name, column_values: $column_values ) { id } } `; const options = { variables }; const response = await monday.api(query, options); return response; }; When passing this data in: const variables = { board_id: 7833822272, group_id: "topics", item_name: "Project Pivot", column_values: JSON.stringify({ status: "14", // aka `Approved` date4: "2024-07-29 11:00:00", long_text: "Pivot demo"

Using the .NET code quickstart, I added this method: app.MapPost("/", async (HttpContext context) => { using var reader = new StreamReader(context.Request.Body); var body = await reader.ReadToEndAsync(); return Results.Ok(body); }).**RequireAuthorization**(); Authorization will need some config and middleware. I realize that Mondaycom Code SDK only supports NodeJS and Python (as of the moment), but is there a way to get this working in C#? And is more official support for dotnet actually on the roadmap?

We are encountering this much more frequency in recent weeks. A user installs our app initially in Workspace A (the default now seems to be restrict to a single workspace for some accounts). Then on a board in Workspace B, the app is visible and an integration recipe can be created - but the app does not have access to Workspace B. Logic would dictate that the app should not be visible when adding integrations to boards in Workspace B. However, that doesn’t appear to be true, and the recipe gets installed. To add to it, the recipe triggers and sends us an event as if everything works. However, the token we receive cannot read or write anything to that board (it can access users, account, etc.). This means the integration is failing. We had not seen this regularly until the last couple weeks - did something change recently that allows the app to be visible for use in a workspace it does not have access to? Lastly, I would say this is a bug, an app should not be visible to create recipes

I basically wanna create an API request to find an item based on a column value (email). Out of all the API docs I used, this one confuses me. It doesn’t show what end-point to use, what all query parameters are required and how it should be inputted to find the right one. I might be wrong here, this is different to the API doc format am familiar with so am stuck, could anyone assist me. PS: I am using Zapier for this

I need a graphQL query to pull all items and subitems for all columns in a specific group id “topics” In a specific board

I was developing an app for a client and this morning at a meeting we had I pushed a new version to live and the app disappeared from client’s board. The automations are still trigerring but not showing up in the automations of the board!!! When do you think this will get fixed? What can I do about it?? I don’t want to uninstall and install the app again since I would have to configure all the automations again… The dev team at monday really really need to stop pushing buggy code to production…

Here is (super anemic) code sample from the .NET quickstart: app.MapGet("/", () => { Console.WriteLine(); Console.WriteLine("Get Environment Variables: "); foreach (DictionaryEntry de in Environment.GetEnvironmentVariables()) Console.WriteLine(" {0} = {1}", de.Key, de.Value); return "Hello from dotnet " + name; }); I can access EnviroVariables (yay). But how do I access Secrets that are stored in the apps general settings? I saw in the docs that Secret Storage is not supported for anything but NodeJS and Python. But it was a little unclear whether that is referring to the secrets key/value pairs, or something else.

I have a few questions regarding my application on the Monday Code platform: Is there a limit on CPU and RAM usage for applications running on Monday Code? Does my application stay active continuously, or does it spin up only upon receiving a request? If I initiate a background job, will it be terminated after a certain period? How large can files be when written to the file system? How long are files stored on the file system once they are written?

Hello, we have a number of in house API calls we make against Monday.com boards our users have developed, the calls such as query = '{boards(ids: ’ + board_id + ‘){columns(ids: “subitems”){settings_str}}}’ Has always retrieved the sub board id without issue, last week on a new board we found the hard coded ids “subitems” no longer worked, and we had to find the item id for the Item title on the main board(which can be Subitems or SubTasks) and on new boards returns a subitem id of subitem__1 Today we have found another change of functionality around Status Text (Our calls are programmatically iterative with smaller slice size and only the sample output of interest is shown below) On older boards we can use the following to get the selected status text. query {boards (ids: ’ + board_id + ') {columns {id title}}} { "id": "status7", "title": "Exclude" }, and query {boards (ids: ’ + board_id + '){items_page (limit: 500) {cursor items {group {id title} id name c

HI, I can’t solve the “DataSource.Error: Web.Contents with the Content option is supported only during an anonymous connection” I already did the anonymous authentication on data source settings, but stil continuous. How can I solve this?

Hi, TLDR; What’s the best way to know whether a user is allowed to edit the view/widget settings in a board or dashboard? Details We have an app that has a widget and view feature in which the user can configure the widget/view within our app (not using the monday configuration/settings). We want to avoid that users without the necessary permissions are able to change the settings, therefor we need to know if the user has the required (dash)board permissions. For a dashboard this means the user needs to be dashboard owner. And for a board this means that any user can make changes unless the board permissions are being restricted to either “Only edit items or subitems that users are assigned to” or “Write updates on items only”, in which case only the board owner should be able to make changes to the widget(s)/board views. We’ve found a variable in the context called editMode which works as expected for a Dashboard. In this case it will only return true for dashboard owners and false fo

I need to get a list of users, with user type = member (not viewer, not admins) Then I need to get their last active date / last login date using API I know how this is done on UI but how to do this using API? Please help!

Hi all, we are trying to clean up our Monday access list. I would like to query for all inactive users and retrieve their last activity date. From what I’ve seen these fields aren’t available through the API. Is that still the case? Is there any way to script this process?

Hello, I am looking for a way to see the Date of the last activity of a user not including logging in. I see in the monday API that there is a last_activity field for every User, but I believe this includes logging in as an activity. Is there a way, through an API, to see the last time a user edited/changed something? Thank you

Hi Everyone, I am having a hard time to connect with Monday.com API using my PBI. I already have my key and board ID. All i need to do is to ingest all the contents from my board ID. Can someone please help me with this? This is my Mcode let Key = Access_token, Board = Board_id, 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 { name, updated_at, group { title }, columns: column_values { title, text }} } }””}”) ] Thank you!