JSON Path Mapping

Warning
The PERSON_NUMBER attribute should not be updated in the JSON Path Mapping.

Screenshot

Full Aggregation

The Oracle HCM Cloud SaaS connector will aggregate the attributes associated with the primary work relationship and corresponding assignments based on the dates. In order to change this behavior, specify the attribute value as specified below in JSON Path Mapping. This will enable the customer to fetch the work relationship and Job Information in accordance with your requirements.

The following API response is an example of how to specify the JSON path query for the workRelationships attribute:

"workRelationships": [
{
"PeriodOfServiceId": 300000034528102,
"LegislationCode": "IN",
"WorkerType": "E",
"PrimaryFlag": true,
"StartDate": "2022-08-11",
"assignments": [
{ "AssignmentId": 300000034528108,
… }
]
},
"PeriodOfServiceId": 300000034528226,
"LegislationCode": "IN",
"WorkerType": "N",
"PrimaryFlag": false,
"StartDate": "2022-08-23",
"assignments": [
{"AssignmentId": 300000034528233,
… }
]

Case 1

If concurrent workRelationships are active and you want to fetch the attribute from primary workRelationships such as PeriodOfServiceId, then the JSON path for attribute mapping is:

workRelationships[?(@.PrimaryFlag==true)].PeriodOfServiceId

Case 2

If concurrent workRelationships are active and you want to fetch the attribute from secondary workRelationships such as PeriodOfServiceId, then the JSON path for attribute mapping is:

workRelationships[?(@.PrimaryFlag==False)].PeriodOfServiceId

Case 3

If multiple workRelationshipsattributes are active, the API response looks like the following:

Copy

"workRelationships": [
{
"PeriodOfServiceId": 300000034528102,
"LegislationCode": "IN",
"WorkerType": "E",
"PrimaryFlag": true,
"StartDate": "2022-08-11",
"assignments": [
{"AssignmentId": 300000034528108,
 "AssignmentType": "E",
"PrimaryFlag": true,
"PrimaryAssignmentFlag": true,
… }
]
},
"PeriodOfServiceId": 300000034528226,
"LegislationCode": "IN",
"WorkerType": "N",
"PrimaryFlag": false,
"StartDate": "2022-08-23",
"assignments": [
{"AssignmentId": 300000034528233,
 "AssignmentType": "P",
"PrimaryFlag": false,
"PrimaryAssignmentFlag": true,
… }
]

If you want to fetch the attribute from assignments which is primary and belongs to a particular AssignmentType such as AssignmentId, then the JSON path for attribute mapping is:

workRelationships..assignments[?(@.PrimaryAssignmentFlag==true && @.AssignmentType=='E' && @.PrimaryFlag==true)].AssignmentId

1. Select Add Another to add a new entry.

2. In each row, enter a CSV/Schema Attribute name, its corresponding JSON Path, and ATOM Feeds Attribute.

3. (Optional) Select Add Another to add more rows to the list.

4. Select Save.

Delta Aggregation

The Oracle ATOM feed API response is divided into the following parts:

• Context

• Changed Attributes

By default, the Oracle HCM Cloud Connector fetches the information from the Changed Attributes section. If you want to change this behavior, the JSON Path mapping section can be used. For example,

Context" : [ {
    "PersonNameId" : "300000040265075",
    "PersonName" : " 7939first",
    "PersonNumber" : "7939",
    "WorkEmail" : "test@gmail.com",
    "PrimaryPhoneNumber" : "",
    "PersonId" : "300000040265074",
    "PeriodType" : "E",
    "WorkerType" : "EMP",
    "DMLOperation" : "UPDATE",
    
  } ],
  "Changed Attributes" : [ {
    "OrderName" : {
      "old" : "test",
      "new" : "test 7939first"
    }
  }, {
    "ListName" : {
      "old" : "test",
      "new" : "test1"
    }
  }, {
    "FirstName" : {
      "old" : null,
      "new" : "7939first"
    }
  }, {
    "FullName" : {
      "old" : "test",
      "new" : "7939first"
    }
  },
  }, {
    "Title" : {
      "old" : null,
      "new" : "MR."
    }
  }, {
    "MiddleNames" : {
      "old" : null,
      "new" : "7939middle"
    }
  } ]
}]]>

In the following example, the PersonName attribute is not available in Changed Attributes. Therefore, the connector will not fetch the value out of the box. To fetch it, you can specify the following JSON path.

Context[0].PersonName