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

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.

Sort field names alphabetically in JSON source data | SnapLogic - Integration Nation

12 Replies

Aleksandar_A
Contributor III
3 years ago
Copy Link
Report
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.
darshthakkar
Valued Contributor
3 years ago
Copy Link
Report
Thank you @AleksandarAngelevski for your suggestion.
I will try it out and keep you posted with my findings…
- darshthakkar
  Valued Contributor
  3 years ago
  Copy Link
  Report
  @AleksandarAngelevski - You’re right, Alphabetical sorting doesn’t work on the first level so you’ll have to break that hierarchy and once you’re at the final stage, your expression will definitely work, I’ve tested it and can confirm that it works.
  
  How I broke the hierarchy: Using JSON Splitter to reorganise JSON - #3 by Supratim (thank you @Supratim for your comments on a different thread)
darshthakkar
Valued Contributor
3 years ago
Copy Link
Report
As we cannot mark multiple suggestions as “Solutions”, wanted to summarize the solution that will work for this use case:

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

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

Both the expressions mentioned above will ONLY work if we are at the last stage of the hierarchy.

How I broke the hierarchy: Using JSON Splitter to reorganise JSON - #3 by Supratim

Thank you @AleksandarAngelevski , @alchemiz and @Supratim for your inputs. Closing this thread now.
- alchemiz
  Contributor III
  3 years ago
  Copy Link
  Report
  $.keys().sort().reverse().toObject((k,i)=> k, (k,i)=> $.get(k))
  - darshthakkar
    Valued Contributor
    3 years ago
    Copy Link
    Report
    Yup, this is for sorting in reverse alphabetical order. Thank you @alchemiz
darshthakkar
Valued Contributor
3 years ago
Copy Link
Report
@AleksandarAngelevski - Is it a safe assumption that we can use the same expression with a minor tweak to organize data alphabetically even if it’s not the JSON format?
- Aleksandar_A
  Contributor III
  3 years ago
  Copy Link
  Report
  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
    Valued Contributor
    3 years ago
    Copy Link
    Report
    Makes sense, thank you @AleksandarAngelevski.
darshthakkar
Valued Contributor
3 years ago
Copy Link
Report
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 🙂

Forum Discussion

Sort field names alphabetically in JSON source data

12 Replies

Recent Discussions

Pagination Logic Fails After Migrating from REST GET to HTTP Client Snap

Pipeline Execute Pool size

trace API and proxy calls

Concat values of a field based on value of another field

JWT Configuration for SnapLogic Public API