Power Query using API v2

monday Apps & Developers
1

Hello! New to the community so this may just be a simple fix, but I’m trying to use the Power Query Editor in Power BI to pull in information from multiple boards within Monday.com. I’ve been able to successfully use the API v1, but it is very cumbersome since I’m pulling from multiple boards and I would like to get API v2 working. I’ve used the developer tool to test my query and I know it pulls the info I want:

query {
boards (ids:000000000) {

                 items {
                     name
                     id
                     column_values{
                         text
                     }
                 }
             }
         }

But when I go into the advanced editor of my Power Query, and put in the following code it errors out. I’ve tried using the curl command and post command, but I might be missing something. Please let me know! Thank you.

let

Source = Web.Contents(https://api.monday.com/v2/updates.json?api_key=[Personal Token Here],
    [
        query {
            boards (ids:[000000000, 000000000]) {
                items {
                    name
                    id
                    column_values{
                        text
                    }
                }
            }
        }
    ]
)

in
Source

2

Hey there! Dipro here, sorry for the late reply on this. I see a couple of errors in your code, happy to walk you through it!

Endpoint

GraphQL uses one endpoint for all queries, and the body of your query is what defines the data you’re trying to get back. Try changing the URL to https://api.monday.com/v2

Authentication

Our API expects the token to be passed in the header of the request, not as a URL query param. Try sending the key as an “Authorization” header.

Request Format

Finally, our API expects the request body to be in the form of JSON key-value pairs. Try formatting your request like this instead:

{ "query" : "{ boards (ids: [xxxxx,xxxxx]) { ... }"

Let me know if that helps!