General

Hi, I have some issues when trying the GraphQL in monday.com Board A - 1877686330 Board B - 2519762415 (duplicate board of Board A) Issue 1: The items in both boards are the same, but the result doesn’t return any items for Board B if I change the board_id (I have checked the column_ids, they are still the same): query { items_by_multiple_column_values (board_id: 1877686330, column_id: "statut77", column_values: ["OUI"]) { id name column_values(ids: ["statut77","personnes8","demandeur4"]) { id text additional_info } } } Result: Board A Board B Issue 2: The filtering doesn’t seem to work: The items with status “A VALIDER” and “A CORRIGER” are returned in the list although the query is filtered by “OUI” When I filtered by “A VALIDER” and “A CORRIGER”, the result return nothing: Can you guys please help to check what is wrong here? Thanks! Br, YarHuoy

hi all i’m trying to create an new item with column value MONDAY_APIKEY = os.getenv("MONDAY_APIKEY") MONDAY_BASE_URI = "https://api.monday.com/v2" MONDAY_HEADERS = {"Authorization": MONDAY_APIKEY} vars = '''{ boardId: 00000000000, itemName: "new item from python", columnValues: {"numbers": {"value": "22222"}} }''' query = f'''mutation ($boardId: Int!, $itemName: String!, $columnValues: JSON!) {{create_item(board_id: $boardId, item_name: $itemName, column_values: $columnValues) {{id}}}}''' query_to_run = {'query': query, 'variables': vars} r = requests.post(url=MONDAY_BASE_URI, json=query_to_run, headers=MONDAY_HEADERS) response = r.json() “numbers” - it’s a column ID getting: <Response [500]> no any other error description advice please

Hi monday.com community! 😄 We are very excited to share a (soon to be live) app for the monday.com marketplace which is the solution to track your time across all boards. Our app is called Tracket, a flexible time-tracking solution for monday.com. You can easily log hours on existing items and subitems. You can log hours with multiple people on the same item. Learn more about this app and get a sneak preview(👀 ) via: Tracket - Makes Time Work The first customers are already using the app. Do you want to onboard as well? Get in touch and we will give you early access to the app’s current functionality. We hope you are just as excited as we are! 🙌 👋 The Avisi Apps Team

Since yesterday I’m trying to upload a new build for a Feature (Item view) but monday just show the message : “New app feature build upload failed”… In the console the message show is: “Failed to load resource: the server responded with a status of 400 ()”

I have a board that lists all our projects going back to 2003 or so. It started its life in Excel. The first column in Excel was job # and the second was job name. That made more sense in Excel than it does in Monday. I’m thinking that it would be preferable to merge the two, but I’m not sure how. It currently looks like this: I’d prefer it to look like this: (ignore the project name) Something like [[CONCAT Proj#, " - ", ProjName]] would be easy enough, but how can I get that resulting value to overwrite the project number, which is Monday’s index column (or whatever they call it)? Thanks!

Seamless Authentication seems to be handled automatically with the SDK, but the SDK is for JS only. If I was developing an app in some other language that doesn’t have the SDK, can I still make use of seamless integration? Do I just have to check the value of the “short-lived API key”? How would I know what value it’s supposed to have? EDIT: A possible answer to my question just occurred to me, but I want to ask if this is correct: Typically, to allow our app to make GraphQL API calls to Monday, we go to Settings>App and then copy the account API key and then present that key when we make an API call. With seamless authentication, do we present the “short-lived token” instead of the API key when making a GraphQL API call to Monday? This token acts as a replacement to the API key that we would copy from the Settings?

Hi, I’m facing an issue with this mutation: mutation saveUpdate ($item_ids:Int, $body: String){ create_update (item_id: $item_ids, body: $body) { id text_body body created_at } } And the answer I’m getting is: { "errors": [ { "message": "An operation name is required" } ], "account_id": XXXXXX } What am I doing wrong? Thanks Carlos

