Solved

Adding to Google Sheet

Forum|Forum|9 years ago
August 18, 2016
2 replies
27 views

bbbutler

Hello,

I have a workspace that reads data from an API using the HTTP Caller. The API contains Wildfire data and I added query parameters to pull data for a single fire. I set up the workspace to dump the data into a Google Sheet. I'd like to push this to FME Server and have it add a new row and put the "updated" data in that new row. In other words I'd like each successful run of the workspace to result in writing a new row to the Google Sheet.

I've played around with all of the default options in the Google Sheet writer but cannot seem to figure out which (if any) of them will create the results I'm looking for. Does anyone out there have any experience with something like this?

Thanks in advance for any advice you might have.

Cheers,

Ben Butler

Best answer by itay

Hi,

Can't say I have much experience with this specific format but checking the documentation shows that an insert is not possible for this plug in.

https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_ReadersWriters/googlesheets/googlesheets.htm?Highlight=Google%20sheet

I would suggest trying the Google fusion table writer which does support inserts.

Itay

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.