ERROR: Root value of JSON structure must be object or array

How To
1

hi

i am trying to work with array inside json but getting this error:
Root value of JSON structure must be object or array.

the array is not in the root. I get this result sample below.
how can iterate the VEHICLES array?

"{"statuscode":0,"data":{"VEHICLES":[{"DV":"22F1001575","NN":"22F1001575_LTE","PN":"22F1001575",…},
{"DV":"053810946623","NN":"Hilik DASH3 Test","PN":"053810946623",…},{"DV":"ES07073","NN":"ES07073","PN":"ES07073","DR":126327,…},{"DV":"859682","NN":"859682","PN":"859682","DR":138762…}
]}}

1 Like
2

Hi @Rafi_Newman,

Can you share if possible via Jsonkeeper, the whole JSON that you want to use?

When I used, the JSON parse on the JSON you shared with modification, It is working fine.

Basically,

  1. Parse JSON
  2. Iterate over Vehicle

See the blueprint that you can export as a new scenario and then see if that is working for you.

Screenshot from 2023-06-28 17-33-30
Screenshot from 2023-06-28 17-33-30726×392 29.4 KB

Screenshot from 2023-06-28 17-33-38
Screenshot from 2023-06-28 17-33-38776×625 60.7 KB

blueprint (45).json (3.3 KB)

Screenshot from 2023-06-28 17-33-46
Screenshot from 2023-06-28 17-33-46964×469 44.8 KB

1 Like
3

here is the full json as copied from the error box of the Parse Json module

do you know why i get these \ chars?. i have another working scenario that gets a clean json from the http request.

you may check the problematic scenario “vehicles online to CSV and mail”
pay attention that executing the http request is allowed only once every 61 seconds or more , otherwise you get an error in a json.

