Need to include null value in the response when the API doesn't give any values

[Jarvish]

Hi All,

I have an API which gives the below raw response,

{
"total": 5,
"data": [
{
"worker": {
"descriptor": "Dummy name",
"id": "9e4bae7b012b01d0c97f1ab726089393"
},
"unit": {
"descriptor": "Hours",
"id": "c4dacbd56bca4a9a8950e8d3ed21bbdb"
},
"absencePlan": {
"timeoffs": "(Discretionary Day)",
"descriptor": "Discretionary Day",
"id": "9f87f860702d108b8efd3c6723349928"
},
"category": {
"descriptor": "Time Off Plan",
"id": "8cdc5bb54494100018789cabb3df006d"
},
"effectiveDate": "2025-02-21"
},
{
"worker": {
"descriptor": "Dummy name",
"id": "9e4bae7b012b01d0c97f1ab726089393"
},
"unit": {
"descriptor": "Hours",
"id": "c4dacbd56bca4a9a8950e8d3ed21bbdb"
},
"absencePlan": {
"timeoffs": "(Diversity Celebration Day)",
"descriptor": "Diversity Celebration Day",
"id": "7219002ea3ed010e3ed3025bfc01eec7"
},
"category": {
"descriptor": "Time Off Plan",
"id": "8cdc5bb54494100018789cabb3df006d"
},
"effectiveDate": "2025-02-21",
"quantity": "8"
},
{
"worker": {
"descriptor": "Dummy name",
"id": "9e4bae7b012b01d0c97f1ab726089393"
},
"unit": {
"descriptor": "Hours",
"id": "c4dacbd56bca4a9a8950e8d3ed21bbdb"
},
"absencePlan": {
"timeoffs": "(Unpaid Leave - PTO, Protected/Sick Time, PTO)",
"descriptor": "PTO",
"id": "9f87f860702d108b8efd482c5a04992e"
},
"category": {
"descriptor": "Time Off Plan",
"id": "8cdc5bb54494100018789cabb3df006d"
},
"effectiveDate": "2025-02-21",
"quantity": "184"
},
{
"worker": {
"descriptor": "Dummy name",
"id": "9e4bae7b012b01d0c97f1ab726089393"
},
"unit": {
"descriptor": "Hours",
"id": "c4dacbd56bca4a9a8950e8d3ed21bbdb"
},
"absencePlan": {
"descriptor": "Vaccine/Wellness Time",
"id": "d560d355351d01aab570df4f8754ae73",
"timeoffs": "(Vaccine/Wellness Time)"
},
"category": {
"descriptor": "Time Off Plan",
"id": "8cdc5bb54494100018789cabb3df006d"
},
"effectiveDate": "2025-02-21",
"quantity": "4"
},
{
"worker": {
"descriptor": "Dummy name",
"id": "9e4bae7b012b01d0c97f1ab726089393"
},
"unit": {
"descriptor": "Hours",
"id": "c4dacbd56bca4a9a8950e8d3ed21bbdb"
},
"absencePlan": {
"timeoffs": "(Volunteer Time)",
"descriptor": "Volunteer Time",
"id": "9f87f860702d108b8efd557de9ac9938"
},
"category": {
"descriptor": "Time Off Plan",
"id": "8cdc5bb54494100018789cabb3df006d"
},
"effectiveDate": "2025-02-21",
"quantity": "40"
}
]
}

if you take a close look for the first item we don't have anything called quantity, if we are not getting any fields like this I want to take it as 0/null using translation mapping.

Current translation mapping which I have is below:

{
"translationMap": {
"timeOffType": "$.data[].absencePlan.id",
"balance": "$.data[].quantity"
},
"translationMapDefaults": {
"timeOffType": "UNKNOWN",
"balance": "UNKNOWN"
},
"successTemplate": "{ "timeOffType": ${timeOffType}, "balance": ${balance} }"
}
Current Response:
{
"timeOffType": [
"9f87f860702d108b8efd3c6723349928",
"7219002ea3ed010e3ed3025bfc01eec7",
"9f87f860702d108b8efd482c5a04992e",
"d560d355351d01aab570df4f8754ae73",
"9f87f860702d108b8efd557de9ac9938"
],
"balance": [
"8",
"184",
"4",
"40"
]
}
Expected Response:
{
"timeOffType": [
"9f87f860702d108b8efd3c6723349928",
"7219002ea3ed010e3ed3025bfc01eec7",
"9f87f860702d108b8efd482c5a04992e",
"d560d355351d01aab570df4f8754ae73",
"9f87f860702d108b8efd557de9ac9938"
],
"balance": [
"NA"/"0"/null
"8",
"184",
"4",
"40"
]
}

Kindly look into this and let me know your thoughts on this.

Regards,
Jarvish Kisanth Singh

[Jarvish]

Hi All,

Can someone help me on this?

Regards,
Jarvish Kisanth Singh

[Jerome.Saint-Marc]

Hello,

I don't think it is possible to capture this missing balance quantity as null/O.

The Data Action translation map entries you have defined are JSONPath expressions (Data Actions leverage JSONPath).
If you define something like: $.data[*].quantity, JSONPath will only return values from data object which did have a quantity attribute.
To get what you want, the data object you want to return O/null would have had to be defined as quantity: null.

Regards,