Christopher, You can look into the EvaluateXQuery, EvaluateXPath, and TransformXml processors to extract data from XML files.
You can then use ReplaceText to build the SQL statement that you want to use and PutSQL to update the database. Thanks -Mark > On Nov 9, 2015, at 3:42 PM, Christopher Hamm <[email protected]> wrote: > > I just tried with 0B size set and it worked fine. Now I just need to look > into parsing the xml to extract fields and update a MySql db. > > Any guidance on that? > > On Nov 9, 2015 3:32 PM, "Joe Witt" <[email protected] > <mailto:[email protected]>> wrote: > "Did you try using an invokeHTTP processor with a FlowFile input file created > using the GenerateFlowFile processor?" -- Which we should admit is super > hacky and we're fixing in 0.4.0 :-) > > On Mon, Nov 9, 2015 at 3:30 PM, Matthew Clarke <[email protected] > <mailto:[email protected]>> wrote: > Did you try using an invokeHTTP processor with a FlowFile input file created > using the GenerateFlowFile processor? > > On Mon, Nov 9, 2015 at 3:23 PM, Christopher Hamm <[email protected] > <mailto:[email protected]>> wrote: > Ugg > https://issues.apache.org/jira/browse/NIFI-993 > <https://issues.apache.org/jira/browse/NIFI-993> > > On Mon, Nov 9, 2015 at 3:10 PM, Christopher Hamm <[email protected] > <mailto:[email protected]>> wrote: > Ok tried that and still wont work. I think it as something to do with message > of "supports expression language: false" for the url. Attached error and xml > template. Any help is appreciated. I need to understand how the dynamic > querying should work in order to complete an actual project. Many thanks > > <nifi-processor-message.png> > > > On Fri, Nov 6, 2015 at 8:04 AM, Aldrin Piri <[email protected] > <mailto:[email protected]>> wrote: > Christopher, > > For this setup, you want to use GetHTTP. InvokeHTTP operates off of FlowFile > input. > > > On Fri, Nov 6, 2015 at 2:33 AM, Christopher Hamm <[email protected] > <mailto:[email protected]>> wrote: > I have a dataFlow setup that looks up api call using current date. I turn it > on and nothing seems to happen.. Help appreciated. > > > > -- > Sincerely, > Chris Hamm > (E) [email protected] <mailto:[email protected]> > (Twitter) http://twitter.com/webhamm <http://twitter.com/webhamm> > (Linkedin) http://www.linkedin.com/in/chrishamm > <http://www.linkedin.com/in/chrishamm> > > > > -- > Sincerely, > Chris Hamm > (E) [email protected] <mailto:[email protected]> > (Twitter) http://twitter.com/webhamm <http://twitter.com/webhamm> > (Linkedin) http://www.linkedin.com/in/chrishamm > <http://www.linkedin.com/in/chrishamm> > > > -- > Sincerely, > Chris Hamm > (E) [email protected] <mailto:[email protected]> > (Twitter) http://twitter.com/webhamm <http://twitter.com/webhamm> > (Linkedin) http://www.linkedin.com/in/chrishamm > <http://www.linkedin.com/in/chrishamm> >
