Skip to main content
  • EN

Quick Questions.

I have a Writer that is writing to a Google Fusion Table. I know that it is creating a table with the "Table Name" that I give it and a new Table Id that is created behind the scenes.

1) First Question: Is there some way in FME to get that Table Id? For any follow up operations (reading, etc) you have to use the Table Id and not the Table Name.

I know that FME is using the Table Id. I can see it in the INSERT INTO statements that it is using... (I replaced the Table Id with Xs.)

Google Fusion Tables: HTML SQL Request: 'POSTFIELDS=sql=INSERT INTO XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX ('geom', ...

Seems like the Table Id would be a nice thing coming out of a FeatureWriter... But maybe there is a way to get it today?

 

2) Second Question: Fusion table requests seem to fail pretty frequently. Is there any way to turn on retry logic so that on fatal errors (that haven't added data) the API request can be retried?

Thanks!

I'm using FME 2017.1. When I use the build-in GoogleFusion reader/writer and even a sqlExecuter you can use the TableName instead of ID. Do you use the standard reader/writer or do you use a httpCaller instead?

On the summary port of the FeatureWriter you can have a attribute like _total_features_written. With a tester you can do some retry logic. If needed you can create a custom transformer and put a loop into your logic.

I'm using FME 2017.1. When I use the build-in GoogleFusion reader/writer and even a sqlExecuter you can use the TableName instead of ID. Do you use the standard reader/writer or do you use a httpCaller instead?

On the summary port of the FeatureWriter you can have a attribute like _total_features_written. With a tester you can do some retry logic. If needed you can create a custom transformer and put a loop into your logic.

I want to use the httpCaller to call a rest API to pass in the new table id. So I can notify another service that a table was updated.

 

Basically everything that uses fusion tables (other than fmes reader/writer) requires the table id.

 

FME is translating the table name to the table id somehow. Just not sure how. 🙂.

 

I checked the rest API for fusion tables and I can see that you can list ALL your owned fusion tables which lists both the table id and name along with all table properties. So maybe that is what FME is doing. I was just hoping for something I could do that was cleaner. (When you have hundreds of tables that request takes a while.)

 

 

 

Reply


Community Stats

30,186
Posts
114,578
Replies
37,852
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.