Pulling PNG Images into DOMO using FTP server calls via SKU keys
Hi,
I have sales data with product information that aligns with our PNG files names inside our ftp server, where all our images are stored. Is there a beastmode where it will populate an image to the table view through calling the ftp, using credentials and some sore of concat(key in below examples) of the data's attribution? Here is an example of the data and I would like an image to show in "image" for any product that has a matching file in our ftp folder.
IMAGE | KEY | Style# | Color Code | REV $ |
M9944C5REPTEAL | M9944C5REP | TEAL | $5 |
Here is an example of both our http and ftp links and I would need to embed the credentials in the beastmode I assume? My HTML isn't the best so hoping someone here can take me to the promise land.
Comments
-
Hi @DMJerry,
I have to preface this response with the disclaimer that I don't know if this solution will work, but I found this https://www.cs.rutgers.edu/~watrous/user-pass-url.html that references storing ftp credentials in a URL. So you may be able to put the username and password in the url with your nested HTML to display the image and it MIGHT be able to show the image from the ftp site.
Hope this is helpful, best of luck!
**Say 'Thanks' by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem as 'Accepted Solution'1 -
0
-
Hi,
I was curious the rest of the code to pull that image into DOMO using the keys within the data to call. I'm still digging in and hoping someone will have an example of the code, using my example, that I can test/use.
Appreciate all the help.
0 -
@DMJerry I found this in the Instagram quickstart for hitting an image stored at a publicly accessible URL. If you're able to get the credentials stored and concatenated to your image ftp URL, I don't see a reason why this wouldn't work:
In your Beast Mode calculated field:
CONCAT('<img src="',`images_thumbnail_url`,'"></>')
The images_thumbnail_url would be the working FTP picture link.
**Say 'Thanks' by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem as 'Accepted Solution'0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 101 SQL DataFlows
- 622 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 748 Beast Mode
- 59 App Studio
- 41 Variables
- 686 Automate
- 176 Apps
- 453 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 396 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 125 Manage
- 122 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 109 Community Announcements
- 4.8K Archive