Retrieve files from attachments in Adobe Livecycle process | Community
Skip to main content
H
harry2ca
Level 2
March 3, 2022
Solved

Retrieve files from attachments in Adobe Livecycle process

  • March 3, 2022
  • 1 reply
  • 1391 views

The long-lived adobe livecycle process has attachments which is List of Document type. It is stored in SQL Server Database as image. Can I retrieve it from SQL Query and pass result to List <Document> type variable  in adobe livecycle process? So I could iterate the list to retrieve all files from the attachments. Please advise.  Thanks in advance.

 

 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by workflowuser

you will have to write some code in the execute script component. The code will be in java. You will be creating a query to get the columns from the database and create a document from that

1 reply

W
Adobe Employee
workflowuserAdobe Employee
Adobe Employee
March 3, 2022

try converting the image to base64 string and then create Document object to get the attachments

    H
    harry2caAuthor
    Level 2
    March 3, 2022

    Thanks for reply. I didn"t make it. Cannot retrieve ist type from database in adobe process. Could you provide more details? 

    Regards. 

      W
      Adobe Employee
      workflowuserAdobe EmployeeAccepted solution
      Adobe Employee
      March 3, 2022

      you will have to write some code in the execute script component. The code will be in java. You will be creating a query to get the columns from the database and create a document from that

        Terms & ConditionsAccessibility statement

        Loading footer...