Hello, Is it possible using the monday API to add boards into a dashboard like the webapp (image). I see nothing about dashboards in the api doc. Thanks.

So I believe multi-operation documents are a thing in GraphQL, i.e. you can select one using an operation name. When I do this I get an error response: “An operation name is required”; but I supplied the operation name. So in the developer’s playground I created a document with 2 queries: query SingleBoard { boards(limit:1) { name columns { title id type } groups { title id } items { name group { id } column_values { id value text } } } } query AllBoards { boards(limit:10) { name } } Sure enough, even though I have a drop-down under the play button in the developer’s playground that allows me to select which query I want, I get “An operation name is required” error regardless of which query I pick. Is this a limitation of the Monday API?

I cannot find a way to edit multiple-person using API. I used both ways to mutate record (IDs and JSON) from documentation: https://api.developer.monday.com/docs/people without success. New records work fine, people value is added. Can someone help me?

I am trying to get all users from monday using the API v2. This query below displays all users with the details specified on the query: query { users{ id name email } } So now I’m trying the below request from a python script: headers = {"Authorization" : config['api_key']} apiUrl = "https://api.monday.com/v2" query = {"query": "users { id email }"} res = r.post(url=apiUrl, json=query, headers=headers) res_data = res.json() I ma getting the following error: {'errors': [{'message': 'Parse error on "users" (IDENTIFIER) at [1, 1]', 'locations': [{'line': 1, 'column': 1}]}], 'account_id': 9415663} Please help, what am I doing wrong?

