Satish,
Something like this would do it in a background script, relatively trivial to put it into a script step in FD to put each string line into an output Array:-
// Declare the output array
var outputString = "";
// Declare the current Building ID variable
var currentBuildingId;
// Declare the current Floor ID variable
var currentFloorId;
// Declare the floors Array to improve loop performance.
var floorsArray = [];
// Declare the rooms Array to improve loop performance.
var roomsArray = [];
// Retrieve the data
var dataArray = JSON.parse(jsonString).data;
// For each building, retrieve the building ID and iterate the floors.
for(var i = 0; i< dataArray.length; i++){
currentBuildingId = dataArray[i].buildingID;
floorsArray = dataArray[i].floors;
// For each floor, retrieve the floor ID and iterate the rooms.
for(var j = 0; j < floorsArray.length; j++){
currentFloorId = floorsArray[j].floorID;
roomsArray = floorsArray[j].rooms;
for(var k = 0; k < roomsArray.length; k++){
outputString += currentBuildingId + "," + currentFloorId + "," + roomsArray[k].roomID + "\r\n";
}
}
}
gs.info(outputString);
Hope this helps,
Richard
