Welcome to the new monday developer community

10 months ago

Home
Community
General
API & Apps framework

API & Apps framework

Discussions category for everything related to app development on top of monday.com

3,488 Topics
13,553 Replies

When you subscribe we will email you when there is a new topic in this category

3488 Topics

Most replies

Most views

Newest first

pepperaddictParticipating Frequently

posted in API & Apps framework

Monday API SDK Not Authenticated or Graphql validation errors

Hi! I just started the quickstart guide and wanted to start querying right away, but instantly hit a wall with GraphQL. BTW I love graphql and use it for my own projects and was excited to see that graphql querying and mutations are allowed. When running monday.api(`query { users { id, name } }`).then((res) => {console.log(res)}) I get: Error: Graphql validation errors It said I didn’t need a token but I tried a token anyway I’ve tried monday.setToken('apiKey') and I get errors: ["Not Authenticated"] I also tried monday.api(query, {token: "apiKey"}).then((res) => console.log(res)) and I get the same error: errors: ["Not Authenticated"] I tested my token in monday.com and it works great. I can query just fine.

766316

5 years ago

dinithijParticipating Frequently

posted in API & Apps framework

How to use add_file_to_column in VB.NET (API Call)

Hi there. I’m using https://api.monday.com/v2 to create items from my VB.NET code. I was managed to do that without any problem. Now I need to upload some files to monday.com using APIs. I found this article Accessing and upload files using the GraphQL API. But couldn’t find any VB.NET or C# examples for add_file_to_column. Can somebody share a VB.NET or C# code sample for the add_file_to_column API call? Thanks in advance. Din

65458

5 years ago

joannetehNew Participant

posted in API & Apps framework

Monday Apps for SAP integration to monday.com

Is there any existing monday apps that we can allow the use of SAP to integrate with monday.com?

56332

5 years ago

ChrisBunaParticipating Frequently

posted in API & Apps framework

Files from Podio to Monday

Hi! I am hoping someone has done something similar as I am having trouble. I have a client I am supporting to move from Podio to Monday.com. I am getting stuck on what’s the best way to pull the attachments and files in Podio to then attach them to the proper item in Monday. Any ideas or suggestions would be great!!!

17757

5 years ago

kfogartyParticipating Frequently

posted in API & Apps framework

Mutable link to columns, etc. (validation as well)

Can you update link to columns through API v2? It would be nice if there were automation’s that if column values were empty, we could provide notification at a minimum. Thoughts? Doable now or is there a potential timeline for functionality like this. When I started with the Monday product; I would have thought it was a more mature platform. Don’t get me wrong there are a lot of great features, but there is lots of typical features that are still non-existent. Automation’s need to be beefed up as quickly as possible. Thanks…

34885

5 years ago

spbNew Participant

posted in API & Apps framework

Querying with large limit is resulting in errors

