-------------------------------------Section list (by school level)-------------------------------------------------------
RestConnectorMasterTable:
SQL SELECT 
	"__KEY_root",
	(SELECT 
		"id" AS "id_u0",
		"course_code",
		"lead_section_id",
		"name" AS "name_u0",
		"offering_id",
		"parent_section_id",
		"school_year",
		"section_identifier",
		"room_id",
		"__KEY_value",
		"__FK_value",
		(SELECT 
			"id",
			"name",
			"__FK_duration"
		FROM "duration" FK "__FK_duration")
	FROM "value" PK "__KEY_value" FK "__FK_value")
FROM JSON (wrap on) "root" PK "__KEY_root"
WITH CONNECTION (
	URL "https://api.sky.blackbaud.com/school/v1/academics/sections?level_num=1165",
	HTTPHEADER "Bb-Api-Subscription-Key" "$(vSubscriptionKey)",
	HTTPHEADER "Authorization" "Bearer $(vToken)",
    QUERY "level_num" "1165",
    QUERY "school_year" "2019-2020"
)
;


------------------------------------- Section List (single teacher)--------------------------------------------------


Let vTeacher = Peek('Teacher ID',$(i),'TempTeacher');

set vURL = 'https://api.sky.blackbaud.com/school/v1/academics/teachers/$(vTeacher)/sections';

Sleep(100);

RestConnectorMasterTable:
SQL SELECT 
	"__KEY_root",
	(SELECT 
		"id" AS "id_u0",
		"course_code",
		"lead_section_id",
		"name" AS "name_u0",
		"offering_id",
		"parent_section_id",
		"room_id",
		"section_identifier",
		"__KEY_value",
		"__FK_value",
		(SELECT 
			"id",
			"name",
			"__FK_duration"
		FROM "duration" FK "__FK_duration")
	FROM "value" PK "__KEY_value" FK "__FK_value")
FROM JSON (wrap on) "root" PK "__KEY_root"
WITH CONNECTION (
URL "$(vURL)",
	HTTPHEADER "Bb-Api-Subscription-Key" "$(vSubscriptionKey)",
	HTTPHEADER "Authorization" "Bearer $(vToken)",
    QUERY "teacher_id" "$(vTeacher)",
    QUERY "school_year" "2020-2021"
    );


------------------------------------- Student list (single section) ------------------------------------- 

TempSections:
Load Distinct [id_u0] as [Section ID]
Resident [Section List]
Where [id_u0]<>0;
;

For i=0 to NoOfRows('TempSections')-1

Let vSection = Peek('Section ID',$(i),'TempSections');

set vURL = 'https://api.sky.blackbaud.com/school/v1/academics/sections/$(vSection)/students';

Sleep(100);

RestConnectorMasterTable:
SQL SELECT 
	"__KEY_root",
	(SELECT 
		"id",
		"name",
		"__FK_value"
	FROM "value" FK "__FK_value")
FROM JSON (wrap on) "root" PK "__KEY_root"
WITH CONNECTION (
	URL "$(vURL)",
	HTTPHEADER "Bb-Api-Subscription-Key" "$(vSubscriptionKey)",
	HTTPHEADER "Authorization" "Bearer $(vToken)",
    QUERY "section_id" "$(vSection)",
    QUERY "school_year" "2019-2020"
);