Integration with Oracle HCM via REST API as Authoritative source

[JasmeenB]

Hi,

We are trying to make connection to Oracle HCM and get the user data into saviynt.

1. Do we have any example to how to get the worker details from HCM to Saviynt using Oracle HCM worker API?

2. Can below response from worker API be parsed by Saviynt and how to get the attributes from Link objects below like names and addresses

{
"items": [
{
"PersonId": "<person_id>",
"PersonNumber": "<person_no>"
"CorrespondenceLanguage": null,
"BloodType": null,
"DateOfBirth": "<DOB>",
"DateOfDeath": null,
"CountryOfBirth": null,
"RegionOfBirth": null,
"TownOfBirth": null,
"ApplicantNumber": null,
"CreatedBy": "<created by>",
"CreationDate": "<create date>",
"LastUpdatedBy": "<las updated by>"",
"LastUpdateDate": "<last updated date>",
"links": [
{
"rel": "self",
"href": "<URL>/hcmRestApi/resources/11.13.18.05/workers/00020000000EACED0005770800005AF34AEAAB750000004AACED00057372000D6A6176612E73716C2E4461746514FA46683F3566970200007872000E6A6176612E7574696C2E44617465686A81014B5974190300007870770800000186C3AADC0078",
"name": "workers",
"kind": "item",
"properties": {
"changeIndicator": "ACED0005737200136A6176612E7574696C2E41727261794C6973747881D21D99C7619D03000149000473697A65787000000002770400000002737200116A6176612E6C616E672E496E746567657212E2A0A4F781873802000149000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B0200007870000000037371007E00020000000578"
}
},
{
"rel": "canonical",
"href": "<URL>/hcmRestApi/resources/11.13.18.05/workers/00020000000EACED0005770800005AF34AEAAB750000004AACED00057372000D6A6176612E73716C2E4461746514FA46683F3566970200007872000E6A6176612E7574696C2E44617465686A81014B5974190300007870770800000186C3AADC0078",
"name": "workers",
"kind": "item"
},
{
"rel": "child",
"href": "<URL>/hcmRestApi/resources/11.13.18.05/workers/00020000000EACED0005770800005AF34AEAAB750000004AACED00057372000D6A6176612E73716C2E4461746514FA46683F3566970200007872000E6A6176612E7574696C2E44617465686A81014B5974190300007870770800000186C3AADC0078/child/addresses",
"name": "addresses",
"kind": "collection"
},
{
"rel": "child",
"href": "<URL>/hcmRestApi/resources/11.13.18.05/workers/00020000000EACED0005770800005AF34AEAAB750000004AACED00057372000D6A6176612E73716C2E4461746514FA46683F3566970200007872000E6A6176612E7574696C2E44617465686A81014B5974190300007870770800000186C3AADC0078/child/citizenships",
"name": "citizenships",
"kind": "collection"
},
{
"rel": "child",
"href": "<URL>/hcmRestApi/resources/11.13.18.05/workers/00020000000EACED0005770800005AF34AEAAB750000004AACED00057372000D6A6176612E73716C2E4461746514FA46683F3566970200007872000E6A6176612E7574696C2E44617465686A81014B5974190300007870770800000186C3AADC0078/child/disabilities",
"name": "disabilities",
"kind": "collection"
},
{
"rel": "child",
"href": "<URL>/hcmRestApi/resources/11.13.18.05/workers/00020000000EACED0005770800005AF34AEAAB750000004AACED00057372000D6A6176612E73716C2E4461746514FA46683F3566970200007872000E6A6176612E7574696C2E44617465686A81014B5974190300007870770800000186C3AADC0078/child/driverLicenses",
"name": "driverLicenses",
"kind": "collection"
},
{
"rel": "child",
"href": "<URL>/hcmRestApi/resources/11.13.18.05/workers/00020000000EACED0005770800005AF34AEAAB750000004AACED00057372000D6A6176612E73716C2E4461746514FA46683F3566970200007872000E6A6176612E7574696C2E44617465686A81014B5974190300007870770800000186C3AADC0078/child/emails",
"name": "emails",
"kind": "collection"
},
{
"rel": "child",
"href": "<URL>/hcmRestApi/resources/11.13.18.05/workers/00020000000EACED0005770800005AF34AEAAB750000004AACED00057372000D6A6176612E73716C2E4461746514FA46683F3566970200007872000E6A6176612E7574696C2E44617465686A81014B5974190300007870770800000186C3AADC0078/child/ethnicities",
"name": "ethnicities",
"kind": "collection"
},
{
"rel": "child",
"href": "<URL>/hcmRestApi/resources/11.13.18.05/workers/00020000000EACED0005770800005AF34AEAAB750000004AACED00057372000D6A6176612E73716C2E4461746514FA46683F3566970200007872000E6A6176612E7574696C2E44617465686A81014B5974190300007870770800000186C3AADC0078/child/externalIdentifiers",
"name": "externalIdentifiers",
"kind": "collection"
},
{
"rel": "child",
"href": "<URL>/hcmRestApi/resources/11.13.18.05/workers/00020000000EACED0005770800005AF34AEAAB750000004AACED00057372000D6A6176612E73716C2E4461746514FA46683F3566970200007872000E6A6176612E7574696C2E44617465686A81014B5974190300007870770800000186C3AADC0078/child/legislativeInfo",
"name": "legislativeInfo",
"kind": "collection"
},
{
"rel": "child",
"href": "<URL>/hcmRestApi/resources/11.13.18.05/workers/00020000000EACED0005770800005AF34AEAAB750000004AACED00057372000D6A6176612E73716C2E4461746514FA46683F3566970200007872000E6A6176612E7574696C2E44617465686A81014B5974190300007870770800000186C3AADC0078/child/messages",
"name": "messages",
"kind": "collection"
},
{
"rel": "child",
"href": "<URL>/hcmRestApi/resources/11.13.18.05/workers/00020000000EACED0005770800005AF34AEAAB750000004AACED00057372000D6A6176612E73716C2E4461746514FA46683F3566970200007872000E6A6176612E7574696C2E44617465686A81014B5974190300007870770800000186C3AADC0078/child/names",
"name": "names",
"kind": "collection"
},
{
"rel": "child",
"href": "<URL>/hcmRestApi/resources/11.13.18.05/workers/00020000000EACED0005770800005AF34AEAAB750000004AACED00057372000D6A6176612E73716C2E4461746514FA46683F3566970200007872000E6A6176612E7574696C2E44617465686A81014B5974190300007870770800000186C3AADC0078/child/nationalIdentifiers",
"name": "nationalIdentifiers",
"kind": "collection"
},
{
"rel": "child",
"href": "<URL>/hcmRestApi/resources/11.13.18.05/workers/00020000000EACED0005770800005AF34AEAAB750000004AACED00057372000D6A6176612E73716C2E4461746514FA46683F3566970200007872000E6A6176612E7574696C2E44617465686A81014B5974190300007870770800000186C3AADC0078/child/otherCommunicationAccounts",
"name": "otherCommunicationAccounts",
"kind": "collection"
},
{
"rel": "child",
"href": "<URL>/hcmRestApi/resources/11.13.18.05/workers/00020000000EACED0005770800005AF34AEAAB750000004AACED00057372000D6A6176612E73716C2E4461746514FA46683F3566970200007872000E6A6176612E7574696C2E44617465686A81014B5974190300007870770800000186C3AADC0078/child/passports",
"name": "passports",
"kind": "collection"
},
{
"rel": "child",
"href": "<URL>/hcmRestApi/resources/11.13.18.05/workers/00020000000EACED0005770800005AF34AEAAB750000004AACED00057372000D6A6176612E73716C2E4461746514FA46683F3566970200007872000E6A6176612E7574696C2E44617465686A81014B5974190300007870770800000186C3AADC0078/child/phones",
"name": "phones",
"kind": "collection"
},
{
"rel": "child",
"href": "URL>/hcmRestApi/resources/11.13.18.05/workers/00020000000EACED0005770800005AF34AEAAB750000004AACED00057372000D6A6176612E73716C2E4461746514FA46683F3566970200007872000E6A6176612E7574696C2E44617465686A81014B5974190300007870770800000186C3AADC0078/child/photos",
"name": "photos",
"kind": "collection"
},
{
"rel": "child",
"href": "<URL>/hcmRestApi/resources/11.13.18.05/workers/00020000000EACED0005770800005AF34AEAAB750000004AACED00057372000D6A6176612E73716C2E4461746514FA46683F3566970200007872000E6A6176612E7574696C2E44617465686A81014B5974190300007870770800000186C3AADC0078/child/religions",
"name": "religions",
"kind": "collection"
},
{
"rel": "child",
"href": "<URL>/hcmRestApi/resources/11.13.18.05/workers/00020000000EACED0005770800005AF34AEAAB750000004AACED00057372000D6A6176612E73716C2E4461746514FA46683F3566970200007872000E6A6176612E7574696C2E44617465686A81014B5974190300007870770800000186C3AADC0078/child/visasPermits",
"name": "visasPermits",
"kind": "collection"
},
{
"rel": "child",
"href": "<URL>/hcmRestApi/resources/11.13.18.05/workers/00020000000EACED0005770800005AF34AEAAB750000004AACED00057372000D6A6176612E73716C2E4461746514FA46683F3566970200007872000E6A6176612E7574696C2E44617465686A81014B5974190300007870770800000186C3AADC0078/child/workRelationships",
"name": "workRelationships",
"kind": "collection"
},
{
"rel": "child",
"href": "<URL>/hcmRestApi/resources/11.13.18.05/workers/00020000000EACED0005770800005AF34AEAAB750000004AACED00057372000D6A6176612E73716C2E4461746514FA46683F3566970200007872000E6A6176612E7574696C2E44617465686A81014B5974190300007870770800000186C3AADC0078/child/workersDFF",
"name": "workersDFF",
"kind": "collection"
},
{
"rel": "child",
"href": "<URL>/hcmRestApi/resources/11.13.18.05/workers/00020000000EACED0005770800005AF34AEAAB750000004AACED00057372000D6A6176612E73716C2E4461746514FA46683F3566970200007872000E6A6176612E7574696C2E44617465686A81014B5974190300007870770800000186C3AADC0078/child/workersEFF",
"name": "workersEFF",
"kind": "collection"
}
]
}

[Darshanjain]

Hi @JasmeenB 

Please find the sample json

{
"connection": "acctAuth",
"url": "https://xxxxxxxxxxx.ca2.oraclecloud.com/hcmCoreApi/resources/latest/emps?onlyData=true&totalResults=...",
"httpMethod": "GET",
"httpHeaders": {
"Authorization": "${access_token}",
"contentType": "application/json"
},
"httpContentType": "application/json",
"colsToPropsMap": {
"firstName": "FirstName~#~char",
"lastName": "LastName~#~char",
"middleName": "MiddleName~#~char",
"displayName": "DisplayName~#~char",
"startDate": "HireDate~#~date",
"enddate": "TerminationDate~#~date",
"employeeId": "PersonNumber~#~char",
"employeetype": "WorkerType~#~char",
"email": "WorkEmail~#~char",
"preferedFirstName": "PreferredName~#~char",
"systemUserName": "UserName~#~char",
"manager": "assignments[0].ManagerId~#~char",
"status": "assignments[0].AssignmentStatus~#~char",
"customproperty1": "NameSuffix~#~char",
"customproperty2": "PersonId~#~char",
"customproperty3": "AddressLine1~#~char",
"customproperty4": "AddressLine2~#~char",
"customproperty5": "AddressLine3~#~char",
"customproperty6": "City~#~char",
"customproperty7": "Country~#~char",
"customproperty8": "PostalCode~#~char",
"customproperty9": "HomePhoneNumber~#~char",
"customproperty10": "HomePhoneAreaCode~#~char",
"customproperty11": "HomePhoneCountryCode~#~char",
"customproperty12": "HomePhoneExtension~#~char",
"customproperty13": "Region2~#~char",
"customproperty14": "assignments[0].AssignmentStatus~#~char",
"customproperty15": "assignments[1].PersonTypeId~#~char"

},
"SuccessResponses": {
"successResponses": {
"message": "success"
}
},
"unsuccessResponses": {
"statusCode": [400, 403, 401, 404, 409, 501, 500],
"errorCodePath": "errorCode",
"userResponsePath": "results"
},
"userResponsePath": "items",
"pagination": {
"offset": {
"offsetParam": "offset",
"batchParam": "limit",
"batchSize": 500,
"totalCountPath": "completeResponseMap.totalResults"
}
}
}

For more information: Please check out the documentation as well

https://docs.saviyntcloud.com/bundle/OracleERPCloud-v55x/page/Content/Understanding-the-Integration-...

Thanks

Darshan