API & Apps framework

New to Monday.com, and I’m trying to use the API to create an item. I’ve tried with SQL server and PowerShell and always get a 500 error back. I’ve read, and tried the code from this post: Using PowerShell to create an item in Monday.com? with no luck. I’ve tried and re-tried using different formatting, but I’m sure the issue is with $query below (tried with escaping the quotes etc.). $apiKey = “xxxxx” $boardId = “1234567890” Set the header with your API key $headers = @{ “Authorization” = $apiKey “Content-Type” = “application/json” } Define the query to create an item $query = " mutation{ createItem1: create_item (board_id: 1234567890, item_name:““Test Item 1"”) { id name } }” Execute the request $response = Invoke-RestMethod -Uri ‘https://api.monday.com/v2/’ -Method Post -Headers $headers -Body $query Any help would be appreciated. This seems like it should be pretty easy, but I cannot get it to work and the error isn’t much help. I can query the board (return data) so I know the au

Referencing Connect boards columns. Today to mutate the linked items, you provide item IDs. However, item Ids passed to the mutation must be of type Int not type ID. This means we cannot directly pass the values we get from queries to the mutation. If we’re creating items and need to link them, we get the item ID back as string ID and need to coerce those to Int to connect the item for example. Since its conceivable one day that using string IDs will become mandatory (such as the addition of word characters,) the sooner this can get resolved the better (maybe even as a hotfix to 2023-10 so we can address it during conversion to API 2023-10) I have to assume this also applies to dependency columns as well. I have seen several posts about this already because documentation has stated item IDs are now type ID - however in this use case the inputs for the mutation were not updated to ID and left as Int.

Hi, I can’t set up a webhook. I use code from here:monday API docs from flask import Flask, request, abort, jsonify app = Flask(__name__) @app.route('/webhook', methods=['POST']) def webhook(): if request.method == 'POST': data = request.get_json() challenge = data['challenge'] return jsonify({'challenge': challenge}) # print(request.json) # return 'success', 200 else: abort(400) if __name__ == '__main__': app.run(debug=True) But it didnt work. For url generation i use ngrok. I see challenges in ngrok: { "challenge": "UEkR7-4VSXqp34ve39ghi8qLJew1qsjEI69Y2TLfvuq6SDAEJ-z88gZHHW3yPBHSV9HfwGOeLlAOwlp7qzAIUQ" } But ngrok terminal: POST / 404 NOT FOUND And python terminal: * Serving Flask app 'app' * Debug mode: on WARNING: This is a development server. Do not use it in a production deployment. Use a production WSGI server instead. * Running on http://127.0.0.1:5000 Press CTRL+C to quit * R

I followed all of the Quick Start App Integration steps but my terminal keeps getting stuck on [nodemon] starting node ./src/app.js. I saw other people were having issues with this and were told to edit a line in the package.json file to this “expose”: “ngrok http 8301”. I looked into the package.json file but dont see anywhere where the “expose” line is. Below is a screen shot of the Package.json file that was created in the quicktart-integrations folder.

Hello, I’ve been trying to integrate Speakatoo for Text-to-Speech conversion, and while the Speakatoo API works fine on Postman, I’m encountering issues with the integration in my application. I’m curious if anyone else has experienced a similar situation or has insights on troubleshooting this. Your assistance would be greatly appreciated!

Hello. I am writing a component library based on Monday’s UI library for customized use in my apps. I am facing an error importing monday-sdk and bundling it will rollup. Here is my rollup config: import typescript from "@rollup/plugin-typescript"; import {nodeResolve} from "@rollup/plugin-node-resolve"; import commonjs from "@rollup/plugin-commonjs"; import {terser} from "rollup-plugin-terser"; import postcss from "rollup-plugin-postcss"; const config = { input: "src/index.ts", output: [ { file: "dist/bundle.cjs.js", format: "cjs", }, { file: "dist/bundle.esm.js", format: "esm", }, ], external: ["react", "react-dom", "monday-sdk-js"], plugins: [ nodeResolve(), commonjs(), typescript({ include: ["*.ts+(|x)", "**/*.ts+(|x)"], tsconfig: "./tsconfig.json", }), terser(), postcss({extensions: [".css"]}), ], }; export default config; in my file I just imported it // container.tsx import mondaySdk from

