Hi All,
Can someone assist me here to get the proper jolt for the below use case .
Use Case :1 if Dnb Response numberOfEmployees.informationScopeDescription contains Both Values "Individual"& "Consolidated".
We need to pick Consolidated Object attribute values.
"numberOfEmployees": [
{
"value": 80,
"minimumValue": null,
"maximumValue": null,
"employeeFiguresDate": null,
"informationScopeDescription": "Individual",
"informationScopeDnBCode": 9068,
"reliabilityDescription": "Actual",
"reliabilityDnBCode": 9092,
"employeeCategories": []
},
{
"value": 170,
"minimumValue": null,
"maximumValue": null,
"employeeFiguresDate": null,
"informationScopeDescription": "Consolidated",
"informationScopeDnBCode": 9067,
"reliabilityDescription": "Actual",
"reliabilityDnBCode": 9092,
"employeeCategories": [
{
"employmentBasisDescription": "Principals",
"employmentBasisDnBCode": 9064
}
]
Usecase 2 : informationScopeDescription contains only Individual or Consolidated data ,then we need to pick data of which ever s available .
"numberOfEmployees": [
{
"value": 80,
"minimumValue": null,
"maximumValue": null,
"employeeFiguresDate": null,
"informationScopeDescription": "Individual",
"informationScopeDnBCode": 9068,
"reliabilityDescription": "Actual",
"reliabilityDnBCode": 9092,
"employeeCategories": []
}]
or
"numberOfEmployees": [
{
"value": 80,
"minimumValue": null,
"maximumValue": null,
"employeeFiguresDate": null,
"informationScopeDescription": "Individual",
"informationScopeDnBCode": 9068,
"reliabilityDescription": "Actual",
"reliabilityDnBCode": 9092,
"employeeCategories": []
}]
our Current Jolt mapping failed use case 2 ,if it contains only "informationScopeDescription": "Individual",
Current Jolt Mapping :
"numberOfEmployees": {
"*": {
"informationScopeDescription": {
"Consolidated": {
"@(2,value)": "[4].attributes.EmployeeDetails[0].value.TotalEmployees[].value",
"@(2,reliabilityDescription)": "[4].attributes.EmployeeDetails[0].value.ReliabilityDescription[].value",
"@(2,informationScopeDescription)": "[4].attributes.EmployeeDetails[0].value.InformationScopeDescription[].value",
"@(2,employeeFiguresDate)": "[4].attributes.EmployeeDetails[0].value.EmployeeFiguresDate[].value",
"@(2,trend)": {
"*": {
"growthRate": "[4].attributes.EmployeeDetails[0].value.GrowthRates[&1].value.GrowthRate[].value",
"@(0,timePeriod)": {
"description": "[4].attributes.EmployeeDetails[0].value.GrowthRates[&1].value.TimePeriod[].value"
}
}
}
}
}
}
},
------------------------------
Anandakumar Ponnuchamy
workday
------------------------------