I’m having trouble at the first step. This library needs the schema available at compile time. I downloaded the schema and saved it to disk, it starts: { "account_id": 6188811, "data": { "__schema": { "directives": [ … When I try to compile my project, it rejects the schema: error: Failed to generate GraphQLQuery impl: Parser error: schema parse error: Parse error at 1:1 Unexpected `{[Punctuator]` Expected `schema`, `extend`, `scalar`, `type`, `interface`, `union`, `enum`, `input` or `directive` It looks like graphql_client is rejecting the schema right from the first {, so I’m wondering if anyone else has successfully accessed Monday from rust code.

Normally to calculate a weekending date I would use the formula as follows: Friday = Daynum 6 of the week Today() + 6 – WeekDayNum( Today() ) If today = Tuesday 04.05.2022 Today() + 6 = 04.11.2022 WeekDayNum( Today() ) = 3 04.11.2022 – 3 = 04.08.2022 Is there a way to calculate this in Monday now? I can’t find a WeekDayNum function.

On Monday dashboard, we can clearly see values in CM Column but we are getting null value in API. Link: https://northern-accountants.monday.com/boards/1831612862/ We are using below GraphQL query to fetch data: { to_be_start : boards(ids: 1831612862) { groups(ids: "new_group81176") { ...boardFields } } } fragment boardFields on Group { items { column_values(ids: ["mirror26"]) { text } } } Same issue exists with “formula_1” column in below link. Link: https://northern-accountants.monday.com/boards/632285673 We are using below GraphQL query to fetch data: { iyep_awaiting_further_client_info : boards(ids: 1831612862) { groups(ids: "new_group1835") { ...boardFields } } } fragment boardFields on Group { items { column_values(ids: ["date7","formula_1"]) { text } } }

Hi, May you please assist, I have aboard where I am able to create Items using the API and python, I am now at a stage where I want to assign an Item to a user so that through permissions a user can only see Items assigned to them, How can I achieve that through the API?

Hello, I am having an issue where I cannot select any board data to test my monday.com item view app with in the widget preview. When trying to select an item, I can see the available boards and select one, but then no items are found on the board. When I try to search for an item that I know exists, I get no results found with the option to create a new item, When I try to create a new item, I get infinite loading, not really sure what is wrong here, but was hoping someone could help me out. Note: I am owner on the boards I attempted this with.

I’m running a query that pulls an entire board which contains about 400 items and 80 columns. i’m using a pretty blunt query: query2 = ‘{boards(ids:###) { name items { name group{title} created_at column_values{ title text } } } }’ It takes about 20 seconds for this to run, which is surprising given that this is just tabular text data. Is this normal latency? I would expect a much faster response on this (maybe 1s). I’ve seen a few (unaddressed) threads about performance of the API - is this an ongoing issue? Thank you

Hey all. I’ve been playing with the Monday API and have made a lot of progress towards getting it ready to be available in our system and a couple of other tools we use, however, I’ve hit a bit of a snag when it comes to adding files. I’ve been able to do everything else from adding items, updates, columns, boards and reading what I’ve needed, but adding files is what has finally broken me. I’m basing my code off of Uploading a file to monday.com, the hard way. The author is using NodeJS so I’ve tried to convert it as best I can. My code below: <cfset dataQuery = 'mutation($file:File!){add_file_to_column(file:$file,item_id:123456789,column_ID:"files"){id}}'> <cfset boundary = "xxxxxxxxxx"> <cfset upfile = "image1.png"> <cfset base64Sample = SAMPLE_BASE64_STRING> <cfset data = ""> <!--- Construct Query ---> <cfset data &= "--" & boundary & ""> <cfset data &= 'Content-Disposition: form-data; name="query";'> <cfset data

Hi all, please help if you can When making an API request call, we seem to have random data points not being brought through. If it was a whole row or column, we could try to find some sort of rule, but this is purely random. The boards in question are slightly complex in that they use Connected Columns, but I don’t see why that would be an issue. We’ve tried exporting the boards manually to Excel using the UI, and we are still missing some data points, not as many as with the API call, but still some. Is there anybody else who has experienced this or knows how to fix it? Best regards,

I have successfully built an app running on my local machine and using the loca.it tunnel. How do I now deploy this on to AWS as a Lamda function or Heroku etc?

Hi, Is there any way to search for items between range of dates while I have one date column in the board? Quite urgent 🙂 Many Thanks,

In the API Playground I can change a text column value for an item using: mutation{change_simple_column_value (board_id: XXXXXXXXXX, item_id: YYYYYYYYYY, column_id: "text", value: "NEW" ){id}} But when I replace the item_id with the id of a subitem I get: { "error_code": "ResourceNotFoundException", "status_code": 404, "error_message": "Item not found in board", "error_data": { "resource_type": "item", ... "error_reason": null } } I can’t find any reference to changing subitem values in the documentation, only (parent) item values. Do I need to pass a parent_id as well or…?

Hello, I started to learn how your API works and everything was fine until I tried to create a new column in a board. I quite litterally copy / pasted the code I found in the doc, put my board ID and my API Key. changed nothing else just to see if it was working but I got this message : “message”: “Parse error on "create_column" (IDENTIFIER) at [1, 1]” here is my code : let query = "create_column(board_id: "+boardID+", title:\\"Work Status\\", description:\\"This is my work status column\\", column_type:text){id}}" fetch ("https://api.monday.com/v2", { method: 'post', headers: { 'Content-Type': 'application/json', 'Authorization' : apikey }, body: JSON.stringify({ 'query' : query }) }) .then(res => res.json()) .then(res => console.log(JSON.stringify(res, null, 2))); } Do you know why this occurs ? Thank you and have a nice day 🙂

Is there any way to create user (person) using GraphQL? Currently I see only read-only query: https://api.developer.monday.com/docs/users-queries-1 Also, here https://api.developer.monday.com/docs/people is noted that I should use ID to set person to item value. So, how should I populate new users with name/email? Thanks for help.

Hello, when creating custom actions it looks like only the only option is for a POST request/webhook to be sent somewhere. Is it possible to instead have it trigger something in a custom app? Example… I have a board with items. I have a button field on this board. I have a custom app with an item view added for this board. When I click the button, open our app’s item view and send a message to it (ideally the same thing you’d send via the webhook) Then we can handle the message and do whatever we need to in the app. Is this possible or are webhooks the only way to work with custom actions currently? Thank you!