var platformData = []; domo.get('/data/v1/platformproductiondata').then(function(data){ var production = []; for (var i = 0; i < data.length; i++) { var productionData = ({ Production_Date: data[i].Production_Date, Monthly_Oil_Volume_bbl: Number(data[i].Monthly_Oil_Volume_bbl).toLocaleString('en').split('.')[0], Monthly_Gas_Volume_mcf: Number(data[i].Monthly_Gas_Volume_boe).toLocaleString('en').split('.')[0] }); production.push(productionData); var platforms = ({ Area_Code_Block_Number: data[i].Area_Code_Block_Number, CISN_plat: data[i].CISN_plat, Complex_Id_Num: data[i].Complex_Id_Num, First_Production_Date: data[i].First_Production_Date, Install_Date: data[i].Install_Date, Latitude: data[i].Latitude, Lease_Number: data[i].Lease_Number, Longitude: data[i].Longitude, Bus_Asc_Name: data[i].Bus_Asc_Name, Structure_Name: data[i].Structure_Name, Structure_Number: data[i].Structure_Number, Structure_Type_Code: data[i].Structure_Type_Code, Daily_Gas_Volume_mcfd: Number(data[i].Daily_Gas_Volume_mcfd).toLocaleString('en').split('.')[0], Max_Daily_Gas_Volume_mcfd: Number(data[i].Max_Daily_Gas_Volume_mcfd).toLocaleString('en').split('.')[0], Daily_Oil_Volume_bd: Number(data[i].Daily_Oil_Volume_bd).toLocaleString('en').split('.')[0], Max_Daily_Oil_Volume_bd: Number(data[i].Max_Daily_Oil_Volume_bd).toLocaleString('en').split('.')[0], Total_Oil_Volume_bbl: Number(data[i].Total_Oil_Volume_bbl).toLocaleString('en').split('.')[0], Total_Gas_Volume_mcf: Number(data[i].Total_Gas_Volume_mcf).toLocaleString('en').split('.')[0], Total_Water_Volume_bbl: Number(data[i].Total_Water_Volume_bbl).toLocaleString('en').split('.')[0], Water_Depth: Number(data[i].Water_Depth).toLocaleString('en').split('.')[0], Production: production }); platformData.push(platforms); } });