I am trying to insert data into a JDBC connection, which works as expected... however I'd like to ensure it returns the ID of the autogenerated primary key.
When I run the following query in SQL Server directly, it works as expected - however I have been unable to emulate this behavior within the API gateway.
Has anybody accomplished returning the data resulting from the insert, or is there another way I should be attempting this?
INSERT INTO [***].[testDatabase]
SELECT SCOPE_IDENTITY() AS newID;
XML Results: (this also seems strange as I specify to Fail assertion if no results return.
<?xml version="1.0" encoding="UTF-8"?>