Skip to main content

Hi All,

Here I need update a value based on filter selector

 

{

  "entries": [

   {

     "FirstName": "Joe",

     "LastName" : "Smith",

     "Company": "Salesforce",

     "Email" : "test@salesforce.com"

    },

    {

     "FirstName": "Max",

     "LastName" : "Minny",

     "Company": "MuleSoft",

     "Email" : "test@mulesoft.com"

    },

    {

     "FirstName": "Tony",

     "LastName" : "Blue",

     "Company": "Salesforce",

     "Email" : "test2@salesforce.com"

    }

  ]

}

 

#DATAWEAVE SCRIPT

 

%dw 2.0

output application/json

---

payload.entries[?($.Company == "Salesforce")]

 

====

 

%dw 2.0

output application/json

---

payload update {

case .entries[0].FirstName -> ""

//.entries[?($.Company == "Salesforce")]

}

 

here based on Company name I should update value

 

Thank you in advance

3 answers
  1. Jan 4, 2024, 9:46 AM

    Hi @Janardhan Chandaka​ 

     

    Please check the script below.

     

    %dw 2.0

    output application/json

    ---

    "entries": payload.entries map((item,index)->

    if(item.Company=="Salesforce")

    item update {case .FirstName -> "Updated Name"}

    else

    item

    )

    Thanks

    Raghavendra

0/9000