Are you using Aurena? If so, it's easy: just download a document from any screen and check the Network tab under Chrome's developer tools and you will see the necessary network request. If it's IEE, it's harder since you need to be able to access our middle tier. That is, if you don't have access to the database directly, then it's not very hard (SELECT from edm_file_storage_tab).

Hello Mathias,

We’re on IEE but we want to use the API instead of SQL commands.

Which API?

Hello Mathias,

Well, this was the initial question: which API (if exists) do I have to use for downloading a document from the database ?

Sorry, I was not clear enough. Did you refer to a PL/SQL API or a web service? You said you didn't want to use SQL but that doesn't rule out calling an API in the database.

Hello Mathias,

We want to use the API in a Webservice, not use a SQL command in it. We will use php to invoke the API with curl command. In other words we want to do something like this

$curl = curl_init();

curl_setopt_array($curl, array(

  CURLOPT_URL => 'https://xxxx.ifs.cloud:48080/int/ifsapplications/projection/v1/DocumentRevisionsHandling.svc/DocIssueSet?%24filter=contains(Title%2C%27TEST%27)%20and%20contains(Info%2C%27Test%20test%27)%20and%20Objstate%20eq%20IfsApp.DocumentRevisionsHandling.DocIssueState%27Released%27%20and%20DtObsolete%20eq%20null',

  CURLOPT_RETURNTRANSFER => true,

  CURLOPT_ENCODING => '',

  CURLOPT_MAXREDIRS => 10,

  CURLOPT_TIMEOUT => 0,

  CURLOPT_FOLLOWLOCATION => true,

  CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,

  CURLOPT_CUSTOMREQUEST => 'GET',

  CURLOPT_HTTPHEADER => array(

    'Authorization: Basic xxxxx='

  ),

));

$response = curl_exec($curl);

curl_close($curl);

echo $response;

and not something like “select * from … whrere ...”

Maybe in this way it is much more clear.

Thanks.

Thanks, it's clear! You wrote that you are using IEE, but the example is calling a projection/making a REST call. Do you have Aurena installed? If so, it's easy!

Yes, we have Aurena installed.

Great! Then do this:

1. Log in to Aurena
2. Open the Document Revision page
3. Find the document you want a link to
4. Use the Create and Send Document Link command
5. Select the command to send the link by e-mail
6. Copy the link you want from the e-mail that opens

We don't have any integration projection for downloading documents, so sorting out the authentication might be slightly harder.

Good luck!