Setting up cohere AI HTTP 401: Unauthorized?

[admin]

Setting up Cohere AI in Oracle APEX

Step 1
Register and get API from Cohere.com

Step 2
Download and install SSL certificates from Cohere.com and install in your Oracle Wallet.

VIDEO: Oracle Wallet Creation, SSL Certificate Import, and Secure Web Services Integration in Oracle APEX
https://youtu.be/77jfvRe2GqQ

Step 3
-- Check the existing ACLs related to Cohere service so better to drop to avoid any confusion.

SELECT * FROM DBA_NETWORK_ACLS;

Step 4 (optional)

BEGIN
DBMS_NETWORK_ACL_ADMIN.DROP_ACL(
acl => 'cohere_api_acl.xml'
);
COMMIT;
END;
/

Step 5
BEGIN
-- Create the ACL
DBMS_NETWORK_ACL_ADMIN.CREATE_ACL(
acl => 'erpstuff_cohere_api_acl.xml',
description => 'ACL for Cohere API Access',
principal => 'APEX_240100', -- << Assign your APEX user depending upon the version in my case it is APEX_240100 user
is_grant => TRUE,
privilege => 'connect',
start_date => SYSTIMESTAMP,
end_date => NULL
);

DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL(
acl => 'erpstuff_cohere_api_acl.xml',
host => 'api.cohere.ai',
lower_port => 443,
upper_port => 443
);

COMMIT;
END;
/

-- Now check the privileges assigned to the ACL
SELECT * FROM DBA_NETWORK_ACL_PRIVILEGES WHERE ACL = 'erpstuff_cohere_api_acl.xml';

Step 6
Configure in Oracle APEX.

Video: Oracle APEX Configure Generative AI Services in 24.1 | Cohere AI
https://youtu.be/zfhG1rZ48Rg

ai.jpg