Requesting oauth token via Oracle

[allwyn1]

Hi

I am trying to request Oauth token from Oracle SQL,   Making an REST API call to authenticate and login into Dev instance and get the success response and should be able to retrieve the access token.

when I do that from Oracle I am getting an error message:

SQL> /

{"error":"server_error","error_description":"access_denied"}   when it trace it down it displays error code as 401 from Service now and I wanted to find out is there any parameter I need to set to authenticate external connection.

Thanks

Allwyn

[coryseering]

Hi Allwyn,

Awesome!

The API is spitting out an auth error because all of that checking happens early on in the authorization process (we don't even check the username and password if the incoming post isn't right) but I see your point.

The log file itself shows better errors, but you'd have to be looking for them in the right place.

[ksk]

Hi, I am trying to make a rest call to servicenow from Oracle Pl/sql. Even though I placed the certificate in the oracle wallet I still get

Error at line 3

ORA-29273: HTTP request failed

ORA-06512: at "SYS.UTL_HTTP", line 1130

ORA-29024: Certificate validation failure

Can you please help?

Thank You