API & Apps framework

Hello, I’m having a problem trying to pass JSON value to columnValues field when creating an item using monday.api() method. Attempt #1: monday.api(` mutation { create_item ( board_id: 0000000, group_id: "topics", item_name: "Hello", columnValues: "${JSON.stringify({people3: {personsAndTeams: [{id: 1111111, kind: 'person'}]}})}" ) { id } } `); Here is the error response I got: { "errors": [ { "message": "Parse error on \\":{\\" (STRING) at [7, 36]", "locations": [ { "line": 7, "column": 36 } ] } ], "account_id": 2222222 } Since the attempt #1 doesn’t work for me, I’ve tried the solution that I found in this community, but it still d

Hi there, I see that it is possible to have different columns for an item and sub-item as shown in this screenshot But when I query columns in a board, I am only getting columns at the item level. How do I get columns corresponding to the sub-items?

Hi all I’ve been trying to create a query for about 6 hours which I think is pretty straightforward. Given a certain board, find all the elements in which the State column is valued with “YES” and the Number column is greater than 3, but i am not finding solution. Can you give me a case study that I can study and understand? Unfortunately I’m not understanding much from the API documentation. Thank you

Hi, in similarity to this post: Rendering image url on updates of an item - graphql monday Apps & Developers Hey all, I am able to create new item and to push to it an update, in form of a string. While inserting the string, I include to the update an image’s url as well:

I am trying to programmatically query via items_by_column_values for fields with blank values (passing “” as the value). I have tried to query for blank on the following field types: Person, Timeline, Number, and they all return no results although there are many responses: “data”: { “items_by_column_values”: }, Is querying for blank fields supported?

Hi Team, How to update through graphql api particular subitem row in that update data of specific coulmn In my use case, I wanted to update a particular subitem by id to particular column “html template” endpoint. So how can I update some text data in that column to that particular subitem row by using the subitem id and column name. Is there graphql api avaialble for this?

Hello, I’m new here. I’m facing a problem in creating a new status column with custom labels when the column is created. I’ve read the API documentation and some posts in this community, and I’ve found that I can create a new item and create a new custom label if it doesn’t exist, but that’s not sufficient because I need to create two new status columns in more than 500 boards with customized labels to match in some automations. Do you have any ideas on how I can add these columns using a script or GraphQL? Regards,

I am stuck on trying to build an integration recipe. I want to create a recipe with a custom trigger that has a built-in action (Create Item) with possible column fields that loads remotely. I want to build a similar recipe to this Zendesk recipe I am stuck on how I can provide the supported fields from my external application, so the user can choose these fields when the recipe is been configured. Something similar to do the Zendesk integration recipe below

when i try this in the API sandbox it works : mutation { change_multiple_column_values(board_id : 1140656959, item_id :3969481029, column_values: “{"person":{"personsAndTeams":[{"id":22027695,"kind":"person"}]}}”) {id} } when i try via posting JSON to the API - i get a 500 error code. heres what i post {“query”: “mutation { change_multiple_column_values(board_id : 1140656959, item_id :3969481240, column_values: “{"person":{"personsAndTeams":[{"id":22027695,"kind":"person"}]}}”) {id} }”} heres the header info Url = “https://api.monday.com/v2” Set objHTTP = CreateObject(“WinHttp.WinHttpRequest.5.1”) objHTTP.Open “POST”, Url, False objHTTP.setRequestHeader “Authorization”, apiKey objHTTP.setRequestHeader “Content-Type”, “application/json” objHTTP.send postData both look identical. i have a bunch of other updates status

I am trying to pull data from Monday API, by traversing below query for all the board_ids. { boards(ids: $(vboardsId)) { name columns { title id type } groups { title id } items { name group { id }}}} I am facing 503 error at random board_ids every time, though its working fine when tested for perticular ids only.

