Loading

Dataweave orderBy descending by String field - Mule 4

公開日: Mar 2, 2024
タスク

GOAL

We want to order a JSON descending by a String field like the following (Type field for this example): 
[
    {
        "AccountNumber": "987999321",
        "NameOnAccount": "QA",
        "Type": "AAAA",
        "CDetail": {
            "Status": "Open"
        }
    },
    {
        "AccountNumber": "12399978",
        "NameOnAccount": "QA",
        "Type": "BBBB",
        "CDetail": {}
    },
    {
        "AccountNumber": "32199974",
        "NameOnAccount": "QA",
        "Type": "CCCC",
        "CDetail": {}
    }
]

And obtain the following output:
  
[
  {
    "AccountNumber": "32199974",
    "NameOnAccount": "QA",
    "Type": "CCCC",
    "CDetail": {}
  },
  {
    "AccountNumber": "12399978",
    "NameOnAccount": "QA",
    "Type": "BBBB",
    "CDetail": {}
  },
  {
    "AccountNumber": "987999321",
    "NameOnAccount": "QA",
    "Type": "AAAA",
    "CDetail": {
      "Status": "Open"
    }
  }
]
 
ステップ
This can be accomplished with a DataWeave Transform like the following: 
%dw 2.0
output application/json
---
(payload orderBy $.Type)[-1 to 0]

 
ナレッジ記事番号

001116896

 
読み込み中
Salesforce Help | Article