Hello...
I have a client that wants to use CallerANI to pull an array of accounts that associate to the CallerANI. This can be 1 or 15 accounts. If we run a DataAction the record only returns the first record of a CallerANI that has 12 records. We are using a $raw_results to get to the data.
Can we use a response array and map through the data using a count of the records returned, to iterate each record into different variables?
Are arrays supported in Architect of GenCloud?
Arrays are called collections in Architect. Can you send the full JSON response that holds the different accounts, we would want to take a look at that first? Take the example below:
I am using the following translationMap as part of a Data Actionto retrieve the queueIds for all waiting callbacks.
"QueueId": "$.conversations..participants[?(@.purpose =='acd')]..segments[0].queueId".
My output contract is
The full response body looks something like this..
{
"conversations": [
{
"conversationId": "f87b2ce3-da7d-4cf1-b0d5-7b8a487aeec5",
"conversationStart": "2022-02-23T00:56:31.789Z",
"divisionIds": [
"9cb31c55-a498-4bbe-a844-34a813d9b906"
],
"originatingDirection": "inbound",
"participants": [
{
"participantId": "298756ef-0eca-4784-aaac-f33000994f21",
"purpose": "acd",
"sessions": [
{
"callbackNumbers": [
"+XX"
],
....
{
...
}
],
"segments": [
{
"conference": false,
"queueId": "1b5e5c0a-318a-4aca-8025-29d3232d7d07",
"segmentStart": "2022-02-23T00:56:32.890Z",
"segmentType": "interact"
}
]
}
]
}
]
},
{
"conversationId": "ab5d7953-1be1-4066-8037-f315cd35e422",
"conversationStart": "2022-02-23T00:59:43.139Z",
"divisionIds": [
"9cb31c55-a498-4bbe-a844-34a813d9b906"
],
"mediaStatsMinConversationMos": 4.883596307487777,
"mediaStatsMinConversationRFactor": 92.49554443359375,
"originatingDirection": "inbound",
"participants": [
{
"participantId": "fbe77c78-1e2b-4521-a305-86c8d6a3b397",
"purpose": "acd",
"sessions": [
{
"callbackNumbers": [
"XX"
],
...
"metrics": [
{
"emitDate": "2022-02-23T00:59:44.232Z",
"name": "nOffered",
"value": 1
}
],
"segments": [
{
"conference": false,
"queueId": "ec4686b0-43af-475a-b286-6c21882dca9f",
"segmentStart": "2022-02-23T00:59:44.232Z",
"segmentType": "interact"
}
]
}
]
}
]
}
],
"totalHits": 2
}
So in my translation map, the QueueId defined in the output contract will store the QueueIds of the waiting callbacks in an array, however many there are. I can use this value in Architect if I want.
Does that help?
This helps a bit. Here is an example of 3 records returned that match CallerANI. So the CallerANI could be associated with 1 or 12 accounts, as an example. We need to pull the information such as acctnumber, membernumber, and address info to help identify the user at the desktop. We will populate variables in Architect to associated AgentDesktop variables so the agent knows they have to further qualify the client.
{
"individualId": 12541,
"memberId": 651245,
"ownershipType": "Primary",
"name": "ACCT MEMBER TEST",
"address": "1245 Main StreeT, MyPlace, ST 98451",
"taxId": "999-99-9999",
"driversLicense": "",
"password": "TEST",
"mothersMaidenName": "SFCU",
"alertMessage": "",
"stops": [
{}
]
},
{
"individualId": 365412,
"memberId": 415412,
"ownershipType": "Primary",
"name": "ACCT MEMBER TEST",
"address": "4152 ThisStreet, YourPlace, ST 98451",
"taxId": "999-99-9999",
"driversLicense": "",
"password": "TEST",
"mothersMaidenName": "STENSON",
"alertMessage": "",
"stops": [
{}
]
},
{
"individualId": 14115,
"memberId": 415214,
"ownershipType": "Primary",
"name": "ACCT MEMBER TEST",
"address": "7777 AnyStreet, ThisPlace, AX 415214",
"taxId": "999-99-9999",
"driversLicense": "",
"password": "TEST",
"mothersMaidenName": "JOHNSON",
"alertMessage": "",
"stops": [
{}
]
}
Are each of these account objects part of an array?
If so, if you want to retrieve all of the individualIds for example you could use the JSONPath of $..individualId to retrieve all of the individualIds and store that value in an array.
My translation map looks something like this
My Output contract looks like this:
And here are my results from my data action
Hopefully this helps and I am understanding your question correctly.
Thanks so much for the outline here. I will give it a run and let you know. This looks correct. I will test it out and reply shortly.
Here is the response. I mirrored the Output Contract the same and I can see my individualId numbers in the array, but the output may be incorrect?
Apply output transformation: Transform failed to process result using 'successTemplate' template due to error:'Unrecognized token '$': was expecting (JSON String, Number, Array, Object or token 'null', 'true' or 'false') at [Source: (String)"${ "individualId": [ 412451, 41521, 5847, 65124, 851452, 52412, 58541, 25124 ]}"; line: 1, column: 2]' Template:'${ "individualId": ${individualId}}'.
looks like there's an issue in the response template. Can you send a screen shot of what you have ?
{
"translationMap": {
"individualId": "$..individualId"
},
"translationMapDefaults": {
"individualId": ""UNKNOWN""
},
"successTemplate": "${\n"individualId": ${individualId}}"
}
{
"title": "Lookup Results",
"type": "object",
"properties": {
"individualId": {
"type": "array",
"items": {
"title": "individualId",
"type": "integer"
}
}
},
"additionalProperties": true
}
I sent the view of the output contract and the translation map
your success template is wrong. You shouldn't have that first "$" in the Template.
you have -- "successTemplate": "${\n"individualId": ${individualId}}"
you should have --"successTemplate": "{\n"individualId": ${individualId}}"
Oh wow. I didn't see that. I looked at it several times. Thanks for pointing that out. I am good now. I really appreciate the eagle eye on that. Thanks again.
Thanks for this. I am able to get the arrays for each account. Once I have the array, how can I pull the items in the array and assign to variables in Architect?
Use the Data Action in Architect, and bind the arrays for each account to a collection variable(s). Once bound to a variable, you can use typical coding syntax such as Common.queueID[0] to retreive the first item in the array, as an example.
Great..I suppose I could also predefine in my Contact Output options to house the various options as well? Although this option above looks very clean. Thanks.
This topic was automatically closed 31 days after the last reply. New replies are no longer allowed.
