JsonArray to String /Data table

[ronanpeter]

Try using the deserialisze json array activity.

Previously when I developed ServiceNow integration I ended up using Excel Power Query as a workaround due to the bug I explained earlier. It may still be an issue here.

I found that PowerQuery works well with the outputs from ServiceNow as a workaround

Convert Dynamic JsonArray into Datatable

If you are more comfortable using Excel - you can have excel deserialise the json array file into the table format you need, you just need to set up the excel workbook with a data connection to the json file. It uses PowerQuery. [JsonPowerQ] Once you have it in the format you need, you can use the Execute Macro activity in UiPath and use this to refresh the workbook each time your process is run, making it dynamically updated from the source Json File.