General

We are trying to retrieve items and subitems with hierarchy and it is failing with query complexity issue. The query is as below: { boards(ids: xxxx) { id name groups(ids: xxxx) { id title items(ids: xxxx) { id name subitems(ids: xxxx) { id name } } } } } Getting below error: { “errors”: [ { “message”: “Query has complexity of 2001200120022, which exceeds max complexity of 5000000” } ], “account_id”: 11771408 } Currently the instance is having sample data with less than 100 items including all the workspaces. How we can avoid the issue with query complexity to retrieve the same data as above. Regards, Prashanth

I am developing a board view using react and I have used the quickstart react js code. I am unable to get the current user logged in userId. With this query : - query { me { id, name } } Every time it is giving me the same result (User who has generated the authentication token and configured the app) Note : - The app is yet to published. @dipro @basdebruin Please help.

Hi there 👋, I’m happy to share our second App ( Field service requests and proof of presence), which was among the winners of the Apps Challenge. This App offers a solution to manage and automate on demand services. It offers 2 features: A GPS proof of presence system , in order to validate that the person in charge went effectively on site to carry out the mission. An IoT solution , which automatically fills out a service request when a user presses a button of a Smilio device. We made a detailed documentation and presentation here: https://www.skiply.eu/en/monday-com-app-field-service-proof-of-presence-gps/ Any feedback appreciated!

I have a fairly simple problem that I can’t find the right combination for graphQL. I have a board that I query data from. One of the columns of the board are people, but they give me their name instead of a userId. How am I supposed to get their user information so that I can get their profile pictures to display in an avatar? Thanks, Jeremy

Hello, I have several supplier accesses (guest) to create on the same board, but I don’t want them to be able to see their name or email address. Is it possible to hide other users from them? Thanks, Jean

I am using Python to create bulk entries in a board to track required trainings. I would like to add information and a URL to the training as the first comment for the item. Can I do this in the initial mutation? Or do I need to capture the item ID and add the comment in another loop? Thanks Bruce — Current script, no adding an update ---- trainingTitle = ‘Do this activity’ trainingDueDate = ‘2022-07-31’ teamsID = ### # Workflow Practice Team teamsID = ### # Python Test Team ‘’’ Script begins ‘’’ updates_query = ‘{teams (ids:’ + str(teamsID) +‘) {users {id }}}’ data = {‘query’: updates_query} response = requests.post(url=apiUrl, json=data, headers=headers) # make request allData = response.json() Traverse the JSON file boardLevelData = allData[‘data’] teamLevelData = boardLevelData[‘teams’] Loop to navigate through the list for allItems in teamLevelData: singleItem = allItems[‘users’] count = 0 # Loop for individual item detail for userDetail in singleItem: userID = userDetail[‘

Hi. I’m looking for a query that can return me among the other fields of an item also the owner, the person to whom the task was assigned. Can you help me?

Can we extract all the data from monday.com of workspace? by providing workspace id?..I wanted to fetch all the data from Monday.com how should I proceed with that

Hey, On my main board I’ve got an automation set up which says, when team member is assigned, then add a new item to the team members board. This happens, and it copies the project name over - then I have an automation on the team members board which says “when an item is created in this board, connect the item where NAME matches NAME in customers projects by overwriting new matches” It works fine with main projects but it cannot link to the sub items. I’ve attempted to create a link on the projects board which links to the sub items but its still not working - so I’m thinking is there another way? I need it so that if 2 or 3 people are working on it then it will mirror the status fields etc - meaning when one person changes the status , the other people see the updates.

I use the graph try-it-yourself and the item in the board is create without the columns values, no error too This is my request, the name of the field is in Hebrew mutation { create_item (board_id:2741432713, item_name:“test02”, column_values: “{"שם סעיף תקציב":"שם סעיף תקציב"}”) { id } } The response is { “data”: { “create_item”: { “id”: “2831461223” } }, “account_id”: 5226483 }

