We are deploying a bot via API and the dev team wants to pass in a nested dictionary, a list of dictionaries, so to speak. Is this possible? If not, can json be passed in a string variable and then the json action package parse out what we need?
Solved
Working with a nested dictionary
+1Best answer by Zaibi
Dear
Yes, it is possible to pass a nested dictionary (a list of dictionaries) as an argument when deploying a bot via the API in Automation Anywhere. You can do this by converting the nested dictionary to a JSON string and passing the string as an argument to the API.
To convert the nested dictionary to a JSON string, you can use the "Convert to JSON" action from the "JSON" package in Automation Anywhere. This action takes a dictionary or list as an input and returns a JSON string representation of the data.
Here is an example of how you might use the "Convert to JSON" action to pass a nested dictionary as an argument to the API:
-
Use the "Convert to JSON" action to convert the nested dictionary to a JSON string and store the result in a variable.
-
Use the "Call API" action to call the API and pass the JSON string as an argument.
-
Use the "Parse JSON" action from the "JSON" package to parse the JSON string and extract the data you need.
Alternatively, you could pass the nested dictionary directly as an argument to the API and use the "Parse JSON" action to parse the data on the server side. This would allow you to avoid the need to convert the data to a JSON string before calling the API.
Regards,
+16- Most Valuable Pathfinder
- 3276 replies
Hi
For handling the dictionary data’s
Would you like to manipulate the JSON to get the data node/key, please explore the JSON object manager.
QuickTip: Using the JSON Object Manager Package
Thanks!
+1Thank you. I don’t think a dictionary will work in this instance because they want to send a nested dictionary. In other words multiple values for each key. See below example payload they want to send.
"doc_requirements": {
"type": "LIST",
"list": [
{
"type": "DICTIONARY",
"dictionary": [
{
"key": "loan_number",
"value": { "type": "STRING", "string": "236221127878" }
},
{
"key": "stack",
"value": { "type": "STRING", "string": "236221127878_Marsh.pdf" }
},
{
"key": "individual_docs",
"value": {
"type": "STRING",
"string": "236221127878_Marsh.pdf::Title - CPL,236221127878_Marsh.pdf::Final Underwriting Docs,236221127878_Marsh.pdf::Title - Wiring Instructions"
}
}
]
},
{
"type": "DICTIONARY",
"dictionary": [
{
"key": "loan_number",
"value": { "type": "STRING", "string": "109221025493" }
},
{
"key": "stack",
"value": {
"type": "STRING",
"string": "109221025493_Werling.pdf"
}
},
{
"key": "individual_docs",
"value": {
"type": "STRING",
"string": "109221025493_Werling.pdf::Title - CPL,109221025493_Werling.pdf::Title - Wiring Instructions,109221025493_Werling.pdf::Final Underwriting Docs"
}
}
]
+14Hi
I don’t think there is a straight approach to fulfill this other than using some inline scripts like Python or Java or through some custom DLL.
- Most Valuable Pathfinder
- 2707 replies
Hi
You are right, we cannot achieve this directly. I’d recommend creating a custom DLL which will do the heavy lifting of calling this api and get you the output in desired format.
Interesting use case, could you also place a enhancement request with AA so it will be beneficial for everyone.
+6Dear
Yes, it is possible to pass a nested dictionary (a list of dictionaries) as an argument when deploying a bot via the API in Automation Anywhere. You can do this by converting the nested dictionary to a JSON string and passing the string as an argument to the API.
To convert the nested dictionary to a JSON string, you can use the "Convert to JSON" action from the "JSON" package in Automation Anywhere. This action takes a dictionary or list as an input and returns a JSON string representation of the data.
Here is an example of how you might use the "Convert to JSON" action to pass a nested dictionary as an argument to the API:
-
Use the "Convert to JSON" action to convert the nested dictionary to a JSON string and store the result in a variable.
-
Use the "Call API" action to call the API and pass the JSON string as an argument.
-
Use the "Parse JSON" action from the "JSON" package to parse the JSON string and extract the data you need.
Alternatively, you could pass the nested dictionary directly as an argument to the API and use the "Parse JSON" action to parse the data on the server side. This would allow you to avoid the need to convert the data to a JSON string before calling the API.
Regards,
Zaibi wrote:
Dear
Yes, it is possible to pass a nested dictionary (a list of dictionaries) as an argument when deploying a bot via the API in Automation Anywhere. You can do this by converting the nested dictionary to a JSON string and passing the string as an argument to the API.
To convert the nested dictionary to a JSON string, you can use the "Convert to JSON" action from the "JSON" package in Automation Anywhere. This action takes a dictionary or list as an input and returns a JSON string representation of the data.
Here is an example of how you might use the "Convert to JSON" action to pass a nested dictionary as an argument to the API:
-
Use the "Convert to JSON" action to convert the nested dictionary to a JSON string and store the result in a variable.
-
Use the "Call API" action to call the API and pass the JSON string as an argument.
-
Use the "Parse JSON" action from the "JSON" package to parse the JSON string and extract the data you need.
Alternatively, you could pass the nested dictionary directly as an argument to the API and use the "Parse JSON" action to parse the data on the server side. This would allow you to avoid the need to convert the data to a JSON string before calling the API.
Regards,
Hi
Where is this “Convert to JSON” action under the JSON package?? Are you using some other A360?
1 person likes this
+1Thanks for all of the feedback. I ended up going with the solution to have the Dev team send the data in json to a string variable and then using the json action package and some assistance from this AAIllustrates video to get it into a useable format. The only potential downside to this is the 65k character limit in a string variable.
1 person likes this
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.