API & Apps framework

Goal: Consume external API (Printavo) and convert order details to board view in monday Progress: I can retrieve our order information from Printavo using Node with below import dotenv from "dotenv"; dotenv.config(); import express from "express"; import fetch from "node-fetch"; const app = express(); const port = 3000; const secret = process.env.USE_SECRET; const email = process.env.USE_EMAIL; app.get("/orders", async (req, res) => { console.log(`/orders endpoint called ${secret}`); const url = `https://www.printavo.com/api/v1/orders?email=${email}token=${secret}`; const options = { method: "GET", }; const response = await fetch(url, options) .then((res) => res.json()) .catch((e) => { console.error({ message: "oh noes", error: e, }); }); console.log("Response: ", response); res.json(response); }); app.listen(port, () => { console.log(`Example app listening at http://localhost:${port}`); }); My plan was to conve

I’m trying to update a location via GraphQL - can’t get it to work in the playground - can anyone help me see what I’m missing? Here is what the documentation says to do: mutation { change_multiple_column_values(item_id:11111, board_id:22222, column_values: “{"location3" : {"lat":"29.9772962","lng":"31.1324955","address":"Giza Pyramid Complex"}}”) { id } } I’m good until after column_values: that is a load of nonsense I don’t know what to keep and what to change. the slashes are just kind of everywhere and I can’t make sense of it. Here is what I’ve been trying to get to work to pass in a string: mutation { change_multiple_column_values(item_id:1653243041,board_id:1636890828, column_values: “{“location_1” : “42.564779 -87.97627779999999 13905 75th St, Bristol, WI 53104, USA”}") { id } and to pass in JSON: mutation { change_multiple_column_values(item_id: 1653243041, board_id: 1636890828, column_values: “{“location_1” : {“lat”:“42.564779”,“lng”:“87.97627779999999”,“address”:“13905 75th

HI everybody, we have an outlook app that integrates users with their Monday account via OAuth handshake request. usually if the app wasn’t installed in the user’s account, Monday would automatically ask for permission to install with all the apps scopes. And now we get this message instead: “App is not installed, in order to use this app you need to first install it”. If we manually install the app through the shareable URL in our user’s account, it works. We don’t know about any changes we’ve made that could’ve done this, is this on Monday’s side, or we’ve miss-looked something? Thank you very much!

Hi, I have some some script, which duplicate a board via Graph API, then next step it searches some item by the name. But it seems that dupolicate is async, because second function cannot finf my item… like it doesn’t exist yet… any clue ho to solve this? Some parameter for Graph API to wait for finish? So SYNC call, not ASYC?

Hi Team, I was wondering which field can we use when building custom action wherein we want the users to specify which columns from their board they want to send to us. I was looking into using a custom entity which would retrieve all the columns from the board and present it to the user but there is no option for a multiple select type. Was wondering what is the best approach for this. Thanks!

When updating “Connect boards columns”, some items are not connected. In the attached video, the items being created are supposed to look exactly like the first three. As shown, the second item is not connected. This happens spontaneously to different number of items if the number of items being created is numerous. I did like to add that, the items are not been created concurrently but rather sequentially as shown in the video. Here is the demo link.

Hi, I am trying to use webhooks with GraphQL API. I have successfully created a webhook that listens change_column_value event. It works correctly for the columns present in the creation time of the webhook. For example, I change a column value webhooks makes a request including the correct details. However, it does not behave this way when I change a value in a newly created column. The webhook sometimes makes requests to given URL and sometimes it does not. To reproduce bug: Create webhook on a board. Change a column so that verify that you have successfully created the webhook. Create a new column - (no request is made to the webhook URL as expected) Change a value on the newly created column (sometimes a request is made to the given URL but sometimes no request is made) Could you help me with this issue either by verifying the bug or suggesting a solution.

Good afternoon, I have a project in development but it’s stagnant due to a difficulty we had with dropdown. I’m using Colab to send information from excel to a monday board, I need to store a value that is only number in a column of the dropdown type, but when the value has only numbers it returns an error 500! Can I get around this issue? The value of ‘Codigo Assessor’ and ‘Codigo cliente’ already exists in the dropdown! Inside collab the excel columns have this ID And I refer like this, with monday columns. I need help referencing numeric values ​​within the dropdown. Thank you in advance for your attention!

I have this code, which I took from the quick start docs, in my app: monday.listen("context", res => { console.log("something is happening"); this.setState({context: res.data}); console.log(res.data); monday.api(`query ($boardIds: [Int]) { boards (ids:$boardIds) { name items() { name column_values { title text } } } }`, { variables: {boardIds: this.state.context.boardIds} } ) .then(res => { this.setState({boardData: res.data}); }); }); When the app view of the board is reloaded, it displays all the information on in the fields on the board: "boards": [ { "name": "Test App", "items": [ { "name": "Facebook Pixel", "column_values": [ { "title": "Status",... However, if I have two windows open, one with the main table and one with the app view; I update a field value in the main table, but the app view json does not reload, nor do I see anything in the console logs. I’m trying to get a proof-of-concept, just to figure out how to trigger actions when a field va

I am trying to build an app using monday sdk and it was all going well but somehow,my public vanishes and now not coming up in the terminal. like ngrok url…! I have also tried http://localhost:4040/status to get that but the page does not comes up ,though my code is running and debugger is attached.

Good morning, I saw some time ago that there is no way to create new values ​​in the drop-down list via API, do you have any updates on that? Thanks!

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?