API & Apps framework

Hello, When importing an excel file manually to Monday, there is a cool feature that allows us to prevent any duplicates (‘Ignore the elements’ on a specific column). I’m trying to reproduce this with the API. What is the best way to do it? Right now the only way I’ve found is : 1 - Query for every item of the board and the value of the choosen column : query{ boards(ids: board_id){ items(){ name, column_values(ids:["column_id"]) { value } } } } 2 - Store every column value in my program. 3 - When sending the queries to create all the items, first check if the column value of the item that is about to be imported already exists in my stored column values, if it does the query is not sent. I guess this solution will work but Im a bit worried about how heavy querying for every items could be considering my program would do that on multiple boards that can have above 500

Until a few months ago, we used a separate workspace for our QA, and now we have 2 prod workspaces and our QA workspace. the problem we are using the same API for both QA and Prod, and this isn’t smart or safe as we are constantly adding functionality. other than purchasing another account to use for QA, how would you recommend we handle this? on our side we have a prod env and QA and so everytime we want to test new implementation we have to change the API to our QA environment and then back. This creates issues. Suggestions? How do others handle this?

We have some complex data transformation logics and the same cannot be achieved using Monday automation recipe. Therefore, we are looking into an alternative option to write the logic in any programming and host the code in Monday.com so that it is up and running 24/7 and when a state of a record changes then automatically triggers the execution of defined logic. It seems that most of the operation/Configuration or automation can also be achieved using Monday API. Is it possible to host logics in the application(not automation recipe)? I very new to Monday.com and figuring out the features available.

Hi guys! I have the next array : And my goal is to do the next format : Could you please advise?

