Original Message:
Sent: 02-21-2025 15:42
From: George Ganahl
Subject: Need to include null value in the response when the API doesn't give any values.
Something I have used when an element in the returned array may or may not have a value is something like:
\"Address1\":$Address1.replace(\"null\", \" $esc.quote$esc.quote\")
That replaces a null value with "" since you can't have a null in the result set
------------------------------
George Ganahl GCP, GCSME, ICCE, ICHD, etc.
Technical Adoption Champion
Genesys
Original Message:
Sent: 02-20-2025 11:41
From: Jarvish Kisanth Singh
Subject: Need to include null value in the response when the API doesn't give any values.
Hi Samuel,
Thanks for the update,
I have asked the question already, but I haven't got the response yet!
------------------------------
Jarvish Kisanth Singh
Original Message:
Sent: 02-20-2025 11:03
From: Samuel Jillard
Subject: Need to include null value in the response when the API doesn't give any values.
Hi Jarvish,
It doesn't look like a "quantity" is returned if there is no timeoff balance. This might be a good question to ask in the Developer Forum as they will be better placed to answer what is expected in the API Responses
------------------------------
Sam Jillard
Online Community Manager/Moderator
Genesys - Employees
Original Message:
Sent: 02-20-2025 08:29
From: Jarvish Kisanth Singh
Subject: Need to include null value in the response when the API doesn't give any values.
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.
#API/Integrations
------------------------------
Jarvish Kisanth Singh
------------------------------