API & Apps framework

Hey all! We’re building an app that triggers notifications from the server side. We are using the graphql create_notification mutation, passing the user’s id, target_id (board_id) and text. As a token, we use one that is generated using the authorization flow. The notification’s text is showing as expected, but the title shows the user’s name and logo, instead of the App’s name and logo: Is it possible to use the App’s name? After all the action was made in the background by the App, and not by the user. Thanks!

Does anyone know if you can layer an external map onto of a Monday.com map? In Monday.com we have a map displaying all jobs to be scheduled and we have a seperate GPS tracking app showing the locations of our technicians I would love to be able to put the GPS app onto of the Monday.com map

Hello, I apologize if this is already common knowledge, but I was unable to find an example of this in my search of the community. Essentially, I attempted to use the “items_by_column_value” query, utilizing the users’ Id as the “column_value” argument. I realize that the column value of a “person” column type is JSON, thus zero results. Please correct me if I am wrong, but there is no way to utilize wildcards in the argument. Is there an example of querying items by user?

Hi all, I am new to monday.com and also to GraphQL, so I had to figure everything from scratch. Currently I am developing app, where I need to upload file to specific database column. Columns looks like this: files_1 : { id: "files_1", text: "https://something.monday.com/protected_static/ID/resources/ID2/image.jpg", title: "Dedication Image", type: "file", value: (JSON.stringify value of text...) } When I want to access photo and display it on web, I need to query with assetID and then I receive publicURL. That was for querying. What I need is upload file from web to monday.com I triend every single solution that I had in mind or I found on google, but nothing helps me. Here is my function for uploading picture: var formData = new FormData(); formData.append("query", `mutation addFile{add_file_to_column (item_id: 3286592696, column_id: files_1, file: ${file}) {id}}`); formData.append('map', '{"image":"variables.file"}'); formData.ap

Hello every one, I need some help please. I use a simple board, an item is assigned to a group of person. This is the structure : {“name”:“Thing to do”,“column_values”:[{“id":“person”,“type”:“multiple-person”,“text”:"user1@mydom.com, user2@mydom.com”},{“id”:“status”,“type”:“color”,“text”:“Done”},{“id”:“timeline”,“type”:“timerange”,“text”:“2022-09-19 - 2022-10-01”},{“id”:“texte8”,“type”:“long-text”,“text”:“Good job”}]} I managed to folow the QuickStart PHP Api Guide and populate the main Label, the status and the last “text8” label. But I can’t manage to populate the timeline column and most of all, the person column. I think there is something about Person ID (I managed to find all the IDs). I tried this : $headers = ['Content-Type: application/json', 'Authorization: ' . $token]; $query = 'mutation ($myItemName: String!, $columnVals: JSON!) { create_item (board_id:XXXXXXXXX, item_name:$myItemName, column_values:$columnVals) { id } }'; $vars = ['myItemName' => 'Thing to do', 'co

Hi all, I was using the api in bubble.io and can’t seem to edit the column values within the call. Here is the POST call {“query”:“mutation { create_item (board_id: 3188858191, group_id: “topics”, item_name: “”, column_values: “{“what_is_your_first_name_” : “value”}” ,) {id, name, column_values {id, title, value}}}” } if i remove the column_values section it works fine and if I make a separate call just to change an existing items columns, that works too but I can’t seem to get it to function when making a create_item call. error message: “message”: “Parse error on “what_is_your_first_name_” (STRING) at [1, 99]”, “locations”: [ { “line”: 1, “column”: 99 } ]

Hi, I am using the below query to retrieve all the updates, the below query throws an error as well as response. Is this an expected behavior? { updates(page: 12, limit: 100) { assets { created_at file_extension file_size id name uploaded_by{ birthday } original_geometry public_url url url_thumbnail } } }

Hi all, definitely not a developer here just trying to learn more about the API as I have a meeting coming up with several developers and don’t want to appear a total idiot… Just wondering if somebody can share with me or point me to a list of all the column types available via the API? (Create, update, read). I have seen “it’s in the API docs” posted in several support threads but despite searching for quite some time can’t find it anywhere. I’m hoping some kind person out there can point me in the right direction. Cheers, Patrick

Choice Number: 3896 Pay Load: { “query”: “mutation ($boardId: Int!, $companyName: String!, $columnVals: JSON! ) {create_item (board_id: $boardId, item_name: $companyName, column_values: $columnVals) {id}}”, “variables”: {“boardId”:2364371628, “companyName”:““test23LastOne””, “columnVals”: “{“phone”:”“7169084086"”,“text”:““test23LastOne””, “text4”:““test23LastOne””, “long_text”:““test23LastOne””, “status4”:“Website Form”,“email”:{“text":""test23LastOne@test.com” “,“email”:""test23LastOne@test.com” “}}”} } Url: https://api.monday.com/v2 Webhook Id: 10 Webhook Name: MarketoToMonday Request Type: http_post Step ID: 3630 Source: Marketo Flow Action Response: {“errors”:[{“message”:“No query string was present”}],“account_id”:6562763} Person ID: 3238884 Response Code: 200 Here is my code: { "query": "mutation ($boardId: Int!, $companyName: String!, $columnVals: JSON! ) {create_item (board_id: $boardId, item_name: $companyName, column_values: $columnVals) {id}}

