SQL Result to Attributes

2018-11-21 Thread Nick Carenza
I would like to add a sql query result to attributes but I don't see a way to do this currently. Anyone know of a processor I am missing or have a workaround? Preferably the result columns would become attributes. I think I cuuld use exctract test to move the current flowfile contents into

RE: NiFi 1.7.1 remote group not connecting when added through restful api until nifi restarted

2018-11-21 Thread christophe.monnet
The POST request that create an RPG returns an RemoteProcessGroupEntity whose ID can be used to call GET repeatedly. At some point you will find the port in RemoteProcessGroupEntity.getComponent().getContents().getInputPorts() but not immediately after creation. -Original Message-

Re: SQL Result to Attributes

2018-11-21 Thread Koji Kawamura
Hi Nick, I thought there was a discussion about adding a general database lookup service, but I can't find LookupService impl available that can fetch value from external databases. If there's such controller service, you can use LookupAttribute processor. (wondering if you're interested in

Re: SQL Result to Attributes

2018-11-21 Thread John McGinn
Brett Ryan has 2 different processors on GitHub that can do something similar. https://github.com/brettryan/nifi-drunken-bundle In the master branch, he has an UpdateAttributesFromSQL. When he discussed this on the list in 2017, I think, it was suggested to turn into a lookup. If you look at