Graphql - monday.com as data source

Queries and Resources
1

Hello,

I am new to using monday.com as a data source in retool. I did stumble across Making your first request (monday.com) and tried following the steps and get this error. Would be super grateful for any tips on how to connect monday.com to retool

monday.com error
monday.com error2038×840 63.2 KB

2

Hello!

Can you wrap your current query with query { ...your current query... }

I was able to return data from Monday with a simple setup like:

query { boards(ids: xxxxxxxxx) { views {id} } }
1 Like
3

I think your query needs to be along the lines of:

{ boards (ids: xxx) {
  name
  id
  description
  items {
    name
    column_values {
      title
      id
      type
      text
} } } }

So you might just be missing the opening {

More info here:

1 Like
4

Thank you! adding query to the query helped resolve this issue. I am now able to get some output - but seems to be not in a table format - id, name should be the column names.. Any suggestions of how to achieve this?

pic
pic2203×1107 113 KB

5

The result is in JSON format, which can be transformed and otherwise manipulated with JavaScript. For just the id & name fields, you can (I think based on your screenshot) access them by setting a table data source to query3.data.boards[0].items_page.items though if you have more than 1 boards object, you would need to flatten the array.

2 Likes
6

Thanks! this worked

1 Like