Fetch the data from JSON

Help Orchestrator
,
3

Hi @Riya1

=> Build Data Table
Output → dt

=> Use Read Text File activity to read the JSON text file store the output in a variable say jsonString.

=> Use Deserializ JSON activity and pass jsonString as Input and store the output in a variable say jsonObject.

=> Use FOr Each Loop and give the below condition:

For Each currentJToken in jsonObject("value")
   Add Data Row Activity
         -> Array Row: New Object() {currentJToken("MachineName").ToString(), currentJToken("State").ToString()}
         -> DataTable: dtOutput
End For Each

=> Use Write Range Workbook to write dtOutput back to excel.

XAML:
Sequence87.xaml (11.6 KB)

Regards