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.

  • August 11, 2022
  • 2 replies
  • 29 views
lferg
Contributor
Forum|alt.badge.img
  • lfergContributor
  • Contributor
  • 5 replies

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!

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

2 replies

nampreetatsafe
Safer
Forum|alt.badge.img+13
  • nampreetatsafeSafer
  • Safer
  • 383 replies
  • Best Answer
  • August 12, 2022

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
  • 5 replies
  • August 14, 2022

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.

Community Stats

32,068
Posts
121,762
Replies
39,693
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
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.