API & Apps framework

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!

Hello developers, I’m trying to query groups, noticing some unexpected values in response for id key. This I’ve been noticing only from yesterday and used to work fine before when I tried. Thus wanted to check if anything wrong on my end (or) something breaking here. Here is my query, getGroups ({ context, metadata }) { return { method: 'post', url: 'https://api.monday.com/v2', headers: getCommonHeaders(metadata), data: { query: `query { boards (ids: ${context.boardId}) { groups { title id } } }` } }; }, And the response looks like this, (just attaching the group part of it) [ { "title": "Group Title", "id": "topics" // expecting this to be something like 1210777 } ] So when I try to make further calls with this id, it fails (say fetching items in a group) Can someone confirm if anything wrong on my end? Thanks in advance.

Is there any documentation on how to work with monday doc blocks i.e. delta format? All I got was that it uses quill delta library. However, the information available on quill delta does not seem to be enough and there seem to be more going on in the monday doc delta format blocks. Is there any documentation available on this?

I want to update status column options and add/remove options using the API. There has to be a way right? I don’t know why there is no documentation on this!

Hello everyone, need help. Trying to pass multiple item ids for query from wordpress platform. The ids are taken from post title. My code: $current_user_id = get_current_user_id(); // Set up the arguments for querying posts $args = [ 'author' => $current_user_id, // Filter posts by the current user ID ]; // Query the posts $user_posts = get_posts($args); // Check if the user has posts if ($user_posts) { // Collect post titles (numbers) in an array $post_titles = []; foreach ($user_posts as $post) { $post_titles[] = esc_html($post->post_title); // Store the post titles (numbers) } $matters = implode(', ', $post_titles); // Comma-separated list of titles (numbers) } else { // No posts found, set matters as empty $matters = ''; } // Setup API request for Monday.com $token = 'abc'; $apiUrl = 'https://api.monday.com/v2'; $headers = ['Content-Type: application/json', 'Authorization: ' . $token]; // Create the GraphQL query dynamically $query

I am looking to sell my app that is currently published in the market. For more details, please write me at devauthor@grinflai.cfd The app has almost 200 installations and was launched this year. It has been on the market for about 5 months. It does not rely on third-party server and is fully hosted on Monday. The app is similar to notes and reminder tool.

Hello, Good day everyone! I’m working on a marketplace app and have a query relating to querying boards and workspaces. I’ve a dropdown where the user can select the workspace → board and create an item in that board. I’m using monday.com APIs and it works as expected. The issue is relating to the write access to the board. A particular user who’s not a subscriber to the board is not able to add an item to it. While this is expected, is there a way I can list only workspaces and boards that the user is subscribed to? I’m aware the workspace and boards API allow us to query subscribers. In case of Workspaces, there is a key named users_subscribers but only 25 count is returned by default. In case of boards API - key is subscribers. I didn’t find any limit of results returned mentioned in the doc but still wanted to confirm here. Do we have any limit on subscriber entities returned as part of response? When it’s being returned with limits, the only way to retrieve the user subscribed boa

Hi all, I am working in a board which populates per Shopify order, using a Zap from Zapier. All the information I need from Shopify is successfully getting into my board, and it’s populating the board one order per item line. When there are multiple line items, though, they populate in the following format: SKU: “SKU-001,SKU-002,SKU-003” Price: “100.00,88.00,15.99” Currency: “USD,USD,USD” Name:“BlueShirt,RedShirt,GreenShirt” Ultimately, I need to split these line items into separate values so that I can create invoices and track values individually. I feel as though this probably should be done via subitems, but I’m open to other solutions. This feels like an issue that would be encountered in any integration with a NoSQL data set, so I’m surprised there isn’t an existing solution. Is there an easy way to break these into individual components without adding dozens of columns with formulas that break it up using “mid” or “search” functions?

Hi, I’m confused… I was working on a new app instance - my app is an integration app, with recipe builder written in python. I tested the app after installed (yesterday) and it worked. But then, I needed to add scopes to my app, so made a draft version and changed scopes in that version. Then, promoted that version to live. From this point, I wasn’t able to Install the new version: the button appears on the “Install App” UI on developers center, but it doesn’t change it state, it immediately returns to its original state, which is “Install app” (the expected behavior is it change to “Uninstall app”). I even removed all scopes in OAuth and the app is still not “installable”. Does anyone know how to troubleshoot? Or have hints with potential issues? See screenshot: Thanks!

Hello team, I am encountering an issue when trying to duplicate a board. The error message I receive is as follows: { “error_message”: “CustomExceptions::DuplicateBoardObjectLinkLimitException”, “error_code”: “RecordInvalidException”, “error_data”: { “error_data”: “CustomExceptions::DuplicateBoardObjectLinkLimitException” }, “status_code”: 422, “account_id”: } I am able to duplicate this board with structure only and other boards with items and updates. The other boards are of same size and integrations and connected columns. The error details are: Location: [{‘line’: 3, ‘column’: 3}] Path: [‘duplicate_board’] Extensions: {‘code’: ‘RecordInvalidException’, ‘status_code’: 422, ‘error_data’: {‘error_data’: ‘CustomExceptions::DuplicateBoardObjectLinkLimitException’}} Could you please provide more information on the specific limit being exceeded and how I can resolve this issue? Thank you,

I need to secure a custom REST endpoint that integrates with Monday.com. Initially, I tried using API keys, but I couldn’t find a way to modify headers for Monday’s webhooks. Now, I’m exploring JWTs for added security, but it seems the only option to generate a signing secret is through creating an app in the Developer Center. Is that the case, or are there alternative ways to securely set up this integration?

I developed a Monday app that integrates with a third-party service. My recipe is structured as follows: When the ‘status’ changes to ‘something’, create *** with ‘attachment’, and then change the ‘status’ to ‘something’. The attachment is a column ID that the user selects when setting up the recipe on their board. This attachment column contains a file. I’m curious about how to retrieve the file content so that I can include it in my API call to the third party. The following JS function gave me only metadata of the image uploaded to this file column: export async function getFileContent(token, itemId, fileColumnId) { // Set the token for the Monday SDK client const mondayClient = initMondayClient(); mondayClient.setApiVersion('2024-01'); mondayClient.setToken(token); try { // Step 1: Query for the column value containing the file URL const response = await mondayClient.api( `query { items(ids: ${itemId}) { column_values

I’m running the following query: query QuerySharedBoards ($limit: Int, $page: Int) { boards (limit: $limit, page: $page, board_kind: share) { id board_folder_id board_kind creator { account { slug } id } description # items_count - complexity too high - see package documenatation above name permissions owners { id email name } state subscribers { id email name is_guest } type updated_at workspace_id } } and getting an internal server error (500 status code) When removing the is_guest and email from the subscribers, everything works perfect. My question is why? When I look for subscribers at the schema I do see that those should be a list of User which do have those properties. Thanks!

I have this query that basically paginates the board until reaching the end. However, I don’t know if it’s something I did in my code or if it’s something with the API itself, but the JSON response always arrives with the link columns empty. def get_items_from_board(self, cursor=None): query = { "query": f""" {{ boards(ids: {self.board_id}) {{ items_page(limit: 100{f', cursor: "{cursor}"' if cursor else ''}) {{ cursor items {{ id name column_values {{ column {{ title id }} text }} }} }} }} }} """ } response = requests.post(self.URL, headers=self.headers, json=query) if response.status_code == 200: return response.json() else:

I am trying to use a custom action I created with the built in trigger ‘when column changes’. How should I go about receiving the itemId of the item in my custom action. I have tried adding input field ‘ItemId’ and ‘ColumnId’. But I am not getting the values in the req.body. Right now I am only getting the BoardID which I have set as context. Can anyone please help me with this. How can I set up the custom action? Trying to create something like the following

Hey everyone, I’ve been reading over the API documentation and not sure if I’m missing some way to do this, but I would like to know the best approach of how to update a row in Monday that’s effectively syncing from another system. If I have a list of objects in the foreign system that have updated in the past 24 hours, and I push that into Monday, every column shows as being updated by the API user. What I ultimately want, is only the values that are different, the delta, to be updated and show in the activity log. Now I can manually do the hard work to pull all objects from the board in Monday, check each column to see if it’s changed, and dynamically build an update multiple column values mutation to make this happen, but gosh that’s a lot of work and computational overhead. Is there not a better way to achieve this? Appreciate any ideas/support/guidance.

I’m automating item creation on a Monday board using responses from Microsoft Forms via Power Automate. The item and updates work smoothly, but I’m stuck on getting file attachments (images, Word, Excel, etc.) added to the item. The files appear on the board but in an unreadable format—I’ve tried both Base64 and binary without luck. Any tips or tricks to make these attachments viewable? HTTP part from Power Automate Output:

I’m getting a 500 error when uploading a file where the filename contains characters outside of the ASCII range 32-127 The API call works fine for most filenames, but occasionally I get a filename with an accented character, and they fail to upload. I could write a filter to remove the accented characters, but was hoping instead there was a solution within Monday so filenames remain accurate. I can manually upload files with accented characters, so the limitation must be the API I’m using api.monday.com/v2/file with a POST, setting the Authorization header to my token, and setting “content-type” to “multipart/form-data” Thanks in advance! Steve

I’m having a heck of a time understanding the custom trigger doc. Everything else in the integrations docs makes sense but not the custom trigger section. It probably doesn’t help that I haven’t implemented webhooks before, maybe that missing bit of context would help me fill in the rest. I’m sure I’m not the only person with this problem. I can easily figure out how custom actions work because the integrations quickstart comes with custom action in the workflow blocks, but there’s no custom trigger given. Which I guess makes sense because a custom trigger requires an outside server. Still… is there an example or more thorough tutorial I can consult? I’m sure I’m not the only person who has had or will have this problem.

Hello. So far, the following query has worked great. Now, for some reason, it no longer works. query { boards(ids: 1147535394) { items(ids: [1660647663]) { id name column_values { id text value } } } } Ultimately, I only need the data from the columns for this one item. Regards. D. Jurisic

Hello everyone, I previously used JIRA software which had a feature called Script Runner. This allowed me to employ Groovy scripts to implement some tailor-made behaviors in the software. I am now using Monday.com and I need a similar capability. To give you a clearer picture: I have columns labeled “start-date” and “end-date” in Monday. Whenever I input values into these columns, I’d like to perform specific operations on them. For instance, I want to add a constant to these values, convert their type, and then place the result in another column named “computed-Value”. Crucially, I need the flexibility to change the type of the result to any of the existing column types available in the Monday. Additionally, I also need the ability to programmatically add new columns based on certain conditions or triggers. Does anyone know if such functionality exists in Monday or if there’s a workaround to achieve this? Any guidance or references would be greatly appreciated! Thanks in advance!

I get this error when I try to create a mock subscription through the graphql api playground. I’m working on an automation app: { "error_message": "User unauthorized to perform action", "error_code": "UserUnauthorizedException", "error_data": {}, "status_code": 403, "account_id": 24876002 } Here is the mutation I’m trying to execute: mutation { set_mock_app_subscription ( app_id:123345, partial_signing_secret: "r6374e82h", is_trial: true, plan_id: "basic_plan_15_users" ) { plan_id } }

Hi. I would like to build a workspace view that uses fetch to talk to a backend running on Monday code that then talks to the API (presumably authenticate with OAuth). Is that possible or would I have to use an Integration for that?

Hi, I am brand new to Monday.com and am currently working on how I can create an api call to pull Individual Time Tracking data from Monday.com and import it into Fabric. I can use Python to do this but I can’t seem to find the correct api commands to do this. The field names I want are: Time entry date, Time entry ID, Item name, User name, Team name, Logged time, Description, Board name, Workspace name, Category name, Created date I haven’t been able to get any commands to work just yet so any help would be greatly appreciated.