Skip to main content

General

-

3351 Topics
M
mjgsNew Participant
posted in API & Apps framework
Graphql query for all items in a board that have a particular column:value

I am using the following query to get all column values for a board: let jobsQuery = { boards (ids: ${cfg.jobBoardId}) { items { id name column_values { id title value } } } }; It’s running in NodeJS. It’s working great, returning all the items. I’d like to narrow the search to only return items that have a particular column set to a particular value. Based on the current dataset returned, it’s the data in ‘name’ that should be used to narrow the search. I tried the following: let jobsQuery = { boards (ids: ${cfg.jobBoardId}) { items (names: ${cfg.jobName}) { id name column_values { id title value } } } }; But that didn’t work, it just returns an empty list. What would I need to update my query to, so as to return the same data structure and columns, but only the subset that match name === cfg.jobName?

29854
M
H
handevNew Participant
posted in API & Apps framework
Move group to another board

Hi All, according to this guide we can move a group to another board. I want to know how can I do this with the API ? I checked the API docs but couldn’t find the matching API function. Thanks.

24497
H
V
ViewportNew Participant
posted in API & Apps framework
Automations with Workplace Templates (Apps/Developers)

Can we use automations to generate workspace template folders? ie A) We’ve made a pretty great chunk of boards/dashboards that live in a folder B) We can get users to generate these manually using Add Template OR C) We get users to enter an automation to create these on the fly as items get moved, people get assigned, etc. Data from the item goes into the folder name and various fields within the boards. eg A) Could be used for sales pipelines; sales person moves item to won > folder is create in a different workspace automatically called X project (name of item) > value of deal gets moved to project value and spread to finance boards and dashboards > project brief gets added as first group before predetermined structure > etc etc. Any ideas?

17514
V
B
BeauElliottNew Participant
posted in API & Apps framework
Finding column data using Column names and IDs

Hello, I’m trying to figure out how to properly query board data. Specifically column values. Is there another way to specify what columns you want to limit your query to? All I see currently is IDs…and those seem be very interesting in the return. I’m getting weird responses back (i.e. Text7, number45, timeline_1, timeline, dup__of_resource_name, etc.). These aren’t the same in each board I’m querying, even though the titles of the columns are very consistent. So while my boards “look” the same, I can’t filter/query them consistently to get the data I need to the above. If I could query by title (which seems that those could be made consistent) it would really help… Any ideas on how to modify this? Is there a way to do this? Am I missing something?

56676
B
H
HughAlexNew Participant
posted in API & Apps framework
Data upload from external database using python

I want to be able to query data directly from my database so that once a form is entered on my website its posted to my database and the latest lead information is then dumped to our CRM board in Monday.com. I cant seem to find a solution to help with this anywhere. I’ve read through the Python API tutorial but everything seems more geared towards pulling data from Monday as opposed to pushing data to Monday. Any help with this would be great.

28799
H
B
BRockoffNew Participant
posted in API & Apps framework
Need some help accessing item status

Hi - I’m new to Monday and am trying to use SyncHub.IO to query my data using PowerBI. It works great to have the Monday.com data in a relational format. My issue is around the text column in ColumnValue table. I’m trying to use the text column to identify the status of items. I get a highly usable set of values most of the time. However it appears a null value in text has multiple meanings - an item that has not been started yet and an item that was deleted. Do I have that correct? I need to know what has not been started vs. what is has been deleted. I looked at the IsDeleted field that that doesn’t seem to help. Thanks

12806
B
V
vpradoParticipating Frequently
posted in API & Apps framework
Working with API v2 and VBA

