API & Apps framework

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

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: