API & Apps framework

Only the item name appears in Monday. The columns are empty. I tried removing the label and text - same result. Code: import requests import json apiKey = "HIDDEN" apiUrl = "https://api.monday.com/v2" headers = {"Authorization": apiKey} query5 = "mutation ($myItemName: String!, $columnVals: JSON!) { create_item (board_id:HIDDEN, item_name:$myItemName, column_values:$columnVals) { id } }" vars = {"myItemName": "Hello everyone!","columnVals": json.dumps({"link": {"link": "www.google.com"}, "people1": {"multiple-person": "Jane"}}),} data = {"query": query5, "variables": vars} r = requests.post(url=apiUrl, json=data, headers=headers) # make request print(r.json()) The ids of the columns are correct. I checked. What am I doing wrongly here? Thank you.

I have 2 accounts. 1 account is the ‘team lead’ and has access to the APIv2 My second account which acts as a ‘team member’ (and registered as a developer) is unable to access the api_v2. Im using the SDK v0.1.1. The error is thrown both in the app widget (via the SDK) and in the API playground. Any ideas? All OAUTH settings are enabled.

Code (PyThon) - variable for query looks like this vars = {"myItemName": "testing","columnVals": json.dumps({"link": {"url":"wwww.google.com","text":"google.com"},"people1":"14123922,12472244","timeline":"2020-11-19-2020-11-29"}),} timeline is of type “timerange”. What am I doing wrong here?

I don’t see it documented in the API, but it is definitely possible… how do you create a read-only column? i see in the Todoist integration, they create a column that’s read-only. does anybody know how to do this?

Creating an item is not an issue. Adding column items (Status and Assignee) results in errors namely: {"errors":[{"message":"Parse error on \\":\\" (STRING) at [3, 11]","locations":[{"line":3,"column":11}]}],"account_id":1157581} The code: $token = 'TOKEN HIDDEN - PUBLIC FORUM'; $apiUrl = 'https://api.monday.com/v2'; $headers = ['Content-Type: application/json', 'Authorization: ' . $token]; $query = 'mutation ($myItemName: String!) { create_item (board_id:564704604, item_name:$myItemName, column_values: "{ "Status":"done", "Assignee":"Jon.Doe@gmail.com" }" $data = @file_get_contents($apiUrl, false, stream_context_create([ 'http' => [ 'method' => 'POST', 'header' => $headers, 'content' => json_encode(['query' => $query, 'variables' => $vars]), ] ])); $responseContent = json_decode($data, true); echo json_encode($responseContent); The error seems to be in the way I add the Columns. I have seen other posts mentioning adding slashes - others mention using a c

Can we get a free temporary premium account for the duration of the devpost hackathon?

Hello fellow developers 👋 I’ve started to play with the APIs for building an app and noticed there’s no implementation of Monday’s UI components. 🙃 for those of you who care for the look and feel of your app, I’ve started an open-source repo for implementing all of the design guidelines as stated here , hoping to implement a minimal set of UI components to build an app which will look native. how can you help? I’d be more than happy for pull requests and help with expanding or maintaining the repo. If anyone from Monday’s dev team is reading this and would like to give a hand, that’d be awesome too! links Github Repo : https://github.com/kaminskypavel/monday-ui-components StoryBook : Link Progress board : Link

Hi, I unable to upload my build since last night, I keep getting unknown error, may I know why?

Hi all, I noticed that the error format thrown by the API has been changed. My code used to check response.errors[0].message but I do see a different error format now { “error_code”: “CreateBoardException”, “status_code”: 400, “error_message”: “Failed to create board from predefined template”, “error_data”: {} } Is this really changed? Did I miss any announcement? Shouldn’t app developers made aware of such important change? OR are there different error formats for queries and mutations?

Hi there, I am storing data from all customers in the same database (multitenant) and thus I need to segregate this data so that one account can’t see data from another. Currently, I am using the client_id for that. However, when installing the app in different Monday accounts, I realised that the client_id that I get from the Monday token is always the same! This is the information I can get from the token: "dat": { "client_id": "123456daef7553456d62345aa37", "user_id": 123456, "account_id": 123456, "slug": "my-monday-subdomain", "app_id": 123456, "install_id": 123456 } Then, the question: should I be using a different id (maybe the account_id) to segregate data in the database correctly between different Monday instances? Thank you.

How do I enable developer mode to view template ids? The docs show I need to enable monday.labs, but I can’t that in my menu. Thank you.

Hi, How can I retrieve the following information using graphQL?

Hi, I am trying to set a column value which has the type Numbers to the value if 0 using API but it keeps resulting in a blank column instead of the numeric value of 0 for some reason. Is it possible to do this? My mutation is using a JSON format for the data. All numbers are okay except from the number 0. If it helps, this is what I’ve been using: https://community.monday.com/t/change-column-value-with-php-variable/12587 Regards

I am trying to update a column value within my Monday.com table using the below code but I am getting the following error: Variable $myvariable is used by but not declared $query = 'mutation { change_simple_column_value (board_id: [BOARD_ID], item_id: [ITEM_ID], column_id: "sold___deposit_paid", value: $myvariable) { id } }'; It works if I put a value in place of the variable though. Why is this happening?

I am new to GraphQL. Does anyone know how to set up queries (or have any examples) using visual studio VB.net.

hi, I want to upload the file to the comment from API. but I am getting an Internal server error. below is my mution code and screen shot. I have even tried forgist.github.com still getting the “internal server error”. also can’t understand what is “var boundary = “xxxxxxxxxx”;” need your help… thanks in advance mutation ($file: File!) { add_file_to_update (update_id: 808129739, file: $file) { id } } Please see the image.

