Skip to main content
  • EN

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

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

Thanks @itay you indeed are correct! I guess I should do my homework before sticking my foot in my mouth in public! Thanks for the response.

Reply


Community Stats

30,353
Posts
115,357
Replies
38,088
Members
Terms & ConditionsCookie 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.