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(WelcomePolicy) | 1 or NULLnull | Welcome Policy Indicator / Consent | ||
| WP_Start_Date__c (format:YYYY-MM-DD) | WPStartDate (WelcomePolicy)YYYYMMDD (20210608) | 20210608 | Welcome Start Date format:YYYYMMDD | ||
| WP_End_Date__c | WPEndDate (WelcomePolicy) | YYYYMMDD (20210608)(format:YYYY-MM-DD) | WPEndDate | 20220609 | Welcome End Date format:YYYYMMDD |
| Object_Name__c | "Account" |
JSON example:
...