• 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.
Solved

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.

  • 11 August 2022
  • 2 replies
  • 8 views
lferg
Rank
Badge

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

icon

Best answer by nampreetatsafe 12 August 2022, 10:16

View original

2 replies

nampreetatsafe
Rank
Userlevel 1
Badge +10

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!

lferg
Rank
Badge

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

28,681
Posts
109,409
Replies
36,542
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.