API & Apps framework

Hi, I am trying to make a custom action which will accept a File Column and another one that will accept a Link Column as input in the recipe sentence from the user. However, when selecting the Field Type from the dropdown while configuring the custom action, I see ‘Status Column’, ‘People Column’, ‘Date Column’, etc., but no option for ‘Link Column’, or ‘Files Column’. How can I go about achieving this?

Hi there, I found this helpful api Last updated to get items update since a particular time. The documentation does not mention the exact format of the date/time to be passed as input. Would appreciate any help on this. Thank you 🙂

I want to open a new modal from my currently open modal (this small one when you open an app for doc action toolbar). I am using this call monday.execute but then I get error in logs: Uncaught (in promise) Error: “openAppFeatureModal” execute command isn’t available or supported for this app feature type For now I am trying to open a google page. monday.execute("openAppFeatureModal", { url: "www.google.com", width: 800, height: 600 }) Which feature types can handle this call? Maybe it is worth to list possible feature types in documentation? Thank you in advance for a help.

Hey guys. I used the link below to update my Monday.com integration query with Power BI due to the API update in 10-2023. Using Power BI to retrieve boards using Cursor-based pagination monday Apps & Developers This is a follow-up to a post (Connecting Power BI to Monday.com API 2023-10) about using Power BI to call the 2023-10 API. I have a set of Power BI M language functions and query that can retrieve data from a board using the items_page and next_items_page API calls. I have shared the Power BI query and related three functions that I used to be able to retrieve a board and the cursor that is used with the next_items_page API call to get the next page of data. Power BI sample with functions an… It’s working perfectly, but it’s limiting the number of pages that are returned in my dataset. This is a problem for me, as I have tables with many lines and I would like the information to appear automatically (as in the previous query). I’m having

