Load a few images from a URL based upon a matching field value
Hello mighty pools of wisdom 😉
I am stuck...
For each client we upload 4 images to a server. Each client has a clientcode field. All files on the server are labeled: [clientcode]_Product_1.png (Example: S56H3M2_Product_1.png .. S56H3M2_Product_4.png)
What I am trying to do is: with only this one specific client [clientcode] selected, now on a 'reload' download the 4 images AS Product1 .. Product4. If I reload without one specific client selected: memory can be cleared.
Something like:
LOAD w3.example.com/images/[clientcode]_Product_1.png AS Product1, w3.example.com/images/[clientcode]_Product_2.png AS Product2, w3.example.com/images/[clientcode]_Product_3.png AS Product3, w3.example.com/images/[clientcode]_Product_4.png AS Product4;
I will then display the product image as text object (with image representation) into a report.
Anyone with an idea? Thank you so much in advance. Alex