Question

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

  • 23 January 2020
  • 2 replies
  • 5 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?


2 replies

Userlevel 5
Badge +25

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.

Badge +21

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.

 

Reply