Hello everyone ! I’m looking for a solution to this problem : I want to read directly in a number column a value from a Json file while knowing the associated key of this Value. Exemple : My API call > https://api.snowtrace.io/api?module=account&action=tokenbalance&contractaddress=0x....&address=0x....&tag=latest&apikey=MyKey The API return : {“status”:“1”,“message”:“OK”,“result”:"19043221718329235974770 »} And I want to fill my number column with the value associated to result key. Then I need to make an automation to refresh value on demand. Is it possible to build this kind of parsing tool directly in monday table column ? Thanks in advance for your help. Regards

let’s say I have a board like below, I want to update the Status column based on the item id. I want to update the text of Customer Status column if a matched item id was found. In this case, the text ‘Active’ will be change to ‘Inactive’. How to do it python? I tried: query = ‘mutation ($columnVals: JSON!) { create_item (board_id:1234, item_name:12345, column_values:$columnVals) { id } }’ vars = { ‘columnVals’ : json.dumps({ ‘status3’ : {‘text’ : ‘Inactive’} }) } data = {‘query’ : query, ‘variables’ : vars} r = requests.post(url=apiUrl, json=data, headers=headers) jsondata = r.json() print(jsondata) board item info: “boards”: [ { “name”: “myboard”, “id”: “1234”, “description”: “”, “items”: [ { “name”: “12345”, “id”: “1234567”, “column_values”: [ { “title”: “Subitems”, “id”: “subitems”, “type”: “subtasks”, “text”: “02342” }, { “title”: “Customer Status”, “id”: “status3”, “type”: “color”, “text”: “Active Customer” }] } ] } ]

when we trying to retrieve sub item(board id is of subitem board) we observed first subitem has parent_item id as null in this query { boards(ids:[1234]){ items { id, name, subitems{ id name } parent_item { id } } } }

I want to pull all board Ids and corresponding ItemIds and its columns.I have list of BoardIds with me.So when I try to loop below query through list of board Ids its giving result for the first board id of the loop takes and showing same data for all the board Ids. Query- { boards(ids: $(vboardsId)) { id name columns { title id type } groups { title id } items { id name group { id } column_values { id text title value }}}} Where - $(vboardsId) variable of for loop which providing board Ids Is it so once we hit the query ,api takes some time to refresh or something as I have traced the loop and boardId its working fine but result is same for all

Hi devs, is this policy correct? https://developer.monday.com/apps/changelog/clarification-on-retry-policies-for-webhooks-and-custom-actions As far as I can see in our tests, when a non-200 HTTP status is returned, monday retries every 30 secs for 10 times, then stops.

