Articles → AUTOMATION ANYWHERE → Read Json Data In Automation Anywhere

Read Json Data In Automation Anywhere

Steps

1. Create a python program to read json data.
2. Open command prompt in automation anywhere.
3. Execute the python program and put output in text file
4. Read text file.

Create A Python Program To Read Json Data

import json


# some JSON:
x = '{ "name":"Karan", "age":37, "city":"Gurgaon"}'

# parse x:
y = json.loads(x)

print(y["name"])
print(y["age"])
print(y["city"])

Open Command Prompt In Automation Anywhere

Execute The Python Program And Put Output In Text File

c:\python\python c:\temp\test.py > c:\temp\output.txt

1. First parameter is the path of python.exe.
2. Second parameter is the path of python file.
3. Third parameter is the path of output file.

Read Text File

Output