Data Actions: convert string to integer in sucessTemplate

[Irina]

Hi,
I'm trying to calculate the number of users that are online and active for a specific queue using /api/v2/analytics/queues/observations/query API.
My response configuration looks as follows:
{
"translationMap": {
"oActiveUserCount": "$.results[0].data[?(@.metric=='oActiveUsers')].stats.count",
"oOfflineQueueUserCount": "$.results[0].data[?(@.metric=='oOffQueueUsers' && @.qualifier==$.systemToOrganizationMappings.OFFLINE[0])].stats.count"
},
"translationMapDefaults": {},
"successTemplate": "#set($oOnlineUserCount = ${successTemplateUtils.firstFromArray(${oActiveUserCount},"0")} - ${successTemplateUtils.firstFromArray(${oOfflineQueueUserCount},"0")}) { "ONLINE_USER_COUNT": $oOnlineUserCount}"

}
When I run my data action, I receive the following error message:
** 10. Apply output transformation: Transform failed to process result using 'successTemplate' template due to error:'Reference $oOnlineUserCount evaluated to null when attempting to render at successTemplate[line 1, column 187]' Template:'#set($oOnlineUserCount = ${successTemplateUtils.firstFromArray(${oActiveUserCount},"0")} - ${successTemplateUtils.firstFromArray(${oOfflineQueueUserCount},"0")}) { "ONLINE_USER_COUNT": $oOnlineUserCount}'.

I think the problem is in data types: firstFromArray returns String, instead of Integer. Is it possible to convert it to Integer in successTemplate?

Regards,
Irina

[Jerome.Saint-Marc]

Hello,

The following response configuration should work:

{
  "translationMap": {
    "oActiveUserCount": "$.results[0].data[?(@.metric=='oActiveUsers')].stats.count",
	"oOfflineQueueUserCount": "$.results[0].data[?(@.metric=='oOffQueueUsers' && @.qualifier==$.systemToOrganizationMappings.OFFLINE[0])].stats.count"
  },
  "translationMapDefaults": {
    "oActiveUserCount": "[]",
    "oOfflineQueueUserCount": "[]"
  },
  "successTemplate": "{\"ONLINE_USER_COUNT\": $math.sub(${successTemplateUtils.firstFromArray(\"${oActiveUserCount}\",\"0\")},${successTemplateUtils.firstFromArray(\"${oOfflineQueueUserCount}\",\"0\")})}"
}

Regards,

[Irina]

Thank you Jerome, it works!