“{"statuscode":0,"data":{"VEHICLES":[{"DV":"Tracer","NN":"Tracer","PN":"Tracer","DR":126327,"DN":"עקיפה - ללא זיהוי נהג","TT":0,"EC":2,"EN":"End drive","EI":"","ET":"2023-05-31 17:13:36","ER":20,"SP":0,"OD":0.0,"EH":0,"GS":2,"ST":8,"X":34.972148,"Y":32.771842,"HD":0,"RPM":0,"VS":3,"RG":"","BL":14.4,"IFN":"Car.png","IDS":0,"PDS":2411734,"TDS":0},{"DV":"AB1987","NN":"F1_Tanklog_Maoz_Haim","PN":"AB1987","DR":126327,"DN":"עקיפה - ללא זיהוי נהג","TT":0,"EC":266,"EN":"Fuel level reading","EI":"","ET":"2023-06-28 09:29:14","ER":30,"SP":0,"OD":19611.9,"EH":0,"GS":2,"ST":11,"X":35.553830,"Y":32.491780,"HD":48,"RPM":0,"VS":1,"RG":"","BL":12.0,"IFN":"Car.png","IDS":0,"PDS":57467395,"TDS":0},{"DV":"TestUU3_12","NN":"UU_CAN100","PN":"TestUU3_12","DR":126327,"DN":"עקיפה - ללא זיהוי נהג","TT":0,"EC":28,"EN":"Sleep mode","EI":"","ET":"2023-06-28 14:31:36","ER":50,"SP":0,"OD":97813.0,"EH":0,"GS":3,"ST":16,"X":34.972482,"Y":32.771742,"HD":0,"RPM":0,"VS":3,"RG":"","BL":12.4,"IFN":"Car.png","IDS":0,"PDS":21673905,"TDS":0},{"DV":"A1321","NN":"A1_321","PN":"A1321","DR":126327,"DN":"עקיפה - ללא זיהוי נהג","TT":0,"EC":28,"EN":"Sleep mode","EI":"","ET":"2023-05-30 13:58:25","ER":20,"SP":0,"OD":83809.0,"EH":0,"GS":2,"ST":8,"X":34.972230,"Y":32.771860,"HD":0,"RPM":0,"VS":3,"RG":"","BL":14.4,"IFN":"Car.png","IDS":0,"PDS":2509845,"TDS":0},{"DV":"15987","NN":"BG95_F1","PN":"15987","DR":126327,"DN":"עקיפה - ללא זיהוי נהג","TT":0,"EC":3,"EN":"GPS","EI":"","ET":"2023-06-28 15:09:00","ER":20,"SP":0,"OD":4562.0,"EH":0,"GS":2,"ST":8,"X":34.972190,"Y":32.771830,"HD":232,"RPM":0,"FP":0.00,"FQ":0.0,"VS":2,"RG":"","BL":12.2,"IFN":"Car.png","IDS":910,"PDS":0,"TDS":910},{"DV":"35789","NN":"Hilik_F2","PN":"35789","DR":126327,"DN":"עקיפה - ללא זיהוי נהג","TT":0,"EC":28,"EN":"Sleep mode","EI":"","ET":"2023-06-28 15:02:47","ER":50,"SP":0,"OD":178404.3,"EH":0,"GS":2,"ST":16,"X":34.972000,"Y":32.771480,"HD":144,"RPM":0,"FP":0.00,"FQ":0.0,"VS":3,"RG":"99_20","BL":12.2,"IFN":"Car.png","IDS":0,"PDS":25583,"TDS":0},{"DV":"789654","NN":"Liana_F1","PN":"789654","DR":138729,"DN":"Driver0107","TT":0,"EC":89,"EN":"Internal battery low","EI":"","ET":"2023-06-08 14:04:43","ER":20,"SP":0,"OD":0.0,"EH":0,"GS":3,"ST":8,"X":34.972150,"Y":32.771850,"HD":0,"RPM":0,"FP":0.00,"FQ":0.0,"VS":3,"RG":"","BL":14.4,"IFN":"Car.png","IDS":0,"PDS":1740941,"TDS":0},{"DV":"A1_E1_101","NN":"Avi_E1","PN":"A1_E1_101","DR":126327,"DN":"עקיפה - ללא זיהוי נהג","TT":0,"EC":3,"EN":"GPS","EI":"","ET":"2023-05-18 10:02:20","ER":20,"SP":0,"OD":97773.2,"EH":0,"GS":2,"ST":8,"X":34.972210,"Y":32.771820,"HD":236,"RPM":0,"VS":2,"RG":"","BL":13.2,"IFN":"Car.png","IDS":3560869,"PDS":3561050,"TDS":0},{"DV":"E1_101","NN":"ILAN_E1","PN":"E1_101","DR":126327,"DN":"עקיפה - ללא זיהוי נהג","TT":0,"EC":28,"EN":"Sleep mode","EI":"","ET":"2023-06-28 14:23:05","ER":10,"SP":0,"OD":24437.2,"EH":0,"GS":2,"ST":12,"X":34.971960,"Y":32.771560,"HD":136,"RPM":0,"VS":3,"RG":"99_20","BL":12.6,"IFN":"Car.png","IDS":0,"PDS":27965,"TDS":0},{"DV":"YOSSI_F1","NN":"YOSSI_F1","PN":"YOSSI_F1","DR":126327,"DN":"עקיפה - ללא זיהוי נהג","TT":0,"EC":4,"EN":"GPS","EI":"","ET":"2023-06-28 15:08:40","ER":10,"SP":108,"OD":6829.1,"EH":0,"GS":2,"ST":14,"X":34.972180,"Y":32.771880,"HD":242,"RPM":225,"FP":0.00,"FQ":0.0,"VS":1,"RG":"","BL":10.2,"IFN":"Car.png","IDS":0,"PDS":14887,"TDS":0},{"DV":"18F1006944","NN":"18F1006944_3G","PN":"18F1006944","DR":126327,"DN":"עקיפה - ללא זיהוי נהג","TT":0,"EC":3,"EN":"GPS","EI":"","ET":"2023-06-28 10:19:15","ER":10,"SP":0,"OD":0.0,"EH":0,"GS":2,"ST":12,"X":34.972160,"Y":32.771850,"HD":154,"RPM":0,"FP":0.00,"FQ":0.0,"VS":3,"RG":"99_20","BL":11.8,"IFN":"Car.png","IDS":0,"PDS":10277475,"TDS":0},{"DV":"TANK","NN":"F1-Escort","PN":"TANK","DR":126327,"DN":"עקיפה - ללא זיהוי נהג","TT":0,"EC":28,"EN":"Sleep mode","EI":"","ET":"2023-06-28 14:50:21","ER":20,"SP":0,"OD":521.9,"EH":0,"GS":2,"ST":6,"X":35.149770,"Y":32.684930,"HD":184,"RPM":0,"FP":41.00,"FQ":123.0,"VS":3,"RG":"","BL":12.6,"IFN":"Car.png","IDS":0,"PDS":173929,"TDS":0},{"DV":"HILIK_F1BG","NN":"HILIK_F1GD","PN":"HILIK_F1BG","DR":126327,"DN":"עקיפה - ללא זיהוי נהג","TT":2,"EC":28,"EN":"Sleep mode","EI":"","ET":"2023-06-28 15:02:54","ER":10,"SP":0,"OD":98531.6,"EH":0,"GS":2,"ST":15,"X":34.972030,"Y":32.771460,"HD":140,"RPM":0,"FP":0.00,"FQ":0.0,"VS":3,"RG":"99_20","BL":12.2,"IFN":"Car.png","IDS":0,"PDS":25576,"TDS":0},{"DV":"Gena_Fuel","NN":"Gena_Fuel","PN":"Gena_Fuel","DR":126327,"DN":"עקיפה - ללא זיהוי נהג","TT":0,"EC":28,"EN":"Sleep mode","EI":"","ET":"2023-06-28 14:31:50","ER":10,"SP":0,"OD":78116.9,"EH":0,"GS":2,"ST":13,"X":34.971770,"Y":32.771400,"HD":266,"RPM":0,"FP":78.00,"FQ":35.1,"VS":3,"RG":"99_20","BL":13.0,"IFN":"Car.png","IDS":0,"PDS":23840,"TDS":0},{"DV":"18U3E63324","NN":"משק ריקלין RI11334","PN":"PLATE-11","DR":126327,"DN":"עקיפה - ללא זיהוי נהג","TT":0,"EC":3,"EN":"GPS","EI":"","ET":"2023-06-28 08:35:51","ER":30,"SP":0,"OD":1145.5,"EH":0,"GS":2,"ST":6,"X":35.404478,"Y":32.753205,"HD":93,"RPM":0,"VS":3,"RG":"","BL":13.1,"IFN":"Car.png","IDS":0,"PDS":1295369,"TDS":0},{"DV":"053810786664","NN":"Hilik T2 Dash","PN":"053810786664","DR":126327,"DN":"עקיפה - ללא זיהוי נהג","TT":0,"EC":28,"EN":"Sleep mode","EI":"","ET":"2023-05-15 10:55:07","ER":40,"SP":0,"OD":837.4,"EH":0,"GS":2,"ST":0,"X":34.972003,"Y":32.771495,"HD":0,"RPM":0,"VS":3,"RG":"","BL":0.0,"IFN":"Car.png","IDS":0,"PDS":3825546,"TDS":0},{"DV":"21F1002059","NN":"רשתות אשדוד","PN":"21F1002059","DR":126327,"DN":"עקיפה - ללא זיהוי נהג","TT":0,"EC":266,"EN":"Fuel level reading","EI":"","ET":"2023-06-28 15:07:25","ER":40,"SP":0,"OD":2048.2,"EH":0,"GS":2,"ST":13,"X":34.682770,"Y":31.836540,"HD":158,"RPM":0,"VS":1,"RG":"","BL":12.0,"IFN":"Car.png","IDS":0,"PDS":0,"TDS":0},{"DV":"21F1002194","NN":"Beit shemesh","PN":"21F1002194","DR":126327,"DN":"עקיפה - ללא זיהוי נהג","TT":0,"EC":266,"EN":"Fuel level reading","EI":"","ET":"2023-06-28 15:08:14","ER":40,"SP":0,"OD":2271.8,"EH":0,"GS":2,"ST":14,"X":34.962310,"Y":31.727740,"HD":164,"RPM":0,"VS":1,"RG":"","BL":12.0,"IFN":"Car.png","IDS":0,"PDS":0,"TDS":0},{"DV":"280427","NN":"280427","PN":"280427","DR":126327,"DN":"עקיפה - ללא זיהוי נהג","TT":0,"EC":132,"EN":"Stopped while in movement mode","EI":"","ET":"2023-05-03 13:40:26","ER":20,"SP":0,"OD":26.0,"EH":0,"GS":3,"ST":8,"X":34.972197,"Y":32.771832,"HD":0,"RPM":0,"VS":3,"RG":"99_20","BL":0.0,"IFN":"Car.png","IDS":0,"PDS":4856622,"TDS":0},{"DV":"121212","NN":"121212","PN":"121212","DR":126327,"DN":"עקיפה - ללא זיהוי נהג","TT":0,"EC":3,"EN":"GPS","EI":"","ET":"2023-06-28 15:08:40","ER":30,"SP":0,"OD":133881.3,"EH":0,"GS":2,"ST":11,"X":34.972140,"Y":32.771870,"HD":0,"RPM":0,"FP":0.00,"FQ":0.0,"VS":2,"RG":"test222","BL":12.2,"IFN":"Car.png","IDS":22829,"PDS":0,"TDS":22950},{"DV":"2000003930","NN":"2000003930_new","PN":"2000003930","DR":138599,"DN":"Driver0096","TT":0,"EC":3,"EN":"GPS","EI":"","ET":"2023-05-27 13:07:28","ER":20,"SP":0,"OD":24.0,"EH":0,"GS":3,"ST":0,"X":34.972272,"Y":32.771831,"HD":0,"RPM":0,"VS":1,"RG":"99_20","BL":0.0,"IFN":"Car.png","IDS":0,"PDS":0,"TDS":0},{"DV":"22F1001575","NN":"22F1001575_LTE","PN":"22F1001575","DR":126327,"DN":"עקיפה - ללא זיהוי נהג","TT":0,"EC":266,"EN":"Fuel level reading","EI":"","ET":"2023-06-28 15:09:05","ER":40,"SP":0,"OD":1184.2,"EH":0,"GS":2,"ST":15,"X":35.553860,"Y":32.491830,"HD":318,"RPM":0,"VS":1,"RG":"","BL":11.8,"IFN":"Car.png","IDS":0,"PDS":0,"TDS":20140936},{"DV":"053810946623","NN":"Hilik DASH3 Test","PN":"053810946623","DR":126327,"DN":"עקיפה - ללא זיהוי נהג","TT":0,"EC":28,"EN":"Sleep mode","EI":"","ET":"2023-06-28 15:08:59","ER":50,"SP":0,"OD":6765.3,"EH":0,"GS":2,"ST":0,"X":34.971928,"Y":32.771477,"HD":0,"RPM":0,"VS":3,"RG":"99_20","BL":0.0,"IFN":"Car.png","IDS":0,"PDS":25578,"TDS":0},{"DV":"ES07073","NN":"ES07073","PN":"ES07073","DR":126327,"DN":"עקיפה - ללא זיהוי נהג","TT":0,"EC":3,"EN":"GPS","EI":"","ET":"2023-05-21 09:59:01","ER":20,"SP":11,"OD":453.5,"EH":0,"GS":2,"ST":10,"X":34.972176,"Y":32.771904,"HD":0,"RPM":630,"FP":50.00,"FQ":30.0,"VS":1,"RG":"99_20","BL":13.6,"IFN":"Car.png","IDS":0,"PDS":0,"TDS":3304878},{"DV":"859682","NN":"859682","PN":"859682","DR":138762,"DN":"Driver0114","TT":0,"EC":3,"EN":"GPS","EI":"","ET":"2023-06-08 08:26:11","ER":40,"SP":0,"OD":149481.5,"EH":0,"GS":2,"ST":11,"X":34.972240,"Y":32.771870,"HD":310,"RPM":0,"FP":0.00,"FQ":0.0,"VS":1,"RG":"99_20","BL":14.4,"IFN":"Car.png","IDS":1752717,"PDS":0,"TDS":1752899},{"DV":"053810947474","NN":"053810947474","PN":"053810947474","DR":126327,"DN":"עקיפה - ללא זיהוי נהג","TT":0,"EC":2,"EN":"End drive","EI":"","ET":"2023-04-30 11:36:55","ER":20,"SP":0,"OD":0.0,"EH":0,"GS":2,"ST":0,"X":34.972164,"Y":32.771870,"HD":130,"RPM":0,"VS":3,"RG":"","BL":0.0,"IFN":"Car.png","IDS":0,"PDS":5110335,"TDS":0},{"DV":"12105000157","NN":"12105000157","PN":"12105000157","DR":126327,"DN":"עקיפה - ללא זיהוי נהג","TT":0,"EC":3,"EN":"GPS","EI":"","ET":"2023-05-16 07:58:32","ER":30,"SP":0,"OD":0.0,"EH":0,"GS":2,"ST":17,"X":34.972161,"Y":32.771857,"HD":0,"RPM":0,"VS":1,"RG":"","BL":100.0,"IFN":"Box.png","IDS":0,"PDS":0,"TDS":0},{"DV":"16893","NN":"Hilik - ERM Test","PN":"16893","DR":126327,"DN":"עקיפה - ללא זיהוי נהג","TT":0,"EC":28,"EN":"Sleep mode","EI":"","ET":"2023-06-28 12:50:37","ER":20,"SP":0,"OD":1116.0,"EH":0,"GS":3,"ST":0,"X":35.096898,"Y":32.645973,"HD":277,"RPM":0,"VS":3,"RG":"","BL":12.7,"IFN":"Car.png","IDS":0,"PDS":152294,"TDS":0},{"DV":"002000003456","NN":"002000003456","PN":"002000003456","DR":126327,"DN":"עקיפה - ללא זיהוי נהג","TT":0,"EC":3,"EN":"GPS","EI":"","ET":"2023-05-02 17:51:03","ER":40,"SP":0,"OD":0.4,"EH":0,"GS":2,"ST":0,"X":113.995564,"Y":22.591904,"HD":0,"RPM":0,"VS":1,"RG":"","BL":0.0,"IFN":"Box.png","IDS":0,"PDS":0,"TDS":0}]}}”

4

i used the “Parse response” option in the http request and now it works

2 Likes
5

Hey @Rafi_Newman welcome to the community :wave:

Great to hear that you managed to achieve this with @Runcorn 's rockstar guidance :clap:

Thanks a lot for keeping us updated on your progress and keep up the great work!