Is it possible to manipulate JSON like this in Mongoose form script?

DM9346

I have this JSON reply from an API below

My goal is to create a list view wherein the environments will be flattened into one array object then the details of each are concatenated like the one below.

My question is, is this possible in form script? Or is this better done outside of mongoose?

Rene Bottern

Sure, you can use something like below (Note! this is in C#).

//<ref>Newtonsoft.Json.dll</ref>
using Newtonsoft.Json;

public static DataTable JsonToDataTable(string json, string subSection)
{
bool columnsCreated = false;
DataTable dt = new DataTable(subSection);

Newtonsoft.Json.Linq.JObject root = Newtonsoft.Json.Linq.JObject.Parse(json);
Newtonsoft.Json.Linq.JArray items = (Newtonsoft.Json.Linq.JArray)root[subSection];

Newtonsoft.Json.Linq.JObject item = default(Newtonsoft.Json.Linq.JObject);

for (int i = 0; i <= items.Count - 1; i++)
{
// Create the columns once
if (columnsCreated == false)
{
item = (Newtonsoft.Json.Linq.JObject)items[i];

// Add each of the columns into a new row then put that new row into the DataTable
item = (Newtonsoft.Json.Linq.JObject)items[i];

dr[((Newtonsoft.Json.Linq.JProperty)jtoken).Name.ToString()] = ((Newtonsoft.Json.Linq.JProperty)item.First).Value.ToString();

// Create the new row, put the values into the columns then add the row to the DataTable
DataRow dr = dt.NewRow();

dt.Rows.Add(dr);
}

return dt;
}