Skip to main content
S
sameerm9237
January 3, 2023
Question

how to store array of files in appian

  • January 3, 2023
  • 10 replies
  • 0 views

I'm  trying to store array of files in database since it does not picks blob as a datatype any work around would be much appreciated.

    10 replies

    harshitb6843
    harshitb6843
    January 3, 2023

    You will have to store those file on Appian and then write their ID to database. 

    S
    sameerm9237Author
    January 3, 2023

    how can I do this can you please elaborate with a code since I'm a beginner.

    gauravg568
    gauravg568
    January 4, 2023

    May I ask why you're trying to store the files in the database, and not within an Appian folder? 

    S
    sameerm9237Author
    January 4, 2023

    I am trying to make a helpdesk system to track record of complaints in order to track I would require user to upload some sort of files and for each file uploaded should be added to the database so I can track which user raised what issue along with the file uploaded 

    gauravg568
    gauravg568
    January 4, 2023

    To achieve this use case, you don't need to store the file in the database. As Harshit has indicated, store the file in an Appian folder, and store the Appian Document ID along with the complaint details in the database. 

    Terms & ConditionsAccessibility statement