Skip to content

Instantly share code, notes, and snippets.

Avatar

Dipro Bhowmik yuhgto

  • New York City, NY
View GitHub Profile
@yuhgto
yuhgto / monday-GraphQL-PowerBI.m
Last active Jul 13, 2022 — forked from petrsvihlik/GitHub-GraphQL-PowerBI.m
Loading GraphQL data (monday.com API v2) into PowerBI
View monday-GraphQL-PowerBI.m
// 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",
@yuhgto
yuhgto / mondayExample.ps1
Created Jan 21, 2020
monday.com Powershell API Example
View mondayExample.ps1
# 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