Sort field names alphabetically in JSON source data

[darshthakkar]

Hi Team,

I have my source data coming in JSON format. I want to sort the fields inside the JSON format alphabetically. One way is to use a mapper and arrange them one-one alphabetically but it is a tedious task if the fields are more. Can we use an expression in mapper or any other snap that does this for us?

Thank you.

Best Regards,
Darsh

[Aleksandar_A · Accepted solution]

Hi @darshthakkar,

One approach will be to Map the input document with the following expression:

$.entries().sort((a,b) => a[0].localeCompare(b[0])).reduce((acc,curr) => acc.extend({[curr[0]]:curr[1]}),{})

Note: This will only sort properties on first level.

Let me know if this helps.

BR,
Aleksandar.

[Aleksandar_A]

Well, if the data that we have on input is in different format I might consider another approach because this is a special use case.

[darshthakkar]

Makes sense, thank you @AleksandarAngelevski.

[alchemiz]

Alternative expression

$.keys().sort().toObject((k,i)=> k, (k,i)=> $.get(k))

[darshthakkar]

Thank you so much @alchemiz for your suggestion.
I’m sure it is going to work, will try and keep you posted…

[darshthakkar]

Hey @alchemiz,

The solution you provided worked, the only consideration is that - “You need to be at the bottom of the hierarchy for sorting to work”.

Thank you, anyways 🙂