I have a few questions about using the built-in monetization. I’d ideally like to retrieve the subscription object and be able to deterministically determine my apps usage against the subscription given that state (and some record keeping on my end). Say my app provides 1000 queries per month to paying users. The subscription object looks like this: app_subscription { plan_id is_trial renewal_date billing_period days_left } Since I don’t have the start/end dates of the current period, it seems difficult to count the number of queries within the monthly period since I don’t know when in the month the subscription started. If the subscriptions are pro-rated based on the calendar months, I can just count usage based on calendar months per subscriber, which isn’t too hard. Is this the case? If not, I could try to listen to some of the webhook events and track subscription changes this myself, bu

I am struggling to understand the error here. Using make’s Monday.com GraphQL module I am getting a parse error when populating the Ids array with data from a previous module, even though the input data looks identical from that of hand entering the 2 user ID’s This is the error thrown The operation failed with an error. [200] [{“message”:“Parse error on "\\xC2" (error) at [2, 27]”,“locations”:[{“line”:2,“column”:27}]}] This is what the query looks like (where 27.value is just a map function grabbing the users ID’s from a people column). If I manually enter the two ID’s in a comma separated list it runs fine, which tells me it is something with the data from the text module, but I just don’t see any difference in input to the module (it all looks correct to me) I have also NOT copied and pasted from the api playground as that is known to cause parse issues with

