Forum Discussion

npise's avatar
npise
New Contributor II
5 years ago
Solved

Jsonpath begins with

Below is my input, i am trying filter for id where type == file and name begins with “Send Email” expression i used in mapper jsonPath($, “entity.entries[?(@.type == ‘file’ && @.name =~ /Send Email...
json
mapper
transform
  • npise's avatar
    npise
    5 years ago

    Thank you all!!

    jsonPath($, “entity.entries[*]”).filter(x => x.hasPath(‘type’) && x.type == ‘file’ && x.hasPath(‘name’) && x.name.startsWith(‘Send Email’)).length >0

    This worked!

Supratim's avatar
Supratim
Contributor III
5 years ago

Can also try below expression-
jsonPath($, "$entries[?(value[‘type’] == ‘file’ && value[‘name’].startsWith('Send