Skip to main content
Question

How to check for the presence (existance) of a google sheet?

  • January 23, 2020
  • 2 replies
  • 51 views

The google writer has the path its going to write to... How do I see the path (URL) it is going to use to write a google sheet?

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

redgeographics
Celebrity
Forum|alt.badge.img+62

If you use a Web Connection to connect to your Google Docs account you only need to enter a sheet name. If it exists FME will treat it according to what you set in the feature type settings (Feature Operation, could be Update, Upsert, Delete or fme_db_operation if you want to handle it per feature).

I think, but haven't tested this, you can also add the shareable url that you can get in Google Sheets.


sigtill
Supporter
Forum|alt.badge.img+25
  • Supporter
  • January 29, 2020

Hi @thane.taylor If you want to check if an URL exist (the shared Google Sheet url) you can use a HTTPCaller and use the HTTP Method HEAD. This will just check if the file is there without downloading it - so its fast.