simple query: { “query”: “{items(limit:50000){ name state board {id} group {title} column_values { title text } }}” } mentioned below is the error. I don’t see this when I query with lower limits like 1000. Is there any max cap till which I can query?? <html> monday.com is having some technical issues @font-face { font-family: Roboto; font-style: normal; font-weight: 300; src: local("Roboto Light"), local("Roboto-Light"), url(data:font/woff2;base64,d09GMgABAAAAACmQAA4AAAAAURgAACk5AAEAAAAAAAAAAAAAAAAAAAAAAAAAAAAAGoFOG5JCHDYGYACHDBEMCvRE3SMLg1oAATYCJAOHMAQgBYJ8ByAbpkIF7Ng0sHEA9uDsckZF2RRNBP9fEjgZQ6rxe01YhItQqVQqtbZKo6NSLXshCcvuamYvk1vBgLu/bcUlFh3Hac1oktcuX/oxUb\\ .......and so on

28658

5 years ago

SV_LaiaNew Participant

posted in API & Apps framework

Creating drop downs with default option

Hi everyone! 👋 I want to create drop down with default options, I have tried with defaults option but it is not working. Would anyone be able to help me out? 😁 Steps to reproduce Embed the SDK in an app Call mutation { create_column(board_id: <bordId>, title: "DropDown 3", column_type: dropdown, defaults: "{\\"labels\\":[\\"My label\\"]}") { id } } See the request fails Only create column without any default label Expected behavior There should be new column with default value which passed in default labels. Cheers!

18192

5 years ago

akashubNew Participant

posted in API & Apps framework

Google Sheet Script Integration to create item

I have tried to code in google script editor and i am not able to what is the issue is the query the code is pasted below. function makeAPICall(key, query) { var url = “api.monday.com/v2”; var options = { “method” : “post”, “headers” : {“Authorization” : key,}, “payload” : JSON.stringify({“query” : query}), “contentType” : “application/json” }; //Logger.log(options); var response = UrlFetchApp.fetch(url,options); Logger.log("API results: " + response.getContentText()); //return response; } function getValueMonday(){ var mondayAPIkey = “xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx”; var boardID = 457712781; var query = “mutation{create_item(board_id:457712781, item_name:‘name’){id}}”; var worked = makeAPICall(mondayAPIkey, query); Logger.log("Pulse ID returned was " + worked); } Th

31771

5 years ago

Eric_MSINew Participant

posted in API & Apps framework

Change_column_value getting Internal server error 500 in test environment

Was trying to isolate an issue with Multiple column changes so limited to testing a single text column change in monday.com mutation {change_column_value (board_id: xxxxxx, item_id: xxxxxx, column_id:"waterbody_1" value:"{\\"testing\\"}") {id} } I still get the error { "error_message": "Internal server error", "status_code": 500 } Is there a way to get more details on the 500 error?

28072

5 years ago

mcdParticipating Frequently

posted in API & Apps framework

Escaping Accents via API in Powershell - Encoding Issue?

Hi! I have automated (or am attempting to create items in a board) using a Powershell script. The item name is based off of data from a SQL Server query. It so far works perfectly well, except for the fact that accents (é,è,à, etc) cause trouble when sending the webrequest. $url = “https://api.monday.com/v2/” $hdr = @{} $hdr.Add(“Authorization” , “Secret_key!”) $hdr.Add(“Content-Type”,“application/json; charset=utf-8") ###This mutation will NOT work: item_name = é $bodytxt ={“query”:“mutation{create_item(board_id:1234,item_name:"é "){id}}”}’ ###This mutation will work just fine: item_name = e $bodytxt ={“query”:“mutation{create_item(board_id:1234,item_name:"é "){id}}”}’ $response = Invoke-WebRequest -Uri $url -Headers

41045

5 years ago

abalest14New Participant

posted in API & Apps framework

API v2 - change people column error 500

Good morning, i am trying the api v2 from “the try it yourself” editor, sending this mutation: mutation { change_multiple_column_values (board_id: xxxx, item_id: xxxxx, column_values: “{"stato": {"label": "Working on it"},"timeline":{"from":"2019-06-03","to":"2019-06-07"},"data":{"date":"2019-06-03"},"persone":{"personsAndTeams":[{"id":xxxxx,"kind":"person"}]}}”) { id } } i get back an internal server error code 500, if i remove this part: ,\\"persone\\":{\\"personsAndTeams\\":[{\\"id\\":xxxxx,\\"kind\\":\\"person\\"}]} then it work fine. where is the mistake? thanks

27667

5 years ago

AetherisNew Participant

posted in API & Apps framework

Integrating monday with Wordpress

Hi all, Im looking to integrate Monday’s API with wordpress. The aim is when a monday item is created in a board copy the ID of the item. Move over to wordpress place the ID into a wordpress post and when the user saves that post as a draft it updates the status of monday based on the Monday ID. I have a rough idea on how to do this but does anyone have some good solutions to tackle this? Currently working with GraphQL and Gatsby to work with API. Thanks all, Ben

61565

5 years ago

amit.lzkpaParticipating Frequently

posted in API & Apps framework

Create item with column values returns 500

Hi I am trying to create a new item with values through the API, but it returns a 500 error. The columns is of a text type. I am following instructions from the API Reference. Did I get something wrong? Thanks.

17723

5 years ago

robmonday.com Partner

posted in API & Apps framework

Really slow Monday v2 APIs using Node.js

Hi all, we perform some queries and mutations using Monday SDK on Node.js in an app installed on Firebase. We are experiencing extreme slowness. A simple webhook request -> Monday query -> some calculations -> Monday mutation can take several seconds (sometimes more than 10 seconds) from when the user changes a value in a board using his browser and sees the changes. In our logs we see that a single query can take 2 or 3 seconds to retrieve a result. Any hints on how to improve speed? Thanks for your help.

17523

5 years ago

morhriveionParticipating Frequently

posted in API & Apps framework

Timeout and data return issues when requesting large queries

I’m running into an interesting issue while performing heavy queries. If the call takes longer than 60 seconds, I get one of two responses from the server. Both are errors, and both are in HTML body. One is a general 504 timeout warning. The second one is returned the page text below. After watching the timing, this happens at exactly the 60 second mark, so the timeout seems to be 60 seconds from the server. I’m not seeing this mentioned anywhere on the documentation. –returned page

1322510

5 years ago

willemdewulfNew Participant

posted in API & Apps framework

Backup/Sync to Google Sheets

Dear Monday Community, Is there a need for a simple & robust backup solution for Monday.com? My company has built an easy & secure backup solution for Podio.com that syncs their data to a readable format in Google Drive. This transparent approach has received lots of praise from the Podio community and we’re keen to do the same for Monday.com. Our users use our backup tool for 3 main reasons: Extra level of disaster recovery Extra restoration capabilities (>30 days) Business continuity during service outages We believe that an independent backup solution would add e

25163

5 years ago

aflaxNew Participant

posted in API & Apps framework

Do i need to build an app?

Hi, Not sure this post belongs here… I have a board that collects manufacturing data https://view.monday.com/206785215-09de7b40656ee79c5947f16457a580cb I would like to create a dashboard that automatically shows: Total Meters and total KG for - yesterday, last week, last month This cannot be done using dashboards, as dashboard don’t support automatically filtering the data (by day, week month) or showing data from “yesterday” so, my question is, how can i create a custom automation that creates such a a dashboard? thanks

12791

5 years ago

basdebruinCommunity Expert

posted in API & Apps framework

Duplicate item does not trigger "When column changes"

I have an app with a trigger “When column change” and a custom action. The action is NOT triggered when an item is duplicated. Is this expected behavior?

14473

5 years ago

Nick94New Participant

posted in API & Apps framework

Unable to get formula column values:

As the title suggests, I am unable to get a formula column value using v2 APIs. The code I am using is as follows : Is there something I am missing?

681310

5 years ago

barrycoxParticipating Frequently

posted in API & Apps framework

Setting group position when you create it

this is similar to Define group color during group create so i suspect the answer is the same. i need to be able to set the position when i create a group (and the color too). currently new groups pick a random color and are created on TOP of the board. something like mutation { create_group ( board_id:xxxxx, group_name: "New Board", **position: xxxxx, color: xxxxx**) { id } } or much BETTER, add a mutation for update_group that allows those to be set. that way we could set color and position on an existing group (or freshly created one) without needing to delete and recreate a group.

17291

5 years ago

kai_devNew Participant

posted in API & Apps framework

When I use mutation query, sometimes some items will be null

Hi there! I’ve been using GraphQL API for 3 months. I love the monday.com! I probably found a bug in mutation (create_item and change_column_value). When I use mutation query, sometimes some items will be null. Reference: Screenshot - a9cc1089a290e639bee15d6e13d01b71 - Gyazo My Node.js code is below, const mondayItemPost = async () => { const items = () => { let obj = {} for (let mo of mondayAry) { obj[mo.id] = mo.value } //in the end, set initial status obj['status'] = {index: 1} return obj } const data = { query: `mutation ($boardId: Int!, $groupId: String!, $itemName: String!, $columnValues: JSON!) { create_item ( board_id: $boardId,

19121

5 years ago

krismikeNew Participant

posted in API & Apps framework

Template to Query Value of Columns selected from a column field

Anyone here that can share a template on how Tto Query Value of Columns selected from a column field? I am trying to create like an array of blocks like this Column-01 - Item 01 Column-02 - Item 01 Column-01 - Item 02 Column-02 - Item 02 and so on…

13852

5 years ago

ArnoNew Participant

posted in API & Apps framework

Best way to get all the sub-items from a parent item

Hey all, I’m new to GraphQL and the Monday API. I’m trying something out for the Hackathon and wonder what the best way is to get all the sub-items from an item? I’m need a ton of times so performances does matter. I saw you need to get the item ID of the parent item to get the sub items via monday.api. Anyone wants to point me to the right direction? Thanks!

52067

5 years ago

DhruvNew Participant

posted in API & Apps framework

Regarding number of participant in Monday App challenges

Hello everyone, Is their any constraint in the maximum number of people in the team?

12551

5 years ago

hiroTochigiNew Participant

posted in API & Apps framework

Ngrok does not work for me

I follow the quick-start tutorial (https://monday.com/developers/apps/quickstart-view/) I can run the app on local environment (localhost) Also, I can build the app and upload it. However, I cannot generate the ngrok address, so it is so inconvenient to develop the app. The below pictures are my ngrok status page.

79493

5 years ago