API & Apps framework

Hi, I am trying update multiple column values of an item using mutation,But I am getting error code 500 everytime. Can anyone please help me out ?? Sending the data into column values in the following format. {“person3”:“Person one”,“numbers”:22,“location”:“New Delhi”,“date”:“IDBI Bank”,“numbers8”:500}const updateItem = async (token, boardId, itemId, columnvalues) => { debugger try { const mondayClient = initMondayClient({ token }); const query = `mutation change_multiple_column_values($boardId: Int!, $itemId: Int!, $columnvalues: JSON!) { change_multiple_column_values(board_id: $boardId, item_id: $itemId, column_values: $columnvalues) { id } } `; const variables = { boardId, itemId, columnvalues }; const response = await mondayClient.api(query, { variables }); console.log(response) return response; } catch (err) { debugger console.error(err); } }; Attaching the snaps of my code.

Fetching boards with the API returns docs from the new docs feature as well. Why are docs treated as boards?

I receive a message from Monday : “URL don’t return solution” I have Lambda function on Python: def lambda_handler(event, context): body_str = event.get("body", "{}") body_str = body_str if body_str else "{}" body_obj = json.loads(body_str) a = body_obj.get("challenge", "") print({"challenge" :a}) return {"challenge" :a} My Cloud Logs show that what I return looks like that And I suppose that is correct solution. At least I’ve tried everything I know. Can you help me, maybe I returning it in a wrong way

I’m currently trying to write a GraphQL query that finds items in a board using the item name. I assume I’m missing something obvious, because I can only find how to: Query item by Id (Using the items function), or Query item by the value of one of the columns (Using the items_by_column_values function) It really seems like I’m missing something obvious Hopefully somebody can help

Hello! I was working on developing a custom item widget using the “Widget Setup” tab to see changes in real time. There is an option to select the board and item to test the widget with, but for some reason, when I select the board, it doesn’t find any item to select, which basically means that I cannot test the app. If, instead, I try to create a new item through there, the loading icon never disappears and the item isn’t created. Has anybody come by this problem and know a fix/workaround? It used to work fine a couple of months ago, and I should have clearance to use the board (I am a board owner as well as being admin in the workspace, and the app has permissions to access and edit board data). I have other similar problems with the custom widgets. For example, when retrieving the context, the theme is always returned as light theme, so I need to manually add a checkbox in the settings to select the theme the user wants Thanks in advance!

I am stuck with a board that has over 40 statuses so creating the individual automation for each status will not look neat as there will be too many automation, The board already has close to 20 automation. The below is what I will like to achieve. “When any status changes to Status in Board, Move item to group”

Hi Folks, Is it possible to get access to the monday.com API GraphQL schema file, so that I could use postman as my API playground? It’s not my intention to put the monday.com API playground down but I need a dark theme at night 😜 Best wishes, Ahmed

I’m trying to create a new item but unable to find the correct syntax to set a status column, please can someone correct the below. (column_values: “status”, “Awaiting” ) Thanks mutation { create_item (board_id: 12345678, group_id: “topics”, item_name: “Test_Name”, column_values: “status”, “Awaiting” ) { id } }

I am trying to create an item on a board, then have the ID of the Item and create another Item in another board and link to items. Here is the code that create the first Item and retrieves the Id of the new item: new_client_name = 'test new client' people = '774666386' # The Owner ID of the task phone = '123456789' email = 'email@email.com' text0 = 'CEO' #Title status4 = 'Kick Off' # Stage date = datetime.today().strftime('%Y-%m-%d') # Created date status = 'Customer' # Type of item - Customer / Other dropdown = 'No' # Some Yes / No question # # CREATE A NEW CLIENT create_a_new_client = 'mutation ($myItemName: String!, $columnVals: JSON!) { create_item (board_id:1405312628, group_id:"1624094797_clients" item_name:$myItemName, column_values:$columnVals) { id } }' vars = { 'myItemName' : new_client_name, 'columnVals' : json.dumps({ 'people' : people, 'date' : {'date' : str(date)}, 'phone' : phone, 'email' : {'email': email, 'text': email}, 'text0' : text0,

Hello, I am trying to upload an image to an update entry, but I get the next message UserUnauthroizedException",“status_code”:403,“error_message”:“User unauthorized to perform action”,“error_data” I found a previous topic with the same problem but the account has never lost his admin privileges, my user can write on the board, actually the script created the updates inside the board, and several items and subitems, before trying to upload the image. I have been using the API v2 token. Any help is greatly appreciated.

Following this tutorial: https://apps.developer.monday.com/docs/quickstart-view - I get to Part 3, step 2: “On the “View Settings” pane on the right, select the blue “Add Field” button. This will let you add a new field to your feature’s settings.” There is no “Add Field” button on my screen:

I’m working with a large monday board with many items. I would like to fetch the latest 30 items appended to this board. Is there a way to do this with the current API? I am aware of the limit keyword, but this returns the first n items instead of the latest ones. Unfortunately, I am now forced to fetch the whole board which can easily take the Monday API up to 20 seconds.