Could someone please help us know - What’s the maximum record we can retrieve in single request using Activity logs? In the document available at below path, it’s mentioned that the default value for limit argument is 25 but no information is available about what’s the maximum value we can provide for it. https://api.developer.monday.com/docs/activity-logs#arguments

Am trying to upload files to an item via php by it throws error internal server 500 Please can someone provide me with the right code Here is my code $curl = curl_init(); curl_setopt_array($curl, array( CURLOPT_URL => 'https://api.monday.com/v2/file', CURLOPT_RETURNTRANSFER => true, CURLOPT_ENCODING => '', CURLOPT_MAXREDIRS => 10, CURLOPT_TIMEOUT => 0, CURLOPT_FOLLOWLOCATION => true, CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1, CURLOPT_CUSTOMREQUEST => 'POST', CURLOPT_POSTFIELDS => array('query' => 'mutation ($file: File!, $item_id: Int!, $column_id: String!) { add_file_to_column ( item_id:$item_id, column_id: $column_id, file: $file) { id}}','variables' => '{"item_id":2267231528, "column_id": "files"}','map' => '{"image":"variables.file"}','image'=> new CURLFILE('https://cdn.pixabay.com/photo/2015/05/26/12/30/baby-784608_960_720.jpg')), CURLOPT_HTTPHEADER => array( "Authorization: $token" ), )); $response = curl_ex

Hello, Not sure what I’m doing wrong here. I see no red lines in the API Playground when sending this mutation but I’m getting a 500 response every time. mutation { create_item (board_id: 2782361481, group_id: "new_group", item_name: "Test", column_values: {text7 : "test-data"} ) { id }} Results in: { "error_message": "Internal server error", "status_code": 500 } This query successfully adds a new item when I exclude the column_values. Any idea what I’m doing wrong?

I cannot access the developer docs. I was looking up a mutation, then the browser refreshed and routed me to https://api.developer.monday.com/inactive. Any thoughts?

Hello, I’m a bit confused about OAuth integration. I created an app and give it boards:read permission. I created board view with Quickstart - ReactJS. I created React App in my localhost and connect it to the monday.com with ngrok successfully. And finally I read boards data successfully. But I did nothing for authorization in any of these steps. But my app worked successfully. Will authorization be automatically provided by monday.com or will I have to manually redirect the user? According to this page, I need redirect user to authorization page with my clientId.

Hey everyone, I’m happy to present you our first app on the Marketplace : dropcontact.io We built this app to helps Sales and Marketing teams to grow their business. Thanks to this integration, transform your monday CRM into a real Sales Machines: find business emails, enrich your B2B contacts (salutation, name standardization, LinkedIn profile…) and add all companies date (website, LinkedIn URL, phone number, address…) Save your precious time, and focus on your sales Our app is 100% RGPD compliant! How it’s work? Connect your dropcontact api key in our integration, Import your data (excel, csv,…) with : • last name • first name • company name or domain name Change the status… and … let the magic happen ! Follow this link for more informations about our app :monday.com

Wondering if anyone has built any integrations to IBM Maximo. We’ve come up with a solution using a webhook and the API, but it doesn’t do everything we want, so we have a multiple step process. We could build a custom action, but it’s not in the plan for now.

Hi folks, It looks like api.developer.monday.com has been down for the past two hours. Is there some scheduled maintenance that I’m not aware of? Here’s the message I get when I go there: Not Yet Active The creators of this project are still working on making everything perfect! Admin Login

Am new to Monday API and am working with Monday quick Start developers sample code here. Docs link I have followed all the instructions, enable board read permission. When I run the code as suggested, my board is empty. it displays { “boards”: [] } What am I doing wrong in the code below. Thanks import React from "react"; import "./App.css"; import mondaySdk from "monday-sdk-js"; import "monday-ui-react-core/dist/main.css" //Explore more Monday React Components here: https://style.monday.com/ import AttentionBox from "monday-ui-react-core/dist/AttentionBox.js" const monday = mondaySdk(); class App extends React.Component { constructor(props) { super(props); // Default state this.state = { settings: {}, name: "", }; } componentDidMount() { // TODO: set up event listeners monday.listen("context", res => { this.setState({context: res.data}); console.log(res.data); monday.api(`query ($boardIds: [Int]) { boards (ids:$board

