...
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 | REQUIRED | Class Period 1 | Class Period 1 | Class Period 01 | Class Period 01 |
ClassPeriods | ClassPeriods | schoolReference | FALSE | schoolReference | REQUIRED | REQUIRED | ||||
ClassPeriods | schoolReference | schoolId | FALSE | int32 | REQUIRED | REQUIRED | 255901001 | 255901107 | 255901001 | 255901107 |
...
...
title | JSON For scenarios |
---|---|
linenumbers | true |
...
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 | ||||||||
---|---|---|---|---|---|---|---|---|
| ||||||||
SELECT
SchoolId,
ClassPeriodName,
LastModifiedDate,
CreateDate
FROM
edfi.ClassPeriod
WHERE
SchoolId = 255901001
|
Code Block | ||||||||
---|---|---|---|---|---|---|---|---|
| ||||||||
SELECT
SchoolId,
ClassPeriodName,
LastModifiedDate,
CreateDate
FROM
edfi.ClassPeriod
WHERE
SchoolId = 255901107
|
Code Block | ||||||||
---|---|---|---|---|---|---|---|---|
| ||||||||
SELECT
SchoolId
,ClassPeriodName
,LastModifiedDate
,CreateDate
FROM
edfi.ClassPeriod
WHERE
SchoolId = 255901001 and
ClassPeriodName = 'Class Period 1'
|
Code Block | ||||||||
---|---|---|---|---|---|---|---|---|
| ||||||||
SELECT
SchoolId
,ClassPeriodName
,LastModifiedDate
,CreateDate
FROM
edfi.ClassPeriod
WHERE
SchoolId = 255901107 and
ClassPeriodName = 'Class Period 1'
|
Code Block | ||||||||
---|---|---|---|---|---|---|---|---|
| ||||||||
SELECT
SchoolId
,ClassPeriodName
,LastModifiedDate
,CreateDate
FROM
edfi.ClassPeriod
WHERE
SchoolId = 255901001 and
ClassPeriodName = 'Class Period 01'
|
...
language | sql |
---|---|
title | Verify Put 2 Update Classperiod for GrandBend Elementary School |
firstline | 1 |
linenumbers | true |
...