Using a JSON decoder

[robertoal]

Dear folks.

I have a question about JSON, I tried different library's but none of them seem te work. 

My goal:

JSON string to array

 

Library's tried:

Well everyone I could find.. I think the one from WARD is best, but hell. I am an amateur. It is the only one notting spitting out random errors, hence my choice.

 

My code thus far:

 

#include <Array.au3>
#Include "Json.au3"


$URL_Activities = 'xxx'
$URL_Vehicles = 'xxx'


$oHTTP = ObjCreate("winhttp.winhttprequest.5.1")
$oHTTP.Open("GET",$URL_Vehicles, False)
$oHTTP.setRequestHeader("postman-token", "xxx")
$oHTTP.setRequestHeader("cache-control", "no-cache")
$oHTTP.setRequestHeader("authorization", "Basic xxx")

$oHTTP.Send()
$oReceived = $oHTTP.ResponseText
$oStatusCode = $oHTTP.Status

ConsoleWrite($oReceived & @crlf)
ConsoleWriteError("StatusCode: - " & $oStatusCode & @crlf)


Local $Json1 = '[{"access_token":"25f64a9e27b7903eacdff8e36fd74c80","vehicles":[{"id":5649,"name":"Ebike6","petrol_usage_per_kilometer":null,"petrol_type":null,"frequency_usage_per_week":null,"co2_emission_per_km":null,"travel_time_per_day":null,"travel_distance_per_day":null,"type":{"id":3,"name":"Bike","combustion":false},"deleted_at":null},{"id":5650,"name":"Ebike7","petrol_usage_per_kilometer":null,"petrol_type":null,"frequency_usage_per_week":null,"co2_emission_per_km":null,"travel_time_per_day":null,"travel_distance_per_day":null,"type":{"id":3,"name":"Bike","combustion":false},"deleted_at":null},{"id":5651,"name":"Ebike8","petrol_usage_per_kilometer":null,"petrol_type":null,"frequency_usage_per_week":null,"co2_emission_per_km":null,"travel_time_per_day":null,"travel_distance_per_day":null,"type":{"id":3,"name":"Bike","combustion":false},"deleted_at":null},{"id":5652,"name":"Ebike9","petrol_usage_per_kilometer":null,"petrol_type":null,"frequency_usage_per_week":null,"co2_emission_per_km":null,"travel_time_per_day":null,"travel_distance_per_day":null,"type":{"id":3,"name":"Bike","combustion":false},"deleted_at":null},{"id":5657,"name":"Default Car","petrol_usage_per_kilometer":0.07142857142857142,"petrol_type":"gasoline","frequency_usage_per_week":5,"co2_emission_per_km":171,"travel_time_per_day":20,"travel_distance_per_day":15,"type":{"id":1,"name":"Car","combustion":true},"deleted_at":null},{"id":5658,"name":"Default Bike","petrol_usage_per_kilometer":null,"petrol_type":null,"frequency_usage_per_week":null,"co2_emission_per_km":null,"travel_time_per_day":null,"travel_distance_per_day":null,"type":{"id":3,"name":"Bike","combustion":false},"deleted_at":null}]}]'

Local $Data1 = Json_Decode($Json1,True)
_ArrayDisplay($Data1,"Test")

 

The $Json1 VAR is the json I get from the http object, if i test this with "Json formatter" it looks like proper JSON.

Bet I get nothing back from the Json_decode function. 

I am running out of ideas, anybody can shed some light on this?

 

Thanks in advance.

BinaryCall.au3

Json.au3

Json_Test.au3

test.json

[EmilyLove]

~snip~

Edited September 29, 2017 by BetaLeaf