I’m trying to use a lookup key called {COMPANY_ID} to provide some multi-tenant features and it seems be be ignored when pushing it through to the stored proc via the REST API as I am getting a cannot convert from varchar to int error (the fk_companyID is an INT). Is this normal behaviour or is it …

Lookup Key not being Inserted for callStoredFuncWithParams()

Martin_Jansen July 3, 2015, 2:25pm 3

Apologies: callStoredProcWithParams() is the one that I used.

Update custom field when updating role?

Topic		Replies	Views
Strange Issue in calling StoredProcedure REST API	1	1866	November 22, 2015
Stored Procedures / Functions from Azure SQL DB REST API	1	2511	June 12, 2017
Getting API Key and passing it as a _proc/procname(parameter) value	1	1206	May 14, 2018
Lookup Key Value in database Connecting to SQL	10	8353	August 31, 2016
Date Format and Lookup keys Version 2 not working Users & Roles	8	3683	January 4, 2016