Reports

i have a quite similar problem. as a solution i followed your approach. Create a Web Credential type HTTP Header. Credential Name Authorization Credential Secret *Bearer {JWT} In the Rest Datasource Definition i select this Credenitials leaving the Authentication Server empty

In APEX (22.1.0) the corresponding Page i run a BeforeHeader Process which executes

apex_credential.set_session_credentials (
    p_credential_static_id => 'DWBASIC',
    p_key =>'JWT',
    p_value =>   v_bearer
);

When running the page i get HTTP Respons 411 error.

Apex debug log snippet looks like that:

begin_request p_url=>http://xxxx.org/DocuWare/PlatformFileCabinets/ff174c35-4b24-473c-8ede-7299dc4e5eeb/Documents?Count=1&Fields=AUSWAHLLISTE,WERT1,WERT2,WERT3,p_method=>POST,p_proxy_override=>,p_transfer_timeout=>,p_https_host=>,p_wallet_path=>

set_header Proxy-Connection: Keep-Alive
set_header User-Agent: Oracle APEX
set_header JWT: ***
HTTP response 411 - Length Required
Header Content-Type: text/html; charset=us-ascii
Header Server: Microsoft-HTTPAPI/2.0
Header Date: Thu, 10 Oct 2024 14:13:14 GMT
Header Connection: close

Any idea what i am missing?

79074862