How do I filter the response in dataweave based on a certain criteria?How to populate XML tag dynamically using DataWeaveHow to filter an array of JSON in Mule DataWeaveHow to groupby using DataweaveDataweave JSON filterfilter mule esb json payload based on request paramIssues in merging the xml response and json response in Dataweavemule filter logic processing in dataweaveHow to map data into Array in Dataweave?How to extract a nested array value frm XML in DataWeave and convert to CSVHow can I pass a table valued parameter to a SQL Server stored procedure in Mule 4?
Publishing papers seem natural to many, while I find it really hard to think novel stuff to pursue till publication. How to cope up with this?
What are the consequences for a developed nation to not accept any refugees?
Why do airports remove/realign runways?
Moving millions of files to a different directory with specfic name patterns
Where are the Wazirs?
How do ballistic trajectories work in a ring world?
How do I talk to my wife about unrealistic expectations?
stuck in/at beta
Users forgotting to regenerate PDF before sending it
Gory anime with pink haired girl escaping an asylum
What kind of Chinook helicopter/airplane hybrid is this?
How do resistors generate different heat if we make the current fixed and changed the voltage and resistance? Notice the flow of charge is constant
How to evaluate the performance of open source solver?
run bash scripts in folder all at the same time
Other Space Shuttle O-ring failures
Intern not wearing safety equipment; how could I have handled this differently?
How should I ask for a "pint" in countries that use metric?
Why won't the U.S. sign a peace treaty with North Korea?
How does one acquire an undead eyeball encased in a gem?
A ring of generalized power series
Computer name naming convention for security
Why is a mixture of two normally distributed variables only bimodal if their means differ by at least two times the common standard deviation?
Why am I getting unevenly-spread results when using $RANDOM?
Can one block with a protection from color creature?
How do I filter the response in dataweave based on a certain criteria?
How to populate XML tag dynamically using DataWeaveHow to filter an array of JSON in Mule DataWeaveHow to groupby using DataweaveDataweave JSON filterfilter mule esb json payload based on request paramIssues in merging the xml response and json response in Dataweavemule filter logic processing in dataweaveHow to map data into Array in Dataweave?How to extract a nested array value frm XML in DataWeave and convert to CSVHow can I pass a table valued parameter to a SQL Server stored procedure in Mule 4?
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;
Lets say I am getting the following response from an API Call.
accounts: [
accountName: "A",
amount: 10$
account Name "B closed",
amount: 20$
]
I want to filter all account responses that contain the closed keyword in the account name. Can anyone tell me how to filter all the responses that contains closed based on this and give me only account A.
I am using dw 1.0 for my mulesoft code. Please let me know if you have any other questions.
dataweave mulesoft
asked Mar 25 at 22:35
Gautham HonnavaraGautham Honnavara
1901 silver badge14 bronze badges
add a comment |
Lets say I am getting the following response from an API Call.
accounts: [
accountName: "A",
amount: 10$
account Name "B closed",
amount: 20$
]
I want to filter all account responses that contain the closed keyword in the account name. Can anyone tell me how to filter all the responses that contains closed based on this and give me only account A.
I am using dw 1.0 for my mulesoft code. Please let me know if you have any other questions.
dataweave mulesoft
asked Mar 25 at 22:35
Gautham HonnavaraGautham Honnavara
1901 silver badge14 bronze badges
add a comment |
Lets say I am getting the following response from an API Call.
accounts: [
accountName: "A",
amount: 10$
account Name "B closed",
amount: 20$
]
I want to filter all account responses that contain the closed keyword in the account name. Can anyone tell me how to filter all the responses that contains closed based on this and give me only account A.
I am using dw 1.0 for my mulesoft code. Please let me know if you have any other questions.
dataweave mulesoft
asked Mar 25 at 22:35
Gautham HonnavaraGautham Honnavara
1901 silver badge14 bronze badges
Lets say I am getting the following response from an API Call.
accounts: [
accountName: "A",
amount: 10$
account Name "B closed",
amount: 20$
]
I want to filter all account responses that contain the closed keyword in the account name. Can anyone tell me how to filter all the responses that contains closed based on this and give me only account A.
I am using dw 1.0 for my mulesoft code. Please let me know if you have any other questions.
dataweave mulesoft
dataweave mulesoft
asked Mar 25 at 22:35
Gautham HonnavaraGautham Honnavara
1901 silver badge14 bronze badges
asked Mar 25 at 22:35
Gautham HonnavaraGautham Honnavara
1901 silver badge14 bronze badges
asked Mar 25 at 22:35
Gautham HonnavaraGautham Honnavara
1901 silver badge14 bronze badges
asked Mar 25 at 22:35
Gautham HonnavaraGautham Honnavara
1901 silver badge14 bronze badges
asked Mar 25 at 22:35
Gautham HonnavaraGautham Honnavara
1901 silver badge14 bronze badges
1901 silver badge14 bronze badges
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
Assuming your input is:
"accounts": [
"accountName": "A",
"amount": "10$"
,
"accountName": "B closed",
"amount": "20$"
]
Then you can filter it like this:
%dw 1.0
%output application/json
---
payload.accounts filter ((account) -> not (account.accountName contains "closed"))
Which will result in:
[
"accountName": "A",
"amount": "10$"
]
answered Mar 26 at 14:52
ShokiShoki
8445 silver badges9 bronze badges
That worked, Thanks !
– Gautham Honnavara
Apr 14 at 17:03
add a comment |
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55347366%2fhow-do-i-filter-the-response-in-dataweave-based-on-a-certain-criteria%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
Assuming your input is:
"accounts": [
"accountName": "A",
"amount": "10$"
,
"accountName": "B closed",
"amount": "20$"
]
Then you can filter it like this:
%dw 1.0
%output application/json
---
payload.accounts filter ((account) -> not (account.accountName contains "closed"))
Which will result in:
[
"accountName": "A",
"amount": "10$"
]
answered Mar 26 at 14:52
ShokiShoki
8445 silver badges9 bronze badges
That worked, Thanks !
– Gautham Honnavara
Apr 14 at 17:03
add a comment |
Assuming your input is:
"accounts": [
"accountName": "A",
"amount": "10$"
,
"accountName": "B closed",
"amount": "20$"
]
Then you can filter it like this:
%dw 1.0
%output application/json
---
payload.accounts filter ((account) -> not (account.accountName contains "closed"))
Which will result in:
[
"accountName": "A",
"amount": "10$"
]
answered Mar 26 at 14:52
ShokiShoki
8445 silver badges9 bronze badges
That worked, Thanks !
– Gautham Honnavara
Apr 14 at 17:03
add a comment |
Assuming your input is:
"accounts": [
"accountName": "A",
"amount": "10$"
,
"accountName": "B closed",
"amount": "20$"
]
Then you can filter it like this:
%dw 1.0
%output application/json
---
payload.accounts filter ((account) -> not (account.accountName contains "closed"))
Which will result in:
[
"accountName": "A",
"amount": "10$"
]
answered Mar 26 at 14:52
ShokiShoki
8445 silver badges9 bronze badges
Assuming your input is:
"accounts": [
"accountName": "A",
"amount": "10$"
,
"accountName": "B closed",
"amount": "20$"
]
Then you can filter it like this:
%dw 1.0
%output application/json
---
payload.accounts filter ((account) -> not (account.accountName contains "closed"))
Which will result in:
[
"accountName": "A",
"amount": "10$"
]
answered Mar 26 at 14:52
ShokiShoki
8445 silver badges9 bronze badges
answered Mar 26 at 14:52
ShokiShoki
8445 silver badges9 bronze badges
answered Mar 26 at 14:52
ShokiShoki
8445 silver badges9 bronze badges
answered Mar 26 at 14:52
ShokiShoki
8445 silver badges9 bronze badges
8445 silver badges9 bronze badges
That worked, Thanks !
– Gautham Honnavara
Apr 14 at 17:03
add a comment |
That worked, Thanks !
– Gautham Honnavara
Apr 14 at 17:03
That worked, Thanks !
– Gautham Honnavara
Apr 14 at 17:03
That worked, Thanks !
– Gautham Honnavara
Apr 14 at 17:03
add a comment |
Got a question that you can’t ask on public Stack Overflow? Learn more about sharing private information with Stack Overflow for Teams.
Got a question that you can’t ask on public Stack Overflow? Learn more about sharing private information with Stack Overflow for Teams.
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55347366%2fhow-do-i-filter-the-response-in-dataweave-based-on-a-certain-criteria%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