Hello, first time here! I’m starting to figure out how to update and get information from Monday boards on a Excel sheet using VBA. Checking out the API documentation, my first attempt was to retrieve the name of a specific board, but the name won’t appear on the response text from the html. This is what I have so far: Public Pass As Variant Sub monday() Dim monday As New MSXML2.ServerXMLHTTP60 Dim response As Variant Dim status As Variant Dim query As String query = " { ""query"" : ""{boards(ids: xxxxx){views{name}}}""} " With monday .Open "POST", myurl , False .SetRequestHeader "Content-Type", "application/json" .SetRequestHeader "Accept", "application/json" .SetRequestHeader "Authorization", mytoken .Send query response = .ResponseText status = .status & " | " & .StatusText MsgBox response MsgBox status End With End Sub For the response text I’m getting: {“data”:{“boards”

32059
V
D
ddarnellNew Participant
posted in API & Apps framework
V2 API: duplicate_board

Hi, The API documentation illustrates how to duplicate a board with structure only by setting duplicate_type: duplicate_board_with_structure. I need to duplicate the board along with its items and I can’t find in the documentation what value I’d use for duplicate_type: Does anyone know? Thanks!

10584
D
V
vpradoParticipating Frequently
posted in API & Apps framework
Working with API v2 and VBA - Parsing Mutation

Hello! I’ve been trying to work with API v2 and VBA. So far I’ve been able do connect to the server and query board fields and values. I’m now trying to creating items and changing column values using mutation, but haven’t had success yet. Hope someone could show me the way. My general code is: Public Pass As Variant Sub monday() Dim monday As New MSXML2.ServerXMLHTTP60 Dim response As Variant Dim status As Variant Dim query As String query = query With monday .Open "POST", myurl , False .SetRequestHeader "Content-Type", "application/json" .SetRequestHeader "Accept", "application/json" .SetRequestHeader "Authorization", mytoken .Send query response = .ResponseText status = .status & " | " & .StatusText End With MsgBox response MsgBox status End Sub When trying to change the columns values, I’ve tried querying the mutation in two different ways, getting different response texts and status. 1st try: quer

21643
M
mattfitzgerald
mattfitzgeraldNew Participant
posted in API & Apps framework
Accessing the ItemId in an Item View app

Hi community, I’m attempting to write a simple app to display information in an Item View. I started with the app described in the Quickstart guide and have compiled and run this little ‘hello world’ without problem. I’m now trying to access the ItemId of the Item that the Item View is connected to. I can access the “context” with something like this monday.listen("context", res => { // do something with res.data } but this just seems to store global app properties, not the ItemId that this is an Item View of. I haven’t been able to find much documentation about developing Item Views, I think they’re pretty new so a lot of the official documentation doesn’t mention them at all (like the Quickstart guide). They are listed here as one of the three app types. Thanks in advance, Matt

19325
mattfitzgerald
C
creinozaNew Participant
posted in API & Apps framework
MuleSoft Connector Integration

In my company we are MuleSoft partners. They provide an integration platform that has nearly 300 connectors available for integrating and interconnecting applications and more. These connectors are exposed through the marketplace that is Anypoint Exchange. At this time we want to create the Moday.com MuleSoft Connector to be available for free on Anypoint Exchange and offer this capability to the developer community and all MuleSoft customers globally. This development has no cost for you or economic benefit for us beyond the marketing that we can obtain. We will need to use their API and the monday.com logo. After finishing the development, the connector will be evaluated by MuleSoft, published in the marketplace and we will be doing some webinars to explain the advantages of using the connector and its ease. To advance to a second step we need to receive the go-ahead from you

18314
H
S
sumonciNew Participant
posted in API & Apps framework
How to read column value by pulseId

I have activated “Developer Mode” in my account. I found phone number column name is 1_phone95 Using webhook, I receive pulseId which is row id(i guess). webhook doesn’t send all column values. So i try to read 1_phone95 column values by the following code snippet $query = ‘query { pulse (ids: 1339686138) { column_values { id type } } }’; But i get the following error: {“errors”:[{“message”:“Field ‘pulse’ doesn’t exist on type ‘Query’”,“locations”:[{“line”:1,“column”:9}],“fields”:[“query”,“pulse”]}],“account_id”:8374454} Now my question is, how do i read all columns or a single column(1_phone95) value? Is it by pulseId or is there are any further technique? I am highly interested to study query in detail. May i have study/documentation link please. Thanks in advance.

26126
S
W
workteam123New Participant
posted in API & Apps framework
Monday api download images

Hi I am trying to download images from a board using a fetch api (axios in this instance) I have a bearer token and have got the url where monday is storing the images e.g. https://.monday.com/protected_static/64xxx81/resources/208xxx328/5XrhMb3TtAgiyFZUKARvsRx0vwhbpp9GGcW9J5nHN6W5QyQDKfWEOvK6IuuLXskzFjYc9Fa4Wn5adyTSAETv1tWDkRJl6JraXqaF.jpg - but I am still unauthorized. What am I doing wrong? Many thanks Gary

20246
W
M
mvr_25New Participant
posted in API & Apps framework
Building developer environment on my laptop too build an app

Iam participating in monday apps-hackathon challenge. I want to start building my app but, i could not create development environment (mentioned in resources>build your apps) in my laptop I mean i followed the same procedure, But iam unable to get the link!!! please help me to solve this problem!I feel much disappointed at the start itself due to this… please help me!!!

10742
dipro
C
cmoffittNew Participant
posted in API & Apps framework
Need Help on the last step for the Quickstart - ReactJS guide

I’m having trouble with step 5, " 1. Open a board, and add your view to it. You should see your app display data for the first item on the board." I don’t see how to find my view when I open up a board. Do I first need to have an admin of the account “install” the app? Some screen shots in this section would be helpful

10182
dipro
G
GabriellaSelbachNew Participant
posted in API & Apps framework
Return specific columns using GraphQL

Hello! I would like to get more columns on my board, but I can only get the id and name, all other fields are said Field ‘team’ doesn’t exist on type ‘Item’ I’m making a filter by date, I don’t know if it’s the most correct either. how can i get all columns in fields ? I’m using mondy’s Api, with javascript. I have the following code structure: async getCelebrateOnPeriod(date: string): Promise<any> { const { query, variables } = gql.query( this.clientQuery.getOnCelebrationOnPeriod( this.boardId, date, date, ), ); const data = await this.mondayApi.api(query, { variables }); getOnCelebrationOnPeriod( boardId: number, columnId: string, date: string, ) { return { operation: 'items_by_column_values', variables: { board_id: { value: boardId, required: true, type: 'Int', }, column_id: { value: 'date4', required: true, type: '

27988
G
S
ShawnBadenParticipating Frequently
posted in API & Apps framework
Create new item w/ column values not working

I’m trying to understand basic item creation. I can create a new item successfully with a name but when I try to add additional column content I get errors. monday.api( `mutation { create_item ( board_id: ${myBoardId}, group_id: "new_group", item_name: "new item creation", column_values: { person: 20602378, } ) { id } }` ) It works if I remove the column-values object.

30997
S
JCorrell
JCorrellCommunity Expert
posted in API & Apps framework
Button Activated Webhook Thoughts

(Scroll to the bottom for the “bottom” line… The “best” way to call a webhook with a button column.) The somewhat long story… In the past I’ve needed to call a webhook based on a button column click. My approach was to create a seperate work status column that I would change with the required automation for the button click. I would then have an integration that would call the webhook when that work column changed. A little clunky. But, it worked. Recently, I had the same need but have come up with a better way to do it. I found that the button column “value” actually changes every time you click it. So, I could use that for the integration trigger. But, you still have to have an attached automation for the button. I looked at the actions available and thought that the Notify action was the least messy and used that thinking that I could just ignore the notifications. I didn’t like the notifications. I thought who else could I send this to? I didn’t want to create a dummy user just for

44247
JCorrell
C
cmoffittNew Participant
posted in API & Apps framework
Elements being cut out of viewport

I’m new here and trying out Monday.com’s native app development feature. Also new to react. To test some things out, I’m trying to simply make an api call to Monday board data and display it in a series of divs. However, for some reason, the Monday window seems to arbitrarily cut out a large number of the top divs. The screen is vertically scrollable, but the very top of the screen has already cut out many of the above divs. Any idea why that happens and how to have more control of the screen?

12083
C
O
odelegacyNew Participant
posted in API & Apps framework
Installed Apps not working

Has anyone else had issues of apps not working? They are appearing in the installed apps, mostly, but if I try to add one to a board, it doesn’t load.

13024
O
K
kylerNew Participant
posted in API & Apps framework
Formatting of Query String for PHP & CURL "Parse Error"

I’m trying to understand how to properly format GraphQL queries for Monday and running into issues. This is what I have so far {"query":"mutation { create_item (board_id: 1293347952, item_name: \\"project 1\\", column_values: {\\"status\\": \\"Active\\", \\"text\\": \\"na\\", \\"date4\\": \\"2021-05-29\\"}) { id }}"} I get the following response {"errors":[{"message":"Parse error on \\"status\\" (STRING) at [1, 86]","locations":[{"line":1,"column":86}]}],"account_id":6734464} Overall my PHP code is as follows $response = MondayHelpers::callMondayAPI( 'mutation { create_item (board_id: ' . env('MONDAY_BOARD_ID') . ', item_name: "' . $project->name . '", column_values: {"' . env('MONDAY_STATUS_ID') . '": "Active", "' . env('MONDAY_COMPANY_ID') . '": "' . $request->user()->companydetails->company . '", "' . env('MONDAY_EXPECTED_ID') . '": "' . $project->expecteddate . '"}) { id }}' ); public static function callMondayAPI($data) { $payload = json_encode(['query'

23953
K
R
raghavendra.patilNew Participant
posted in API & Apps framework
Where to write Javascript in Monday.com

I would like to write Java script in Monday.com . I want to write it to post some data to external application using JS . But not getting where exactly write the JS code.

21454
R
J
JasonBenichouParticipating Frequently
posted in API & Apps framework
Custom Integration "Every week, if status is something, send webhook and create update" - for all items

Hi everyone, I’m beginner in this world of developers. I need some help please, I’m trying to create a custom integration (or automation) : “Every week, if status is something, send a webhook and create an update” Someone can help me please ? I have read several times all the documentations (API, tutorials to create app…) Thank you for your help, Jason

225521
J
N
NixoidParticipating Frequently
posted in API & Apps framework
How to add Custom page (Settings page for App)

Hi, I need some assistance. Can someone explaine how i can create app with costom page for display my setting page. I want create app which make requests to monday api and collect some data. but i need give to user ability to configure what data they need.(for example select colums) For that i need show user some configuration page. i found that i can create table view and show that custom page there as iframe but i think it is not right way. more information about how it should work: user create some ‘set’ of ‘export settings’ with some id on app side(on my server; can create multiple sets). 3dparty service make request to my server with ‘set’ id, my app make request to Monday and collect requested data. There is no any triggers or actions on Monday side. But i need give user ability to open app setting page for create sets of ‘export settings’ and get his auth code for api requests

15596
N
S
suchithraNew Participant
posted in API & Apps framework
Integration Between Monday.com and Mailchimp

Integration Between Monday.com and Mailchimp, to flow all column values from monday.com to Mailchimp. Does the Monday.com API support to map column values from Monday to Mailchimp? If this supports, please guide me here…

18137
S
Terms & ConditionsCookie settings