API & Apps framework

Hi guys, I am trying to get some items of my team which are overdue using the following query: query { items_page_by_column_values (limit: 50, board_id: 4001269428, columns: [{column_id: “timeline”, column_values: [“PAST_TIMELINE”], compare_attribute: [“START_DATE”]}, {column_id: “priority”, column_values: [“Low”, “High”, “Medium”]}, {column_id: “people”, column_values: [“xxxx”,“xxxx”,“xxxx”,“Meir Peleg”,“xxxx”,“xxxx”, “xxxx”]}, {column_id: “status”, column_values: [“Waiting for xxxx”, “Working on it”, “No Started Yet”]}]) { cursor items { name creator { email } } } } What’s worng?

Hi, I can’t understand why my code is working on my staging site / staging monday board but not in the live environment. The request is exactly the same format for both environments but live is not processing the request. The API is not returning ANYTHING - usually it would send me back a syntax error or some reason the request didn’t work… So HOW do you debug an API query if the Monday API returns nothing to the caller??? EXAMPLE (working) [28-Nov-2023 03:48:09 UTC] {“query”:“mutation {addMembership : create_subitem (parent_item_id:5559740500, item_name: "Membership Renewal - Stripe", column_values: "{\\"item\\" : \\"Member Advantage\\",\\"amount\\" : \\"20\\",\\"date0\\" : \\"2023-11-28\\",\\"order_name\\" : \\"blep blep\\",\\"email\\" : {\\"email\\" : \\"blep@blep.com\\" , \\"text\\" : \\"blep@blep.com\\" }}") { id } }”} [28-Nov-2023 03:48:09 UTC] Response-----> [28-Nov-2023 03:48:09 UTC] Array ( [data] => Array ( [addMembership] => Array ( [id] => 5580876159 ) )

I can insert an item if it looks like this $mutationQuery = 'mutation { create_item( board_id: ' . $boardId . ', group_id: "' . $groupId . '", item_name: "' . $cursus . '" ) { id } }'; but when i try to insert any value to another column i always get an error, am i doing something wrong?. this the code i have $mutationQuery = 'mutation { create_item( board_id: ' . $boardId . ', group_id: "' . $groupId . '", item_name: "' . $cursus . '", column_values: { "lange_tekst": { "text": "'.$cursus.'" } } ) { id } }'; this is my full code if you want to know if ($_SERVER["REQUEST_METHOD"] == "POST") { $token = 'MY_API'; $apiUrl = 'https://api.monday.com/v2'; $headers = ['Content-Type: application/json', 'Authorization: ' . $token]; $cursus = 'lolinit'; $boardId = '5554649549'; $

Hey, I want to build an integration between my software and MONDAY. My goal is to report working hours on projects in my system, and make an API call to update the MONDAY. I don’t really know the method with GRAPHQL, I wanted to know if there are other options? Any request I can send in POSTMAN in raw and not in Graphql? Thank you

I use the following query: query {next_items_page (cursor: “cursor_string”, limit: 50) {cursor items {id name column_values {id value …on MirrorValue {display_value} }}}} the query works as expected if we neglect the term “…on MirrorValue {display_value}”, but returns an internal server error 500 when included. Is there a way that I can make this work?

Trying to use the API to return email address(es) for any people columns for a given item. It would seem that “email” is not a valid field for “persons_and_teams” and I am only able to get the ID/s. I’m assuming there is a way to accomplish this using variables or nesting queries, but I just haven’t learned enough about QraphQL yet 🙂 It would also be nice if there was a way to filter the returned data to only show people columns that are not empty. That filter only seems to work on items page, but couldn’t figure out how to make that work with just one specific item. (there are 5 people columns on the board, and typically not all of them are set) Was hoping someone could point me in the right direction for any work arounds to accomplish this! Thanks, Matt

Hello community, I am working on a software in react/node, and I was wondering if it is possible to create a contact person or lead through an integration in our software. If this is possible, could you please direct me to the correct place in the docs, since I can’t seem to find it. Thank you in advance!

Attempted to create a Feature but encountered an error while executing this command: npx @mondaydotcomorg/monday-cli@latest scaffold run ./ quickstart-react -t item-view-10114722 CLI execution and console output (results): npx @mondaydotcomorg/monday-cli@latest scaffold run ./ quickstart-react -t item-view-10114722 Starting scaffolding process Repository was downloaded successfully Copying the directory Started injecting data to .env file Finished injecting data to .env file Installing packages. It can take a few moments Node modules were installed successfully Running the project monday-react-quickstart-app@0.0.1 start npm run stop && concurrently “npm run server” “npm run expose” monday-react-quickstart-app@0.0.1 stop kill-port 8301 && kill-port 4049 && kill-port 4040 0 process was killed 0 process was killed 0 process was killed [0] [0] > monday-react-quickstart-app@0.0.1 server [0] > react-scripts start [0] [1] [1] > monday-react-quickst

so i want to build an integration type app and i was following the guides online and then suddenly this happend. So basically i copied the npx thing in my cmd and then it started some process but when it said [nodemon] starting node ./src/app.js it was just stuck. I thought it’s just taking awhile but it has been 2 hours and nothing is happening.

Hi all, We are importing with the API account using the country field. An error occured when we tried to inject the “RE” code “La réunion” or “Reunion island”. We found the country code comes on the Monday API documentation from the following URL : Country This URL redirect to the following JSON file : http://country.io/names.json the “RE” code exists in this file but the API refuses it. When we try to type this country on a board, the country doesn’t exists. Is it a bug because of the accent “é” ? Is this country recently hidden ? Is the JSON is outdated ? If other countries are in the same case, can you give us a list of these ? Thank you for your help

Hello good morning. a general question. I would like to be able to see and read information about creating an app in the item view. The information I have found so far has not been enough. If there is a guide or a step by step it would be the most ideal. thanks in advance.

mutation { mut1(...) {...} mut2(...) {...} ... } If I execute multiple mutations in the same request, assuming mut1 succeeds and mut2 fails, will the API roll back the changes made for mut1? So if one fails, all fail? Or will the changes from mut1 be kept? From the GraphQL specification, if I understand correctly, mutations are executed sequentially, and there is no information in case of failures. I did find that the Hasura GraphQL engine rolls back the changes, but I wanted to ask if this is also the case for Monday.hasura.io " If multiple mutations are part of the same request, they are executed sequentially in a single transaction. If any of the mutations fail, all the executed mutations will be rolled back."

With addiing complexity I get that the query is 3095, which is still okay no? { “data”: { “complexity”: { “before”: 10000000, “query”: 3095, “after”: 9996905, “reset_in_x_seconds”: 60 }, With the following next page: query{ next_items_page( cursor: “MSwzODY4Mjc4NDMwLDhfaWxtVTJhQWVqLS1IMjl3dE0tQiw0MjMsMix8MzI3ODM3ODYwMw” ) { cursor items { id column_values { column { id title type } value text } column_values { ... on MirrorValue { column { id title type } display_value text } } } } } I get an error response 🙂 { “errors”: [ { “message”: “Failed to fetch”, “stack”: "TypeError: Failed to fetch\\n at https://monday.com/nhp/_next/static/chunks/d310b1ebcb21564b607af0377ef0e1240c79bee0.dd6c8b0f89ced6ba8a82.js:1:13303\\n at https://monday.com/nhp/_next/static/chunks/pages/_app-11ac16eedf3cc32ce5ee.js:1:30591\\n at o (https://monday.com/nhp/_next/static/chunks/pages/_app-11ac16eed

Hi, struggling to use Graph API for basic stuff. I can create new items in a board using long hand query mutation, but the same query wont work when using column_values. This works fine { "query": "mutation ($boardId: Int!, $itemName: String!){create_item(board_id: $boardId, item_name: $itemName, column_values: \\"{\\\\\\"text\\\\\\":\\\\\\"a text value\\\\\\"}\\"){id}}", "variables": { "boardId": 12345, "itemName": "new item" } } But when i try convert column_values to a variable, it doesn’t work, 500 Internal Server Error. { "query": "mutation ($boardId: Int!, $itemName: String!, $columnValues: JSON!){create_item(board_id: $boardId, item_name: $itemName, column_values: $columnValues){id}}", "variables": { "boardId": 1234, "itemName": "new item", "columnValues": { "text": "some text" } } }

We are working through our transition to the 10-2023 API changes and have hit a dead end. Our previous use of the item_by_column_values uses the state = “active” argument to retrieve only active items for from a board. Is there any way to add this filter to a query utilizing the new item_page_by_column_values now that the state field is no longer an argument.

Hello everyone, I’m facing a challenge and hope someone can provide me with a tip or assistance. The challenge is as follows: I would like to assign certain information to the “Unternehmen” (company) column. I have found all the relevant information such as “type” and “column_id” using the API documentation and the API Playground. However, I keep encountering an error message. Are there any alternative approaches to assign information to the “Unternehmen” column?

How to link custom trigger’s output to standard actions in the Monday CRM ? I have created a trigger then i created a recepie then i create an integration how to link triggers output fields into new item fields ?

Clearing File Attachments in a Column and Updating it for 500 resource items in a loop causes Complexity Exception for every 10,11 and 12 despite giving 2 second wait after clear file attachments and 3 second wait after file update. Additionally it seems Monday API seems to be crashing the GraphQL with an invalid response which the library is not able to handle. I have reported the same here: Casting Error in GraphQL C# Library · Issue #600 · graphql-dotnet/graphql-client · GitHub Appreciate if some one could help address these issues.

Hi, Is there a way I can get the people icon via GraphQL API? Br, YH

Hey all, With the new API out, I’m swapping my queries and can’t figure out how to return only the column “email_address” from a items_page_by_column_values query. Any ideas? Original query: query {items_by_column_values (board_id: 12345, column_id: “status_199”, column_value: “Ready”) {id name column_values(ids:[“email_address”]){text}}} new query: query{items_page_by_column_values (limit: 100, board_id: 12345, columns:[{column_id: “status_199”, column_values: [“Ready”]}]){cursor items {id name}}}

I’m curious with the new feature allowing Teams to become owner of boards if the API will be updated? I want to make teams owners of new boards created rather than just subscribers using GraphQL API in Make.

I have a query where I am trying to obtain the id and name for a board item based on a column value. I am trying to pass the variable $name to the query like this: $name = “Test Practice Full Service”; $query = 'query ($name: String!){ items_by_column_values (board_id: 3873753003, column_id: "name", column_value: $name) { id name } }'; However, I get an error message: Variable $name of type String! was provided invalid value what am I doing wrong here, and how should I structure this query so that I can pass the $name variable into the query?

We are facing a piquant situation using GraphQLClient’s SendQueryAsync method to call Monday.com API. The line goes like this var response = await graphQLClient.SendQueryAsync(request) If the server returns a proper JSON it is all fine. However if the server returns a message like Complexity budget exhausted, query cost 30001 budget remaining 29984 out of 1000000 reset in 8 seconds, it throws a message like Error converting value Complexity budget exhausted, query cost 30001 budget remaining 29984 out of 1000000 reset in 8 seconds to type GraphQL.GraphQLError. Path errors[0] line 1 position 305 How do we configure this graphqlclient to cast the string into GraphQL Error or are we missing something else?

Hello guys, I am Emmanuel Katto from (Uganda) Africa. I am new in creating app development and wanted to create an application like Pinga, is this possible to create an app like Pinga, if yes then how?

Hello, I am trying to automate the download of our time tracking logs for our main board using the API. The ideal download would be similar to the data provided in the “timer” tab of the spreadsheet but condensed to Task ID, User ID, Start Date/Time, End Date/Time, (including the subitems too in the same query ideally) I had thought that I had done this using the activity_log function (screenshot below) but the duration there tracks the total time spent, not individual logs? Don’t think I am barking up the right tree. Could anybody let me know if there is a simple query I am missing that I can run to get all time logs (filtered by start date)? I am using python also in case that matters! Thanks