Skip to main content
  • EN
  • Home
  • Forums
  • FME Form
  • Data
  • I have an excel file of pipe CCTV record pdfs hyperlinks. The pdfs are stored in Google Drive and I want to be able to download these in bulk to a local folder.

I have tried using the excel reader to get my file in, then httpcaller with the URL as my column of google drive shared hyperlinks. Renaming the output to a column which identifies the name that I want. I'm obviously not getting the settings right in the httpcaller or missing something entirely. New to using this and really no idea what I should be doing. For now I have only focussed on trying to download the Report but ultimately there is also a video avi to be downloaded. My input excel file looks like the following: Newname for the report and then the report google drive hyperlink.

image

Have you tried using the GoogleDriveConnector? There's an Object ID parameter that you can actually set by parsing out the Object ID from your URLs. I've put together a quick workspace demonstrating this. The URL I have there is a public URL which you can use. You will just need to update the Web Connection to your own Google Drive connection and download folder. Hope this helps!

Have you tried using the GoogleDriveConnector? There's an Object ID parameter that you can actually set by parsing out the Object ID from your URLs. I've put together a quick workspace demonstrating this. The URL I have there is a public URL which you can use. You will just need to update the Web Connection to your own Google Drive connection and download folder. Hope this helps!

Thanks Nampreet that works great for the download. I had tried the GoogleDriveConnector but obviously didn't get the input values correct. Now trying to figure out how to get the downloaded file renamed.

I have followed a previous answer of Takahi's in the post https://community.safe.com/s/question/0D54Q000080hKw8SAE/quick-way-too-rename-files-for-noobs with a PATH reader and FILECOPY writer which allows me to put in a standard prefix or suffix. Found that reading in my excel file and joining with DATABASEJOINER works a treat.

Reply


Community Stats

30,126
Posts
114,349
Replies
37,758
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.