API & Apps framework

First off, the following closed thread is related and it would have been nice to comment there: Date format of activity_log.created_at field monday Apps & Developers Hi, I’m building an integration and I cannot see how to convert the activity_log.created_at field from an integer to a date. Cannot find anything in your KB, nor online in general. An example of a returned “date” field is “15

I’ve noticed when using change_multiple_column_values with a column that doesn’t exist, instead of registering an error or simply doing nothing, it creates that column and populates it. How do I prevent this? I want to make sure that only existing columns are updated.

I have created a custom app in order to use a custom workspace template. I have created a sample workspace template as a feature in my app and installed the app to my organizations Monday.com account. However, I cannot find the workspace anywhere. Where does the workspace template appear?

I’m trying to create a custom trigger but I can’t put it in the frame, I haven’t used this tool much could someone help me? trigger:

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: {

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

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: 'Nu

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)