sqlRead

Executes a write sql statement and returns the number of rows affected

Parameters

1. requestBody - The Gebra Suite Api uses this to get the url and user information to access the Gebra Suite Server.

2. statementName - The name of the statement

3. additionalParameters - all controls in the current config are set as paramters automatically. If you need to add additional parameters, you can use this json object to set them

4. queryOptions - (optional) a json object with options for the request

   • timeout - (optional) timeout for the SQL request. Default is 30 seconds

   • connectionKey - (optional) a key to a custom settings entry with the connection string to an external MSSQL database

Example Usages

Read all data without parameters

   let rowsChanged = await serverApi.sqlRead(req.body, "getAddresses", {}, {timeout: 90});

Read all data with parameters

   let rowsChanged = await serverApi.sqlRead(req.body, "getAddresses", { adrType: 1});