Skip to main content
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.

lferg
Contributor
Forum|alt.badge.img
  • lfergContributor
  • Contributor

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

Best answer by nampreetatsafe

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!

View original
Did this help you find an answer to your question?

2 replies

nampreetatsafe
Safer
Forum|alt.badge.img+12

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
Contributor
Forum|alt.badge.img
  • lfergContributor
  • Author
  • Contributor
  • August 14, 2022
nampreetatsafe wrote:

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


Helpful Members This Week

Community Stats

31,103
Posts
117,914
Replies
38,855
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie 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.