| Task | Source | Target | JSON Format |
|---|
| Online Channel | online Channel endpoint (OData API) | CRM | Fairpass Profile record json |
| Fairpass Migration Data | TESS - NAS - CSV file | CRM | Fairpass Profile record json |
| TTC FairPass monthly Files (3) download | TTC SFTP | Corp NAS |
|
TTC FairPass Card Replacement File
(1 of 3 in TTC files) | Corp NAS - xml file | CRM | FairPass Card Replace json |
FairPass Profile Data Mapping
| OData field | TESS CSV field | JSON field | Example |
|---|
| firstname | GivenName | First_Name__c | "Julius", |
| lastname | LastName | Last_Name__c | "Cicconettii", |
| dob | BirthDate | Date_of_Birth__c | "1967-04-09", |
| ADDRESS_FULL | StreetName | Street__c | "1815-12 12", |
| email | EmailAddress | Email__c | "d@email.com", |
| CITY | City | City__c | "ETOBICOKE", |
| WARD | ProvinceCode | Province__c | "Ontario", |
| POSTAL_CODE | PostalCode | postal_code__c | "M5N 5E3", |
| phone | Alternate contact numbe | Phone__c | "333-333-3336", |
| phoneMobile | TelephoneNumber | Phone_Mobile__c | "333-333-3336", |
| sams_member_id | SAMS Reference# | sams_member_id__c | "372180668841", |
| presto_number | PrestoCardNum | presto_card__c | "41234567890", |
| tcs_household_id | TCS ID # (Children) | TCS_member_id__c | "372180668841", |
| "Fairpass Online" | "Fairpass Migration" | Process_type__c | "Fairpass Online", |
| Web_reference_number |
| Web_Reference_Number__c | " |
1| 1604077789" |
| Created_On |
| "Created_On__c" | "2020-10-22T18:44:19.000+0000" |
| StartDate | Start_Date__c | 1980-09-03 |
| ExpiryDate | End_Date__c | 1980-09-03 |
| IssueDate | Issue_Date__c | 1980-09-03 |
JSON Example
{
"allOrNone" : false,
"compositeRequest" : [
{
"method" : "POST",
"url" : "/services/data/v49.0/sobjects/HSI_Web_Form_Event__e",
"referenceId" : "1618255275",
"body" : {
"Created_On__c" : "2021-04-12T15:21:15.592-04:00",
"First_Name__c" : "",
"Last_Name__c" : "",
"Date_of_Birth__c" : "1982-,
"Street__c" : " E",
"City__c" : "Toronto",
"Province__c" : "Ontario",
"postal_code__c" : "M3C ",
"Email__c" : "",
"Household_Id__c" : "1188323",
( or "sams_member_id__c" : "215550914",)
"presto_card__c" : "",
"Process_type__c" : "Fairpass Online",
"Web_Reference_Number__c" : "1618255275"
}
}...
]
} |
|---|
Reference Jira:
| Jira Legacy |
|---|
| server | JIRA |
|---|
| columns | key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution |
|---|
| serverId | 171541f2-d15a-30f9-88a2-170d76c90864 |
|---|
| key | HSIF-2717 |
|---|
|
| Jira Legacy |
|---|
| server | JIRA |
|---|
| columns | key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution |
|---|
| serverId | 171541f2-d15a-30f9-88a2-170d76c90864 |
|---|
| key | HSIF-2718 |
|---|
|
| Jira Legacy |
|---|
| server | JIRA |
|---|
| columns | key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution |
|---|
| serverId | 171541f2-d15a-30f9-88a2-170d76c90864 |
|---|
| key | HSIF-2719 |
|---|
|
...
FairPass Card replacement Mapping:
| TTC XML field | JSON Field | Example |
|---|
| CONCESSION |
| 94:TTC-Fair Pass |
| OLDCARDNUMBER |
| 31240111780217006 |
| NEWCARDNUMBER |
| 31240111835903006 |
| DATEOFTRANSFER |
| 02/01/2020 07:47:36 AM |