General

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

Good morning Monday.com Community! We at Trix Solutions are pleased to announce the official release of Moncli v1! We had a lot of good feedback with our initial beta release. We have also incorporated new features developed by the great developers at Monday.com including: Uploading files to items and updates Creating subitems Duplicating items Updating item link columns Clearing updates from items Adding replies to updates Creating workspaces Accessing board views and activity logs You can find our code and documentation on our Github repository here. We greatly look forward to your feedback. Happy coding! - Andrew (Trix Solutions)

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?

Status Controlled Groups moves an item in a given group to another group on status change. The move will only take place if the item lives within the group specified. With this you can easily transform your groups to process or project stages. Every time the user changes the status to e.g. Done the item is advanced to the next group (stage) and the status is reset to e.g. Assigned. With an advanced recipe you can even specify that the owner should be changed when advancing through your groups. For example: an item containing a document starts in the group Bronze. When the author (=owner) set the status to Finalized the item is moved to group “Review 1”, the status is reset to Assigned and the people listed as Reviewers are now becoming the owners of the item. The board permissions are set so that only Owners can make changes to the item. When the reviewers set the status to Finalized the item advances to the group “Silver” and the ownership is transferred back to the Author(s). From t

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

Hello everyone, I was trying to create a new Monday integration to my app and I had some issues after I finished with the OAuth process (my integration doesn’t need the user to enter any particular board_Id on any other data I get access to it from the token). As I confirmed my integration I was getting this error on this particular request ( when I pressed on the “Add to board” button), I hope you guys could help me out, Thanks a-lot!

General Caster General Caster includes a collection of automation recipes aimed at performing enhanced calculations in monday.com without using a formula column . Complete documentation is available here. From Timeline to Timeline Formula Given {item.timeline} your first Timeline column placeholder, use the following formula: CONCATENATE(FORMAT_DATE(ADD_DAYS(LEFT({item.timeline}, 10), 7), "YYYY-MM-DD"), ";", FORMAT_DATE (ADD_DAYS(RIGHT({item.timeline}, 10), 7), "YYYY-MM-DD")) to update your second Timeline column with a range shifted by 7 days from first Timeline.