Forum Discussion

darshthakkar's avatar
darshthakkar
Valued Contributor
3 years ago
Solved

Sort field names alphabetically in JSON source data

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...
azure_blob
  • koryknick's avatar
    koryknick
    3 years ago

    If you are referring to a tab-delimited file, simply replace the field delimiter from a comma to “\t”

ariana's avatar
ariana
New Contributor
4 years ago
Copy LinkReport

Hi there! Thanks for your help. Here is what I am looking at now, still no output:
Mapper -

Mapper validation output -

POST Snap:

Pipeline:

Edit: I will add that I did try simply copying the body into the mapper with “$” in the Post snap but with the same (lack of) results.

ptaylor's avatar
ptaylor
Employee
4 years ago
Copy LinkReport

Change HTTP entity from $entity to JSON.stringify($entity).

  • koryknick's avatar
    koryknick
    Employee
    3 years ago
    Copy LinkReport

    If you are referring to a tab-delimited file, simply replace the field delimiter from a comma to “\t”