Skip to main content

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=nPersonal Token Here],

    b

        query {

            boards (ids:a000000000, 000000000]) {

                items {

                    name

                    id

                    column_values{

                        text

                    }

                }

            }

        }

    ]

)

in

Source


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!

Terms & ConditionsCookie settings