AnsweredAssumed Answered

json split document not working - data process shape

Question asked by akhajooei272797 on Jul 5, 2017
Latest reply on Jul 10, 2017 by akhajooei272797

Hi,

 

I am trying to split a json response by eId under application (made them bold below) using the Data Process Shape. my input json is:

 

{
"candidates": [
{
"address": "1818 Albion Street",
"address2": "",
"application": {
"comments": "",
"customField": [
{
"fieldCode": "hgn_job_title",
"key": "Halogen Job Title",
"value": "HR Coordinator"
},
{
"fieldCode": "hgn_base_salery",
"key": "Halogen Base Salery",
"value": "19.00"
},
{
"fieldCode": "hgn_base_salary_type",
"key": "Halogen Base Salary Type",
"value": "HOUR"
}
],
"disposition": "Not interviewed",
"eId": "ppHuQjwe",
"gender": "Female",
"hasArtifacts": true,
"job": {},
"jobviteChannel": "Email",
"lastUpdatedDate": 1498228474080,
"race": "Black or African American",
"resume": {
"content": "\ntest resume\n\n",
"format": "Text",
"name": "resume.txt"
},
"sentDate": 1496162075097,
"source": "nashvillegeneralhospital - Desktop",
"sourceType": "Career Site",
"veteranStatus": "Not a Veteran",
"workflowState": "Rejected"
},
"city": "Nashville",
"companyName": "Nashville General Hospital",
"country": "USA",
"countryCode": "USA",
"countryName": "United States",
"eId": "eZozCiwl",
"email": "nghhrtest.@gmail.com",
"firstName": "Nghhr",
"homePhone": "615-341-4054",
"lastName": "Test",
"location": "Nashville, TN United States",
"mobile": "",
"postalCode": "37208",
"state": "TN",
"stateCode": "TN",
"stateName": "Tennessee",
"title": "HR Coordinator",
"workPhone": "",
"workStatus": "None"
},
{
"address": "1818 Albion Street",
"address2": "",
"application": {
"comments": "",
"customField": [
{
"fieldCode": "hgn_status",
"key": "Halogen Status",
"value": "The New Hire has been created."
},
{
"fieldCode": "hgn_status_date",
"key": "Halogen Status Date",
"value": "05/30/2017"
},
{
"fieldCode": "hgn_hire_type",
"key": "Halogen Hire Type",
"value": "HIRE"
},
{
"fieldCode": "hgn_preferred_contact_phone_type",
"key": "Halogen Preferred Contact Phone Type",
"value": "HOME"
},
{
"fieldCode": "emergency_contact_last_name",
"key": "Emergency Contact Last Name",
"value": "Rih"
}
],
"disposition": "Not interviewed",
"eId": "pYcvQjwj",
"gender": "Female",
"hasArtifacts": true,
"job": {
"company": "Nashville General Hospital",
"customField": [],
"department": "Human Resources",
"eId": "oKqP4fwN",
"hiringManagers": [
{
"firstName": "Steve ",
"lastName": "Kennedy",
"userId": "sflUXhwd",
"userName": "steve.kennedy@nashvilleha.org"
}
],
"primaryHiringManager": {
"firstName": "Steve ",
"lastName": "Kennedy",
"userId": "sflUXhwd",
"userName": "steve.kennedy@nashvilleha.org"
},
"recruiters": [
{
"firstName": "Mariah",
"lastName": "Brooks",
"userId": "s1ei1hwk",
"userName": "Mariah.Brooks@NashvilleHA.org"
}
],
"requisitionId": "",
"subsidiaryId": "fnV9Vfw6",
"title": "HR Coordinator"
},
"jobviteChannel": "Email",
"lastUpdatedDate": 1498228446280,
"race": "Black or African American",
"resume": {
"content": "\ntest resume\n\n",
"format": "Text",
"name": "resume.txt"
},
"sentDate": 1496163870313,
"source": "nashvillegeneralhospital - Desktop",
"sourceType": "Career Site",
"veteranStatus": "Not a Veteran",
"workflowState": "Rejected"
},
"city": "Nashville",
"companyName": "Nashville General Hospital",
"country": "USA",
"countryCode": "USA",
"countryName": "United States",
"eId": "eZozCiwl",
"email": "nghhrtest.@gmail.com",
"firstName": "Nghhr",
"homePhone": "615-341-4054",
"lastName": "Test",
"location": "Nashville, TN United States",
"mobile": "",
"postalCode": "37208",
"state": "TN",
"stateCode": "TN",
"stateName": "Tennessee",
"title": "HR Coordinator",
"workPhone": "",
"workStatus": "None"
}
],
"total": 2,
"status": {
"code": 200,
"messages": []
}
}

 

I imported this json into a json profile and then I choose the element below for splitting in data process shape:

 

eId (Root/Object/candidates/Array/ArrayElement1/Object/application/Object/eId)

 

so I would like to get two documents as result one with the first application eId and one with the other one but I get the same as input.

 

I am not sure what I am missing.

 

would really appreciate your help

Outcomes