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.
...
Salesforce Fields | OW API Fields | OW API Example | Comment | |
|---|---|---|---|---|
| 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 |
| Mrs. | ||
| 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 | 0121h0000004kgaAAA (Parent) (age >=18 based on birthday) 012W000000016sEIAQ (Child) (age <18 based on birthday) | |||
| 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 (format:YYYY-MM-DD) | StatusChangeDate | 20190826 | ||
| 20191002 | ||||
| WP_Ind__c | WPInd | 1 or null (WelcomePolicy) | WPStartDate (WelcomePolicy) | WPEndDate (WelcomePolicy)Welcome Policy Indicator / Consent |
| WP_Start_Date__c (format:YYYY-MM-DD) | WPStartDate | 20210608 | Welcome Start Date format:YYYYMMDD | |
| WP_End_Date__c (format:YYYY-MM-DD) | WPEndDate | 20220609 | Welcome End Date format:YYYYMMDD | |
| Object_Name__c | "Account" |
JSON example:
...