API & Apps framework

Hi :_), I have a working mutation (tested on playground, does the job) to insert a new item with populated columns: mutation { create_item( board_id: ${MondayService.issuesBoardId}, group_id: ${MondayService.clientTicketGroupId}, item_name: "fromApp12", column_values: "{\\"people2\\":{\\"personsAndTeams\\":[{\\"id\\":\\"36904156\\",\\"kind\\":\\"person\\"}]}, \\"dropdown\\": {\\"ids\\":[3]}, \\"status94\\": {\\"index\\": 2, \\"post_id\\":null}, \\"status3\\": {\\"index\\": 2, \\"post_id\\":null}, \\"dup__of_severity\\": {\\"index\\": 2, \\"post_id\\":null} }") { id name } } I am attempting to use it in the following way: console.log(resFromNewItem); if (resFromNewItem.status === 200) { console.log("New Item created Succesfully!"); } else { console.log("Error creating item: ", resFromNewItem.data); } } catch (err) { console.log("error in mon

Hi all, I have a board with the following columns: The dev assignee and Reporter columns are of type “multiple-person” and with id of “person”. I am having a person’s id, which I’m trying to insert in the followingway: mutation { create_item( board_id: 3782143770, item_name: "New ItemZzzZ", column_values: "{\\"multiple-person\\":{\\"

Hi all, do you know if this article about Error Codes is up to date?monday API docs As far as I can see I don’t receive any error_code, status_code, error_message or error_data fields, but a simple errors array containing a message field. For example, triggering an error on purpose by calling a non-existing xxx field, I get the following errors array: Array ( [0] => stdClass Object ( [message] => Field 'xxx' doesn't exist on type 'Query' [locations] => Array ( [0] => stdClass Object ( [line] => 1 [column] => 129 ) ) [fields] => Array ( [0] => query [1] => xxx ) ) ) Do you know how to get the fields mentioned i

Hello, I have an issue with the monday.storage API. The app has a Board View and a Widget. Both store data in the monday.storage and this works well. Publishing new minor versions of the app has no issue as well. But when I publish and install a new major version, all created board views and widget lose its data. Is it a known issue? Is there any workaround for this? Thanks, Andrey

In the API playground, I can change a column value using mutation {change_simple_column_value (board_id: 12345, item_id: 54321, column_id: "text3", value: "{00002_0000067584}") {id}} But if I send the folowing in my JSON request to the API endpoint, I get a 500 error {"mutation": "mutation {change_simple_column_value (board_id: 12345, item_id: 54321, column_id: "text3", value: "{00002_0000067584}}") {id}}"} I have also tried without the {} but I get the same error. My guess is I am constructing the JSON incorrectly to resolve to GraphQL but I have exhausted different approaches, what am I doing wrong? Jon

Hi, I can create item working in SQL Server. Creating item with column values in (monday.com) is also working. However, when I try to create item with column values in SQL, it is not working. I have tried many kind of parenthesis for the text. None of them work. Please see below. –Working. Below query is working SET @query = ‘{“query”: "mutation {create_item (board_id: 3791969201, group_id: "new_group16869", item_name: "new item 91") {id }} " }’ –Not working. Below query is not working when I added the column values array SET @query = ‘{“query”: “mutation {create_item (board_id: 3791969201, group_id: "new_group16869", item_name: "new item 11", column_values: “{ "text" : "test_value" }” ) {id}}”}’ EXEC @hr = sp_OACreate ‘MSXML2.ServerXM

I am looking for resources to learn how to build my own apps for Monday. I need to build a few things that i can’t find in the app marketplace.

I am trying to use a custom app to send all columns of an item to a webhook when a certain update happens on the item. So far I have been able to make a recipe that triggers a custom action, but what is send does not send all the fields and I am at a bit of a loss as to how this could be accomplished, any ideas?

I am using monday.storage.instance.setItem(key, value) to store the details. How to add multiple values for a same / single key. Could you please let me know App storage(DB) limit? How to store objects and array values in a key? Thanks in advance! Priya

If the API included a new short lived token (or JWT) when there is a complexity limit exceeded error, it would eliminate the need to use OAuth tokens where the only use case is concern the SLT will expire before retries complete due to complexity limit errors. This could be enhanced by having an NBF (not before) claim in the SLT, which is set to when the limit resets, and then the expiration to be 1 minute after that. I’d much prefer to never store tokens at all. Only reason I’ve had to use OAuth has been due to complexity limits, I’m sure I’m not alone.

I reported this to support but have no idea how long it will take to get a response and wanted to ask the community if they knew what was going on: I created a local app which processes a CSV file. It loops through the rows and follows the following steps using API calls: List itemin my local APP I created a loop through a CSV file and read the rows. For each row I do the following with the API: Check if item exists with same name using search for item with name column If doesn’t exist Add it as an Item and use specific columns from Row to populate specified column IDs Check if SubItem Exists If not add a SubItem to the Item created in step 2 using specific columns from Row to populate specified column IDs All of these steps receive responses of success and IDs for whatever is created. I suspected items were missing, often watch the browser and there would be an item/subitem sum I looked at as it grew in t

When querying the API for boards, subitem boards show up in the results (type=sub_items_board). For those subitem boards, how can I determine what the parent board is? I would assume each board of type sub_items_board is linked to a board of type=board. My goal is to determine the columns of a subitem board based solely on a board ID. I know it’s possible to get the columns of a subitem board based on a subitem ID, but I need it based on a board ID alone. Is this possible?

Hello, Denis here, dev at Marker.io and working on our monday.com integration. We are encountering several blocking issues when working with webhooks. Basically, we’re creating webhooks through the api via a an api token provided by the user. The issues are the following: The webhooks don’t appear in the list of integration; The events stay stuck on In Progress in the activity log and we never receive the event;

I’m trying to get a column selection field working for a custom app I’m developing but no matter what I can’t seem to get it to work. At best it shows “Board and Group” Otherwise it shows nothing at all. Doesn’t matter what the settings are or which Board I’ve selected for the app. I have tried everything but I can’t figure out w

We are trying to develop a item view app but all users can delete the view. Is it possible to disable the delete button with permission or smt.

Hello, i’ve got a mirror column for subitems on a board, which i would like to use in a DocuGen document. Everything works fine, but the mirror column doesn’t get displayed in my document. There’s only an empty space… I’ve tried to fix it by using a formula column, which “copies” the mirror column. But this also doesn’t work. Thanks! Greets Fabian

As we are developing an front end App, we need to store certain data in the database storage using the database storage. Could you please confirm us the below points. We are in need of know the storage limit for an APP. Is it possible to store object or array of values in a key? Example: ``` monday.storage.instance.setItem(‘AzureDomain’, values.azuredomain).then(res => { console.log(“setItem…”,res); }); Thanks in Advance! Priya

There was a question asked a while ago about a user profile endpoint being available. The system I am working with doesn’t support GraphQL queries in the user profile retrieval endpoint well, so https://api.monday.com/v2?query={me{account{id name}}} doesn’t work. Would be ideal if there was an endpoint like https://api.monday.com/v2/me or similar, if anyone knows?

As we are developing an front-end APP, we are in need of knowing the database limit to store the item details. Could you please confirm the below points? App Database limit to store the data Is it possible to store the objects or array of values for a key? Example: monday.storage.instance.setItem('domain', {name: "xxx",api_key:"yyy"}).then(res => { console.log("setItem.......",res); });

I am trying to create a python script that reads an XML file and imports the data to Monday.com Board. I have the XML scraper built, now i need to learn the API side… I have this example working without the 2 “Text” fields, After i added the 2 text fields I get a ‘error_code’: ‘ColumnValueException’, Can someone please help me understand why this error is happening? even chatGPT agree’s it should work but isnt… MY CODE BELOW Creating a new item with column values populated apiKey = "apikey here" apiUrl = "https://api.monday.com/v2" headers = {"Authorization": apiKey} query5 = 'mutation ($myItemName: String!, $columnVals: JSON!) { create_item (board_id:3716595122, item_name:$myItemName, column_values:$columnVals) { id } }' vars = { '

I’m using the Graphql API to update Monday - but it behaves inconsistently and doesn’t always perform the update. I’ve noticed in my log, that in some calls to the change_column_value mutation, it returns undefined - I think these are the cases where it doesn’t save the change, but it’s all very inconsistent - because if I call it again, it does save. What are the cases where change_column_value returns undefined? Should I add logic that will repeat the update until it doesn’t return undefined? Here’s the graphql: mutation ($id: Int!,$value:JSON!,$board:Int!,$column_id:String!) { change_column_value( item_id:$id column_id:$column_id, board_id:$board, value:$value ) { id name, column_values(ids:[$column_id]){ id value } } } Here’s a link to my code on github:

I am storing a data using storage api, it is working fine on same session, but as soon as I refresh the web page I am not getting the saved data using storage api. Can you please help me over here? Thank you

Hi, May I know is that possible for us to create the same feature like: by using this provided feature?

Hi, Wonder what I am doing wrong. I am reading the JWT token in C# and all I get is: {“accountId”:xxxxxxxx"userId":xxxxxxxx,“aud”:“http://xxx”,“exp”:1671813626,“iat”:1671813326}} According to Choosing an authentication method, I should get a shortLivedToken field. Blockquote When you decode the JWT token, you will see a shortLivedToken field. This is an API token that is valid for 1 minute and can be used to authenticate against the monday.com API.

Hi all, So i’m trying to implement the OAuth workflow with monday. I did all the steps in the doc, but somehow, whenever my application calls the redirect towards the /authorize endpoint, after I authorize the application in the web interface, I get a : {"error":"server_error","error_description":"Internal server error","state": ... My request is to this URL: https://auth.monday.com/oauth2/authorize?client_id=MY_CLIENT_ID&state=MY_STATE So to debug this in order to see if my app’s request was the problem, I copied the suggested URL in the app OAuth section (app framework) which is just the previous URl without the state query param. I still get redirected to the web interface where I allow the monday integration its needed scopes. But after this, when my configured single redirect URL gets call, the request query contains the internal server error. What am I missing ?