Android Question JSONPARSER giving strange Columns order depending on device

[infow]

I´m using this simple code to show a JSON text into a webview, but the same code it´s working diferent on each device, the problem it´s the columns order, in Cellphones work well and comes with the JSON field order, in tablets with 4.4.2 Android version it´s parsed ok but the columns come with an aleatory order...

Can anyone give me a help...

    Dim parser As JSONParser
    parser.Initialize("[{""DESCR_GR_IND"":""xxx"",""COD_PROD"":""10015848"",""DESCR_PROD"":""xxxx 5MG - 13 A  25KG - 03 COMPR"",""201611"":0.0000,""201612"":0.0000,""201701"":0.0000,""201702"":0.0000,""201703"":0.0000,""201704"":0.0000,""201705"":1.0000,""201706"":0.0000,""201708"":0.0000,""201709"":1.0000,""201710"":1.0000},{""DESCR_GR_IND"":""xxxx"",""COD_PROD"":""10015849"",""DESCR_PROD"":""xxxx 10MG - 26 A 5KG - 03 COMPR"",""201611"":0.0000,""201612"":0.0000,""201701"":0.0000,""201702"":0.0000,""201703"":1.0000,""201704"":0.0000,""201705"":1.0000,""201706"":0.0000,""201708"":2.0000,""201709"":0.0000,""201710"":1.0000}]")
    Dim rows As List
    rows = parser.NextArray
  
    Dim mp As Map
    Dim m As Map
    Colunas.Initialize
    m = rows.Get(0)
    For z = 0 To m.Size -1
        Colunas.Put(z,m.GetKeyAt(z))
    Next

JSON:

[{"DESCR_GR_IND":"xxx","COD_PROD":"10015848","DESCR_PROD":"xxx 5MG - 1,3 A  2,5KG - 03 COMPR","2016/11":0.0000,"2016/12":0.0000,"2017/01":0.0000,"2017/02":0.0000,"2017/03":0.0000,"2017/04":0.0000,"2017/05":1.0000,"2017/06":0.0000,"2017/08":0.0000,"2017/09":1.0000,"2017/10":1.0000},{"DESCR_GR_IND":"xxx","COD_PROD":"10015849","DESCR_PROD":"xxx 10MG - 2,6 A 5KG - 03 COMPR","2016/11":0.0000,"2016/12":0.0000,"2017/01":0.0000,"2017/02":0.0000,"2017/03":1.0000,"2017/04":0.0000,"2017/05":1.0000,"2017/06":0.0000,"2017/08":2.0000,"2017/09":0.0000,"2017/10":1.0000}]

 

[infow]

If I change the column titles the order changes... still random...

 

[KMatle]

From the JSON specification at http://www.json.org/:

"An object is an unordered set of name/value pairs"

As a consequence, JSON libraries are free to rearrange the order of the elements as they see fit. This is not a bug.

 

[infow]

I tried on https://b4x.com:51041/json/index.html, it shows as 4.4.2

It comes aleatory too... But on new devices comes alright...

 

[infow]

In any other device comes ok...

 

[infow]

There is a way to show the data as I get it, from the text? Following the order? I created a dynamic display of the data... just need that it follow the order...

 

[infow]

I understand that it´s JSON problem... It seems it´s someway fixed on new devices...

 

[infow]

I tested in http://json.parser.online.fr/ , it parses alright..., other sites random...

 

[NJDude]

That depends on the parser, some of them have that behavior.

 

[infow]

Yes, the question is: Why in a few devices did not keep the order, and others did...

 

[NJDude]

It could be that some devices might process the data internally as objects and not like arrays (even if an array is passed), objects are unordered.

 

[infow]

There is no way to avoid this? I will have to abandon all my work that I used JSON as a way to send the data...

 

[NJDude]

Why? just use the key names, that will need some extra code but it can be done.

Some people just like drama I think

 

[infow]

Why? just use the key names, that will need some extra code but it can be done.

Some people just like drama I think

That was easy, but I did a dinamic display of data, there is no way to declare... Some querys, even the columns are pivots, and the query generate dinamic columns too...

 

[infow]

As it seems have no "polite" solution to my case, I will use Regex to find my columns order

 

[NJDude]

Why not changing your output format? (CSV, XML, etc.) or it must be JSON?

 

[Erel]

The order of list items is guaranteed to be correct. You can change the structure to a list instead of map and fill the map yourself from the list.