Accessing xml documents stored in Marklogic Server via Oracle APEX Restful Webservice

Question

There is a setup done by our dba in Marklogic server, and he has uploaded several xml documents.

I am trying to access those documents via oracle apex RESTFUL web service pl/sql code

declare
l_clob       CLOB;
BEGIN

l_clob := apex_web_service.make_rest_request(
p_url => 'http://abcd.efg.com:8011/v1/documents?uri=/C/storage/data/temp.xml',
p_http_method => 'GET',
p_username    => 'temp',
p_password    => 'temp' );
dbms_output.put_line(l_clob);
END;

The dbms_output is printing the below error xml

<rapi:error xmlns:rapi="http://marklogic.com/rest-api">
<rapi:status-code>401</rapi:status-code>
<rapi:status>Failed Auth</rapi:status>  <rapi:message-code/> 
<rapi:message>Unauthenticated</rapi:message></rapi:error>

Any ideas what is the cause of the problem ??

Justin Makeig · Accepted Answer · 2013-04-23 17:40:01Z

3

I think you need to tell Oracle to do digest authentication for the HTTP request or switch your REST server instance to use basic auth.

answered Apr 23, 2013 at 17:40

Justin Makeig

2,13715 silver badges29 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user989729 Over a year ago

I have switched the authentication setting from Digest to Basic in the Marklogic Server. It worked. Thanks for your suggestion.

Tyler Replogle · Accepted Answer · 2013-04-25 23:24:36Z

0

What kind of authentication are you using? basic?

if so, have you given the temp user the correct permissions to save data or use the rest end points.

You might want to try just using the admin user and making the server authentication type application level. just to see if it works. I wouldn't use that in production.

answered Apr 25, 2013 at 23:24

Tyler Replogle

1,3397 silver badges13 bronze badges

Collectives™ on Stack Overflow

Accessing xml documents stored in Marklogic Server via Oracle APEX Restful Webservice

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related