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

[AleksandarAngel]

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 🙂