#_jsonResult# SELECT userContext, transactionLimit, validIPAddresses, coalesce( reference, left( apiKey, 250 )) as reference, allowedOperations FROM tbl_SEC_APIKeys with (nolock) WHERE apiKey = and ownerId = and ownerType = SELECT COUNT( transactionId ) AS transactionCount FROM tbl_API_LOG with (nolock) WHERE apikey = and transactionTime >= DATEADD( minute, -1, ) SELECT w.auth_CustFldr, w.auth_AppName, w.auth_LoginSecureIDs, w.auth_ReminderSiteName, w.auth_ReminderFromAddy, w.auth_LoginHelpAddy, c.FSL_CompanyID, c.FSL_TableCode, w.websiteid, w.auth_GenericBrokerPortalLogin FROM fsenablers..tbl_CUS_Websites w, fsenablers..tbl_CUS_Customers c WHERE w.portal_ownerId = and w.portal_ownerType = AND w.CustomerID = c.CustomerID select attrbId LoginAreaID from tbl_SEC_Attributes with (nolock) where ownerId = and fsl_tablecode = and attrbTypeId = 3 and attrbId = select fspro_UserId, passwordLock from tbl_fspro_Members with (nolock) where email = and ownerId = and fsl_tablecode = and loginEnabled = 1 #_jsonResult# insert into tbl_API_LOG( ownerType, ownerId, apiKey, transactionTime, transactionType, url, request, rateLimitRemaining, ip_address ) values ( , , , , , , null, , ) update tbl_API_LOG set statusCode = , responseTime = where transactionId = update tbl_API_LOG set rateLimitRemaining = where transactionId = update tbl_API_LOG set request = where transactionId = update tbl_API_LOG set response = , responseTime = , statusCode = '200 OK' where transactionId =