I need to download one or more PDF documents from Sharepoint as part of an export process. These PDF’s have random titles and filenames, in the Sharepoint library an extra column was added containing a unique ID. It’s this ID I have to use in order to download the correct PDF.
Problem is that I can get this ID from Sharepoint using the Sharepoint Online List Reader, but that cannot give me the download URL. Conversely I can get the download url from the SharepontOnlineConnector transformer, but that one does not allow me to get the added custom ID.
So in order to get all the info I need, have to use the reader AND the connector and join the results from both together, which is rather ugly.
Am I missing something? Is there a way either of these can be configured where I get all the necessary info in one go? Or is this as designed? If the last, I’ll file an Idea I suppose...