On Premise customers may create an API Key and secret for each application that will integrate with the REST API. This is done by creating a record in the OAUTH_CONSUMERS table. Run the following sql query to create the consumer record you will use, replacing 'MyKey' and MySecret' with values you wish to use. Note: you should create a Key and Secret that are not easy to guess. We suggest creating a random key and secret composed of numbers, letters and symbols. Replace 'LicenseName' with the name of your Integrify license.

Sql Server

INSERT INTO [dbo].[OAUTH_CONSUMER]
           ([CONSUMER_GUID]
           ,[CONSUMER_KEY]
           ,[SECRET]
           ,[CREATED_DATE]
           ,[ALLOW_PROGRAMMATIC_ACCESS]
           ,[DATAINSTANCE_ID]
           )
     VALUES (
           NEWID()
           ,'MyKey'
           ,'MySecret'
           ,GETDATE()
           ,3
           ,'LicenseName' )

Oracle

INSERT INTO OAUTH_CONSUMER
           (CONSUMER_GUID
           ,CONSUMER_KEY
           ,SECRET
           ,CREATED_DATE
           ,ALLOW_PROGRAMMATIC_ACCESS
           ,DATAINSTANCE_ID
           )
     VALUES (
           SYS_GUID()
           ,'MyKey'
           ,'MySecret'
           ,SYSDATE
           ,3
           ,'LicenseName' );
commit;