JSON DataProvider (or RepeaterBlock) changes the sorting of the json array returned as data

[esellier]

Hosting

• Self
  • Method: Docker Compose
  • Budibase Version: 3.8.4

Describe the bug
I have a JSON Data Provider which returns a sorted an array of objects.
In a repeater block I display the rows return by this data provider, but the order is changed (on unknown criteria).
As a JSON Data Provider does not provide a sort capability, there is no way to ensure the resulting data is correctly sorted.
Either the data provider or the repeater block should not change order of objects in the array.

[linear[bot]]

BUDI-9233 JSON DataProvider (or RepeaterBlock) changes the sorting of the json array returned as data

[andz-bb]

hey @esellier,

it sorts alphabetically on the first key of the object in the array. You could add a property like index to the start of each object with ascending numbers to force the objects to remain sorted how you want them to be.

here's a json object I had where it was being sorted by year because it was the first key of the first object:

if I want it to sort based on the raw order of the object itself, I can add some js like so:

const your_array = [] // your json array
return your_array.map((object, i) => ({ index: i + 1, ...object }));

hope this helps - if you have any questions on this let me know