Creating Dynamic JSON on basis of excel data

Help Activities
, , ,
6

Hello @Pogboom

If you want to edit the values in your text file that is formatted like JSON, then yes.

  1. Read text file
  2. Deserialize Json
  3. For each row in Excel file

If the column name is the same as you json keys, then you could loop these, to save space on the Assign activities.

  1. For each dt_ExcelFile.Columns
Assign jobj_JsonObject("priceList")(currentColumnName) = currentDataRow(currentColumnName)

Regards
Soren