Hi, I'm accessing data from an API and am triggering the I/O on a RevPi based on the data. I'm wondering on the best approach to parse the data and act on it. My programming now is becoming somewhat unwieldy.
I have the data coming back in an XML format. The structure is something like this:
object
payload: object
DispatchEventResult: object
$: object
DispatchEventList: array[1]
0: object
DispatchEvent: array[35]
[0 … 9]
0: object
DemandEventSourceType: array[1]
EndDate: array[1]
EventId: array[1]
FacilityName: array[1]
IsInternalTestEvent: array[1]
IsTestEvent: array[1]
IsoId: array[1]
IsoName: array[1]
MeterId: array[1]
MeterName: array[1]
ProductTypeId: array[1]
ProductTypeName: array[1]
ProgramName: array[1]
ResourceId: array[1]
StartDate: array[1]
ZoneId: array[1]
ZoneName: array[1]
1: object
2: object
3: object
4: object
5: object
6: object
7: object
8: object
9: object
[10 … 19]
[20 … 29]
[30 … 34]
What I would like to do is be able to look through each array and store the specified data, since the number of arrays can change. Right now I have the switch node storing objects and a function node but it's static and if the number of arrays change it will not work. How can I parse through this entire object and store the data associated with object:EventId?