Hi @Pablo_Sanchez ,
I was able to Get the Data into the Json as Needed. Although there might be a better method than this.
First we have to identify the group of values in the input String. We could use the below Regex for that :
\[(\d+)\](\w+)
We can then use the Matches Activity with the above pattern to get the resultant matched values.
Here onwards, the data I have converted to a Datatable for ease in grouping the values.
Next, Group the data based on Number and iterate through the Grouped Values and add the Jobject or JArray as needed in the loop to a parent JObject.
Output would be in the Below format :
Check the workflow and Let us know if this doesn’t work :
ConvertString_ToJson.xaml (13.0 KB)