Hi, I am able to create new item, and to assign to the columns of that item values, BUT… some values remain, some values are changing back to ‘empty’. What do I mean by that? Well, they literally change back to empty values after approximately a second after the issue appears. The crazily weird part is that for two columns, where their two mutations require pretty much the same mutation, one of them has it’s value remaining, the other is changing back. I thought perhaps it’s related to automations, but I’ve turned all of them off, and the issue maintains. Any ideas what could be the issue? The following are my mutations, and once again, I will state that the action works, and then retracts itself (from some columns). export const postNewIssueQuery = ( MondayService: MondayType, reqBody: IssueInterface, clientsForMutation: string, reporterMondayId: string ): string => { return mutation { create_item

When using the Graph API to retrieve all items from a board, you can only retrieve active board items unless you specify the id’s of each item. When doing a data extraction for downstream systems, we want to pull the latest information each time, as such don’t want to specify the id’s in the graph query, but page through all items instead. However the ‘exclude_nonactive’ setting only works when you specify id’s, therefore once you have something extracted you can’t use the same method to get a status update on a board item. After back and forth with support, the issue has been added to the ‘bugs’ backlog as its not an easy fix. Therefore the only way when using the graph and paging through the board items, that we can work out if something has been deleted or not is by using the ‘activity_log’ with the event “delete_pulse” and seeing if we have a matching pulse_id for the given board item_id. Utilizing webhooks is not an option as we will need to add them to each board

I have been trying to run the React quickstart on a MacBookPro. Recently switched from Windows to a Mac. Just trying to setup the quickstart view sample first up. the xxx.tunnel.monday.app. is returning timeout. with “504 Gateway Time-out” if I switch back to the Windows PC. it works correctly. localhost:8301. and local IP versions work on the Mac. So it is running. Mac local firewall is off. both mac and PC are on the same network. anyone seen this problem? Search didnt seem to give me any answers.

Clearing a column is as easy as sending a “” to it, don’t forget to JSON.stringify it. Except for long-text and people column where you need to send {} 🙁 That was until recently. Somewhere beginning of March the people column can’t be cleared in this way. You need to do a column mutation: mutation { change_column_value( board_id: 1111111111, item_id: 1122334455, column_id: "person", value: "{\\"removed_person_or_team\\":{\\"id\\":12345678,\\"kind\\":\\"person\\"},\\"persons_and_teams\\":[{\\"id\\":12345678,\\"kind\\":\\"person\\"}]}" ) { id } } EDIT: luckily there is another (undocumented) way to clear completely: mutation { change_column_value( board_id: 1234567, item_id: 112233445566, column_id: "people", value: "{\\"clear_all\\": true}" ) { id } }

I was trying to make an post API call to update value on the Monday board but it is throwing an error in Node.js var action = “mutation{change_column_value (board_id:3258333017, item_id:785444200, column_id:“text”, value:“board1”){ id }}”; fetch (“https://api.monday.com/v2”, { method: ‘post’, headers: { ‘Content-Type’: ‘application/json’, ‘Authorization’ : ‘’ }, body: JSON.stringify({ ‘query’ : action }) }) .then(res => res.json()) .then(res => console.log(JSON.stringify(res, null, 2))); When I try to do this it is throwing an error: { “error_message”: “809: unexpected token at ‘board1’”, “status_code”: 500 } can anyone help me with this?

Has anyone found/documented a timeout on an app event? How long does the monday.com server wait for our 200 (or other) response before dropping the connection when it sends us a webhook for a workflow block? Basically, how long do we have to complete (including any complexity retries) and return with a status code and body (including severity code, notification text, notification title, etc.) before the monday server drops the connection and starts retrying the event? Providing appropriate responses is also impossible if we need to use a queue (per best practices) for mutations - there is no way to know the outcome of the mutation (easily) to respond with an appropriate status/error (referring to the new error mechanism that can disable a recipe, etc.), so we have to hold this connection and just wait for retries until near timeout - then queue them. But what is the official monday timelimit for us to r

I am trying to create a new item with column values populated, but the API is throwing an error. I can’t figure out what I am doing wrong here. This is my code: $query = 'mutation ($myItemName: String!, $columnVals: JSON!) { create_item (board_id:XXXXXXXX, item_name:$myItemName, column_values:$columnVals) { id } }'; $vars = ['myItemName' => 'Test Veterinary Hospital', 'columnVals' => json_encode([ 'status' => ['label' => 'Agency'], 'text' => ['text' => 'Test Practice Management System'], 'text7' => ['text' => 'https://example.com/'], 'text6' => ['text' => 'Test Name'], 'text37' => ['text' => 'Email'], 'text1' => ['text' => 'test@example.com'], 'text2' => ['text' => '555-555-5555'], 'text3' => ['text' => '333-333-3333'], 'text8' => ['text' => 'Address Info'], 'text4' => ['text' => 'Yes'], 'text87' => ['text' => 'No'], 'date' =

Hi, I’m updating monday using graphql and some of my updates are not saved incosistently and I don’t know why. Here’s a log af an update that I’ve made, we can see in the column_values the result from monday saying ot was saved with the value “45” but the data in monday did not reflect this change. See Monday change log:

I’m unable to get the itemMapping in the POST content to my server as part of my custom action. I’m using the built-in trigger ‘When status changes to something’ and I’m setting the itemMapping as an input field in the custom action configuration. I’m also making sure to specify the trigger output as the input source. Are there any gotchas or any configurations that I might be missing? I’ve seen a couple of other topics that mention the same issue but I don’t see any solutions for them.

From the Monday UI its possible to update a cell value and add an Icon to it: Is it possible to add/update this icon from API using change_simple_column_value() or the change_column_value()

I’m having difficulty finding the right format for query items by timeline. Looking to search for all items with timeline of certain dates. I have tried the following: { items_by_column_values (board_id: 3886193895, column_id: "timerange", column_value: {"timerange" : {"from" : "2023-06-03", "to" : "2023-06-07"}) {id}} } and { items_by_column_values (board_id: 3886193895, column_id: "timerange", column_value: "{"to":"2023-02-07","from":"2023-02-11"}") {id} } } Any advice on what works would be appreciated!

My endpoint is being hit by my custom action twice for some reason. There’s an initial POST to my endpoint after the trigger, for which I return a 200 OK. After my 200 response, there’s another POST to my endpoint for some reason. My trigger is ‘When status changes to something’ and I’m only changing the status once. Are there any gotchas that I need to be aware of to prevent this from happening? Why would the custom action be triggered twice? Thanks!

Am I missing something or didn’t we used to be able to specify the Subitem Board ID when performing queries like listing subitems or subitems by column values or multiple column values? Ive been trying to query multiple dates using a date column and it errors “500” when using subitem board id and finds nothing when using the main board id since my items do not include the date column. Is there a way to include the columns from subitems?