Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Aggregate Resource

Resource

PropertyName

IsCollection

DATA_TYPE

ODS REQUIRED/OPTIONAL

Ed-Fi Dashboard Requirement

Scenario 1

POST

Scenario 2

POST

Scenario 3

PUT

Scenario 4

PUT

ClassPeriods

ClassPeriods

name

FALSE

nvarchar

REQUIRED

REQUIREDClass Period 1Class Period 1Class Period 01Class Period 01

ClassPeriods

ClassPeriods

schoolReference

FALSE

schoolReference

REQUIRED

REQUIRED    

ClassPeriods

schoolReference

schoolId

FALSE

int32

REQUIRED

REQUIRED255901001255901107255901001255901107

...

 

...

titleJSON For scenarios
linenumberstrue

...

Scenario 1  
POST http://apicert.doubleline.us/api/api/v2.0/2016/classPeriods
{
	"name": "Class Period 1",
	"schoolReference": {
		"schoolId": 255901001
	}
}
Scenario 2  
POST http://apicert.doubleline.us/api/api/v2.0/2016/classPeriods
{
	"name": "Class Period 1",
	"schoolReference": {
		"schoolId": 255901107
	}
}

Scenario 3 
PUT http://apicert.doubleline.us/api/api/v2.0/2016/classPeriods/40a17fc04f3e4c17b1d62371a87e9e16
{
	"id": "40a17fc04f3e4c17b1d62371a87e9e16",
	"name": "Class Period 01",
	"schoolReference": {
		"schoolId": 255901001
	}
}


Scenario 4 
PUT http://apicert.doubleline.us/api/api/v2.0/2016/classPeriods/9da5971e4c9c439ba05772962487b313
{
	"id": "9da5971e4c9c439ba05772962487b313",
	"name": "Class Period 01",
	"schoolReference": {
		"schoolId": 255901107
	}
}

 

Verification Scripts 

 

Code Block
languagesql
titleVerify Create 1 Classperiod for GrandBend High School
firstline1
linenumberstrue
SELECT
	SchoolId, 
	ClassPeriodName,
	LastModifiedDate,
	CreateDate
FROM
	 edfi.ClassPeriod
WHERE
	SchoolId = 255901001
Code Block
languagesql
titleVerify Create 2 Classperiod for GrandBend Elementary School
firstline1
linenumberstrue
SELECT 
	SchoolId, 
	ClassPeriodName,
	LastModifiedDate,
	CreateDate
FROM
	 edfi.ClassPeriod 
WHERE
	SchoolId = 255901107
Code Block
languagesql
titleVerify Create 1 - Data Specific Classperiod for GrandBend High School
firstline1
linenumberstrue
SELECT 
	 SchoolId 
	,ClassPeriodName
	,LastModifiedDate
	,CreateDate
FROM
	 edfi.ClassPeriod 
WHERE
	SchoolId = 255901001 and
	ClassPeriodName = 'Class Period 1'
Code Block
languagesql
titleVerify Create 2 - Data Specific Classperiod for GrandBend Elementary School
firstline1
linenumberstrue
SELECT 
	 SchoolId 
	,ClassPeriodName
	,LastModifiedDate
	,CreateDate
FROM
	 edfi.ClassPeriod 
WHERE
	SchoolId = 255901107 and
	ClassPeriodName = 'Class Period 1'

Code Block
languagesql
titleVerify Put 1 Update ClassPeriod for GrandBend High School
firstline1
linenumberstrue
SELECT 
	 SchoolId 
	,ClassPeriodName
	,LastModifiedDate
	,CreateDate
FROM
	 edfi.ClassPeriod
WHERE
	SchoolId = 255901001 and
	ClassPeriodName = 'Class Period 01'

...

languagesql
titleVerify Put 2 Update Classperiod for GrandBend Elementary School
firstline1
linenumberstrue

...