question Re: Use a variable in a processor in Support Questions

Use a variable in a processor

raniaa — Wed, 19 Jan 2022 16:38:52 GMT

Hi,

I'm trying to pass an output value of a processor dynamically into another and use it as a new property , here is my flow:

ReplaceText (gives the output)-> UpdateAttribute (i created a property which value is referencing output) -> EvaluateXpath ( i want to pass this value in a new property here) . I tried passing it by ${property_name} and $property_name but nothing works. Is it impossible to have a property referencing another in the EvaluateXpath processor ?

Thanks.

Re: Use a variable in a processor

DigitalPlumber — Wed, 19 Jan 2022 17:02:37 GMT

Can I clarify that what you want to do is dealing with XML and XPath?

Or based on this "I'm trying to pass an output value of a processor dynamically into another and use it as a new property"

Output values in to flowfile attributes depend on the previous processor.

If you are not dealing with XML then the processor you most likely need is ExtractText followed by an RouteOnAttribute

Re: Use a variable in a processor

raniaa — Thu, 20 Jan 2022 10:41:23 GMT

Hi @DigitalPlumber thanks for your response, im actually dealing with an XML file so i need to use EvaluateXpath to extract values from my file ( i have Getfile -> SplitXml -> EvaluateXpath in my flow). On the other hand i have a CSV file that im extracting a value from ( i have another flow Getfile -> UpdateAttribute -> QueryRecord -> ReplaceText-> UpdateAttribute) My goal is to pass the value of the UpdateAttribute into the EvaluateXpath so i can extract a value from my XML file based on the ouput value extracted from my CSV.

Re: Use a variable in a processor

DigitalPlumber — Thu, 20 Jan 2022 20:05:56 GMT

I understand the issue EvaluateXPath does not take in an attribute syntax and fails at validation since it is validating for a valid Xpath path.

I wonder if there is a way to use QueryRecord instead.

Re: Use a variable in a processor

raniaa — Fri, 21 Jan 2022 13:44:04 GMT

Indeed @DigitalPlumber , EvaluateXpath can't handle variables, only an Xpath. Queryrecord might be an alternative if i was using another type of file but since im using an XML file and this processor performs an SQL Query what can be my parameters in the query ?