How to add node with data in JArray datatype?


Follow the steps

  1. Convert the jarray to datatable using assign activity with dt = varJarray.ToObject(Of DataTable)
  2. Use add data column activity and add a new column Column3
  3. Then populate the values …as I see all the 3 values are similar say if you want to add xxx only as value for all roes then use assign with dt.Columns("Column3").Expression = "'xxx'"
  4. Now you need to convert the datatable to jarray again using the same serialize and deserialize steps you used above in your code after read range

Ideally as per your code …you can start from step 2 as you are reading datatable from excel anyways and can add the column after that immediately and populte it


1 Like