Hi all, I am trying to get column IDs on GAS (google apps script) with the code below. But I am getting an error with below. Could you please help me out? Thank you! function getBoardDataClicked() { // This function is run when the “Get Board Data” button is clicked const boardId = getBoardId() // Get board-specific group data from Monday.com and set it to sheet: const boardName = getAndSetData(boardId, ‘groups’, ‘A6’) // Get board-specific column data from Monday.com and set it to sheet: getAndSetData(boardId, ‘columns’, ‘D6’) // Set board name to sheet: setboardName(boardName) // Redetermine column widths: autoResizeColumns() } function getAndSetData(boardId, type, startCellAddress) { // This function gets board-specific data from Monday.com and set it to sheet. // The type of the retrieved data is specified by the “type” parameter. // “startCellAddress” determines the location in which the data is to be pasted on the sheet. // Make HTTP request: const resData = getData(boardId, ty

Hi, How to know if user is a viewer on board/dashboard view (client side- react) when app is loading? Basically I would like to display a proper “missing permissions” message instead of the app display, in case it’s a viewer. Code sample will be great. Thanks Roi

I wondering there is how to delete workspace using Monday developer’s API’s.

I’m striving to retrieve the corresponding boardId of a mirrored column when multiple boards and items are connected. The query I use is: { boards(ids: 3184598220) { columns { id title type settings_str } items(ids: 3184598225) { created_at email group { id title } parent_item { id } subitems { id } column_values { id type text value additional_info } } } } I know I need to cycle multiple times thru board.columns and board.items.column_values properties. { "data": { "boards": [ { "columns": [ { "id": "name", "title": "Name", "type": "name", "settings_str": "{}" }, { "id": "person", "title": "Person", "type": "multiple-person", "settings_str": "{}" },

We have tried creating subitem for item which has more than 350 files , not able to create sub item for it , is there any limitation to create sub item? We are getting response as null, please advice if this is expected reposne { “data”: { “create_subitem”: null }, “account_id”: 11771408 }

It may be that I’m misusing this method, but it seems as though monday.set('settings', params) doesn’t behave as it should. No matter the value I pass in, the settings remain the same. I’d expect it to update one or more settings based on what I pass in as an argument, but that’s not the case. Would anyone happen to know if this method is broken, or if I’m just not using it correctly? This is the method I’m referring to and I’ve added some screenshots that will hopefully provide additional clarity.

Hi, I want to create app that would change the background of the text editor used to send email on the CRM. But, the app is inside an iframe, and I can’t manage to edit the CSS. I tried all the types of applications. How can I do it? wanted css added: .ql-editor{ background-color: red; } example source code: take monday example: welcome-apps/apps/quickstart-react/src at master · mondaycom/welcome-apps · GitHub replace only index.js with: import React from "react"; import {createRoot} from "react-dom/client"; import "./index.css"; import App from "./App"; import * as serviceWorker from "./serviceWorker"; const root = createRoot(document.getElementById("root")); root.render(<App />); document.addEventListener('DOMContentLoaded', (event) => { const collection = document.getElementsByClassName(".ql-editor"); for (let i = 0; i < collection.length; i++) { collection[i].style.backgroundColor = "red"; }; }); // If you want your app to work offline and load fa

it would be nice to have the column type listed with the column ID in developer mode in the column heading menu. I know right now we can go to “change column type” to see the column type but not all column types show this menu item. Plus its another click. The value from board.column.type would be preferred.

Does anybody have an hosted javascript example of some simple code for developing a custom action along with the appropriate definitions of the feature?

I understand that the administrator functionality has the ability to download data from all workspaces in the form of a zip file. There is a task that requires periodic backups of data from all workspaces on-premises, and it is cumbersome to go into the administrator’s account and download the data every time. If the function exists as an API, I think the efficiency of the work can be increased a lot, so I wonder if the function exists as an API. If this function does not exist as an API, I would like to ask if there is a way to solve the above task with an API. (After checking the API, there is an indicator called Complexity, and if this indicator exceeds 5000000, data cannot be imported. I am asking because I think the complexity will be very high to import data from all workspaces.)

What does “Visualization type= milestone” specifies ? How to differentiate between planned and actual timelines?? When I try to run below query,I got values for timeline as a single field ,not as two different fields? {boards(ids: 1123282008) { items { id subitems { id } column_values { id value } }}} How to pull these fields?