To use the Integrify REST API, you will need an API Key and Secret.
Cloud customers may request a key pair for use with the Integrify REST API by submitting a help request.
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.
INSERT INTO [dbo].[OAUTH_CONSUMER] ([CONSUMER_GUID] ,[CONSUMER_KEY] ,[SECRET] ,[CREATED_DATE] ,[ALLOW_PROGRAMMATIC_ACCESS] ,[DATAINSTANCE_ID] ) VALUES ( NEWID() ,'MyKey' ,'MySecret' ,GETDATE() ,3 ,'LicenseName' )
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;