I want to create a high level, overview of my project as the main page in Monday. If you’re familiar with Asana’s main portfolio page, that’s what I want to replicate. Somewhere where anyone can get an overview of a project’s current status, timeline, summary of the project goal, as well as quick access to key links and documents. Is there a way to make this that I’m not aware of?

HI All, In our Outlook integration we open an OAuth window to connect with monday, and it fails on IE11 on Windows 7 (Microsoft was kind enough to let us know) please see below : Is there a way to fix this?

Im starting my first steps, and i dont see how can i create a item and upload a file in the same line. Can anyone help me here.

Hello, I would like to know how I can construct a url to a board from the board id. My app queries monday.com and allows the user to select the board using the monday.com API. At the moment this is the query we are using: query: `query { boards (${options || ''}) { name description id workspace_id } }`, Since I have the board_id how can I construct a url so that I can link the user to the specific board? I have tried https://monday.com/boards/${board_id} but this generates a broken link

While creating a Monday API to connect our server to Monday board, I want to create an item with values for each colums. Problem : it works for every colum except for the rating one. I 've tried many syntax but no one works. The official doc at https://api.developer.monday.com/docs/rating doesn’t help. Does anybody know how to do it ? Here is the code : $column_values = [ 'name' => 'xxxxxxxxxx', 'person' => '20985745', 'status' => '14', // 'classement' => '5', // 'classement' => '5/5', // 'classement' => "{\\"rating\\":1}", // 'classement' => "{\\"rating\\":1\\"}", // 'classement' => "{rating:1}", // 'classement' => rating:1', // 'classement' => {'rating:1'}, // 'classement' => "{\\"rating:1\\"}", // 'classement' => 'rating 1', 'classement' => 'rating\\:1', 'date' => '2021-09-01 16:30:00', 'texte' => 'Bonjour', 'statut_1' => '1', 'personnes' => '20791487', 'lien_internet' =

Hi, I’m trying to create new items, providing column values. Everything it’s fine, except with link (url) columns. Can anybody tell me how to add a link field? I know that a link field has 2 subfields (“web address” and “text to display”), so I suppose that I have to provide an object with both values, but I cannot find any example in the documentation. What should be the proper way to add the link field: mutation { create_item (board_id:111111, item_name:“test3”, column_values: “{"link": "www.test.com"}” ) { id } }

Hi there, I’m using Postman to build out all of our API calls before coding them. I need to add a value to just one column while creating an item. However, I’m receiving a Parse error when sending the request. Is it escaped wrong? Thanks for anyone that can help! Here’s what the request body looks like: { “query”:“mutation { create_item (board_id: 12345, group_id: "Test board", item_name: "item_name", column_values: "{\\"text\\": \\"company_datetime\\" }" { id }”}

Hi, With our app we deploy it will multiple automations and a few sample items. In the template boards locally they are all there but when deployed the automations and items disappear. Any idea?

Hi all, Wondering if you experience the same. In a custom trigger I have defined the subscribe / unsubscribe endpoints. When the user makes a change to the recipe monday will go through the unsubscribe and then subscribe events. All works fine until my endpoint send a non-200 status from my unsubscribe endpoint. Monday will fail obviously, no problem. Any successive call monday make to my unsubscribe endpoint for that recipe contains an empty payload. I am discussing this with the appsupport team but wanted to know if you experience the same. Look like this bug is introduced in the weekend of July 24.

First off, the following closed thread is related and it would have been nice to comment there: Date format of activity_log.created_at field monday Apps & Developers Hi, I’m building an integration and I cannot see how to convert the activity_log.created_at field from an integer to a date. Cannot find anything in your KB, nor online in general. An example of a returned “date” field is “15905438472681046”, which corresponds to approx May 28th 2020 (give or take a few days) The number is too big to be Unix Epoch. Thanks I’m doing the same, querying and parsing activity_log queries. I’ve validated that the following Python/Pandas code converts Monday.com Unix timestamps correctly: import pandas as pd pd.to_datetime(16155031105053254 / 10000000, unit='s') >> Timestamp('2021-03-11 22:51:50.505325312') But the following also works: pd.to_datetime(16155031105053254 / 10000, unit='ms') >> Timestamp('2021-03-11 22:51:50.505325312') pd.to_d

I’ve noticed when using change_multiple_column_values with a column that doesn’t exist, instead of registering an error or simply doing nothing, it creates that column and populates it. How do I prevent this? I want to make sure that only existing columns are updated.

I have created a custom app in order to use a custom workspace template. I have created a sample workspace template as a feature in my app and installed the app to my organizations Monday.com account. However, I cannot find the workspace anywhere. Where does the workspace template appear?

I’m trying to create a custom trigger but I can’t put it in the frame, I haven’t used this tool much could someone help me? trigger: action: When I try to add to the frame I can’t.