Reading JSON Format

[amit_saroha]

Hi,

How I can use an expression to read the below in a mapper to get individual values true or false? I am using as - $DocumentId.startsWith(“EBSPERSON_”)

[

{

"Content_ID":

"EBSPERSON_547229"

}

{

"Content_ID":

"EBSPERSONAD_547229"

}

{

"Content_ID":

"EBSPHONE_547229"

}

]

[amit_saroha]

Below is the actual data and I want to pass the value “EBSPERSON_547229” in the target path.

[Dheeraj]

Use below expression :

jsonPath($, "$_Document_ID[?(value.Content_ID.startsWith('EBSPERSON_'))].Content_ID")

[amit_saroha]

Thanks, @Dheeraj - But it didn’t work ☹️

[Dheeraj]

I see your JSON is not formatted properly. I would recommend validating the JSON snippet using some external validators
You can also attach your pipeline here and I can look into that