This documentation is for WSO2 Data Services Server 3.2.2. View documentation for the latest release.
Returning Generated Keys - Data Services Server 3.2.2 - WSO2 Documentation
||
Skip to end of metadata
Go to start of metadata

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:

  • No labels