I am currently setting up a workflow where I need to extract an image (specifically a signature captured from an iPad) from an internal SharePoint list on our intranet. The challenge I’m facing is that there might be multiple images within this list, and I need to ensure I can access the correct one. however an image for each single row of the list (because 1 row means one new record)
Once I extract the desired image, I need to insert it into a specific cell within an Excel file. right now I’m using the Excel Cell Updater node since I need to update a template Excel file with various changing information for each instance (the famous row above of the sharepoint list)
I would greatly appreciate your insights, cause i dont know how to perform this action
happy to expand if needed
@Fabio_Gris to identify three correct image you could try to list them and then have some sort of filter (latest, name) to find the correct one. Then transfer that maybe to a local temporary folder and then place it in Excel. You might have to convert it to PNG.
Tks @mlauber71 for your reply. let me deep dive a little bit more my issue. i’m connecting to an internal sharepoint list within my company.
In addition to all the various information, the list contains images in .png format that are nothing more than a customer’s signature. I can get the URL of where the image is located and indeed, copying the URL into Chrome for example, I can reach it and opens without issues.
However, I’m not succeeding in downloading the images to a local folder, I think because of company’s firewall. in fact, trying to use the GET request node, it gives me the error 403 - forbidden. I really don’t know how to solve this.
currently to bypass this issue, at the moment I have created a macro in the excel file that takes the image, via link, and paste it in the excel; but it’s not the best solution because the excel file must be opened and the macro must be run (the generated excel file is always on sharepoint so I can’t even use task schedulers). I would also need to transform the excel file into pdf but this is perhaps another topic (at the moment always through the famous macro in addition to placing the image, I transform the file into pdf).
Last but not least, for some reason that I don’t understand, Knime image processing extension is not downloadable, guess is related to the blocks upstream.
Thanks to anyone who can help me
Happy to expand or attach some pics if needed
