VBA-tools / VBA-JSON

JSON conversion and parsing for VBA
MIT License
1.8k stars 574 forks source link

Parsing inner JSON properties #161

Open nightfullstar opened 4 years ago

nightfullstar commented 4 years ago

We need to parse in the resultList's inner properties. '{ "vehicleId":100255, "plate":"34 UN 6645", "displayName":"", "resultList":[ { "vehicleId":100255, "plate":"34 UN 6645", "displayName":"", "kmType":"1", "startTime":1550008817000, "firstTime":1550008817000, "endTime":1550095188000, "lastTime":1550095188000, "startDistance":109804, "endDistance":109956, "totalDistance":152, "distanceMultiplier":1, "ignitionOnTotalTime":18147, "maxSpeed":100, "averageSpeed":32, "movementTime":15497, "idleTime":2650, "stopTime":68164, "alarmCount":0, "upperSpeedCount":0, "idleTimeCount":2, "harshAccCount":0, "harshDecCount":0, "ignitionOnCount":16, "ignitionOffCount":16, "startLatitude":41.051678333333, "startLongitude":28.753481666667, "startAddress":"TURKEY \u0130stanbul K\u00fc\u00e7\u00fck\u00e7ekmece Yar\u0131mburgaz Mh. Yonca Sk.", "endLatitude":41.051803333333, "endLongitude":28.75346, "endAddress":"TURKEY \u0130stanbul K\u00fc\u00e7\u00fck\u00e7ekmece Yar\u0131mburgaz Mh. Yonca Sk." } ] }'

houghtonap commented 4 years ago

VBA-JSON makes use of the VBA Collection object for JSON Arrays and the Scripting.Dictionary object for JSON Objects. Both of these objects are described on Microsoft's website. The issue you opened is not an issue with VBA-JSON, but is basic knowledge of programming in VBA. Please at least do some basic research, before opening new issues that are basically requests for general programming help. For an understanding of how the parse the object created by VBA-JSON, see this comment.

https://github.com/VBA-tools/VBA-JSON/issues/131#issuecomment-585378506