Skip to main content
mujaeits0001
June 14, 2021
Question

i am trying to fetch image from database using integration

  • June 14, 2021
  • 4 replies
  • 0 views

Hi, 

i inserted some value to the database by using integration .

values  examples :are name, price, description, image.

i am  fetch the data in my record type all the values are coming, but when i am trying to display the record in the interface, image is showing null or empty.

when i saw  the cloud database in my DB the  image value is showing .

can anyone give me a suggestion 

4 replies

mikes0011
Brainy
June 14, 2021

When you say "image", exactly what is the database storing?  AFAIK the database will not store an actual file object that can be directly read and understood by Appian, but if it's storing the data for an image it would be encoded i.e. in Base64.  I believe in the past there have been some workarounds to convert base64 data back into documents in Appian, but this has been incosnsitent and involves plug-ins that are no longer available.

The Expression Guru
mujaeits0001
June 14, 2021

i am using appian trial version in that appian cloud database

mikes0011
Brainy
June 14, 2021

That still doesn't tell me what is being stored in the database for the "image" you're referring to.  How (i.e. in what format or by what method) is the image stored there initially?  Is the DB storing the actual image (binary) content or just the Appian document ID?  How are you attempting to display the image on your form?  When you run a query directly from the DB what do you see in the result?

The Expression Guru