Hi All, I’m trying to use change_multiple_column_values ( Guide to Changing Column Values) to update multiple columns in an item using on query. However I keep getting a 500 server error: I’ve tried a number of ways i.e. {“query”: “mutation { change_multiple_column_values ( item_id: 3618440629, board_id: 3618438405, column_values:"{\\"status\\":\\"Done\\",\\"status9”:\\"Done\\",“status8\\":\\"Stuck\\",\\"status4\\":\\"Stuck\\",\\"status0\\":\\"Not started\\",\\"status89\\":\\"Not started\\",}") {id}}”} {“query”: “mutation { change_multiple_column_values ( item_id: 3618440629, board_id: 3618438405, column_values:”{“status”:“Done”,“status9”:“Done”,“status8”:“Stuck”,“status4”:“Stuck”,“status0”:“Not started”,“status89”:“Not started”,}“) {id}}”} and {“query”: “mutation { change_multiple_column_values ( item_id: 3618440629,

Hi there, did any of you have ever managed to create a connection between Monday.com and Clockify? I don’t mean on time tracker (this is already working) but rather on the board level. What I am looking for is: every time I create a new invoice in a Monday.com board a new expense (with the same information) is created in Clockify it may be quite tricky, I am wondering if Zapier can help on this. Thanks

I’m trying to integrate Monday with Omie to display and use the existing dashboard. Does anyone know how to help me? I’m stuck. Where i need to put my code ? i need to pay some server ? from fastapi import FastAPI import requests app = FastAPI() OMIE_API_KEY = ‘your_omie_api_key’ MONDAY_API_KEY = ‘your_monday_api_key’ Endpoint to retrieve and display the Omie dashboard integrated with Monday @app.get(‘/dashboard’) def get_integrated_dashboard(): # Retrieve Omie dashboard data omie_dashboard_data = get_omie_dashboard() if omie_dashboard_data.get('error'): return {'error': omie_dashboard_data['error']} # Integrate Omie dashboard with Monday monday_payload = { 'name': 'Omie Dashboard',

How can I customize the settings panel of the board view, like they did for Priority Cards?

When I use monday.api() from the node module “monday-sdk-js” with the query query { items (ids: [3298111887,4254562863,3286311905]) { name } } then I get only two items back: "data": { "items": [ { "name": "task #3" }, { "name": "Ads" } ] }, "account_id": 13449709 } When I do the same with GraphQL playground then I get all three: { "data": { "items": [ { "name": "task #3" }, { "name": "Item 3" }, { "name": "Ads" } ] }, "account_id": 13449709 } The items are on different boards. One of them is shared

When I try to access monday.storage via the SDK in a workdoc, I see the error: “storage command isn’t available or supported for this app feature type”. Is it expected that this is available in workdocs? I’m using the example from the documentation when trying to get/set the storage key: monday.storage.

I tried the following and couldn’t create the doc with this response. `mutation { create_doc (location: { board: {item_id:1234, column_id: "monday_doc" } } ) { id } }` { error_code: 'InvalidColumnIdException', status_code: 200, error_message: "This column ID doesn't exist for the board", error_data: { column_id: 'monday_doc', board_id: null, error_reason: 'store.monday.automation.error.missing_column' } } When I searched item and column with API in the workspaces I am working on, it failed to create a doc with any value. What are the item_id and column_id needed to create the doc?

Hola! Quisiera saber si alguien sabe como copiar un dato a columnas de tipo relation_board y connect_board en javascript, lo he logrado en columnas tipo texto y numero, pero en estas primeras de dos de relacion y conexion no he tenido exito, por lo que pregunto si habrá alguna sintaxis especial para ellas o algo, encontré temas parecidos en la comunidad sin embargo las soluciones dadas fueron url de documentacion que actualmente ya no funcionan y no carga la pagina. Mi código ahorita es algo así por si es de ayuda (Solo es una parte): const textColumnIds = [‘board-relation’,‘name’]; textColumnIds.forEach(columnId => { const queryCambiarTexto = `mutation { change_simple_column_value(item_id: ${itemId}, board_id: ${boardId}, column_id: "${columnId}", value: "${itemId}") { id } }`; fetch("https://api.monday.com/v2", { method: 'post', headers: { 'Content-Type': 'application/json', 'Authorization': author

Hello, I’m trying to follow the addMultiBlocksFromHtml api method documentation to add a doc block to a workdoc but I have the following error: Error: “addMultiBlocksFromHtml” execute command isn’t available or supported for this app feature type. Is not supposed to be supported for workdocs? Or what am I doing wrong? I just took the example provided in the documentation. Thanks, Gorka.

I wonder is it possible to code and automation to exisitng integration. For example, Monday integrates with Survey Monkey but they only offer two automations. I want to figure out if I can build special ones…

Hi team ! Regarding the pricing mechanism and monetization in the marketplace - If my app’s price is seat based, and the app has the same functionalities for all kind of pricing plans, should I manage any pricing mechanism in my code? According to my understanding, I should refer the plan id in the code only if I want to expose any specific/extra functionality to specific pricing plan. But in my case, once a customer paid for the app, he has an access for all of it features, so when customer want to renew the app subscription or extend the number of seats, monday monetization platform already handles this matter as soon as the customer subscription ends, right? (the platform just enforce him to extend and renew the subscription, right?) Thanks in advanced!

When I was trying to access storage API in workdocs, getting Invalid storage access issue. The methods using are monday.storage.instance.getItem(key) monday.storage.instance.setItem(key, value) Am I missing something? Or any other way to store properties in workdocs. Looking forward for your response. Thanks in Advance!

Hi guys, please help to understand what I’m doing wrong. Using GraphQL succesfully creating board, creating item with title. But whenever I’m trying to update column values on the item for the board I’ve created resiving UserUnauthroizedException 403 exception. Please advice, how I can see what permissions do I need? this throws and error: mutation { create_item (board_id: 3896215602, group_id: "duplicate_of_implementation_go", item_name: "“+ title +”", column_values: "{\\"text\\":\\"testTEST\\"}") { id }}" This workds as intended with no access issues: “mutation { create_item (board_id:”+ boardId +“, group_id: "duplicate_of_implementation_go", item_name: "”+ title +“") { id }}”

Hi team ! In the setting field configuration, What is the meaning of the “Required for onboarding” checkbox and the alias input field? Thanks

Hi, I am trying to use general caster to detect if there is a change between creation and updated dates. The following doesn’t seem to work: IF({item’s Created Time}<> {item’s Updated Time}, “Different”, “Same”) Let me know the correct formula to use. Thank you

Apps Breaking changes: Sandboxing for all iframes Date TBD Updates to seat-based view apps and trial subscriptions starting August 28th (marketplace only) API Breaking changes: API version 2023-10 January 1st, 2024 API release postponed to January 15th

I am currently using the monday storage API to store data for an item-view app. I need to enable data sharing to a board-view as well as some other features so am looking to move to a relational database. Currently, the only way I can see to migrate data from monday storage to the relational database would involve a user clicking into each item that they have data stored against and then waiting while a migration task runs. This is obviously not a great UX and also causes problems such as not having any idea when all data is migrated or preventing the possibility of partial migration if the user clicks of the item early. I feel like I’m missing something, is there a better way to access item-view data for all items in an account when they upgrade a major version of an app?

Hi, Similar to this question: Items Query responding with error I have the exact same error; for example (on version 2023-07) query { boards (ids: 3553135069) { items { id name column_values { id title value } } } } Returns: { "errors": [ { "message": "Unexpected token 'u', \\"upstream r\\"... is not valid JSON", "stack": "SyntaxError: Unexpected token 'u', \\"upstream r\\"... is not valid JSON" } ] } This query just ran successfully this morning, 10 minutes later the same query doesn’t work.

I have just started to use some of the API features and have made it through some of the tutorial items but I’m pretty new at this type of work. I would really love to see more example scripts of basic operations. I know that updating an item requires an Item ID but I’m having trouble querying that successfully. Could anyone provide a python script that finds an Item ID on a specific board based on a column value like “Employee Number”? Bonus points if the response could include the next logical leap of editing a text column and a status column. I have looked through many of the forum posts and I see most common responses are just snippets and I’m not confident I would know what to do with a response that doesn’t include all portions of the script needed with the variables changed to something like “API_Key”, “Board_ID” etc. Please and thank you in advance.

TL;DR: It’s been a week since we announced the AI App Hackathon winners and we are still getting goosebumps thinking about all that this outstanding event generated! 💥 💣 You like to see things in numbers , aren’t you? 😎 Here are some numbers on the event 1633 people registered and worked in 225 teams operating in London, Tel-Aviv and Online. Prize worth was $63K divided by 6 winning apps 2 minutes: That’s how long it will take you to read all about the winning AI apps and be pumped up like we are writing that. Here we go. 👊🏼 Grand prize: AI Smart Form by Adapavist (Online) 🏆 Smart From leverages the forms feature to a whole new level of capabilities using AI. The app allows users to create automatic

Hi I would like to use the API to access all of our boards etc. but am running into 401 permissions errors. How can I create a user or generate an API key/token that has access to all the data available from the API? Or if that’s not possible what’s the best way of going about that? Thanks