
MadhusudanS.93394 (Customer) asked a question.
Hi All,
I have implemented OKTA as authentication in ORACLE APEX using SSO option. The OKTA team is sending custom claims in a payload. How should I fetch this payload in oracle apex. Could anyone of you tell the process to get this payload in apex and use the custom claim.
This is the sample payload sent by OKTA team. Shoud I write any PLSQL code in post authentication procedure or any kind of process.
Sample payload.
{
"sub": "00u1eruv3lwot0h8",
"name": "Ram",
"email": "Ram@gmail.com",
"ver": 1,
"iss": "https://oktapreview.com/oauth2/default",
"aud": "0oa2g83asah4GdhCH0h8",
"iat": 17550123654,
"amr": [ “pwd”],
"idp": "00ojo0gzckm4u0K4O5A0h7",
"nonce": "nonce",
"preferred_username": "Ram@gmail.com",
"auth_time": 1000,
"at_hash": "preview_at_hash",
"apex_username": "ram",
"Apex_role": ["admin","contributer","reader"] }

Hi,
This article might help?
https://apexapplab.dev/2021/05/31/okta-authentication-for-apex-in-5-minutes/
Thanks,
Rohith
Hi Rohit, this article shows how to use OKTA as authentication in Apex.
I have successfully implemented authentication. My issue now is getting the payload data in apex. I want a method/process on how to fetch the payload from OKTA to Apex. Once the Payload data is in apex. I can parse the JSON and get the required data.
Hi @MadhusudanS.93394 (Customer) I would recommend you to reach out to Apex support, you may get appropriate support for the same.