Toronto Employment and Social Services (TESS) is providing a web service that returns client profiles. This approach eliminates the need for HSIO to temporarily save any client information.
TESS has documented the service here and the OpenAPI definition of the service is provided here.
OW Client Service to CRM Platform Events Mapping
Adult Mapping
The source is the JSON from the GetClientProfile method in the TESS-HSI service. The destination is the JSON representation of the Salesforce Account sobject.
| Source | Destination | Comment |
|---|---|---|
GivenName | FirstName | |
LastName | LastName | |
MiddleName | MiddleName | |
Suffix | Not needed | |
| ReferenceNum | Ontario_Works_Id__c | |
DoB | personBirthDate | there may be the need to transform the date: the input format is yyyymmdd |
personEmail | No email address | |
telephoneNumber | Phone | |
Secondary_Phone__c | Not provided by OW | |
PersonMobilePhone | Not provided by OW | |
| streetNumber|| ' ' || streetName | street | |
| city | city | |
| province | state_code | |
| postalCode | postal_code | |
| 'CA' | country_code | |
| 'Address' | geocodeAccuracy | |
| businessUnitId | household_id__c | |
| StatusCode | case_status__c | |
| DomesticViolenceIndicator |
Salesforce Sync JSON Data Mapping:
Salesforce Fields | OW API Fields | OW API Example |
|---|---|---|
| JSON_Message__c | ||
| first_name__c | GivenName | Bibiana |
| last_name__c | LastName | MKMOPPJXK |
| case_status__c | CS10001 | |
| SAMS_Status__c | Status | Completed |
| 1 | ||
| Name | firstname + ' ' +MiddleName + ' '+ lastname | |
| F | ||
| gender__c | Gender | Female |
| salutation__c | Title | |
| date_of_birth__c (yyyy-mm-dd) | DoB | 19820428 |
| email__c | (null) | |
| phone | Telephone | 555-5555555 |
| Secondary_Phone__c | (null) | |
| Other_phone__c | (null) | |
| Mobile_phone__c | (null) | |
| Is_Aboriginal__c | (null) | |
| BillingStreet(Primary) | UnitNumber + '-' +streetNumber + ' ' + streetName | 12-1254 Street |
| BillingCity | city | SCARBOROUGH |
| BillingState | province | SCARBOROUGH |
| BillingPostalCode | postalCode | M5N 5E3 |
| BillingCountry | "CA" | |
| ShippingStreet(Secondary) | (null) | |
| ShippingCity | (null) | |
| ShippingState | (null) | |
| ShippingPostalcode | (null) | |
| ShippingCountry | (null) | |
| RecordTypeId | ? | |
| Ontario_Works_Id__c | ReferenceNum | 15146436109 |
| Children_Services_Id__c | (null) | |
| CSIS_household_Id__c | (null) | |
| AccountSource | "Ontario Works" | |
| Children_Services_Household_Id__c | (null) | |
| RGI_Houshold_Id__c | (null) | |
| OW_Household_id__c | ICCaseID | 1212724857222 |
| 0 | ||
| Is_sensitive_client__c(Boolean/Integer) | DomesticViolenceIndicator | 0 |
| OW_start_date__c | StatusChangeDate | 20190826 |
| 20191002 | ||
| Object_Name__c | "Account" |
Process Log
The process log table is used to manage the date ranges when calling the service.