General

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.ServerXMLHttp’, @Object OUT EXEC @hr = sp_OAMethod @Object, ‘open’, NULL, ‘POST’, @Url, false EXEC @hr = sp_OAMethod @Object, ‘setRequestHeader’, NULL, ‘Authorization’, ‘xxxxx’ EXEC @hr = sp_OAMethod @Object, ‘setRequestHeader’, NULL, ‘Content-Type’, ‘applicatio

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 the import. It would complete and the page would refresh at some point and coun

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; Tried on a new trial account to make sure it wasn’t a problem of limits. Can you please advise? We have many customers expecting the syncing feature we’re trying to make. Denis from Marker.io

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 what to do. Even creating an app from scratch yields nothing better for me. Looking for any help here at all.

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 = { 'myItemName': 'Item 1', 'columnVals': json.dumps({ 'status': {'label': 'Working on it'}, 'date4': {'date': '2022-12-31'}, 'text': {'text': 'text here'}, 'text1': {'text': 'text here'} }) } data = {'query': query5,

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:github.com I would love to hear from you

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? Thanks! Br, YarHuoy

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 ?

Hi, I’m currently trying to duplicate a group with 34 items through the graphQL API. So far so good, the API is easy to use & the request schema helps a lot. I encounter the following problem: I successfully duplicate a group with the following mutation query: mutation { duplicate_group (board_id: ${boardId}, group_id: ${groupId}, add_to_top: true) { id } } The group is duplicated in monday & visible. However, not all items of the group are present in the duplicated group. The number varies. Sometimes I get 15/34, other times I get 18/34… I suspect this might be because my whole custom action exceeds the query complexity limit (it performs more than 1 query). But, I would expect in this case that monday returns a status code 429, this is not the case. Anybody knows why my item are not all created ? Thanks in advance!

Had a look through the documentation but I’m not too sure if this is possible, am I able to use GraphQL to add a new view to a selected board?

I’d like to request assistance. I’ve already created the template as a solution pack by creating the app on my account, but I encountered the issue of the connect board column. 4 connected board columns that add new boards to the template automatically every time the template is used. Roadmap: link to epics Epics: link to sprint management Sprint management: link to bugs queue, link to metadata Does anyone else have this problem, or does anyone know how to solve it? Regards,

I’ve been trying to create a custom automation with trigger every second/minute. What I’m wondering is whether there’s some way to know what action user choose?, so I can pass data to webhook. And Can I catch or create a webhook event to know whenever this trigger run? so I don’t need to use setInterval()

Hello, Prefacing this by saying I am by no means a developer at all - but I am trying my best to learn what I can to create custom, workable solutions for my organization. I’m looking to create a very simple item view app that simply displays the contents of a link column as an iframe. Any preliminary guidance on how to approach such a thing? I’ve created simple item views where I’ve just been able to embed the static website I would like (in my use case, an online form). However, I would like the item view to display dynamic links specific to the item. Any guidance on how to create an app on how to do this? Happy to even just get some articles I can read to learn about how to start. Essentially, the app will need to be able to read the monday.com item data and display the link column’s content as the iframe src. Thank you in advance!