API & Apps framework

Hey there, I’m having some trouble creating an item with a numeric column value. No matter what formatting I try, I get an error that says I am using an incorrect data structure for that column. Code and error response is below. Any tips appreciated! query6 = 'mutation ($myItemName: String!, $columnVals: JSON!) { create_item (board_id:BOARD_ID_HERE, item_name:$myItemName, column_values:$columnVals) { id } }' vars = { 'myItemName' : 'Hello everyone!', 'columnVals' : json.dumps({ 'numbers1' : {'value' : '25'} }) } data = {'query' : query6, 'variables' : vars} r = requests.post(url=apiUrl, json=data, headers=headers) numbers1 is the ID of the column in question. I’ve also tried the following formats in place of that line: 'numbers1' : {'value' : "25"} 'numbers1' : {'value' : 25} 'numbers1' : {'value' : "\\"25\\""} Every time I get the same error: {'error_code': 'ColumnValueException', 'status_code': 200, 'error_message': 'invalid value, please check our API documentation for the

Hi everyone, Since a couple of days we are receiving (we think) incorrect data using the GraphQL API for Monday. Or atleast the behaviour is not as expected. We are trying to query items inside of a specifc group and we want to retrieve the updates that are linked to each item. We are using the following query: query { boards (ids: 294306894) { name state groups (ids: new_group) { title items { id name updates { id creator_id } } } } } We do get updates but instead of each item having its own array of their own updates, every item has an identical array containing all updates from different items. Also adding item_id to the properties list for the updates we do see different ids which indicate the updates in the list are not just the updates for the item. I can’t remember this was the normal behaviour and

Hello! my code return one error when execute query. Using o monday playground that is query: mutation { change_simple_column_value (board_id: 1320360890, item_id: 1537903846 , column_id: "lider3", value: "{\\"email\\"=>\\"gabriellaselbach@gmail.com\\", \\"text\\"=>\\"gabriellaselbach@gmail.com\\"}") { id } } Here is code in Nodejs using graphql query --> mutation ($board_id: Int!, $item_id: Int!, $column_id: String, $value: String) { change_simple_column_value (board_id: $board_id, item_id: $item_id, column_id: $column_id, value: $value) { id } } variables { board_id: 1320360890, item_id: 1537903846, column_id: 'lider3', value: 'gabriella.staniecki@nodo.cc' } errors: [ { message: 'Nullability mismatch on variable $column_id and argument column_id (String / String!)', locations: [Array], fields: [Array] }, { message: 'Nullability mismatch on variable $value and argument value (String / String!)', locations

My authorization request is as below auth.monday.com and i have set my redirect uri to https://fc7f6898f266.ngrok.io/monday/test on monday platform (i have only one redirect uri set for my app) My problem is when I run the authorization request from the postman it shows me an error { "error": "invalid_request", "error_description": "Invalid redirect_uri" } Please help me out on this.

We’re using Subitems to track resources assigned to items on our boards. We’re using the API to pull everything into an external portal. We need a way to tie the subitems back to their parents, so we’ve set up mirror columns in the subitems, tied to their parent. The process is working, but populating the subitems’s mirror column is manual - user has to click on the field. We can’t find a way to automate it. Is there a way to do this programmatically via an app? Or is there an automation available that we’re not aware of?

Hi, last time I checked about this it seemed that things were quite limited with subitems, so I’d like to get a current answer. It’s my understanding that there’s now a create subitem method. To get all subitems for a board, you must first query all items in a board to retrieve the subitem IDs, and then query the subitem IDs (no way to directly query all subitems in a board). To modify a subitem, you can modify it like you would a normal item, correct? Thanks in advance.

Hi! Today the monday API request that I was using to get subitems broke, every new item that is using subitems, will not have a group id like “subitems_of_PARENT_ITEM”, but instead all group ids = “topics”. This is my API request: The GROUP_ID_FOR_PARENT_ITEM var below is something like “subitems_of_XXXXX” (with the exact item ID to use, I am inputting XXXXX to select ONLY subitems of a specific item) query { boards (ids: BOARD_ID_SUBITEMS) { groups (ids: GROUP_ID_FOR_PARENT_ITEM) { items { id name } } } } This works fine for my old items but suddenly new items added to my group will have all GROUP_ID_FOR_PARENT_ITEM = ‘topics’ now. Did you change the API? If so, any way I can now narrow down easily the subitems response only to subitems belonging to a specific item ID? Thanks, Lorenzo

Hi! What is the best way to retrieve all boards within a workspace? When querying for boards one cannot filter on workspace, and the Workspace type does not list the boards it contains. Any idea? Thanks!

Hi team, Please assist or guide me how to connect Monday connect to PowerBI

Hi all We have just transitioned our Monday boards into a new tenant, that we now share with a sister company. I used the cross account copier and integromat to facilitate 90% of the work. The challenge however is that I now need to extract a number of files that have been uploaded into Monday using the pulse update functionality. Can anyone please shed some light on the most effective strategy that I can apply to extracting the files and uploading them into the new tenant, which we now access. I cant seem to find any related (productive) feedback on the best step to take, and which is the best technology to achieve that? Thank you

Hello, I updated the Data Clean view app with a feedback link and a know more link. I did this in a minor version and made it live. However the view is not updated, on multiple accounts, after a vigorous* cache refresh. Any idea why? Thanks, Laurent vigorous: * I pressed very strongly on my keyboard keys.

Hi, I am trying to use item mapping for a column that contains images. I have tried different things but it doesn’t work, its also not specified in the documentation. Does anybody have any experience with this or can suggest a workaround? Thanks in advanced. EDIT: Added more detail Essentially I am trying to send to an external API a text column and an image column when a particular date/time in another column in the same row expires. I created a recipe but found here a way to map the data far calls from monday.com to external apis. I mapped the first text field as described in the docs but I am having trouble mapping the image.

The type of field “replies” on Updates is “Replay”. what are the fields of this type (“Replay”)?

I’ve notices that there are inconsistencies in the documentation for the create_group and duplicate_group mutations, and I’m trying to understand what the reality is: In the create group mutation, the API lists group_name (!string) as the name of the group. In the duplicate group mutation, the API lists group_title (string) as the title, and group_id (!string) as the “unique identifier”. In the other 2 mutations (archive, delete), only group_id is listed. So I’m trying to understand what exactly group_name, group_title and group_id are and what they are used for. Is one of these a typo, does one serve the same purpose as another? Or is there really a unique purpose for each one of them, and if so, what is it?

When I duplicate a board thru the UI, it offers me the choice of duplicating the ‘structure, items & updates’, which allows me to duplicate the board with all the data. When I try with the API, it seems that the updates are not duplicated, and so my new board doesn’t have any of the data that I added as updates. Is there any way to duplicate the board via the API with the updates information in there?

Hi, How to work with items_by_column_values for search by email user, I thought it would be something like that : items_by_column_values(board_id:12346, column_id:123456,column_value:‘test@email.com’){id name column_values_str}} Thank you

Hello, I was wondering what the best query would be for retrieving all of the items from a board. I’d also like to see specific columns and the updates associated with the items. Thanks, Dan

Hello, I am trying to use the API to query all items with a value within a column. Even though I expect over 100 items as a result, I only get 3. I’ve tried this when I set the column type to “Status” and “Text” and I received the same result for both. However, when I filter for the same value on the web app, I get the expected amount of over 100. Is there any other debugging that can be done to find the root cause of this issue?

where colum1 = value1 and colum2 = value2 query { items_by_column_values( board_id: 1234567890, column_id: "status", column_value: "Done" ) { id name column_values { id text value } } items_by_column_values( board_id: 1234567890, column_id: "status2", column_value: "Reviewing" ) { id name column_values { id text value } } }

Hi there, I am trying to get items by timeline column, however using the query below I do not get anything back. I have tried multiple things including with the column value I got back from the items (ids[xxxxx]) query. What am I missing? query { items_by_column_values ( board_id: 499053030, column_id: "timeline", column_value: "{\\"to\\":\\"2020-11-06\\",\\"from\\":\\"2020-11-02\\"}" ) { id name } }

Hi Monday Team, I’m using monday-sdk-js in my board view app and seems like notice messages are broken at the moment.GitHub I’m seeing the following error for all types of notice messages. The sdk hasn’t been updated recently though. I’m not sure why I am getting this. components-f77bf2ae18fe889371af.js:formatted:12319 Uncaught TypeError: ({(intermediate value)(intermediate value)(intermediate value)}[e] || a) is not a function at D.execute (components-f77bf2ae18fe889371af.js:formatted:12319) at D.receiveMessage (components-f77bf2ae18fe889371af.js:formatted:12051) Any help would would be greatly appreciated. Thanks, Uday.

The monday client SDK is broken on mobile monday.execute(‘confirm’) doesn’t fire, and doesn’t handle the promise steps to reproduce: create a monday app use the sdk to call monday.execute(‘confirm’) observe that the promise is not returned and your app is broken is there a doc or post where we can track ongoing issues with the sdk on mobile?

Hi there, I used for the first time the new concept of “App versions” in Monday. I have created a new version, then a new build in the specific feature with a different URL than the previous version and then I’ve made the version live. However, when I go to my production app, I still see that Monday is fetching the iframe source from the old URL, not the new one I have set to the new version. Is this a cache issue? How do I make sure that users are getting the new URL of the latest version? Thank you.

Hello, I Tested in playground one mutation for updated column in board , when i used graphql not working, my response request is undefined mutation { change_simple_column_value (board_id: 1320360345, item_id: 1338898345, column_id: "texto9", value: "dsfsdfsdfds") { id } } IDs Modificates GraphQl with node.js query = mutation ($board_id: Int!, $column_id: String!, $item_id: Int!, $column_value: String!) { change_simple_column_value (board_id: $board_id, column_id: $column_id, item_id: $item_id, column_value: $column_value) { id } } variables { board_id: 1320360345, column_id: 'texto9', item_id: 1338898345, column_value: 'oioioioiio' } this.mondayApi.api(query, { variables });

I wanted to know if there is any limitation in the creation of subitem, I need to create 57 subitem, create normal up to subitem 53, then return the following error: { errors: [ ‘Not Authenticated’ ] } This is the mutation i’m using: const query = mutation { create_subitem (parent_item_id: ${itemId}, item_name: "${nomeSubItem}") { id, board { id } } };