When using the items_by_column_values to return a set of pulses the state on each item does not match the state of the item within the board. To reproduce create new board add item archive item query board using items_by_column_values see archived item has state = “active” { items_by_column_values(board_id: x column_id: "text", column_value: "X") { id name, state } }

If you’ve ever tried to GET the values of a status column or PUT new values in, you’ve probably noticed that a number value is used to identify the different status labels. We’ve made this quick key to help you map those numbers to the corresponding label colors in your account: Edited July 2020- Alex: The link below will provide the new updated Status column colors by index, including the 10 new colors added recently: https://view.monday.com/471878000-13f8e67ced7f0463687b9694f8044fac

Hi All, I am having some trouble getting the ‘Updates’ data I am after. API v1 I am able to use this endpoint - “https://api.monday.com:443/v1/updates.json?api_key=<API_TOKEN>” to return Update data that includes, amongst other fields, ‘update_id’, ‘pulse_id’, ‘pulse_name’, ‘created_at’, ‘body_text’, ‘posted_by’, and ‘replies’. API v2 I believe I need to use the following query - query { updates ( limit: 100 ) { body id } } - but I can not figure out how to set up this query to return all of the data that API v1 returns. Any help on this would be appreciated I am fairly new to the API v2 so I may be missing something obvious! It would also be good to understand how long Monday.com are planning on maintaining the API v1! Thanks, James

Hi, guys! I’m trying to get the items created in the last 30 days of a specific board by calling Monday API in Google Sheets using Google Apps Script. The code to call the API and parse JSON is not a problem. I’ve done that before and it was successful. The problem is filtering the data by a date range. What I’ve already tried: I’ve used items_by_column_values and that would work perfectly if the argument column_value accepted a time period in GraphQL. But sadly it only accepts one value. I’ve tried this query: query { boards (ids: 157244624) { items(limit: 1000, newest_first: true) { name } } } That’d work because I’d get the newest items of a specific board. But I saw in a post that the argument newest_first in items doesn’t work when nested in boards 😕 I saw in another post that I could add a date range in my end (Google Apps Script) , but I don’t know how to do that. Can anybody help me with sample code in Javascript / Google Apps Script or a link where I can study t

Hi, Trying unsuccessfully to upload a file to an existing column following the API docs, but I receive a Bad Request error without too much information regarding what is bad. I’m working with Python, first I generate a request data: req_data = “”“mutation{ add_file_to_column(item_id: %s, column_id: “%s”, $file: “%s”) { id } }”“” % (item_id, column_id, self.to_base_64(fpath)) The file path is opened and then converted to a base64 string, this is the final request: mutation { add_file_to_column( item_id: 724825528 column_id: “Files” $file: “LHByb2plY3RfbmFtZSxncm91cAowLGJhdHJ1LAoxLGJpc2Vhc2ssCjIsY2JjZGFpcnlpbCwKMyxjY2JvdHRsZXJzdXMsCjQsY2Nici1wcm9kLAo1LGNjbGliZXJ0eXVzLAo2LGNjdHJhZG14LAo3LGRpYWdlb2FyLAo4LGRpYWdlb2JlbmVsdXgsCjksZGlhZ2VvaW4sCjEwLGRpYWdlb2l0LAoxMSxkaWFnZW9rZSwKMTIsZGlhZ2VvbXgsCjEzLGRpYWdlb25nLAoxNCxkaWFnZW9ub3JkaWNzLAoxNSxkaWFnZW9ydSwKMTYsZ3NrbnosCjE3LGluYmV2Y2ksCjE4LGluYmV2bmwsCjE5LGluYmV2dHJhZG14LAoyMCxtb25kZWxlemRtaXVzLAoyMSxuZXN0bGVpbCwKMjIscG5nanAsCjIzLHJpbmllbHNlbnVz

Hi, Is it possible to return meaningful person data via a query? I’m new to monday and may be attempting to handle this in the wrong manner. In a simple query the data brought back as part of the payload within column_values is something like the following: “{”“personsAndTeams”“:[{”“id”“:16491444,”“kind”“:”“person”“}],”“changed_at”“:”“2020-10-06T15:04:20.130Z”“}” This is not much good in my use-case which is reporting: I want a name or email address rather than an id. Is it possible to write the query such that it returns a more useful value, or can this id be used in an additional query to return either the specific user in each case, or a list of users that could then be ‘matched’ using the id as a key?

Hi Just wondering if there’s an API for duplicating / cloning an Item? Like we can do from the UI I can’t seem to find any reference in the API

Is there any demand for full duplication of a board using the V2 API? I would like to create boards (out of templates) from my Wordpress site and then assign users and guests to the newly created boards. Any ideas?

Hello All, I am using this small code in M query (power BI) to extract data out of monday board. But when i try to schedule a refresh in power BI platform it says “not authenticated”. Can any one help me to find a way to add authentication in the code or how can i login to this https://api.monday.com/v2 so that power BI can authenticate itself. Any help will be appreciated. here is the code. let Key = “api token”, Board = “board id”, Source = Web.Contents( “https://api.monday.com/v2”, [ Headers=[ #“Method”=“POST”, #“Content-Type”=“application/json”, #“Authorization”=“Bearer " & Key ], Content=Text.ToBinary(”{““query””: ““query { boards(ids: " & Board & “) { items { name, columns: column_values { title, text } } } }””}”) ] ), //Line 19 converts the data inside “data → board-> items” to a table with the column names “Title”, “Updated At”, “Group”, “Columns” Data = Table.FromList(Json.Document(Source)[data][boards]{0}[items], Record.FieldValues, {“Title”, “Columns”}), #“Ex