API & Apps framework

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:

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”: [

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-s

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",

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.addE

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?

I had a look at the Multiple Accounts section here but I couldn’t find info on this. Here is the scenario: -Say we have an app called app1. -User X is part of foo.monday.com. They authorize app1. They’re able to make API calls and get the info they need. -User X is now added to another account/subdomain: bar.monday.com. They authorize app1 in this new instance. A couple of questions: Question is: will the new access token generated after authorizing app1 be valid for API calls done on bar.monday.com only? OR will the new access token be valid for both

Hi All, Im new in this world and i need to : From one board, extract a initial load. Then, in a daily load, i need to get the updated or new records from last load using update and create date field . I was reading a lot of post about it, but i didnt get the solution yet. Any clue about it? Regards

I am creating a custom field type in my integration that derives values from a remote options url. The payload for the remote options field looks like this { recipeId: 30019598123, integrationId: 72966189123, automationId: 72966189123, pageRequestData: {}, dependencyData: null } . This is insufficient for my use case as my application need to know which user has triggered the custom field. I have tried to use the dependencies but that seems to require a manual user input. Is it possible to automatically add a userId value to the payload that is sent to the remote options url?

Hi Team, We are accessing Monday API to send data from Custom POC application to Monday.com board. We are able to pass item name value via our code through API call Running Code: let query3 = ‘mutation{ create_item(board_id: 3106812303, item_name: “new item”) { id }}’; fetch(“https://api.monday.com/v2”, { method: ‘post’, headers: { ‘Content-Type’: ‘application/json’, ‘Authorization’: ‘YOUR_TOKEN’ }, body: JSON.stringify({ ‘query’: query3 }) }) .then(res => res.json()) .then(res => console.log(JSON.stringify(res, null, 2))); but when we try to rest information of the board along with item name, it generates error. Not Running Code: let query3 = ‘mutation{ create_item(board_id: 3106812303, item_name: “new item”, column_values: “{“text”:“ready 3”}”) { id }}’;

Hi Team, we are trying to create item with column values in Monday.com board from C# code but item is not created please suggest where we are missing string columnvalue = “ready 5”; string query = @“{ ““query””: ““mutation {create_item(board_id: 3133804748,item_name: new item test10, column_values:"”{\\"“text\\"”:\\"”” + columnvalue + @“\\"”}"“) { id} }”" }"; string MondayApiKey = “Token”; string MondayApiUrl = “https://api.monday.com/v2/”; byte dataBytes = System.Text.Encoding.UTF8.GetBytes(query); HttpWebRequest request = (HttpWebRequest)WebRequest.Create(MondayApiUrl); request.ContentType = "application/json"; request.Method = "POST"; request.Headers.Add("Authorization", MondayApiKey); using (Stream requestBody = request.GetRequestStream(

Hi all, I would like to be able to dynamically generate a link to an external website, probably within a monday board, that would contain (whether it would be sent thru get or post) session information such as the monday user id and account id of the logged in user, so when the user clicked the link, the external website would receive that information and be able to pre-fill a form on the external website with their monday user id and account id. Of course the link itself would be different for each user, as each user has a different id. I’m imagining something like a button that a user could press on their board that would take them to the website in question, or even a url link which could be custom-generated for each user that they could click on somewhere in their board. Is such a thing possible? Can anyone point me in a direction of how to do this, or at least how to grab a logged-in user’s session information to use in a different site? Than

Hi , i am trying to Calling items_by_column_values via C# but its giving error but its running in API playground : query { items_by_column_values (board_id: 3216756962, column_id: “text6”, column_value: “db255f1d-c3e6-43ee-8a96-921c5256eda3”) { id name } } and my C# string is : {“query”: "items_by_column_values(board_id: 3216756962,column_id: "text6",column_value: "db255f1d-c3e6-43ee-8a96-921c5256eda3") {id} " } and my code is as below : public async Task QueryMondayApiV2() { string projectCode = “text6”; string rowguid = “db255f1d-c3e6-43ee-8a96-921c5256eda3”; //var query = @"{""query"": ""mutation {create_item(board_id: 3136520113,item_name: \\""" + projectCode + @"\\"",column_values:\\""{\\\\\\""text\\\\\\"":\\\\\\""" + projectName + @"\\\\\\"",\\\\\\""text_14\\\\\\"":\\\\\\""" + Projectdescription + @"\\\\\\""}\\"") {id} }"" }"; var query = @"{""query"": ""items_by_column_values(board_id: 3216756962,