Created 09-17-2019 03:39 PM
Hi,
I am in need of SQL Server lookup, found this library https://github.com/mrcsparker/nifi-sqllookup-services-bundle but there are no good examples especially when dealing with incoming CSV text file. Appreciate if anybody can point me to an article or sample workflow that does something similar.
Thanks in advance
Created 09-19-2019 07:11 AM
i don't think there is a way to combine all 3 processors into one.
We still need to use ExecuteSQL -> ConvertAvroToJson -> EvaluateJsonPath to extract the values from the flowfile.
If the answer was helpful to resolve your issue, Accept the answer to close the thread 🙂
Created 09-17-2019 09:40 PM
Created 09-18-2019 01:46 PM
@Shu_ashu : Thank you so much for the link, it covers part of my need.
The other thing is to assign the lookup value to attribute so I think the solution is
ExecuteSQL -> ConvertAvroToJson -> EvaluateJsonPath
can we do it in one step instead of 3 like above? All I am pulling is one field from the database table.
Query: select id from table A
Created 09-19-2019 07:11 AM
i don't think there is a way to combine all 3 processors into one.
We still need to use ExecuteSQL -> ConvertAvroToJson -> EvaluateJsonPath to extract the values from the flowfile.
If the answer was helpful to resolve your issue, Accept the answer to close the thread 🙂