I am successfully using the monday API to load Updates to specific items in monday.com from MS/Excel. However, I can’t work out how to edit the text in an existing Update. I am capturing the Update ID when I create it in my spreadsheet but I can’t see how to use this to edit the text. Any ideas?

API-Version: 2023-10 query { boards (ids: 12345) { items_page (limit: 10) { cursor items { id name created_at updated_at state group { title deleted } columns: column_values { column { id title } text value } subitems { id name created_at updated_at columns: column_values { column { id title } text } } } } } }

Are there any stable examples of utilising the API to create an item in a board using PHP. The API Quickstart for PHP seems to have issues in the code, I think around the arrays.

Hi, I have a board with a column "relations" where the column value is an array of ids I want to set the value of another column "relation_count" based on how many ids are in “relations” value. relations is changed -> set relation_count I wonder if and how to set an automation of that nature.

Hey Monday community, I would like some feedback on this gql query import { gql } from 'graphql-request'; export const GET_VOLUNTEERS_GROUPED_BY_LANGUAGE = gql` query GetVolunteersGroupedByCanSpeakLanguage( $boardId: ID! $groupId: String! $langColId: ID! $capacityColId1: String! $capacityColId2: ID! $limit: Int ) { boards(ids: [$boardId]) { groups(ids: [$groupId]) { items_page( limit: $limit query_params: { rules: [ { column_id: $langColId, compare_value: [null], operator: is_not_empty } { column_id: $capacityColId2, compare_value: [8], operator: lower_than } ] order_by: [{ column_id: $capacityColId1, direction: asc }] } ) { items { id

When I listen “events” by SDK, and then change column values for different types of columns - the “change_column_values” always triggers as it should, but except for the column with type = “name”. Is it a bug or how can I do it in another way? Method I use: monday.listen('events', callback)

The festive season is here, but your workload hasn’t gotten the memo! To assist you in balancing holiday tasks, New Year’s resolutions, and work obligations, we’ve handpicked the top 9 Monday.com apps designed to make this holiday season a breeze Would love to hear your thoughts! Enjoy​:snowman:🍧 blog.sundae.so

Hi team! There is any option to retrieve all the forms urls of an account through the api? or in any other way? Thanks!

Hi there, I’m working on the Timeline column. To implement a function in my app, I need to get the item by timeline column with a specific day, a specific time time range. I had tested some cases, and monday.com API already supports so well with operator: between. See: items_page( limit: $limit query_params: {rules: [ { column_id: $timelineField, compare_value: ["2023-11-19", "2023-12-02"], compare_attribute: "START_DATE", operator: between }, { column_id: $timelineField, compare_value: ["2023-11-19", "2023-12-02"], compare_attribute: "END_DATE", operator: between } ], operator: or } ) However, it doesn’t seem working well on greater_than_or_equals, greater_than, lower_than_or_equals, and lower_than. It still works fine with other defined compare values such as "TODAY" , "TOMORROW",. But what I need is a special day. so this is the query I

I am coding an api in C# .net. Here is a query I send to Monday.com which works just fine and retrieves the items: {“query”: "{boards (ids: 5493163446) { items { id name state } } } "} I have patterned create_item after that but all of these seven mutations result in a Server Error 500. This is my first create so I could use some basic help, for example, do I need to use the word query or just mutation and is the mutation in quotes or curly braces, etc. I have removed any column values to try and simply the query as much as possible - could it be complaining because there are no column values, just the name? {“query”: "mutation: create_item (“board_id”: 5493163446, “group_id”: “new_group”, “item_name”: “This item imported programmatically”) " { id } } {“query”: "mutation {create_item (“board_id”: 5493163446, “group_id”: “new_group”, “item_name”: “This item imported programmatically”) } " { id } } {“query”:“mutation { create_item (board_id: 5493163446, group_id: “new_group”, item_name:

Hey folks, I want to say the sandbox is an AMAZING tool in exploring and composing my queries. I am attaching here a screenshot showing a minor css bug where in use cases like my own where I want a bit nuts with the amount of queries a scroll bar appears and then using it is a bit hard as the querybuilder window overlaps a bit with its position. Here’s a proposed fix:

Hi, It seems as though there has been a change with the monday-sdk-js library or integrations recently. We have been using the openItemCard action to open item cards for various items. monday apps framework We use this sometimes in board views, sometimes in dashboards, and sometimes in item views. We’ve noticed that currently the openItemCard action is only working when this is called within a board view, and for an item that exists on the current board. For all other scenarios when the action is called on either a dashboard, an item view, or requesting an item from a related board we get the following error. { "res": { "method": "execute", "data": { "success": false, "message": "Item <item_id> is not in the context of the current board undefined" }, "requestId": "..." } }

Hi, I have one query, in migration guide of 2023-10 it is written that “Migrate apps to use the API correctly”, so we are using monday.com platform only so any change required in app here from our end? Reference link:monday API docs

Hi everybody, On a board, we have a column with 3 values for example red; green and blue. Users can only select one value. Now we want to add a new value “pink” to our list value using the playground . Is there a simple way to add this new value and not update an item with this new value with create_labels_if_missing option !? And how to delete a value from a column list ? For example i do not want blue value anymore. Thank you

Hello, I noticed in the documentation (Mirror) that you can include a fragment in your query, as shown in the example: query { items(ids: [1234567890, 9876543210]) { column_values { ... on MirrorValue { column id } } } } However, when attempting to retrieve information with the fragment on a Mirror column that is not connected to a board, an error is returned: { "error_message": "Internal server error", "status_code": 500 }

The new API version (2023-10) now only gives a summarized version of the time-tracking log. It does not give individual users.

We are ‘citizen developers’ and new to Monday. We created two simple python API calls this spring that were working perfectly to return a really small board - until a week (or so) ago. Now we’re trying to update and running into issues. We got the call working for the simplest of our calls - the one where we don’t need mirrored column values, etc. But implementing the fragments for the display_value for data from a mirrored board is problematic. We have tried a multitude of variations in different versions in both the developer and the regular API playgrounds. Our current non-working version of the query looks like: query { boards (ids: 4304082965) { name id description items_page { items { name column_values { … on MirrorValue { display_value } } } } } } } What are we missing?

I would appreciate some details on the various filters supported for the date type column.monday API docs "TODAY", "TOMORROW", "YESTERDAY", "THIS_WEEK", "ONE_WEEK_AGO", "ONE_WEEK_FROM_NOW", "THIS_MONTH", "ONE_MONTH_AGO", "ONE_MONTH_FROM_NOW", "PAST_DATETIME", "FUTURE_DATETIME", "UPCOMING", "OVERDUE", "DONE_ON_TIME", "DONE_OVERDUE", "$$blank$$" What does `“$$blank$$” mean? / How is it used? How is "OVERDUE", "DONE_ON_TIME", "DONE_OVERDUE" used? The date column does not seem to have this information. If you use a filter like “TODAY”, how is the comparison done? Like does it find all date values within the “today range” for the user’s specific timezone or all “today” values in UTC? Is there any way to filter with a specific date or date and time. Like query_params:{rules:[{column_id:"date1",compare_value:["2023-11-16 05:00:00"],operator:any_of}]

Hello, I am currently in the process of moving all the boards for one of our clients from the American server to the European server. Unfortunately, in this scenario, the “Cross account copier” cannot assist. Therefore, I am using an integration via N8N using the Monday.com API. Unfortunately, I am facing an issue—I would like to transfer the updates for all items. The creation and assignment to items are successful, but unfortunately, the person assigned at the start of the update is not the same when it arrives on the European server. This is because the API does not provide the option to change the user with their email or ID. The update is automatically assigned to me. Do you have any ideas to suggest for allowing the assignment of the update to someone other than me, whether it’s by their ID or email? Thank you in advance for your responses. Best regards, Delépine Tom.