General

For some reason my add_file_to_column query costs is 100001 for a small 2KB file. What can I do to reduce the api query budget size of the upload? @Matias.Monday Any pointers on how to make this more efficient? async function uploadAndRemoveFile(upfile, token, itemId, columnId) { try { const affordability = await canAfford(token, 100001) console.log("Can Afford Query: " + affordability.canAfford) if(affordability.canAfford) { const mondayClient = initMondayClient(); mondayClient.setToken(token); console.log("UPLOAD AND REMOVE FILE"); console.log("upfile: " + upfile); console.log("itemId: " + itemId); console.log("columnId: " + columnId); const filename = path.basename(upfile) const query = `mutation($item_id: ID!, $column_id: String!, $file: File!) { add_file_to_column(item_id: $item_id, column_id: $column_id, file: $file) { id } }`; // Define variables for

Get Started Today: https://monday.com/marketplace/10000446 This integration brings a powerful suite of tools directly to your project management workflow, making it easier than ever to manage and succeed in your projects. Key Features of Our Portfolio Project Management App: 📊 Gantt Charts: Visualize your project timelines in a clear and interactive format, allowing for precise planning and adjustments on the go. ⏱️ Auto Scheduling: Optimize your project schedules automatically, ensuring that deadlines are met without constant manual adjustments. 🚩 Milestones & Dependencies: Track critical milestones and understand the dependencies within your project to manage risks and align your team’s efforts effectively. 📈 Baseline & Critical Path Analysis: Compare your current progress against the original project plan (baseline) and identify the critical path to prioritize tasks that directly impact your project’s timeline. 🌐 Portfolio Managem

Hi, I want to have a custom trigger of “column change” but the user will be able to select ONLY file type column. How can i achieve this? When creating a custom trigger I need to select a subscribe URL, which I don’t need in this case because I am not using any external system. So - How can i create a custom trigger “When a File column changes”? Thanks in advance!

Hi, I have so many features for my app. On app submission to marketplace, which feature is getting published? Or should I have only 1 feature per app? I am a little bit confused here. Thanks in advance. Regards

Hi, I’m trying to get files from one subitem and put them into the files column of another subitem. Retrieving the public download URL from the actual file (asset) and the link from the Google Drive file works fine. And adding the asset to the files column also works. However, I don’t know how to add a link to the files column via the API. To clarify, I have 3 files: 1 uploaded from my PC (asset). I know how to move that one 1 files that’s linked from Google Drive 1 files that is a link Any clue if this is possible?

Maybe it’s my own implementation, but it seems that the API budget limit is the same across load balanced EC2 Instances in AWS for my application I’m developing. Has anyone else seen this? Is it just better to build on monday code instead 🤷? Is the budget per board that the token originates, or it based on the server?

I’m trying to get the text value of a status column for a specific item using Zapier webhooks. And I’m getting the following error? Thank you in advanced!

How do I get an owner of a pulse? I see a creator, but no owners. query { boards(ids:“***”) { id, name, pulses { id, name, creator { id, } } } }

Hey guys. This post is for those who, like me, is confused about the monday create_item mutation, specifically the column_values parameter, allowing to set values for other columns than the default name column. For me it worked just fine to set any text field like this; {"field": "value"}, and that’s as far as the Monday API documentation goes, but if you want to fill non-normal fields, like email or phone, the format is different, like this; {"email": { "text": "text to appear in the column - often the email", "email": "test@test.com" }} And for the phone field format, it should look like this; {"phone": { "text": "text to appear in the column (phone numer...?)", "phone": "+123123123" }} Full cURL request for your convenience; curl --location --request POST 'https://api.monday.com/v2' \\ --header 'Content-Type: application/json' \\ --header 'Authorization: {YOUR_KEY_HERE}' \\ --data-raw '{"query":"mutation {\\r\\n create_item(board_id: 611638622, item_name: \\"My Item\\", group_i

{ errors: [ 'Complexity budget exhausted, query cost 100001 budget remaining 99951 out of 5000000 reset in 50 seconds' ], error_code: 'ComplexityException', status_code: 429, account_id: 20288401 } When this occurs is it best to just return a 400 failed message for the integration, since the shortLivedToken only lasts 30 seconds?

Hello, I have a python code, but i do not know how monday filters work with pd.json_normalize python function. I don’t think it is written ok, because I believe column{title} should be written somewhere. Can someone help me? Thanks in advance 😉 item_features = pd.DataFrame() pulse_3 = pulse_3.reset_index(drop=True) for i in range(1,len(pulse_3)): q_features = ( "{boards(ids:" + pulse_3.loc[i, 'board_id'] + "){items_page (limit:500){cursor items {id name column_values{... on MirrorValue {display_value} ... on BoardRelationValue{display_value} column{title} text type}}}}}" ) q_features = {"query": q_features} r_features = requests.post(url=apiUrl, json= q_features, headers=headers) features_json = r_features.json() df_features_norm = pd.json_normalize( features_json['data']['boards'][0]['items_page'], record_path=['items', 'column_values'], meta=[ ['items', 'id'], ['items', 'name']

Hi Team, Good day, As you can see in the below image, I have duplicate recipes. I want to delete the duplicate recipes, but I don’t have the option to remove the recipe. You can see the below recording video as well. How can i delete this duplicate recipe, Help us on this, @TeamSoftware Thanks in advance

Hi, I am struggling to maintain api’s error messages using app sdk aka monday.api(query). I am developing a client side react application and I am using monday.api(query) to do http request. For success scenarios there is no problem I can get the payload. But for error scenarios such as rate limit problems I can’t get the full json payload which should contain status code, error code etc. When there is an error scenario it returns like the following: As you see it only contains the message as string. And this is the returning actual payload from the server including all information that I need. I took the SS from Chrome’s developer tools. Here is my code: Monday.api('query goes here') .then(success_fn, function (err) { console.log(err.data) }) My library versions. I assume I am using the latest versions. ├── @mondaycom/apps-cli@2.4.0 ├── @mondaycom/apps-sdk@3.0.2 ├── monday-sdk-js@0.5.5 ├── monday-ui-react-core@2.104.0 My api version is 2024-07. My u

Hello everyone, So, I’m reading through the docs (specifically for the storage, but my question stands for queues, etc.) and I see a bunch of examples of how to use storage with javascript sdk. But is there a way to use that from a backend written in a different language? Swagger/postman collection would be very helpful. Thanks.

I am trying to create a new board column name “xyz” via the API and get the following error message “The specified ID already exists or is reserved for a column in this board”. I did create a column named “xyz” previously but deleted via the API. When I query the columns from the board I can see that the “xyz” column is not listed. Is there a way I can create the column with the same name I used before?

We have developed a monday.com application. When doing the oauth to the customers account we are getting an error they must install the application first. We found the link for people to install the application first, but this complicates the install process. How do you suggest we handle the integration with monday when we have an install link and a permissions link? I feel like the permissions for oauth should install the app, and there shouldnt be a seperate process.

Hey guys, I am sure this has been answered a few times but I am having trouble with a particular query. No code language, having trouble with the playground and postman. I am trying to send a link in my JSON for updating multiple values at the creation of an item. The mutation mutation CreateNewItem ($itemName: String!, $colVals: JSON){ create_item (board_id: 1234, group_id: "new_group", item_name: $itemName, column_values: $colVals){ id } } Unformatted(500 error): { "itemName": "test", "colVals": { "link5__1": { "url": "https://google.com", "text": "Go To Ticket" } } } If I attempt to stringify with single slashes I get 200 code but nothing shows up. If I attempt to stringify with multiple slashes like so I can get it to show up in the link column but it shows up as a string. Whatever I do I cannot get the link to show up and direct me. {"colVals":"{\\"ticket_number__1\\": \\"Test\\", \\"link5__1\\": \\"{\\\\\\"url\\\\\\": \\\\\\"https://google

Hi there. I am trying to upload a file into a file’s column executing cURL in Windows cmd. My petition is this: C:/curl/bin/curl -X POST -H "Content-Type:application/json" -H "Authorization: MySecretToken" "https://api.monday.com/v2/file" -d "{ \\"query\\":\\"mutation add_file($file: File!) {add_file_to_column (item_id: itemID, column_id:\\\\\\"files__1\\\\\\" file: $file) {id}} \\" , \\"map\\":\\"{\\\\\\"image\\\\\\":\\\\\\"variables.file\\\\\\" } \\" , \\"image\\":\\"@/C:/PRUEBA.pdf\\" }" But I cannot upload the file, I get this error: {"errors":[{"message":"Variable $file of type File! was provided invalid value","locations":[{"line":1,"column":19}],"extensions":{"value":null,"problems":[{"path":[],"explanation":"Expected value to not be null"}]}}], First, I tried using Postman and worked, then I look the cURL code snippet and try to re write it, but it does not work. I would appreciate any recommendation.

Hi there, Is there a way to fetch items that we are updated after a certain timestamp? Thank you.

I noticed that the GraphQL published at https://api.monday.com/v2/get_schema?format=sdl&version=stable is missing types for docs. It is present when using the playground. Is there a recommended way to get the complete types? Cheers, Reinier

Hello. I was wondering if there is any ability for developers to interact with the “updates” item view. I would want to get maybe the text of an update and date/time an update was created. Thanks.

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