thatdoogieguy

blueprint:
  name: Control Light Entities From Motion & Other Triggers
  description: >
    Forked from YAMA with a number of changes and additions to meet my specific needs and customisation requirements.

    Configure either only the light selector or with all time sensors for the best results.

    Optionally configure the Override Blocker, Alarm State Blocker, and No Motion Blocker to further customise the results.

    The Sleep Mode Override allows for a global scene override to ignore time of day and provide a more suitable scene (i.e. dim lighting or selective colouring) to assist with not disturbing other home dwellers.

thatdoogieguy

// 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",