question How to evalute Attribute (Json format) in Support Questions

How to evalute Attribute (Json format)

mohdriyaz — Sat, 30 Mar 2024 07:02:50 GMT

How to Evaluate attribute (output of Invoke Http which is in JSON format)

This attribute value contain a Json in the following format

{

location : { FileSource : "X" , URL : "Y"}

}

From this attribute value (Json), I need to extract File Source and URL and put it into another attribute with the same name.

Note : Flow file Content should remain as it is.

Any Pointer ..??

Re: How to evalute Attribute (Json format)

saquibsk — Tue, 02 Apr 2024 02:10:57 GMT

Hi @mohdriyaz,

You can achive this by using following steps.

Step1: In GenertateFlow I took your input

Step2: Use EvaluateJsonPath and set the Destination as Flowfile-attribute and write the JSON Path

Step3: Use UpdateAttribute in case of further modification.

output:

------------

If you found any of the suggestions/solutions provided helped you with your issue, please take a moment to login and click "Accept as Solution" on one or more of them that helped.

Re: How to evalute Attribute (Json format)

mohdriyaz — Thu, 04 Apr 2024 07:09:28 GMT

@saquibsk

Thanks for Reply.

Solution you have provided will work with content of flow file and not with the attribute. EvaluateJsonPath is use to evaluate the JSON present in flow file content.

In my case , I have JSON present as attribute and not as content of flow file.

Re: How to evalute Attribute (Json format)

mohdriyaz — Thu, 04 Apr 2024 07:13:22 GMT

I got the Solution.

Use UpdateAttribute processor and Expression Language.

Here "SignedURL" is the attribute (containing complex Json) and from that I fetch particular Key value using Expression Language (JSONPATH)