How to create an Url address for image in SQL Server Filetable

126 Views Asked by At

I have saved the image as base64 in the SQL Server FileTable.

Now I want to send the address of this file with API in string format for Android to be displayed with the Picasso library.

Do you have a solution?

1

There are 1 best solutions below

1
David Browne - Microsoft On

FileTable files aren't natively accessible over http using a URI. They are available over SMB using a UNC, eg \\someserver\someshare\somefolder\somefile.jpg

If you want to serve the images to an Android app, you'll need to add an HTTP endpoint to your back-end application to deliver file over http.