General

I need to pull data from a group in my board. The condition is that I have to filter items in this group by a specific item column value. I could figure out how to get all items belonging to a group on a board using this query: {boards (ids:BOARD_ID_HERE) { groups (ids: GROUP_ID_HERE) {items (limit:2) { name created_at column_values{id title text} }}}} What would be the query for filtering the group items based on a column value?

I have noticed a couple of issues that may or may not be related. Issue 1: I have created a custom integration using the API to create items in Monday whenever a contract signed event webhook is fired from our proposal software. Most of the time it works fine. Occasionally though, the item will have blank entries in a few columns despite the API call returning a success code without an error message. To make it even more confusing, the activity log in Monday shows that the value was entered into the column, and no action appears after to indicate that it has been deleted or rolled back. To me this means there is either a bug that is preventing the item from displaying correctly, or the column value is being deleted without record of this happening in the activity log (undocumented roll back). If it is a roll back, this is a huge problem, because whatever is triggering the roll back is seemingly random, and is not consistent with any valid reason for rolling back an update (ie

We have a live app for monday.com and we are working on new version of this app. We need user to do Oauth to provide us with token for extra features(this is in draft). We never had Oauth before and in draft version was working fine with which ever url we provided in redirect uri I know of this caveat but it was not this issue because we never had Oauth or redirect uri Invalid redirect_uri error Now what happened recently is the auth stopped working always giving us Invalid redirect uri error. Then I added app_version_id to auth url and it worked. Questions: - Is this intended behaviour? When was this implemented? What do I need to make or change url for auth when we go live with this version does it include version id or not? this is very high priority please we are scheduled to launc

Hello, I’ve been able to modify a query to create a record and put in all the values. The issue is the filter has the text not showing. Is there a way to modify the Text of the column? This is an integration field with Pipedrive. "id": "pipedrive_deal", "title": "Pipedrive Deal", "value": "\\"1\\"", "text": "" My query to create the record: #mutation{create_item(board_id:####, item_name:“Test”, column_values:“{"text00":"Test Name", "text1":"IN", "pipedrive_deal":"1", "text7":"test", "pipeline":"Clients", "numbers":"1", "hours7":"Full-Time", "text3":"Practice", "text60":"null", "text0":"Undocumented", "Date4":"2017-09-03", "text9":"2017-09-03"}”) {id}}

Hey there! I was wondering if it is possible to list all of the installed apps on my workspace via GraphQL. Also, if it possible to query which apps are installed for each user.

Hi, A client of mine that’s using Monday is asking if I can create a custom app that opens a dialog to allow the user to enter some extra information before going through a recipe/integration. None of the App features in the documentation seem like they would cleanly fit the purpose. What’s a good starting point for doing this?

Hello, We are new to Monday.com and this is my first post. I am curious to know if anyone tackled integration between Replicon and Monday.com and willing to share the knowledge. Thanks!

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

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.

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’

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

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 ---&g