I have some JSON data -
{"status": 200, "message": "ok", "data": {"priceIndex": 0.4513350942223604, "action": "charge", "responseGenerated": "2017-08-01T13:30:48.244247+12:00", "dischargeIfPriceAbove": 360.4239999999999, "losseskW": 2.0, "billable": "ICJ-19133", "capacitykWh": 100.0, "chargeRatekW": 90.0, "chargePercent": 50.0, "efficiencyPercent": 82.0, "averagePrice": 300.3533333333333, "chargeIfPriceBelow": 240.28266666666664, "GXP": "HOR0331", "dischargeRatekW": 90.0, "prices": [{"starts": "2017-08-01T13:30:00+12:00", "ends": "2017-08-01T14:00:00+12:00", "spotEnergyPriceDollarsPerMWh": 135.56}, {"starts": "2017-08-01T14:00:00+12:00", "ends": "2017-08-01T14:30:00+12:00", "spotEnergyPriceDollarsPerMWh": 135.56}, .......
We have used the HTTP retriever and regex to get the unique values out (status and capacity etc) but we are having trouble getting the "prices" data out as the constituents of prices are not unique (starts,ends,spotEnergyPriceDollarsPerWh). Looking for advice for the best way to iterate through the "prices" JSON data to create point values. The idea would be to log a point value (Starts1) which takes the time after the first appearance of "starts" in the prices, then iterate through to the next appearance of starts and log the time as Starts2 etc etc.
Any suggestions would be appreciated.