Hello, I need help with my Python code where I am retrieving element information from all boards specified in a table named: df_boards_norm. But i run into a problem that in some boards there are more then 500 items (and i have a limit of 500, I cant change this part), and the cursor then is not null. I need somehow to check if the cursor is not null to run the code again with the same board id where it left of, but if it comes on null, run other boards like normal. Thie is my part of the code: pulse_1 = pd.DataFrame() for i in range(len(df_boards_norm)): q_pulses = ( "{boards(ids:" + df_boards_norm.loc[i, "id"] + "){items_page (limit:500){cursor items{id name column_values (types: time_tracking){value}}}}}" ) data_pulses = {"query": q_pulses} r_pulses = requests.post(url=apiUrl, json=data_pulses, headers=headers) pulses_json = r_pulses.json() df_pulses_norm = pd.json_normalize( pulses_json['data']['boards'][0]['items_page'],

I’d need a solution to send a weekly summary of all the items+subitems with “Done” status to a certain channel in Slack 🫣 The basic Slack integration only supports item status (no subitems…) and the nature of the automation is kinda flooding the Slack channel (every Done status sends the message), as there’s no way to “summarize” the statuses. So, I though if the API could be the solution here 🙂 I could be terribly wrong, but please bare with me. Is there something like that already available/examples somewhere?

Whenever we add a app’s item view to a board, we’re getting the error “Sorry for the inconvenience, we couldn’t create the Widget”. This seems to be a recent error (last couple of days.) It doesn’t happen with standard item views (like Item Card), but it seems to happen only with app item views (I tried a couple of apps, including DocuGen.) Although the errors is displayed, the item view is added successfully and it doesn’t seem like there is any impact on the usability of the app’s item view. Does anyone know the reason for this error?

Good afternoon, I’m trying to create an application using a node.js integration in which when the status changes, it sends a confirmation message to the user using monday.execute , for example. However, I’m struggling to establish the connection and would appreciate any help. Thanks, everyone.

Hi, I want to search my board by item names using items_page_by_column_values Grapql query. When I run the following query it returns empty result even though the item is on the board as active. items_page_by_column_values(board_id:12345678, columns:[{column_id: "name", column_values: ["Task"]}]){ items{ id } } Here is my board view: As you see there are items including “Task” keyword but the api does not mange to find them. How can I retrieve my items searching by the item name leveraging the API? Thanks.

We submitted an application that got denied because it isn’t a monday.com application thats integrated using the monday.com framework. The approach we took was using oAuth and the API, but it’s standalone. With this, my though is to build a monday.com application that integrates with our application (that lives externally). My though would be when a column is updated, post to “our application”. Would this be the correct approach to glue or application from monday,.com to our application so we can have a listing in the market place? Thanks!

I am using make.com to create subitems in a monday board. The query itself is fine and working. In this specific scenario, I am listing items in a group (around 200 items) and creating a subitem for each item. Each time, the 33rd operation fails, due to API cmplexity issues. It’s quite strange as I have done similar things in the past with no problem at all. Here’s the error: [200] [“Complexity budget exhausted, query cost 30001 budget remaining 9967 out of 1000000 reset in 0 seconds”] [ Error Code: complexityBudgetExhausted ] Here’s the api call: mutation { create_subitem( parent_item_id: {{7.id}} item_name: “test” column_values: “{"text": "0db9d56361", "email": {"email":"{{7.mappable_column_values.email.email}}","text":"{{7.mappable_column_values.email.text}}"}}” ) { id } } Does anyone no what might be the issue? Thank you in advance!

Hi All not sure what went wrong below query working fine some time before { boards{ id name columns { title id type } groups { title id } items { id name group { id } column_values { id text value }}}} today i was testing data it says “message”: “Field ‘items’ doesn’t exist on type ‘Board’”, can you please help me how to find who made changes …because this query working fine i think 2 months before ,

Has anyone tried integrating Monday with ServiceNow? We manage all of our request in SN and use Monday to track projects and product reporting for our PMO, so we want to be able to link the two applications to avoid duplication.

I’m trying to update columns on monday via make and I receive a 500 error, 809 “unexpected token” - no idea what this means. I know the error is coming from Monday Here are a few images of the error and the input:

Hi, I am using monday’s JS SDK to do api calls. Should I have a concern to maintain rate limit errors or does the SDK mange these rate limiting problems on behalf of me? Thanks

Looking at the new app_subscriptions_operations API (App subscription operations) One thing that doesn’t stand out as obvious to me is the subscription period. It seems tied to the billing period. Does this mean if someone is billed yearly, it only resets yearly? Or does it reset at the monthly period of the year?

Hi, we developed an app that integrates with the monday.com API via oauth. From my understanding it looks like there are processes. One is that they install their application in their tenant, but a second step they have to give permissions to to our app to access data. If the user installs from the market place, I assume the app is installed there and then they are directed to my app to sign up and go through the oauth process? If the user starts from my application, do I have to send them to the install link to do the install, and then have them give access through the oauth process? Also, the market place submission form doenst seem to be working, I filled out all the fields and it says I have to fill out all required fields. I doubled and trippled check. Thank you, Marty

I’ve been looking at the Files column type, and see that for external files hosted in say Google Drive, Box, Dropbox or Sharepoint, the files are described by a stringified version of the structure below: { "files": [ { "name": "Book.xlsx", "fileId": "c42b3230-42b3-42b3-42b3-9d6f7b2a081b", "fileType": "ONE_DRIVE", "createdAt": 1234, "createdBy": "456", "linkToFile": "https://someinstance-my.sharepoint.com/:x:/g/personal/username_someinstance_onmicrosoft_com/PlkJXFVMWpEV2cVApxt_H_EB6GH1viK96wa1-rEqGKjmpw" }, ... ] } 👉 What mutation would be required to add a file from an external provider such as Google Drive, Box, Dropbox or Sharepoint to a column? This is not the normal “upload a file” mutation as described here by: mutation { add_file_to_column ( item_id: 1234567890, column_id: "files", file: YOUR_FILE ) { id } } or curl --location 'https://api.monday.com/v2/file' \\ --header 'API-Version: 2024

Hello, I’ve been working on trying to pull hours from the Time Tracking column that I’ve added to a board via the Activity Log API. I added some hours yesterday and verified that it showed up in the API call. Today, however, those activities are not in the activity log and - for context - the query to pull the maximum number of activities across all the boards in our environment. Also, I’m using API version 2024-04. Is this an issue anyone else has experienced or a known bug? Here’s the python code/query I was working with: import requests import json import pandas as pd from datetime import datetime, timedelta apiKey = myapikey apiUrl = “https://api.monday.com/v2” headers = {“Authorization”: apiKey, “API_Version”: ‘2024-04’} activity_log_query = ‘{ boards (limit: 1000) {id activity_logs {data entity event id user_id created_at} }}’ activity_log_data = {‘query’: activity_log_query} activity_log_request = requests.post(url=apiUrl, json=activity_log_data, headers=headers) activity_log =

Hello, I am having trouble pulling column values from my boards. I am trying to use the below query, but I keep getting the error “Field ‘items’ doesn’t exist on type ‘Board’”. I’ve tried to shift this around and mess with the syntax with no luck. { “query”: “{ boards(ids: 1234567890) { items(limit: 50) { column_values(ids: [“text”, “date_1”]) { title value } } } }}” }

