Original Message:
Sent: 11-07-2023 01:00
From: Anandakumar Ponnuchamy
Subject: DnB Jolt Mapping
Hi Lynn,
will it possible to filter a data multi level filter condition . Actually we want take get employee attributes details if
"informationScopeDescription": "Consolidated", && "reliabilityDescription": "Actual", attaching the current jolt mapping for your reference .
Jolt Mappping :
"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"
}
}
}
}
}
}
},
DnB Response :
{
"value": 9100,
"minimumValue": null,
"maximumValue": null,
"employeeFiguresDate": null,
"informationScopeDescription": "Consolidated",
"informationScopeDnBCode": 9067,
"reliabilityDescription": "Actual",
"reliabilityDnBCode": 9092,
"employeeCategories": [
{
"employmentBasisDescription": "Principals",
"employmentBasisDnBCode": 9064
}
],
"trend": [
{
"timePeriod": {
"description": "1-3 years",
"dnbCode": 13711
},
"growthRate": -6.0
},
{
"timePeriod": {
"description": "1-5 years",
"dnbCode": 13721
},
"growthRate": -59.0
}
]
}
------------------------------
Anandakumar Ponnuchamy
workday
Original Message:
Sent: 10-05-2023 13:03
From: Lynn Overall
Subject: DnB Jolt Mapping
this should work , however take into account if you need the additional attributes you will need to add those into the Jolt transformation however based on the requirement
first check for "Individual" and "Consolidated" in the "informationScopeDescription" field for each item in the "numberOfEmployees" array. If it finds both, it assigns the value "Individual" to "Individual" and "Consolidated" to "Consolidated" in the output. If it finds only "Individual," it assigns "Individual" to the output, and if it finds only "Consolidated," it assigns "Consolidated" to the output
[
{
"operation": "shift",
"spec": {
"numberOfEmployees": {
"*": {
"informationScopeDescription": {
"Individual": {
"*": {
"@": "Individual"
}
},
"Consolidated": {
"*": {
"@": "Consolidated"
}
}
}
}
}
}
}
]
------------------------------
Lynn Overall
Dun & Bradstreet
Austin TX
Original Message:
Sent: 10-05-2023 10:37
From: Anandakumar Ponnuchamy
Subject: DnB Jolt Mapping
hi @Jay Daly,
Could you please share your input here .
------------------------------
Anandakumar Ponnuchamy
workday
Original Message:
Sent: 10-05-2023 10:36
From: Anandakumar Ponnuchamy
Subject: DnB Jolt Mapping
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
------------------------------