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 |
|---|---|---|
| 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 | StatusChangeDate | 20190826 |
| 20191002 | ||
| Object_Name__c | "Account" |
JSON example:
{ |
|---|
Process Log
The process log table is used to manage the date ranges when calling the service.
...