Skip to main content

API & Apps framework

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

  • 3,355 Topics
  • 13,321 Replies
3351 Topics
R
rkaplanNew Participant
posted in API & Apps framework
GraphQL query for all data in account

What would be the GraphQL syntax to retrieve all data in my account - boards, IDs, items, subitems, anything else in the account?

9601
Matias.Monday
M
martinsmithNew Participant
posted in API & Apps framework
How to list apps using API

I am trying to list by API the apps installed in my Monday account. Looking at the network, I see the call to the backend is: https://slug.monday.com/apps with the cookie as the authentication method. This works great for me. Now I am trying to do the same on behalf of an app. I created an app, and gave it all permissions at Set Up Permission Scopes. I can’t get any response using the app token I got. What I tried to do instead, is running the graphql at https://api.monday.com/v2/ with the query: query { apps { created_at } } but then I got: { "errors": [ { "message": "Permission Denied! Your token doesn't grant access to apps:read" } ], } When trying to add apps:read to the consent link, I get: {"error":"invalid_scope","error_description":"Invalid scope param"} Is there any other way to list the apps?

15301
Matias.Monday
Y
Yan1New Participant
posted in API & Apps framework
Excel power bi query

I am trying to load a board including the subitems to the excel from Monday. I’ve used the following code to do so and recieved the following error: Code: [ Headers=[ #“Method”=“POST”, #“Content-Type”=“application/json”, #“Authorization”=“Bearer " & Key ], Content=Text.ToBinary(”{““query””: ““query { boards(ids: " & Board & “) { items { name, updated_at, group { title }, columns: column_values { title, text } subitems { name } } } }””}”) ] ), Data = Table.FromList(Json.Document(Source)[data][boards]{0}[items], Record.FieldValues, {“Title”, “UpdatedAt”, “Group”, “Columns”}), #“Monday” = Table.FromRecords(Table.TransformRows(Data, each List.Accumulate([Columns], [ Title = [Title], UpdateDate = [UpdatedAt], Group = [Group][title] ], (state, current) => Record.AddField(state, current[title], current[text]) ) )) Error: DataFormat.Error: There were more columns in the result than expected. Details: Count=4 Thank you in advance.

13611
Matias.Monday
S
sgraflundNew Participant
posted in API & Apps framework
User Defined Fields in Items

Is there a way to retrieve custom user defined fields from items in the API calls?

15092
S
basdebruin
basdebruinCommunity Expert
posted in API & Apps framework
Pagination in combination with shortLivedTokens

Hi fellow developers I am trying to get my head around this. I need to query all items and subitems in a given board. Due to the amount of items and the level of nesting the query will hit complexity very soon. I want to use pagination to query in smaller pieces but I have to wait for the next minute (reset of complexity) and I am using shortLivedTokens to access the API. If I just wait for 1 minute the shortLivedToken will not be valid anymore. At this moment the query takes place during the subscribe of an integration app with a custom trigger. I don’t see a way to “refresh” the short lived token as I can’t respond with non-200 (no retries will be done from monday). I can redesign in a way the query takes place in an action so I can respond with non-200 and wait for the retry (which will contain a new shortLivedToken). The challenge with that is to keep track of which page is required. Any ideas are welcome.

14655
Matias.Monday
N
nicospbrNew Participant
posted in API & Apps framework
HELP Duplicating board with API

Hi, I am trying to duplicate 3 boards every 2 weeks (so not running into the limit) using python. Running the code does not yield any error but the board is not duplicated. Any ideas what I should do? def duplicate_board(board_id, name): query = 'mutation ($name: String!) { duplicate_board(board_id:'+str(board_id)+', duplicate_type: duplicate_board_with_structure, board_name: $name) {board {id} }}' vars = { 'name' : name } data = {'query' : query, 'variables' : vars} r = requests.post(url=apiUrl, json=data, headers=headers) # make request print(r.json())

10672
N
kallikakis
kallikakisParticipating Frequently
posted in API & Apps framework
Column ids - difficult to handle figuring out for each column

Is it just me or the way Monday handles column ids is super difficult to manage? I have the graphql mutation running and every time I have to guess what is the columnId for the specific column I need to update. Not cool that I have to open the developer tools, inspect the network tab and then find the column id of my column. Isn’t there a way to avail this on the UI? I can’t find a way to create subitems’ columns which could have sold the issue but still a lot of overhead for what should have been a pretty single thing to have

11816
kallikakis
jsararas
jsararasParticipating Frequently
posted in API & Apps framework
Create an Item and Subitems in one move using GraphQL mutation

I have a flat table with row data. From that, I want to create parent items and their respective subitems. I made up a store example. I want to track the things I receive for my store in a board where the item (parent) is the Box, and in it can be one or multiple different items (subitems). I’m looking for a starting point or suggestions- do I first create the items, store the parent item ids somewhere, then loop back and create the subitems for each? Or can I do it all ‘in one move’ as I iterate through the list. I’m actually working in VBA but Python code would be helpful too. Here’s a graphic: Thanks!

14321
basdebruin
M
MaximusNew Participant
posted in API & Apps framework
Zapier changing statuses to numbers

Hello, I have been seeing this a lot recently where zapier is changing statuses in monday to numbers and I am not sure why. I was wondering if anyone has seen this before?

8253
M
S
SeverynParticipating Frequently
posted in API & Apps framework
Nested options list (like in Gmail integration)

How can I build a custom field with the nested options list like in the Gmail integration.

13821
Matias.Monday
S
SeverynParticipating Frequently
posted in API & Apps framework
Populate "People" column value using users emails

Background: We have integration which creates an item on the Monday board when action is created in our platform. It is using Graph QL API to achieve this. Use case: We want to populate people columns on the Monday with created by and assigned to users but we know only emails of these users. Problem: According to documentation the user ids should be provided to be able to populate “people” column value. https://api.developer.monday.com/docs/people The apps framework docs say that you can populate people fields by providing only emais. https://apps.developer.monday.com/docs/dynamic-mapping#examples-of-each-field-type Is there way to populate “People” column value by posting only user email?

20647
S
M
MeneghiniParticipating Frequently
posted in API & Apps framework
Query to Return Column Value based on Another Column's value

Is it possible to merge two queries into one? I want to return the column values for “Name” and “Email_Address” where the column “batch_5” = “70”. this would be merging the queries for items_by_column_values and items? This is the query I have but it returns all the columns: query { items_by_column_values (board_id: 1234, column_id: “batch_5”, column_value: “70”) { name column_values { id text } } }

11072
M
R
rajnialiNew Participant
posted in API & Apps framework
Filter output by a specific status value

How can I print only the items in a board with the status marked as “Done” using Python? Here is my current code-> import requests import json import pprint apiKey = “MyApiKey” apiUrl = “https://api.monday.com/v2” headers = {“Authorization” : apiKey} query2 = ‘{boards (ids: 2257165976) { name items { name column_values {title value text} } } }’ data = {‘query’ : query2} r = requests.post(url=apiUrl, json=data, headers=headers) # make request pprint.pprint(r.json(), width=400)

14000
R
C
cliff.leavittNew Participant
posted in API & Apps framework
Monday API change_multiple_column_values not working

Hello, I have been working with the Monday API with some success. I have run into difficulty with change_multiple_column_values. Here is the error: message: “Parse error on “: {” (STRING) at [1, 107]”, the character at 107 is a semicolon I have a working query in POSTMAN mutation { change_multiple_column_values (item_id: 22222222, board_id: 1111111111, column_values: "{\\"date4\\": {\\"date\\":\\"1993-08-27\\"},\\"text9\\": \\"Barney Rubble\\",\\"text0\\": \\"Corporate\\",\\"link\\":{\\"url\\" : \\"https://support.company.com/app/itdesk/ui/requests/109348000039391139/details#\\", \\"text\\":\\"Original Request\\"} }") { id } } So I took that POSTMAN query and escaped it to use in a C# console app {\\"query\\":\\"mutation {change_multiple_column_values (item_id: 22222222, board_id: 1111111111, column_values: \\\\\\"{\\\\\\"date4\\\\\\": {\\\\\\"date\\\\\\":\\\\\\"1993-08-27\\\\\\"},\\\\\\"text9\\\\\\": \\\\\\"Barney Rubble\\\\\\",\\\\\\"text0\\\\\\": \\\\\\"Corporate\\\\\\",\

18152
C
C
cokihimNew Participant
posted in API & Apps framework
Guide to localization in Monday apps

When building plugins for CMS like Wordpress, we usually use localization to cater to bigger market opportunities, is there any guide / best practices to utilize localization when building a Monday Apps ?

8881
Matias.Monday
alicemgray
alicemgrayNew Participant
posted in API & Apps framework
Need help for monday.com implementation

Can anyone help me in finding the best monday.com developers for implementation?

9962
Matias.Monday
G
gdacierNew Participant
posted in API & Apps framework
Can't see files added by add_file_to_column

Hi, I am trying to use the graphql API to add a file to a column. The query seems to work as I receive an asset ID in the response, but I don’t see the file in the item/column when I go on Monday.com. Furthermore when I query the asset to get the url and open it in my browser I see the following error : “SyntaxError: JSON.parse: unexpected character at line 1 column 1 of the JSON data”. Here is the request I am doing: curl --location --request POST 'https://api.monday.com/v2/file' \\ --header 'Authorization: SecretKey' \\ --form 'query="mutation add_file($file: File!, $item_id: Int!, $column_id: String!) {add_file_to_column (item_id: $item_id, column_id: $column_id, file: $file) {id}}"' \\ --form 'variables="{\\"item_id\\":2286426338, \\"column_id\\": \\"files\\"}"' \\ --form 'map="{\\"image\\":\\"variables.file\\"}"' \\ --form 'image=@"/home/gdacier/Documents/Myphoto.jpg"' Note that when I try to add the same file to an udpate using add_file_to_update it works : curl --location --req

12301
Matias.Monday
M
MeneghiniParticipating Frequently
posted in API & Apps framework
Export Board as Excel File Using API

Hello All, Is there a way to export a board with all the color fields and formatting using the API? From what I’ve read it seems I can only pull all the information via a query then create the excel file and format the fields using code. I want to make an API call that will give me the exported board as a file so I can upload it to Google Drive. Thanks for any help or ideas!

21031
basdebruin
S
SeverynParticipating Frequently
posted in API & Apps framework
How can I map to exact Status values?

Use case: Our platform has 4 fixed states for action item and when we syncing changes from our side to Monday it works well because Status column can support any values even when they are not created. Problem: users want to have them mapped to specific status values in the Monday. e.g. “Paused” in our platform would be equal to “Stuck” in Monday etc. Does Monday provides such possibilities? Also we are considering to sync changes from Monday to our platform and it will be the same issue.

26538
S
C
Carlos-iParticipating Frequently
posted in API & Apps framework
Automations, Webhooks

Hi guys, We have a problem, we think monday webhooks are down, no signal has arrived to our server , and automations does not work. Please help

9002
C
J
JorgemolinaParticipating Frequently
posted in API & Apps framework
Subitems Column Id

Hi Community, How to get subitems id columns in the playground any suggestions.

18054
J
L
lokishocrNew Participant
posted in API & Apps framework
Issue in prod not able to replicate in developer using published build

I have an issue with our app subitems template, I can’t replicate that in developer tho I’m using the published build. Any ideas what I can do? The problem is related with the workflow of presenting the options. If you want the specifics when deleting a subitem from a template, in developer I get the save template button and then the button option to apply the template. In prod, when I delete a subitem, I just get the apply template button. I can’t replicate that in developer even using published version.

15171
L
Sina
SinaParticipating Frequently
posted in API & Apps framework
Any way to check if Webhooks already exists?

Hello! Is there any way to make a query and check if there is any active Webhooks on a board I got? In the documentation I only found ways to create Webhooks (which I do) and delete Webhooks, but I would like to make a query and check if there are any active Webhooks so I don’t create them again if they exist. Anybody knows? 🙂 Thanks a lot!

19744
Sina
DanLiebeschutz
DanLiebeschutzNew Participant
posted in API & Apps framework
Getting the wrong board id in a web hook triggering when a subitem is updated

Hello! Something strange happens when my webhook receives some data from Monday. It gives me the wrong board id. This is the board id I’m getting: When actually the board id is: 2167071773 When I’m trying to put the board id I got from the web hook in the url, it redirects me to the correct board id. Thanks! 🙂

10533
DanLiebeschutz
M
Matthias1New Participant
posted in API & Apps framework
Get only columns and items with values

Hello, i’m trying to build an API call to get all time tracking information about all boards and all items to use them for a more detailed controlling. But currently I am faced with the problem of filtering out all the zero values. My Code: query queryname { boards { name items { id name column_values (ids: "zeiterfassung") { id value } } } } The result i get: "data": { "boards": [ { "name": "Board 1", "items": [ { "id": "2268502411", "name": "Subitem", "column_values": [] } ] } { "name": "Board 2", "items": [ { "id": "2066324479", "name": "1.Introduction to Sales Professional (15min)", "column_values": [ { "id": "zeiterfassung", "value": "{\\"running\\":\\"false\\",\\"duration\\":19800,\\"startDate\\":1642092461,\\"additional_val

18081
Matias.Monday

Badge winners

  • Bronze marketplace partner
    jbaizahas earned the badge Bronze marketplace partner
  • Bronze marketplace partner
    Gerdahas earned the badge Bronze marketplace partner
  • Bronze marketplace partner
    eazyBIhas earned the badge Bronze marketplace partner
  • Bronze marketplace partner
    sa07chinhas earned the badge Bronze marketplace partner
  • Bronze marketplace partner
    rselvarajhas earned the badge Bronze marketplace partner
Show all badges
Terms & ConditionsCookie settings