The Return Generated Keys option appears under Input Mappings in the Queries page.
It inserts data to a table that has auto increment key columns. The auto incremented key value of the record is mapped to the result output mappings of the data service. For example, the sample query below is used to insert values to a table by the name
wes_teams, which has an auto increment column:
INSERT INTO wes_teams(TEAM) VALUES(?)
Once the user selects
Return Generated Keys option, an auto increment key is added as an output mapping as follows: