SQL exector get rows by update /insert a table

If I’m understanding your question correctly, you have a set of features you’re passing through an SQLExecutor to insert/update into a table. You’re then wanting to send an email with these features.

The SQLExecutor has the initiator output port, this outputs the features passed in through the initiator input port. I’m assuming you’re only wanting to send one email, so you need to reduce the number of features down to one (if you pass ten features to an emailer, you’ll send ten emails).

There are numerous ways to do this. For your situation, I think the HTMLReportGenerator will be helpful. This will allow you to build a table with the features that can then be inserted into the body of an email.

what i want is:

The nummers of rows insert/updated in a SQLExecutor.

Get the nummers and send this via an emailer

Hi ​@g.bizournet, I agree with ​@hkingsbury that the HTMLReportGenerator would be great for this. You could have one path that ends in a writer that would write your updates into the database table, and then a second path that will create a table via the HTMLReportGenerator and send it off via the Emailer. Here’s a mockup of how that might look: 

Hope that helps!