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.

Topic		Replies	Views
Lookup Key Value in database Connecting to SQL	10	8399	August 31, 2016
Date Format and Lookup keys Version 2 not working Users & Roles	8	3731	January 4, 2016
Rest api > mysql proc (two params) > json post data REST API	2	2491	January 20, 2018
How can i use Lookup Key with order by or group by Miscellaneous	1	2206	November 3, 2015
Storing data for users Users & Roles	7	5059	August 4, 2016