yuhgto

# This example will update a date, person and text column for all items on a board
# It will show you how to query the API (read data) and mutate column values for each of the returned items. 

# set URL and headers for API calls
$url = "https://api.monday.com/v2/"
$hdr = @{}
$hdr.Add("Authorization" , "YOUR_API_KEY_HERE")
$hdr.Add("Content-Type","application/json")

# set board ID

yuhgto

// Playing around with a PowerBI query to pull data from monday.com into PowerBI
// This can come in handy when building PowerBI reports that utilize GraphQL endpoints for loading data.

let
    Source = Web.Contents(
	"https://api.monday.com/v2",
	[
		Headers=[
			#"Method"="POST",
			#"Content-Type"="application/json",