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.
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;