Hi Indus, The data content is the body of the FlowFile that comes out of the success relationship. This data is structured in Avro format. If you haven't had the chance to give it a look over, the usage guide give some additional details concerning interaction with ExecuteSQL [1].
>From here, the general pattern to interact with the data in flow is converting to JSON using ConvertAvroToJson [2] which opens up a lot of possibilities when joined with EvaluateJsonPath [3] If you have any other questions let us know. Any specifics concerning your DB schema can help give some additional pointers and interactions with some options for interacting with your results. [1] https://nifi.apache.org/docs/nifi-docs/components/org.apache.nifi.processors.standard.ExecuteSQL/index.html [2] https://nifi.apache.org/docs/nifi-docs/components/org.apache.nifi.processors.avro.ConvertAvroToJSON/index.html [3] https://nifi.apache.org/docs/nifi-docs/components/org.apache.nifi.processors.standard.EvaluateJsonPath/index.html On Sat, Dec 5, 2015 at 6:17 PM, indus well <[email protected]> wrote: > Hi NiFiers: > > Is there a sample data flow to show the usage of the ExecuteSQL processor? > I can connect to the database and execute the SQL SELECT query and I can > see the executesql.row.count value, but I don't know how to get the data > content returned from the query. Please help. > > Thanks, > > Indus >
