Hi there I am trying to convert JSON to Data-Table to write in a spreadsheet, attaching a sample file, I am keep getting error on passing the string to Deserialize Json Array activity but its throwing error, while trying with Deserialize it as JObj its able to parse it but unable to convert it to Data-Table to get the data in spreadsheet. This Json is complicated one
i cant attach a screenshot because the policies of organization
you should do :
build data table contains columns that you want to add in excel
2.use Deserialize JSON Array Activity and put as input the name of variable that contains json
and put the output in variable lets call it “JSOARR”.
for each item in “JSOARR”
and put inside for each, assign activity for fields you want to get from json and store inside it the filed from json object as string like below:
then use add data row and put id and age to store on build data table that you already created in step 1
use write range and put name of build data table variable to store on excel sheet
But You need to define some Fixed Fields Not All the fields is a lot of information there and I don’t understrand how you will process this.
You need to adress Items in one line but select maximum 10 items not 100 items.