I am attempting to query an item by column value, and am not getting a return value. Below is the code, and the response: query { items_by_column_values (board_id: 000000000, column_id: "name", column_value: "1001200 (Michael Andert)"){ id name } } Response: "data": { "items_by_column_values": [] }, I am positive that the item exists and is named exactly what is shown in the query. You can search for this project within the monday browser app, and it comes back as a full text match. When I run a board query and return all items, the repsonse indludes: { "id": "2802943814", "name": "1001200 (Michael Andert)" }, Seems like the search by column value api endpoint has a bug.

Hi, I’m learning how to build an App. I want do it from scratch and reproduce the slack template integration. My first step is the authentication using tunnel, middleware to link React between Monday and the React app. I can’t fully understand what is done. Having hard time to reproduce it and test. Is there guides or courses to help me to get started from scratch this kind of app?

Hello. I have a board that has multiple number columns. Some are in inches and some are in lbs. I have the units set on the columns themselves, so you can tell at a glance which columns are which when you look at a board from inside Monday.com. I’m working on an integration that accesses this data via graphql and totals up the lbs and totals up the inches separately. Using the following Query, I can get the column values and see which columns are numeric. But, the additional_info property is empty. Is there someplace else I should be looking for the unit data? query getMaterials($materialNames: [String]!) { items_by_multiple_column_values(board_id: 22222222, column_id: "name", column_values: $materialNames) { name column_values { title text type value additional_info } } }

We could see Webhooks and Activity logs available to get Updates (for example to get Newly created/updated Boards, Groups, Items) at Monday.com instance. We could see using both Webhooks and Activity logs we get updates (Created/modified) data. With initial analysis we could see Activity logs provide updates for more events/actions performed on Monday.com. Kindly help us know what is recommended between Webhooks or Activity logs to get the updates. Also help us know where could we find sample response data and a playbook for Webhooks, if there is any, to try out the webhooks.

Hello, I am attempting to build a custom integration that will search a Customers board for existing customers based on multiple columns. This is why I’m not using the built automation recipe for connecting items where columns match. For more details: I’m using phone number and email column to search multiple customer boards and if they match the intended functionality is that it will connect the customer to the quote. Issue I’m running into, is that when I do this I don’t know of a way to add a connected item without overwriting the existing ones. What I’m guessing is a way to do this: Query the existing connected column before mutation and appending the new item id to the existing list of item ids if there are any. Then mutate using this new list of item ids. What I’m hoping I can do: I noticed that when I query a connected boards column I get the following response: '{"changed_at":"2022-05-30T23:33:26.358Z","added_pulse":[],"linkedPulseIds":[{"linkedPulseId":123456789}]}' I’m hopin

I created an Item as follows and it got created successfully $query = 'mutation ($myItemName: String!, $columnVals: JSON!) { create_item (board_id:641098600, item_name:$myItemName, column_values:$columnVals) { id } }'; $vars = ['myItemName' => "My Personal Task", 'columnVals' => json_encode([ 'status' => ['label' => 'Done'], 'date4' => ['date' => '1993-08-27'], 'firstname1' => ['firstname' => 'Tony'], 'lastname1' => ['lastname' => 'Paul'], ])]; Now I want to query the items that I created as the code below to get item name, firstname, lastname etc. $query = ' query{ items { id name firstname lastname } }'; Here is the error it displays {"errors":[{"message":"Field 'firstname' doesn't exist on type 'Item'","locations":[{"line":1,"column":26}],"fields":["query","items","firstname"]},{"message":"Field 'lastname' doesn't exist on type 'Item'","locations":[{"line":1,"column":36}],"fields":["query","items","lastname"]}],"account_id":66xxxx}