FairPass synchronization to CRM

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	"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:

Error rendering macro 'jira' : Unable to locate Jira server for this macro. It may be due to Application Link configuration.

Unable to locate Jira server for this macro. It may be due to Application Link configuration. Unable to locate Jira server for this macro. It may be due to Application Link configuration.

Reference TESS CSV format mapping.MigrationMapping.xlsx

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