Hello, is there anyway to add validation on DropDown components as you can on TextField ones?style.monday.com

Hello, For the past few days, I’ve been encountering an error when attempting to activate an integration locally: FetchError: request to https://api.monday.com/v2 failed, reason: unable to verify the first certificate at ClientRequest.emit (node:events:513:28) at TLSSocket.socketErrorListener (node:_http_client:490:9) at TLSSocket.emit (node:events:513:28) at emitErrorNT (node:internal/streams/destroy:151:8) at emitErrorCloseNT (node:internal/streams/destroy:116:3) at processTicksAndRejections (node:internal/process/task_queues:82:21) { type: 'system', errno: 'UNABLE_TO_VERIFY_LEAF_SIGNATURE', code: 'UNABLE_TO_VERIFY_LEAF_SIGNATURE' } Anyone have any idea into what might be causing this issue? Thank you.

In my app, I have set up the sdk with the right token, I can make other query, however When I try to upload a file to a column on a board, it hits an internal server error. my code as following: const file = await fetch('/images/test.pdf').then(r => r.arrayBuffer()); console.log(file) const query = mutation {add_file_to_column (item_id: 1844256842, column_id: "files", file: ${file}) {id}} try{ const response = await monday.api(query) console.log(24, response) }catch(e){ console.log(e) } error message as follow

Hello team, I have this very basic structure: mutation createSubItem($parent_item_id: ID!, $item_name: String!, $columnValues: JSON) {create_subitem ( parent_item_id: $parent_item_id, item_name: $item_name, column_values: $columnValues) { id }} with the following variables: {"parent_item_id":<CORRECT_PARENT_ITEM_ID>, "item_name":"Item name string", "columnValues": "{\\"status\\": \\"Requested\\" , \\"people__1\\" : {\\"personsAndTeams\\":[{\\"id\\":5344389,\\"kind\\":\\"person\\"}]}}" } If I take out the PEOPLE’s section of my column_values, everything works, except for obviously no people’s assignment is happening. However, running the above code, I get the following error: { "error_message": "invalid value - unable to assign person with id: <PERSON'S ID>. Please check our API documentation for the correct data structure for this column. https://developer.monday.com/api-reference/docs/change-column-values", "error_code": "ColumnValueException", "error_data":

Hello, According to this forum post, one of the activities tracked by the Activity Log is create_update, but when I make an Activity Log query on my board, the create_update event never appears, even though updates have been made on the board. I can see other events, including update_column_value, add_owner, create_pulse, and many others but I cannot see create_update. Thank you!