Usage and reference manual.
©2016 ampEducator Inc.
ampEducator gives developers access to a REST style API allowing them to access a large subset of it's features.
In order to start using the API there are two things which need to be done. Both of them require administrator access to the ampEducator account.
To access the api you must make an HTTP request in the following forms:
https://{purl}.ampeducator.com/api/{resource}/{action}?apiKey={apiKey}{parameters}
curl --data "apiKey={apiKey}{parameters}" https://{purl}.ampeducator.com/api/{resource}/{action}
purl
is the unique identified for the institutionresource
identifies the section of the applicationaction
identifies what is being requestedapiKey
is the unique secret key for the institutionparameters
are any additional pieces of data which are required for the actionThe application will always respond with a JSON object in the following form:
{"messages": "general": [arrayOfStrings], "warning": [arrayOfStrings], "errors": [arrayOfStrings], "withErrors": boolean, "totalMessages": 1}, {"action": String}, {"query" : Map}, {"data" : Object[]}
messages
is an Object which will identify whether or not the
requested action was successfull along with any response messagesaction
is a String identifying which action was requestedquery
is a Map (String key, String value)
containing all the parsed query parametersdata
contains an array of objects returned by the
applicationEach action will expect different parameters.
key=value
.
For example when requesting a student you might pass something like
studentID=123
.key_{type}=value
where {type}
can be found in the table below. Using
this you could for example request all students added after a
certain date by passing createdDateTime_gt=2016-01-01
.
This would be interpreted by the application as createdDateTime>'2016-01-01'
.createdDateTime_gt=2016-01-01
and
createdDateTime_lt=2016-02-01
.YYYY-MM-DD
format.HH:MM:SS
format.true/false
.Type | Example | Interpreted | Notes |
---|---|---|---|
eq | key_eq=value |
key=value |
Equals, the default option. |
neq | key_neq=value |
key!=value |
Not equal to. |
gt | key_gt=value |
key>value |
Greater than. |
gte | key_gte=value |
key>=value |
Greater than or equal to. |
lt | key_lt=value |
key<value |
Less than. |
lte | key_lte=value |
key<=value |
Less than or equal to. |
like | key_like=value |
key LIKE %value% |
Value contains the key. |
notLike | key_notLike=value |
key NOT LIKE %value% |
Value doesn't contains the key. |
bwIn | key_bwIn=value |
(key & value) != 0 |
The value mask contains the key. |
bwNotIn | key_bwNotIn=value |
(key & value) = 0 |
The value mask doesn't contain the key. |
The last have been included because ampEducator makes use of role and location masks and these bitwise operations can be helpful in restricting / allowing multiple roles and locations.
The following keys are reserved and can be used to control the results returned from the API.
orderBy
If a field name is provided, the results
will be returned ordered by that field.orderDir
Possible values are ASC
and DESC
.
Results will be sorted accordingly.limit
If a value is provided than the API will only
return the requested number of objects.offset
When a limit is provided, providing this
value will offset the results so that they begin from the given
number.ampEducator uses masks to control access to some objects by role and location.
Recruiter Managers
and Recruiters
to have access you would use 8+16=24
as the role mask.
Role Name | Mask Value |
---|---|
Admin | 2 |
Location Admin | 4 |
Recruiter Manager | 8 |
Recruiter | 16 |
Registrar | 32 |
Finance | 64 |
Student Advisor | 128 |
Faculty | 256 |
Front Office | 512 |
Student | 1024 |
Access to courses can be set per instructor.
Gradebook
and
Attendance
you would use 2+64=66
.
Course Section | Mask Value |
---|---|
Announcements | 1 |
Attendance | 2 |
Course Details | 4 |
Documents | 8 |
Events | 16 |
Grades (Scheme) | 32 |
Gradebook | 64 |
Students | 128 |
{purl}
and {apiKey}
with values specific to your institution. You should immediately
see the results from ampEducator. http://{purl}.ampeducator.com/api/location/get?apiKey={apiKey}
id
field along with createdDateTime
,
createdByUserID
, lastModifiedByDateTime
and lastModifiedByUserID
fields. These are always read
only.
Abbreviation | Available | Description |
---|---|---|
c | On Create | The field can be set when a new object is being added. |
r | On Read | The field can be set to restrict results when getting objects. |
u | On Update | The field can be set when an existing object is being updated. |
Add, update and manage academic sessions and intakes.
Action | Required | Returns |
---|---|---|
/academicSession/get Retrieves academic sessions. |
None | AcademicSession [ ] |
/academicSession/getIntakes Retrieves program intakes for an academic session. |
academicSessionID | ProgramIntake [ ] |
Field | Format | Notes / Values |
---|---|---|
academicSessionID | int | |
createdDateTime | yyyy-mm-dd hh:mm:ss | |
createdByUserID | int | |
lastModifiedDateTime | yyyy-mm-dd hh:mm:ss | |
lastModifiedByUserID | int | |
sessionKey | string | |
sessionName | string | |
sessionStart | yyyy-mm-dd | |
sessionEnd | yyyy-mm-dd | |
registrationStart | yyyy-mm-dd | |
registrationEnd | yyyy-mm-dd | |
studentDistinctionGroupID | int | |
notes | string | |
defaultChoice | boolean | |
status | string | 'Active','Completed' |
deleted | boolean |
Field | Format | Notes / Values |
---|---|---|
programIntakeID | int | |
createdDateTime | yyyy-mm-dd hh:mm:ss | |
createdByUserID | int | |
lastModifiedDateTime | yyyy-mm-dd hh:mm:ss | |
lastModifiedByUserID | int | |
academicSessionID | int | |
programIntakeCode | string | |
programIntake | string | |
programIntakeDate | yyyy-mm-dd | |
expectedEndDate | yyyy-mm-dd | |
deleted | boolean |
Add, update and manage student financial accounts..
Action | Required | Returns |
---|---|---|
Account Invoices |
||
/account/getInvoices Retrieves account invoices. |
None | AccountInvoice [ ] |
/account/addInvoice Add a new invoice for student. |
AddAccountInvoiceForm | AccountInvoice |
/account/postInvoice Post an invoice. |
PostAccountInvoiceForm | AccountInvoice |
/account/updateInvoice Update invoice details. |
EditAccountInvoiceForm | AccountInvoice |
/account/deleteInvoice Delete an invoice. |
DeleteAccountInvoiceForm | |
/account/getInvoiceItems Retrieves account invoice line items. |
None | AccountInvoiceItem [ ] |
/account/addInvoiceItem Add a new invoice item for an invoice. |
AddAccountInvoiceItemForm | AccountInvoiceItem |
/account/updateInvoiceItem Update an invoice item. |
EditAccountInvoiceItemForm | AccountInvoiceItem |
/account/deleteInvoiceItem Delete an invoice item. |
DeleteAccountInvoiceItemForm | |
/account/getInvoiceItemTaxes Retrieves tax information for account invoice line items. |
None | AccountInvoiceItemTax [ ] |
Account Charges |
||
/account/getCharges Retrieves account charges. |
None | AccountCharge [ ] |
/account/addCharge Add a new charge for a student. |
AddAccountChargeForm | AccountCharge |
/account/updateCharge Update charge details. |
EditAccountChargeForm | AccountCharge |
/account/deleteCharge Delete charge. |
DeleteAccountChargeForm | |
Account Payments |
||
/account/getPayments Retrieves account payments. |
None | AccountPayment [ ] |
/account/addPayment Add a new payment from a student. |
AddAccountPaymentForm | AccountPayment[ ] |
/account/updatePayment Update payment details. |
EditAccountPaymentForm | AccountPayment |
/account/deletePayment Delete payment. |
DeleteAccountPaymentForm | |
Account Adjustments |
||
/account/getAdjustment Retrieves account adjustments. |
None | AccountAdjustment [ ] |
/account/addAdjustment Add a new account adjustment for a student. |
AddAccountAdjustmentForm | AccountAdjustment[ ] |
/account/updateAdjustment Update adjustment details. |
EditAccountAdjustmentForm | AccountAdjustment |
/account/deleteAdjustment Delete adjustment. |
DeleteAccountAdjustmentForm | |
Account Funding |
||
/account/getFunding Retrieves account funding. |
None | AccountFunding [ ] |
/account/addFunding Add new account funding for a student. |
AddAccountFundingForm | AccountFunding[ ] |
/account/updateFunding Update funding details. |
EditAccountFundingForm | AccountFunding |
/account/deleteFunding Delete funding. |
DeleteAccountFundingForm | |
Account Payment Plan |
||
/account/getPaymentPlanItems Retrieves account payment plan items. |
None | AccountPaymentPlanItem [ ] |
/account/addPaymentPlanItem Add new account payment plan item for a student. |
AddAccountPaymentPlanItemForm | AccountPaymentPlanItem |
/account/updatePaymentPlanItem Update account payment plan item for a student. |
EditAccountPaymentPlanItemForm | AccountPaymentPlanItem |
/account/deletePaymentPlanItem Delete payment plan item for a student. |
DeleteAccountPaymentPlanItemForm | |
Other |
||
/account/getPaymentAccounts Retrieves payment accounts. |
None | PaymentAccount [ ] |
/account/getRevenueAccounts Retrieves revenue accounts. |
None | RevenueAccount [ ] |
/account/getSalesDiscountAccounts Retrieves sales discount accounts. |
None | SalesDiscountAccount [ ] |
/account/getTaxAccounts Retrieves tax accounts. |
None | TaxAccount [ ] |
/account/getFundingSources Retrieves funding sources. |
None | FundingSource [ ] |
Field | Format | Notes / Values |
---|---|---|
accountInvoiceID | int | |
createdDateTime | yyyy-mm-dd hh:mm:ss | |
createdByUserID | int | |
lastModifiedDateTime | yyyy-mm-dd hh:mm:ss | |
lastModifiedByUserID | int | |
invoiceKey | string | |
invoiceAssignedID | string | |
studentID | int | |
locationID | int | |
locationMask | long | |
invoiceStatus | string | 'Draft','Pending','Overdue','Paid','Deleted' |
invoiceDate | yyyy-mm-dd | |
invoiceDueDate | yyyy-mm-dd | |
invoiceSubTotal | double | |
invoiceTaxAmount | double | |
invoiceTotalAmount | double | |
invoicePaymentsAppliedAmount | double | |
invoiceCreditsAppliedAmount | double | |
invoiceBalance | double | |
invoiceNotes | string | |
posted | boolean | |
postedDateTime | yyyy-mm-dd hh:mm:ss | |
postedByUserID | int | |
deleted | boolean |
Field | Format | Notes / Values |
---|---|---|
accountInvoiceItemID | int | |
createdDateTime | yyyy-mm-dd hh:mm:ss | |
createdByUserID | int | |
lastModifiedDateTime | yyyy-mm-dd hh:mm:ss | |
lastModifiedByUserID | int | |
accountInvoiceID | int | |
locationID | int | |
locationMask | long | |
academicSessionID | int | |
programID | int | |
programCode | string | |
courseID | int | |
courseCode | string | |
revenueAccountCode | string | |
revenueAccountName | string | |
itemDescription | string | |
itemRate | double | |
itemQuantity | double | |
itemSubTotal | double | |
itemTaxMask | long | |
itemTaxDescription | string | |
itemTaxAmount | double | |
itemTotalAmount | double | |
itemPaymentsAppliedAmount | double | |
itemPaymentsAppliedTaxAmount | double | |
itemPaymentsAppliedTotalAmount | double | |
itemCreditsAppliedAmount | double | |
itemCreditsAppliedTaxAmount | double | |
itemCreditsAppliedTotalAmount | double | |
itemBalance | double | |
modified | boolean | |
deleted | boolean |
Field | Format | Notes / Values |
---|---|---|
accountInvoiceItemTaxID | int | |
createdDateTime | yyyy-mm-dd hh:mm:ss | |
createdByUserID | int | |
lastModifiedDateTime | yyyy-mm-dd hh:mm:ss | |
lastModifiedByUserID | int | |
accountInvoiceID | int | |
accountInvoiceItemID | int | |
taxAccount | string | |
taxName | string | |
taxRate | double | |
taxAmount | double | |
taxPaymentsAppliedAmount | double | |
taxCreditsAppliedAmount | long | |
taxBalance | string | |
deleted | boolean |
Field | Format | Notes / Values |
---|---|---|
studentID | int | Required. |
invoiceDate | yyyy-mm-dd | Required. |
invoiceDueDate | yyyy-mm-dd | Required. |
invoiceNotes | string |
Field | Format | Notes / Values |
---|---|---|
accountInvoiceID | int | Required. |
Field | Format | Notes / Values |
---|---|---|
accountInvoiceID | int | Required. |
invoiceDate | yyyy-mm-dd | Required. |
invoiceDueDate | yyyy-mm-dd | Required. |
invoiceNotes | string |
Field | Format | Notes / Values |
---|---|---|
accountInvoiceID | int | Required. |
Field | Format | Notes / Values |
---|---|---|
accountInvoiceID | int | Required. |
revenueAccountID | int | Required. |
academicSessionID | int | (Optional) The session this invoice item should be associated with. |
programID | int | (Optional) The program this invoice item should be associated with. |
courseID | int | (Optional) The course this invoice item should be associated with. |
itemDescription | string | Required. |
itemRate | double | Required. |
itemQuantity | double | Required. |
taxMask | long | The summation of masks for any taxes being applied. |
Field | Format | Notes / Values |
---|---|---|
accountInvoiceItemID | int | Required. |
accountInvoiceID | int | Required. |
revenueAccountID | int | Required. |
academicSessionID | int | (Optional) The session this invoice item should be associated with. |
programID | int | (Optional) The program this invoice item should be associated with. |
courseID | int | (Optional) The course this invoice item should be associated with. |
itemDescription | string | Required. |
itemRate | double | Required. |
itemQuantity | double | Required. |
taxMask | long | The summation of masks for any taxes being applied. |
Field | Format | Notes / Values |
---|---|---|
accountInvoiceItemID | int | Required. |
accountInvoiceID | int | Required. |
Field | Format | Notes / Values |
---|---|---|
accountChargeID | int | |
createdDateTime | yyyy-mm-dd hh:mm:ss | |
createdByUserID | int | |
lastModifiedDateTime | yyyy-mm-dd hh:mm:ss | |
lastModifiedByUserID | int | |
chargeAssignedID | string | |
studentID | int | |
locationID | int | |
locationMask | long | |
academicSessionID | int | |
programID | int | |
programCode | string | |
courseID | int | |
courseCode | string | |
chargeStatus | string | 'Pending','Overdue','Paid','Reversed','Deleted' |
chargeDate | yyyy-mm-dd | |
chargeDueDate | yyyy-mm-dd | |
chargeDescription | string | |
chargeAmount | double | |
chargePaymentsAppliedAmount | double | |
chargeCreditsAppliedAmount | double | |
chargeBalance | double | |
revenueAccountCode | string | |
revenueAccountName | string | |
chargeNote | string | |
reversed | boolean | |
deleted | boolean |
Field | Format | Notes / Values |
---|---|---|
studentID | int | Required. |
revenueAccountID | int | Required. |
academicSessionID | int | (Optional) The session this invoice item should be associated with. |
programID | int | (Optional) The program this invoice item should be associated with. |
courseID | int | (Optional) The course this invoice item should be associated with. |
chargeDate | yyyy-mm-dd | Required. |
chargeDueDate | yyyy-mm-dd | Required. |
chargeDescription | string | Required. |
chargeAmount | double | Required. |
chargeNote | string |
Field | Format | Notes / Values |
---|---|---|
accountChargeID | int | Required. |
revenueAccountIDChanged | boolean | |
revenueAccountID | int | Required if revenueAccountIDChanged is 'true'. |
academicSessionIDChanged | boolean | |
academicSessionID | int | Required if academicSessionIDChanged is 'true'. |
programIDChanged | boolean | |
programID | int | Required if programIDChanged is 'true'. |
courseIDChanged | boolean | |
courseID | int | Required if courseIDChanged is 'true'. |
chargeDate | yyyy-mm-dd | Required. |
chargeDueDate | yyyy-mm-dd | Required. |
chargeDescription | string | Required. |
chargeAmount | double | Required. |
chargeNote | string |
Field | Format | Notes / Values |
---|---|---|
accountChargeID | int | Required. |
Field | Format | Notes / Values |
---|---|---|
accountPaymentID | int | |
createdDateTime | yyyy-mm-dd hh:mm:ss | |
createdByUserID | int | |
lastModifiedDateTime | yyyy-mm-dd hh:mm:ss | |
lastModifiedByUserID | int | |
paymentKey | string | |
paymentAssignedID | string | |
studentID | int | |
locationID | int | |
locationMask | long | |
applyToFunding | boolean | |
fundingSourceCode | string | |
fundingSourceName | string | |
paymentStatus | string | 'Approved','Pending','Declined','Deleted' |
paymentRefundStatus | string | 'None','Partial','Refunded' |
paymentAccountCode | string | |
paymentAccountName | string | |
paymentDate | yyyy-mm-dd | |
paymentDescription | string | |
paymentAmount | double | |
paymentRefundedAmount | double | |
paymentRefundsAppliedAmount | double | |
paymentAvailableAmount | double | |
paymentApplied | double | |
paymentBalance | double | |
paymentAppliedToPlan | double | |
paymentAppliedToPlanBalance | double | |
paymentNotes | string | |
onlinePayment | boolean | |
creditCardHolder | string | |
creditCardRef | string | |
merchantTransactionID | string | |
merchantResponseCode | string | |
merchantResponseText | string | |
merchantAuthorizationCode | string | |
deleted | boolean |
Field | Format | Notes / Values |
---|---|---|
studentID | int | Required. |
paymentAccountID | int | Required. |
date | yyyy-mm-dd | Required. |
description | string | |
amount | double | Required. |
fundingSourceID | int | |
applyType | string | 'auto', 'selectInvoices', 'selectCharges' |
accountInvoiceID | int | Required when applyType is 'selectInvoices'. Repeat for multiple invoices. |
accountChargeID | int | Required when applyType is 'selectCharges'. Repeat for multiple charges. |
applyToPaymentPlanType | string | 'auto', 'planItems', 'none' |
accountPaymentPlanItemID | int | Required when applyToPaymentPlanType is 'planItems'. Repeat for multiple payment plan items. |
paymentNotes | string |
Field | Format | Notes / Values |
---|---|---|
accountPaymentID | int | Required. |
updateApplyToFunding | boolean | |
fundingSourceID | int | Required when updateApplyToFunding is 'true'. |
paymentDate | yyyy-mm-dd | Required. |
paymentDescription | string | |
paymentAmount | double | Required. |
paymentNotes | string |
Field | Format | Notes / Values |
---|---|---|
accountPaymentID | int | Required. |
Field | Format | Notes / Values |
---|---|---|
accountAdjustmentID | int | |
createdDateTime | yyyy-mm-dd hh:mm:ss | |
createdByUserID | int | |
lastModifiedDateTime | yyyy-mm-dd hh:mm:ss | |
lastModifiedByUserID | int | |
adjustmentAssignedID | string | |
studentID | int | |
locationID | int | |
locationMask | long | |
revenueDebitFlag | boolean | |
revenueCreditFlag | boolean | |
adjustmentType | string | 'Credit','Debit','Refund' |
adjustmentDate | yyyy-mm-dd | |
adjustmentDescription | string | |
adjustmentAmount | double | |
adjustmentApplied | double | |
adjustmentBalance | double | |
adjustmentCreditAccountCode | string | |
adjustmentCreditAccountName | string | |
adjustmentDebitAccountCode | string | |
adjustmentDebitAccountName | string | |
adjustmentNote | string | |
locked | boolean | |
deleted | boolean |
Field | Format | Notes / Values |
---|---|---|
studentID | int | Required. |
adjustmentDate | yyyy-mm-dd | Required. |
adjustmentDescription | String | |
adjustmentAmount | double | Required. |
adjustmentArType | string | 'debit', 'credit', 'refund' |
adjustmentDebitAccountCode | string | Required when adjustmentArType is 'credit'. |
adjustmentCreditAccountCode | string | Required when adjustmentArType is 'debit'. |
adjustmentPaymentAccountCode | string | Required when adjustmentArType is 'refund'. |
adjustmentApplyToCreditType | string | Required when adjustmentArType is 'credit'. Options are 'noneCredit', 'selectInvoices', 'selectCharges'. |
adjustmentApplyToInvoiceID | int | Required when adjustmentApplyToCreditType is 'selectInvoices'. Repeat for multiple invoices. |
adjustmentApplyToChargeID | int | Required when adjustmentApplyToCreditType is 'selectCharges'. Repeat for multiple charges. |
adjustmentApplyToRefundType | string | Required when adjustmentArType is 'refund'. Options are 'nonePayments', 'selectPayments'. |
adjustmentApplyToPaymentID | int | Required when adjustmentApplyToRefundType is 'selectPayments'. Repeat for multiple payments. |
adjustmentNote | string |
Field | Format | Notes / Values |
---|---|---|
accountAdjustmentID | int | Required. |
adjustmentDate | yyyy-mm-dd | Required. |
adjustmentDescription | String | |
adjustmentAmount | double | Required. |
adjustmentNote | string |
Field | Format | Notes / Values |
---|---|---|
accountAdjustmentID | int | Required. |
Field | Format | Notes / Values |
---|---|---|
accountFundingID | int | |
createdDateTime | yyyy-mm-dd hh:mm:ss | |
createdByUserID | int | |
lastModifiedDateTime | yyyy-mm-dd hh:mm:ss | |
lastModifiedByUserID | int | |
adjustmentAssignedID | string | |
studentID | int | |
locationID | int | |
locationMask | long | |
fundingSourceCode | string | |
fundingSourceName | string | |
fundingStatus | string | 'Pending', 'Paid', 'Overdue', 'Deleted' |
fundingDescription | string | |
fundingDueDate | yyyy-mm-dd | |
fundingAmount | double | |
fundingAmountCollected | double | |
fundingAmountBalance | double | |
fundingNotes | string | |
deleted | boolean |
Field | Format | Notes / Values |
---|---|---|
studentID | int | Required. |
fundingSourceID | int | Required. |
fundingDescription | string | Required. |
fundingDueDate | yyyy-mm-dd | Required. |
fundingAmount | double | Required. |
fundingNotes | string |
Field | Format | Notes / Values |
---|---|---|
accountFundingID | int | Required. |
fundingDescription | string | Required. |
fundingDueDate | yyyy-mm-dd | Required. |
fundingAmount | double | Required. |
fundingNotes | string |
Field | Format | Notes / Values |
---|---|---|
accountFundingID | int | Required. |
Field | Format | Notes / Values |
---|---|---|
accountPaymentPlanItemID | int | |
createdDateTime | yyyy-mm-dd hh:mm:ss | |
createdByUserID | int | |
lastModifiedDateTime | yyyy-mm-dd hh:mm:ss | |
lastModifiedByUserID | int | |
adjustmentAssignedID | string | |
studentID | int | |
paymentStatus | string | 'Pending', 'Overdue', 'Paid' |
paymentDescription | string | |
paymentDueDate | yyyy-mm-dd | |
paymentAmount | double | |
paymentPaid | double | |
paymentBalance | double | |
autoPaymentFromSaved | boolean | |
accountCreditCardID | double |
Field | Format | Notes / Values |
---|---|---|
studentID | int | Required. |
paymentDescription | string | Required. |
paymentDueDate | yyyy-mm-dd | Required. |
paymentAmount | double | Required. |
autoPaymentFromSaved | boolean | When true and a saved credit card exists, payment will be taken from that card. |
Field | Format | Notes / Values |
---|---|---|
accountPaymentPlanItemID | int | Required. |
paymentDescription | string | Required. |
paymentDueDate | yyyy-mm-dd | Required. |
paymentAmount | double | Required. |
Field | Format | Notes / Values |
---|---|---|
accountPaymentPlanItemID | int | Required. |
Field | Format | Notes / Values |
---|---|---|
paymentAccountID | int | |
createdDateTime | yyyy-mm-dd hh:mm:ss | |
createdByUserID | int | |
lastModifiedDateTime | yyyy-mm-dd hh:mm:ss | |
lastModifiedByUserID | int | |
paymentAccountCode | string | |
paymentAccountName | string |
Field | Format | Notes / Values |
---|---|---|
revenueAccountID | int | |
createdDateTime | yyyy-mm-dd hh:mm:ss | |
createdByUserID | int | |
lastModifiedDateTime | yyyy-mm-dd hh:mm:ss | |
lastModifiedByUserID | int | |
accountCode | string | |
accountName | string | |
deleted | boolean |
Field | Format | Notes / Values |
---|---|---|
salesDiscountAccountID | int | |
createdDateTime | yyyy-mm-dd hh:mm:ss | |
createdByUserID | int | |
lastModifiedDateTime | yyyy-mm-dd hh:mm:ss | |
lastModifiedByUserID | int | |
accountCode | string | |
accountName | string | |
deleted | boolean |
Field | Format | Notes / Values |
---|---|---|
taxAccountID | int | |
createdDateTime | yyyy-mm-dd hh:mm:ss | |
createdByUserID | int | |
lastModifiedDateTime | yyyy-mm-dd hh:mm:ss | |
lastModifiedByUserID | int | |
taxMask | long | |
taxAccountCode | string | |
taxAccountName | string | |
taxRate | double | Between 0-100%. |
deleted | boolean |
Field | Format | Notes / Values |
---|---|---|
fundingSourceID | int | |
createdDateTime | yyyy-mm-dd hh:mm:ss | |
createdByUserID | int | |
lastModifiedDateTime | yyyy-mm-dd hh:mm:ss | |
lastModifiedByUserID | int | |
code | string | |
name | string | |
deleted | boolean |
Add, update and manage general, course and program announcements.
Action | Required | Returns |
---|---|---|
/announcement/get Retrieves annnouncements. |
None | Announcement [ ] |
Field | Format | Notes / Values |
---|---|---|
announcementID | int | |
createdDateTime | yyyy-mm-dd hh:mm:ss | |
createdByUserID | int | |
lastModifiedDateTime | yyyy-mm-dd hh:mm:ss | |
lastModifiedByUserID | int | |
associateWith | string | None, Course, Program |
associateWithID | int | |
associateWithDetails | string | |
Display Until | yyyy-mm-dd | |
pinned | boolean | |
announcementDate | yyyy-mm-dd | |
announcementTitle | string(250) | |
announcement | string | |
announcementDocumentID | int | |
bulkEmailID | int | |
ownerUserID | int | |
audienceRoleMask | int | |
locationMask | long | |
restrictStudentStati | boolean | Only display announcement to select student stati. Only populated when student role in audience. |
studentStati | string | List of student stati to restrict announcement to. Delimited by |. Only populated when student role in audience. |
deleted | boolean |
Add, update and manage courses.
Action | Required | Returns |
---|---|---|
/course/get Retrieves courses. |
None | Course [ ] |
Field | Format | Notes / Values |
---|---|---|
courseID | int | |
createdDateTime | yyyy-mm-dd hh:mm:ss | |
createdByUserID | int | |
lastModifiedDateTime | yyyy-mm-dd hh:mm:ss | |
lastModifiedByUserID | int | |
locationID | int | |
locationMask | long | |
academicYearID | int | |
status | string | |
courseCode | string(50) | |
courseName | string(100) | |
section | string(50) | |
version | int | |
courseDescription | string | |
courseCapacity | int | |
courseHours | double | |
courseHoursScheduled | double | |
courseCredits | double | |
passingMark | double | 0-100 |
finalMarkType | string | |
customGradingScaleID | int | When final mark is 'Custom'. |
finalMarkTypeAlt | string | |
excludeFromGPA | boolean | |
excludeFromAttendance | boolean | |
openEnded | boolean | |
attendanceType | string | |
courseStart | yyyy-mm-dd | |
courseEnd | yyyy-mm-dd | |
selfEnrol | boolean | |
coursePercentageGradeAverage | double | |
courseGradePointAverage | double | |
numEnrolled | int | |
numCompleted | int | |
totalTuition | double | |
instructorOneID | int | |
instructorOneAccess | int | |
instructorTwoID | int | |
instructorTwoAccess | int | |
instructorThreeID | int | |
instructorThreeAccess | int | |
instructorFourID | int | |
instructorFourAccess | int | |
instructorFiveID | int | |
instructorFiveAccess | int | |
instructorSixID | int | |
instructorSixAccess | int | |
instructorSevenID | int | |
instructorSevenAccess | int | |
instructorEightID | int | |
instructorEightAccess | int | |
instructorNineID | int | |
instructorNineAccess | int | |
instructorTenID | int | |
instructorTenAccess | int | |
customField1-5 | string(500) |
Download, upload and manage documents in your account.
Action | Required | Description |
---|---|---|
/document/get Retrieves document meta-data. |
None | Document [ ] |
/document/getData Retrieves document data encoded in Base64. |
documentID | string |
/document/add Adds a new document. |
AddDocumentForm | Document |
/document/getTags Retrieves defined document tags. |
None | DocumentTag [ ] |
Field | Format | Notes / Values |
---|---|---|
associateWith | string | One of 'None','Course','Staff','Student' |
associateWithID | int | Required when associateWith is not None . |
fileName | string | |
fileMimeType | string | |
fileDescription | string | |
readRoleMask | int | If associateWith is None , sum of role masks which can read this document. |
updateRoleMask | int | If associateWith is None , sum of role masks which can update this document. |
locationMask | int | If associateWith is None , sum of locations masks which can access this document. |
documentData | string | The document data encoded in Base64 |
Field | Format | Notes / Values |
---|---|---|
documentID | int | |
createdDateTime | yyyy-mm-dd hh:mm:ss | |
createdByUserID | int | |
lastModifiedDateTime | yyyy-mm-dd hh:mm:ss | |
lastModifiedByUserID | int | |
associateWith | string | |
associateWithID | int | 0 (None) or the id of the associated object. |
documentTagID | int | 0 (None) or the id of the document tag. |
fileName | string | |
fileSize | double | Given in kilobytes. |
fileMimeType | string | |
fileDescription | string | |
fileExtension | string | |
filePath | string | |
internal | boolean | |
ownerUserID | int | |
readRoleMask | int | |
updateRoleMask | int | |
locationMask | int |
Field | Format | Notes / Values |
---|---|---|
documentTagID | int | |
createdDateTime | yyyy-mm-dd hh:mm:ss | |
createdByUserID | int | |
lastModifiedDateTime | yyyy-mm-dd hh:mm:ss | |
lastModifiedByUserID | int | |
documentTag | string(100) | |
deleted | boolean |
Add, edit and manage events.
Action | Required | Returns |
---|---|---|
/event/get Retrieves events. |
None | Event [ ] |
Field | Format | Notes / Values |
---|---|---|
eventID | int | |
createdDateTime | yyyy-mm-dd hh:mm:ss | |
createdByUserID | int | |
lastModifiedDateTime | yyyy-mm-dd hh:mm:ss | |
lastModifiedByUserID | int | |
sequence | int | Sequentially updated on change. |
associateWith | string | None, Prospect, Student |
associateWithID | int | 0 (None) or the id of the associated object. |
associateWithStatusID | int | |
eventType | string | Meeting, Phone Call In, Phone Call Out, To Do, Other |
eventDescription | string | |
eventAllDay | boolean | |
eventDate | yyyy-mm-dd | |
eventStart | yyyy-mm-dd hh:mm:ss | |
eventEnd | yyyy-mm-dd hh:mm:ss | |
resourceID | int | |
completed | boolean | |
completedByUserID | int | |
completedDateTime | yyyy-mm-dd hh:mm:ss | |
ownerUserID | int | |
readRoleMask | int | For 'Other' event type. |
publicEvent | boolean | For 'Other' event type. |
locationMask | int | For 'Other' event type. |
attendeeOneID
attendeeTwoID attendeeThreeID attendeeFourID attendeeFiveID attendeeSixID attendeeSevenID attendeeEightID attendeeNineID attendeeTenID |
int | For 'Meeting' event type. |
deleted | boolean |
Add, update and manage groups.
Action | Required | Returns |
---|---|---|
/group/get Retrieves groups. |
None | Group [ ] |
/group/getMembers Retrieves group members. |
groupID | GroupMember [ ] |
Field | Format | Notes / Values |
---|---|---|
groupID | int | |
createdDateTime | yyyy-mm-dd hh:mm:ss | |
createdByUserID | int | |
lastModifiedDateTime | yyyy-mm-dd hh:mm:ss | |
lastModifiedByUserID | int | |
groupName | string(100) | |
groupDescription | string | |
numMembers | int | |
ownerUserID | int | |
readRoleMask | int | |
updateRoleMask | int | |
locationMask | long |
Field | Format | Notes / Values |
---|---|---|
groupMemberID | int | |
createdDateTime | yyyy-mm-dd hh:mm:ss | |
createdByUserID | int | |
lastModifiedDateTime | yyyy-mm-dd hh:mm:ss | |
lastModifiedByUserID | int | |
groupID | int | |
studentID | int |
Retrieve infomation about locations.
Action | Required | Returns |
---|---|---|
/location/get Retrieves locations. |
None | Location [ ] |
Field | Format | Notes / Values |
---|---|---|
locationID | int | |
createdDateTime | yyyy-mm-dd hh:mm:ss | |
createdByUserID | int | |
lastModifiedDateTime | yyyy-mm-dd hh:mm:ss | |
lastModifiedByUserID | int | |
locationMask | int | |
status | string | 'Active','Disabled' |
name | string | |
contactPerson | string | |
contactPersonPosition | string | |
addressOne | string | |
addressTwo | string | |
city | string | |
province | string | Province / State |
postalCode | string | PostalCode / Zip |
country | string | ISO 3166-1 2 Letter Code |
phone | string | |
fax | string | |
string | ||
deleted | boolean |
Add, update and manage programs.
Action | Required | Returns |
---|---|---|
/program/get Retrieves programs. |
None | Program [ ] |
Field | Format | Notes / Values |
---|---|---|
programID | int | |
createdDateTime | yyyy-mm-dd hh:mm:ss | |
createdByUserID | int | |
lastModifiedDateTime | yyyy-mm-dd hh:mm:ss | |
lastModifiedByUserID | int | |
status | string | Active, Inactive |
version | int | |
programCode | string(50) | |
programName | string(100) | |
programHours | double | |
programWeeks | int | |
programFormat | string | FullTime, PartTime |
passingMark | double | 0-100 |
crendentialCode | string(20) | |
credential | string | |
finalMarkType | string | Percentage, LetterGrade, GradePoint, PassFail, Custom |
customGradingScaleID | int | When final mark is 'Custom'. |
finalMarkTypeAlt | string | Percentage, LetterGrade, GradePoint, PassFail, None |
totalProgramCredits | double | |
notes | string |
Add, update and manage prospect data.
Action | Required | Returns |
---|---|---|
/prospect/get Retrieves prospects. |
None | Student [ ] |
/prospect/getNotes Retrieves prospect notes. |
studentID | StudentNote [ ] |
/prospect/enroll Enrolls a prospect as a student. |
EnrollProspectForm | Student |
Field | Format | Notes / Values |
---|---|---|
studentID | int | Required. |
studentAssignedID | string | Automatically generated if left blank. Must be unique. |
advisorID | int | The user ID for this student's advisor. |
status | string | Required. Must be a valid defined status. |
sendEmail | boolean | When true student will receive credentials by email. |
Generate and download reports.
Action | Required | Returns |
---|---|---|
/report/get Retrieves reports. |
None | Report [ ] |
Field | Format | Notes / Values | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
reportID | int | |||||||||||||||
createdDateTime | yyyy-mm-dd hh:mm:ss | |||||||||||||||
createdByUserID | int | |||||||||||||||
lastModifiedDateTime | yyyy-mm-dd hh:mm:ss | |||||||||||||||
lastModifiedByUserID | int | |||||||||||||||
reportDocumentID | int | |||||||||||||||
status | string | None, Running, Completed, Error | ||||||||||||||
lastRun | yyyy-mm-dd hh:mm:ss | |||||||||||||||
reportName | string(100) | |||||||||||||||
reportDescription | text | |||||||||||||||
reportJRXML | string | |||||||||||||||
scheduleType | string | None,Daily,Weekly,Monthly | ||||||||||||||
scheduleWeekdays | int |
|
||||||||||||||
scheduleMonthly | int | 1-28 | ||||||||||||||
emailResults | boolean | |||||||||||||||
emailUserID | int | |||||||||||||||
emailUserTwoID | int | |||||||||||||||
emailCC | string(500) | Emails (CSV) | ||||||||||||||
associateWithLinkType | string | None,Student | ||||||||||||||
associateReportParameterID | int | |||||||||||||||
log | text | |||||||||||||||
readRoleMask | int | |||||||||||||||
updateRoleMask | int | |||||||||||||||
locationMask | long |
Retrieve infomation about staff.
Action | Required | Returns |
---|---|---|
/staff/get Retrieves staff. |
None | Staff [ ] |
Field | Format | Notes / Values |
---|---|---|
staffID | int | |
createdDateTime | yyyy-mm-dd hh:mm:ss | |
createdByUserID | int | |
lastModifiedDateTime | yyyy-mm-dd hh:mm:ss | |
lastModifiedByUserID | int | |
locationID | int | |
locationMask | long | |
roleMask | int | Mask of roles assigned. |
locationAccessMask | long | Mask of accessible locations. |
imageDocumentID | int | The DocumentID of the image for this staff. If 0 then no image has been uploaded. |
userID | int | |
hourClockID | int | |
status | string | Active,Not Active |
namePrefix | string | Mr, Ms, Mrs, Miss |
firstName | string | |
middleName | string | |
lastName | string | |
gender | string | Male,Female |
addressOne | string | |
addressTwo | string | |
city | string | |
province | string | Province / State |
postalCode | string | PostalCode / Zip |
country | string | ISO 3166-1 2 Letter Code |
phone | string | |
altPhone | string | |
dateofBirth | yyyy-mm-dd | |
string | ||
sin | string | SIN / SSN / NIN |
position | string | |
sendDailyAgenda | boolean | |
inbox | int | Number of unread emails in inbox. |
totalHours | double | |
customField1-30 | string | |
deleted | boolean |
Add, update and manage student data.
Action | Required | Returns |
---|---|---|
Student |
||
/student/add Adds a new student. |
AddStudentForm | Student |
/student/get Retrieves students. |
None | Student [ ] |
/student/updateAdmin Updates admin information for a student. |
EditStudentAdministrativeForm | Student |
/student/updateCustom Updates custom fields for a student. |
EditStudentCustomFieldForm | Student |
/student/updateDetails Updates basic information for a student. |
EditStudentDetailsForm | Student |
/student/updateEducation Updates education information for a student. |
EditStudentEducationForm | Student |
/student/updateEmergencyContacts Updates emergency contacts for a student. |
EditStudentEmergencyContactsForm | Student |
/student/updateEmployer Updates employer information for a student. |
EditStudentEmployerForm | Student |
/student/updateOther Updates other misc information for a student. |
EditStudentOtherForm | Student |
/student/addStatus Adds a new status for the student. |
AddStudentStatusForm | StudentStatus |
Student Academic Session |
||
/student/getSessions Retrieves list of student academic sessions. |
studentID | StudentAcademicSession [ ] |
/student/addSession Registers a student into a new academic session. |
AddStudentAcademicSessionForm | StudentAcademicSession |
Student Program |
||
/student/getPrograms Retrieves a list of student programs for student. |
studentID | StudentProgram [ ] |
/student/getProgram Retrieves a specific program for student. |
studentProgramID | StudentProgram |
/student/enrollProgram Enrolls a student into a new program. |
EnrollStudentProgramForm | StudentProgram |
/student/updateProgram Updates details of a student program. |
EditStudentProgramForm | StudentProgram |
/student/completeProgram Completes a student program. |
CompleteStudentProgramForm | StudentProgram |
/student/withdrawProgram Withdraws a student from a program. |
WithdrawStudentProgramForm | StudentProgram |
/student/reenrollProgram Reenrols a student in a withdrawn program. |
ReenrollStudentProgramForm | StudentProgram |
/student/makeProgramPrimary Makes a program the student's primary program. |
studentProgramID | StudentProgram |
Student Transfer Credit |
||
/student/getTransferCredits Retrieves a list of student transfer credits for student. |
studentID | StudentTransferCredit [ ] |
/student/addTransferCredit Adds a new studend transfer credit. |
AddStudentTransferCreditForm | StudentTransferCredit |
/student/updateTransferCredit Updates an existing student transfer credit. |
EditStudentTransferCreditForm | StudentTransferCredit |
/student/deleteTransferCredit Deletes an existing student transfer credit. |
DeleteStudentTransferCreditForm |
Field | Format | Notes / Values |
---|---|---|
namePrefix | string | Mr, Ms, Mrs, Miss |
name | string(150) | Required. |
phone | string(50) | |
string(100) | Required. Must be unique. | |
dateofBirth | yyyy-mm-dd | |
overrideStudentAssignedID | booelan | If true you must provide a student ID. |
studentAssignedID | string(100) | Required if override is set to true . Must be unique. |
locationID | int | Location of this student. Required. |
status | string | Current status of student. If not provided the default status is used. |
advisorID | int | The user ID for this student's advisor. |
agentID | int | The user ID for this student's agent. |
tag | string | Repeat for multiple tags. |
leadSourceCode | string | |
interested | string | The interested code for any courses or programs. Must be a valid interested code. Repeat for multiple interests. |
emailLoginInfo | boolean | If true the student will receive an email with their login information. |
Field | Format | Notes / Values |
---|---|---|
studentID | int | Required. |
studentAssignedID | string | Required. Must be unique. |
locationIDChanged | boolean | |
locationID | int | Required if locationIDChanged is true changed. |
recruiterIDChanged | boolean | Only applicable if student type is 'Prospect'. |
recruiterID | int | Required if recruiterIDChanged is true . Only applicable if student type is 'Prospect'. |
advisorIDChanged | boolean | Only applicable if student type is 'Student'. |
advisorID | int | Required if advisorIDChanged is true . Only applicable if student type is 'Student'. |
agentIDChanged | boolean | |
agentID | int | Required if agentIDChanged is true . |
feeClassCode | string | Required. Must be a valid defined fee class code. |
internationalStudent | boolean | |
hourClockID | int | The hour clock ID for this student. |
Field | Format | Notes / Values |
---|---|---|
studentID | int | Required. |
customField1-100 | string(500) | Every custom field is updated. Date custom fields must have the form 'yyyy-mm-dd'. |
Field | Format | Notes / Values |
---|---|---|
studentID | int | Required. |
namePrefix | string | Mr, Ms, Mrs, Miss |
firstName | string(50) | Required. |
middleName | string(50) | |
lastName | string(50) | |
addressOne | string(100) | |
addressTwo | string(100) | |
city | string(50) | |
province | string(50) | Province / State |
postalCode | string(25) | PostalCode / Zip |
country | string(2) | ISO 3166-1 2 Letter Code |
permAddressOne | string(100) | |
permAddressTwo | string(100) | |
permCity | string(100) | |
permProvince | string(50) | Province / State |
permPostalCode | string(25) | PostalCode / Zip |
permCountry | string(2) | ISO 3166-1 2 Letter Code |
phone | string(50) | |
mobilePhoneCountry | string(2) | ISO 3166-1 2 Letter Code. Required if mobile phone is present. |
mobilePhone | string(50) | |
workPhone | string(50) | |
altPhone | string(50) | |
string(100) | Required. | |
secondaryEmail | string(100) | |
gender | string | If set, must be one of 'Male', 'Female', 'TG', 'Other'. |
dateofBirth | yyyy-mm-dd | |
sin | string(25) | SIN / SSN / NIN depending on country. |
Field | Format | Notes / Values |
---|---|---|
studentID | int | Required. |
educationHighSchoolGraduate | boolean | |
educationHighSchoolGraduationYear | yyyy | Required if educationHighSchoolGraduate is true . |
educationHighSchoolName | string(50) | |
educationHighSchoolNotes | string | |
educationPostSecondaryOne | boolean | |
educationPostSecondaryOneName | string(50) | Required if educationPostSecondaryOne is true . |
educationPostSecondaryOneFrom | yyyy-mm-dd | |
educationPostSecondaryOneTo | yyyy-mm-dd | |
educationPostSecondaryOneCredential | boolean | |
educationPostSecondaryOneCredentialType | string | Required if educationPostSecondaryOneCredential is true . One of 'Certificate', 'Diploma', 'Bachelors', 'Masters', 'Doctorate', 'Other' |
educationPostSecondaryOneNotes | string | |
educationPostSecondaryTwo | boolean | |
educationPostSecondaryTwoName | string(50) | Required if educationPostSecondaryTwo is true . |
educationPostSecondaryTwoFrom | yyyy-mm-dd | |
educationPostSecondaryTwoTo | yyyy-mm-dd | |
educationPostSecondaryTwoCredential | boolean | |
educationPostSecondaryTwoCredentialType | string(15) | Required if educationPostSecondaryTwoCredential is true . One of 'Certificate', 'Diploma', 'Bachelors', 'Masters', 'Doctorate', 'Other' |
educationPostSecondaryTwoNotes | string |
Field | Format | Notes / Values |
---|---|---|
studentID | int | Required. |
emergencyContactOne | string(50) | |
emergencyContactOneRelationship | string | Required if contact one is populated. Must be one of 'Friend', 'Grandparent', 'Parent', 'Sibling', 'Signifigant Other', 'Spouse', 'Other' |
emergencyContactOnePhone | string(25) | Required if contact one is populated. |
emergencyContactOnePhoneAlt | string(25) | |
emergencyContactTwo | string(50) | |
emergencyContactTwoRelationship | string | Required if contact two is populated. Must be one of 'Friend', 'Grandparent', 'Parent', 'Sibling', 'Signifigant Other', 'Spouse', 'Other' |
emergencyContactTwoPhone | string(25) | Required if contact two is populated. |
emergencyContactTwoPhoneAlt | string(25) |
Field | Format | Notes / Values |
---|---|---|
studentID | int | Required. |
employer | string(50) | |
employerContact | string(25) | |
employerAddressOne | string(100) | |
employerAddressTwo | string(100) | |
employerCity | string(50) | |
employerProvince | string(50) | |
employerCountry | string(2) | ISO 3166-1 2 Letter Code |
employerPostalCode | string(25) | |
employerPhone | string(50) | |
employerEmail | string(100) | |
employerWeb | string(100) | |
employerPosition | string(100) | |
employerPositionType | string | If set, must be one of 'Full Time', 'Part Time' |
employerStartDate | date | yyyy-mm-dd |
employerSalary | string(100) |
Field | Format | Notes / Values |
---|---|---|
studentID | int | Required. |
leadSourceCode | string | If defined, must be a valid lead source code. |
tag | string | Repeat for multiple tags. |
interested | string | Repeat for multiple interested programs / courses. Must be a valid interested code. |
expectedProgramIDChanged | boolean | |
expectedProgramID | int | Required when expectedProgramIDChanged is true . |
expectedProgramAcademicSessionIDChanged | boolean | |
expectedProgramAcademicSessionID | int | Required when expectedProgramAcademicSessionIDChanged is true . |
expectedProgramIntakeIDChanged | boolean | |
expectedProgramIntakeID | int | Required when expectedProgramIntakeIDChanged is true . |
expectedProgramStartDate | yyyy-mm-dd | |
expectedProgramEnrollDate | yyyy-mm-dd | |
expectedProgramEndDate | yyyy-mm-dd | |
expectedDate | yyyy-mm-dd | |
expectedRevenue | double | |
expectedRevenueProbability | double | 0-100 |
expectedRevenueDate | yyyy-mm-dd |
Field | Format | Notes / Values |
---|---|---|
studentID | int | |
createdDateTime | yyyy-mm-dd hh:mm:ss | |
createdByUserID | int | |
lastModifiedDateTime | yyyy-mm-dd hh:mm:ss | |
lastModifiedByUserID | int | |
studentType | string | 'Prospect','Student','Public','Duplicate'. |
enrollmentItemsRequired | int | |
enrollmentItemsCompleted | int | |
enrollmentItemsStatus | string | 'NA','Completed','Not Completed' |
enrolledFromProspect | boolean | |
enrolledByUserID | int | |
enrolledDateTime | yyyy-mm-dd hh:mm:ss | |
advisorID | int | UserID of the assigned student advisor. |
locationID | int | Location of this student. |
userID | int | UserID of this student. |
hourClockID | int | The id of the assigned hour clock. |
imageDocumentID | int | The DocumentID of the image for this student. If 0 then no image has been uploaded. |
imageThumbnail | string | Thumbnail of student image. Base64 encoded, jpeg, 30x45. |
studentAssignedID | string(100) | |
source | string | API, Application,Form,Import,Moodle,Public Form,Web |
sourceDetails | string(100) | Details of the source. |
namePrefix | string | Mr, Ms, Mrs, Miss |
firstName | string(50) | |
middleName | string(50) | |
lastName | string(50) | |
preferredName | string(50) | |
addressOne | string(100) | |
addressTwo | string(100) | |
city | string(50) | |
province | string(50) | Province / State |
postalCode | string(25) | PostalCode / Zip |
country | string(2) | ISO 3166-1 2 Letter Code |
permAddressOne | string(100) | |
permAddressTwo | string(100) | |
permCity | string(100) | |
permProvince | string(50) | Province / State |
permPostalCode | string(25) | PostalCode / Zip |
permCountry | string(2) | ISO 3166-1 2 Letter Code |
phone | string(50) | |
mobilePhone | string(50) | |
workPhone | string(50) | |
altPhone | string(50) | |
string(100) | ||
secondaryEmail | string(100) | |
gender | string | |
dateofBirth | yyyy-mm-dd | |
sin | string(25) | SIN / SSN / NIN depending on country. |
internationalStudent | boolean | true, false |
feeClassCode | string | |
studentLeadStageID | int | |
leadStageKey | string | |
leadStage | string | |
leadStageDateTime | yyyy-mm-dd hh:mm:ss | |
leadStageStatus | string | 'NA','Completed','Not Completed' |
leadSourceCategoryCode | string | |
leadSourceCode | string | |
interested | string | Delimited by | |
tag | string | Delimited by | |
baseHours | double | |
expectedProgramID | int | |
expectedProgramAcademicSessionID | int | |
expectedProgramIntakeID | int | |
expectedProgramStartDate | yyyy-mm-dd | |
expectedProgramEnrollDate | yyyy-mm-dd | |
expectedProgramEndDate | yyyy-mm-dd | |
expectedDate | yyyy-mm-dd | |
expectedRevenue | double | |
expectedRevenueProbability | double | 0-100 |
expectedRevenueDate | yyyy-mm-dd | |
lastContactDateTime | yyyy-mm-dd hh:mm:ss | |
lastContactType | string | 'Email','Meeting','Phone','Sms' |
lastContactTypeID | int | |
lastContactByUserID | int | |
educationHighSchoolGraduate | boolean | |
educationHighSchoolGraduationYear | yyyy | |
educationHighSchoolName | string(50) | |
educationHighSchoolNotes | string | |
educationPostSecondaryOne | boolean | |
educationPostSecondaryOneName | string(50) | |
educationPostSecondaryOneFrom | yyyy-mm-dd | |
educationPostSecondaryOneTo | yyyy-mm-dd | |
educationPostSecondaryOneCredential | boolean | |
educationPostSecondaryOneCredentialType | string(15) | |
educationPostSecondaryOneNotes | string | |
educationPostSecondaryTwo | boolean | |
educationPostSecondaryTwoName | string(50) | |
educationPostSecondaryTwoFrom | yyyy-mm-dd | |
educationPostSecondaryTwoTo | yyyy-mm-dd | |
educationPostSecondaryTwoCredential | boolean | |
educationPostSecondaryTwoCredentialType | string(15) | |
educationPostSecondaryTwoNotes | string | |
emergencyContactOne | string(50) | |
emergencyContactOneRelationship | string(30) | |
emergencyContactOnePhone | string(25) | |
emergencyContactOnePhoneAlt | string(25) | |
emergencyContactTwo | string(50) | |
emergencyContactTwoRelationship | string(30) | |
emergencyContactTwoPhone | string(25) | |
emergencyContactTwoPhoneAlt | string(25) | |
employer | string(50) | |
employerContact | string(25) | |
employerAddressOne | string(100) | |
employerAddressTwo | string(100) | |
employerCity | string(50) | |
employerProvince | string(50) | |
employerCountry | string(2) | ISO 3166-1 2 Letter Code |
employerPostalCode | string(25) | |
employerPhone | string(50) | |
employerEmail | string(100) | |
employerWeb | string(100) | |
employerPosition | string(100) | |
employerPositionType | string | Full Time, Part Time |
employerStartDate | date | yyyy-mm-dd |
employerSalary | string(100) | |
currentStatus | string | Current status of student. |
currentStatusResult | string | Pending, Success, Failure |
currentStatusResultDate | yyyy-mm-dd | |
currentStatusAction | string | Next action to take. |
currentStatusEventDate | yyyy-mm-dd | |
currentFollowUpDate | yyyy-mm-dd | |
currentProgramCode | string | |
currentProgramName | string | |
totalCreditsEarned | double | |
percentageGradeAverage | double | |
gradePointAverage | double | |
avgAttendance | double | |
optedIn | boolean | Student opted into receiving emails. true, false |
optedInDate | yyyy-mm-dd | |
optedInIP | string | |
optedInNote | string | |
optedOut | boolean | Student opted out of receiving emails. true, false |
optedOutDate | yyyy-mm-dd | |
optedOutNote | string | |
customField1-100 | string(400) | |
deleted | boolean |
Field | Format | Notes / Values |
---|---|---|
studentAcademicSessionID | int | |
studentID | int | |
academicSessionID | int | |
registeredByUserID | int | |
registrationDate | yyyy-mm-dd | |
registrationNote | string | |
currentAcademicSession | boolean | |
creditsAttempted | double | |
creditsEarned | double | |
percentageGradeAverage | double | |
gradePointAverage | double | |
letterGrade | string | |
distinction | string | |
courseHours | double | |
timeclockHours | double | |
attended | int | |
absences | int | |
lates | int | |
avgAttendance | double | |
avgAbsences | double | |
avgLates | double |
Field | Format | Notes / Values |
---|---|---|
studentID | int | Required. |
academicSessionID | int | Required. |
registrationDate | yyyy-mm-dd | Required. |
makeCurrent | boolean | When true will set this academic session as student's current session. |
chargeFees | int | 0 No Fees, 1 Charge Account, 2 Invoice Account |
accountInvoiceID | int | Optional. Will add fees to provided invoice. |
note | string |
Field | Format | Notes / Values |
---|---|---|
studentNoteID | int | |
createdDateTime | yyyy-mm-dd hh:mm:ss | |
createdByUserID | int | |
lastModifiedDateTime | yyyy-mm-dd hh:mm:ss | |
lastModifiedByUserID | int | |
studentID | int | |
note | string | |
numRevisions | int | |
deleted | boolean |
Field | Format | Notes / Values |
---|---|---|
studentID | int | Required. |
status | string | Required. The new status. |
note | string |
Field | Format | Notes / Values |
---|---|---|
studentStatusID | int | |
createdDateTime | yyyy-mm-dd hh:mm:ss | |
createdByUserID | int | |
lastModifiedDateTime | yyyy-mm-dd hh:mm:ss | |
lastModifiedByUserID | int | |
studentID | int | Required. |
eventID | int | |
status | string | |
result | string | |
reason | string | |
note | string |
Field | Format | Notes / Values |
---|---|---|
studentProgramID | int | |
createdDateTime | yyyy-mm-dd hh:mm:ss | |
createdByUserID | int | |
lastModifiedDateTime | yyyy-mm-dd hh:mm:ss | |
lastModifiedByUserID | int | |
studentID | int | |
programID | int | |
startingAcademicSessionID | int | |
programIntakeID | int | |
programEnrollDate | yyyy-mm-dd | |
programStartDate | yyyy-mm-dd | |
expectedEndDate | yyyy-mm-dd | |
percentageGradeAverageCalculated | double | |
gradePointAverageCalculated | double | |
letterGradeCalculated | string | |
passFailCalculated | string | |
customGradeCalculated | string | |
percentageGradeAverage | double | |
gradePointAverage | double | |
letterGrade | string | |
passFail | string | |
customGrade | string | |
distinction | string | |
totalCreditsEarned | double | |
totalCreditsEarnedPercentage | double | |
totalHoursCompleted | double | |
totalHoursCompletedPercentage | double | |
totalHoursMissed | double | |
totalHoursMissedPercentage | double | |
totalHoursLate | double | |
totalHoursLatePercentage | double | |
status | string | Enrolled,Completed,Withdrawn |
statusDate | yyyy-mm-dd | |
statusReasonCode | string | |
statusReason | string | |
subStatus | string | |
credentialStatusCode | string | |
credentialAwardedCode | string | |
credentialAwarded | string | |
credentialAwardedDate | yyyy-mm-dd | |
credentialAwardedByUserID | int | |
credentialAwardedNote | string | |
primaryProgram | boolean | |
avgAttendanceCalculated | double | |
avgAbsencesCalculated | double | |
avgLatesCalculated | double | |
avgAttendance | double | |
avgAbsences | double | |
avgLates | double | |
avgAttendanceOverall | double | |
avgAbsencesOverall | double | |
avgLatesOverall | double | |
overrideFinal | boolean | |
overrideFinalDateTime | yyyy-mm-dd hh:mm:ss | |
overrideFinalUserID | int | |
overrideFinalReason | string | |
overrideAttendance | double | |
overrideAttendanceDateTime | yyyy-mm-dd hh:mm:ss | |
overrideAttendanceUserID | int | |
overrideAttendanceReason | string |
Field | Format | Notes / Values |
---|---|---|
studentID | int | Required. |
programID | int | Required. |
academicSessionID | int | Required. Student will automatically be registered if not registered. |
programIntakeID | int | |
programEnrollDate | yyyy-mm-dd | Required. |
programStartDate | yyyy-mm-dd | Required. |
expectedEndDate | yyyy-mm-dd | |
subStatus | string | |
primary | boolean | When true this program will be student's primary program. |
chargeFees | int | Required. '0' No Fees, '1' Charge Fees, '2' Invoice Fees |
accountInvoiceID | int | Will add fees to selected invoices. 'chargeFees' must be 2. |
Field | Format | Notes / Values |
---|---|---|
studentProgramID | int | Required. |
academicSessionIDChanged | boolean | |
academicSessionID | int | Required when changed. |
programIntakeIDChanged | boolean | |
programIntakeID | int | Required when changed. |
programEnrollDate | yyyy-mm-dd | Required. |
programStartDate | yyyy-mm-dd | Required. |
expectedEndDate | yyyy-mm-dd | |
subStatusChanged | boolean | |
subStatus | string | Required when changed. |
subStatusDate | yyyy-mm-dd | Required when changed. |
subStatusNote | string | |
primary | boolean | When true this program will be student's primary program. |
Field | Format | Notes / Values |
---|---|---|
studentProgramID | int | Required. |
overrideFinal | boolean | |
overrideFinalMark | double | Required for override. Between 0-100. |
overrideFinalReason | string | |
overrideAttendance | boolean | |
overrideAttendanceAmount | double | Required for override. Between 0-100. |
overrideAttendanceLateAmount | double | Required for override. Between 0-100. |
overrideAttendanceReason | string | |
awardCredential | boolean | |
completedDate | yyyy-mm-dd | Required. |
subStatus | string | |
note | string |
Field | Format | Notes / Values |
---|---|---|
studentProgramID | int | Required. |
withdrawType | int | Required. '1' Withdraw, '2' Remove Program from Record |
withdrawDate | yyyy-mm-dd | Required. |
withdrawCode | string | Required. Must match defined withdrawn codes. |
subStatus | string | |
reverseFees | int | Required. '0' No, '1' Reverse Charges, '2' Reverse Invoice |
accountChargeID[] | int[] | The charges to reverse. Required when reversing charges. |
accountInvoiceID | int | The invoice to reverse. Required when reversing invoice. |
note | string |
Field | Format | Notes / Values |
---|---|---|
studentProgramID | int | Required. |
subStatus | string | |
primary | boolean | When true this program will be student's primary program. |
Field | Format | Notes / Values |
---|---|---|
studentTransferCreditID | int | Required. |
createdDateTime | yyyy-mm-dd hh:mm:ss | |
createdByUserID | int | |
lastModifiedDateTime | yyyy-mm-dd hh:mm:ss | |
lastModifiedByUserID | int | |
studentID | int | |
courseCode | string | The course code in ampEducator. |
courseName | string | The course name in ampEducator. |
courseCredits | double | |
prevCourseCode | string | The course code being transferred. |
prevCourseName | string | The course name being transferred. |
prevInstitution | string | |
prevSession | string | |
transferDate | yyyy-mm-dd | |
notes | string |
Field | Format | Notes / Values |
---|---|---|
studentID | int | Required. |
courseCode | string | Required. The course code in ampEducator. |
courseName | string | Required. The course name in ampEducator. |
courseCredits | double | Required. |
prevCourseCode | string | Required. The course code being transferred. |
prevCourseName | string | Required. The course name being transferred. |
prevInstitution | string | Required. The name of institution being transferred from. |
prevSession | string | |
transferDate | yyyy-mm-dd | Required. |
notes | string |
Field | Format | Notes / Values |
---|---|---|
studentTransferCreditID | int | Required. |
courseCode | string | Required. The course code in ampEducator. |
courseName | string | Required. The course name in ampEducator. |
courseCredits | double | Required. |
prevCourseCode | string | Required. The course code being transferred. |
prevCourseName | string | Required. The course name being transferred. |
prevInstitution | string | Required. The name of institution being transferred from. |
prevSession | string | |
transferDate | yyyy-mm-dd | Required. |
notes | string |
Field | Format | Notes / Values |
---|---|---|
studentTransferCreditID | int | Required. |
Add, update and manage templates
Action | Required | Returns |
---|---|---|
/template/get Retrieves templates. |
None | Template [ ] |
Field | Format | Notes / Values |
---|---|---|
templateID | int | |
createdDateTime | yyyy-mm-dd hh:mm:ss | |
createdByUserID | int | |
lastModifiedDateTime | yyyy-mm-dd hh:mm:ss | |
lastModifiedByUserID | int | |
pdfTemplateID | int | |
templateSize | string | Letter, Legal, A4, Custom |
customWidth | double | With 'Custom' template size. In inches. |
customHeight | double | With 'Custom' template size. In inches. |
templateTitle | string(100) | Required. |
templateDescription | text | |
template | text | |
ownerUserID | int | |
readRoleMask | int | |
updateRoleMask | int | |
locationMask | long |