Claudio,
Here's an example of one of my scripts and how I parse the JSON information.
JSON response from my server:
{
"OUTLAST_PAYMENT":"200.00"
"OUTLAST_PAYMENT_DATE":"06/13/2019"
"OUTRETURN_CODE":"00"
"OUTRETURN_MESSAGE":"Account payment info. passed !"
}
Here's how I extract the information. I don't know if this is the right or best way to do this but this is how I successful extract the information. I have a Set Value element from the Math category. Under the Setting tab, I have 5 local variables defined (a separate variable for each piece of information I need to extract from the JSON response):
Name: localOUTLAST_PAYMENT, value:
importPackage(com.audium.server.cvpUtil)
var json = {Data.Element.rest_Get_Payment_Info.response_body}
var path = "$.OUTLAST_PAYMENT"
JSONPathUtil.eval(json,path)
Name: localOUTLAST_PAYMENT_DATE, value:
var json = {Data.Element.rest_Get_Payment_Info.response_body}
var path = "$.OUTLAST_PAYMENT_DATE"
JSONPathUtil.eval(json,path)
Name: localOUTRETURN_CODE, value:
var json = {Data.Element.rest_Get_Payment_Info.response_body}
var path = "$.OUTRETURN_MESSAGE"
JSONPathUtil.eval(json,path)
Name: localOUTRETURN_MESSAGE, value:
var json = {Data.Element.rest_Get_Payment_Info.response_body}
var path = "$.OUTRETURN_CODE"
JSONPathUtil.eval(json,path)
Name:localOUTLAST_PAYMENT_RETURNED (not in every response), value:
var json = {Data.Element.rest_Get_Payment_Info.response_body}
var path = "$.OUTLAST_PAYMENT_RETURNED"
JSONPathUtil.eval(json,path)
In the Data tab of the element, Session Data pane:
lastPaymentAmount, session data: {LocalVar.local_OUTLAST_PAYMENT}, create: After (VERY important to do this after, not before. If you do before, your variable will be empty)
Do this for each piece of data you want to return to ICM.
See attached file for screenshots of what is returned in the Set Value element.
Once you have the local variable data stored in your session variables, you can return those to ICM in the Caller Input, External VXML 0, 1, 2, and 3 variables in the CVP Subdialog Return element. If you have more than 5 pieces of data you need to return to ICM, you can either use a ReqICMLabel element or concatenate your data into CSV, return it to ICM then extract it using Before and After statements in a Set Variable node. If you need to do this, let me know and I'll show you an example of how I had to do this in the past.
I hope this helps.
