For PutSQL you have to generate a SQL statement.
For your previous question, I've suggested how to make that fork to
separate root attributes from array, and how to break array into separate
flow files (ff per element of array).
Now, having single elements, you can generate INSERT/UPDATE SQL statement
per each element and use PutSQL to execute it on your DB.
Alternatively, once you get separate flow files, you can use ConvertRecord
to convert your array elements into records, then use MergeRecords and then
use PutDatabaseRecord (that will improve performance because you can use
PutDatabaseRecord with multiple records in flow file).
On Wed, Sep 5, 2018 at 3:18 PM l vic <lvic4...@gmail.com> wrote:
> I need to save data with "root" object to be saved into "root" table and
> array "mylist" of contained objects to be saved into "mylist" table:
> {
> "id": 3,
> "name": "ROOT",
> "mylist": [{
> "id": 10,
> "info": "2am-3am"
> },
> {
> "id": 11,
> "info": "3AM-4AM"
> },
> {
> "id": 12,
> "info": "4am-5am"
> }]
>
> }
>
> so I have to perform single "upsert" into "root" table and multiple
> "upsert"s into "mylist" table from one flow... Does PutSQL support this?
> Thank you
>
>
