Skip to main content
Question

Download document with API

  • March 1, 2024
  • 9 replies
  • 262 views

Forum|alt.badge.img+8

Hello,

I’m searching for the API that download the document from the database.

Do you know which one is ?

Thanks.

9 replies

Mathias Dahl
Superhero (Employee)
Forum|alt.badge.img+32
  • Superhero (Employee)
  • 2903 replies
  • March 1, 2024

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).


Forum|alt.badge.img+8
  • Author
  • Do Gooder (Customer)
  • 28 replies
  • March 1, 2024

Hello Mathias,

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


Mathias Dahl
Superhero (Employee)
Forum|alt.badge.img+32
  • Superhero (Employee)
  • 2903 replies
  • March 1, 2024

Which API?


Forum|alt.badge.img+8
  • Author
  • Do Gooder (Customer)
  • 28 replies
  • March 2, 2024

Hello Mathias,

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


Mathias Dahl
Superhero (Employee)
Forum|alt.badge.img+32
  • Superhero (Employee)
  • 2903 replies
  • March 3, 2024

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.


Forum|alt.badge.img+8
  • Author
  • Do Gooder (Customer)
  • 28 replies
  • March 4, 2024

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.


Mathias Dahl
Superhero (Employee)
Forum|alt.badge.img+32
  • Superhero (Employee)
  • 2903 replies
  • March 4, 2024

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!

 


Forum|alt.badge.img+8
  • Author
  • Do Gooder (Customer)
  • 28 replies
  • March 4, 2024

Yes, we have Aurena installed.


Mathias Dahl
Superhero (Employee)
Forum|alt.badge.img+32
  • Superhero (Employee)
  • 2903 replies
  • March 4, 2024

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!