Diagnose a Google Fusion spreadsheet update using the API to download the CSV version

Question

I am trying to diagnose problems updating Google Fusion spreadsheets using CSV data through the API. It seems that everything works correctly on the code side, without errors, but the data does not reflect the changes. Any ideas how I can diagnose what is going wrong?

I am using the GoogleApis.Fusiontables.v2 C # library (v1.27.1.833 the last thing I tried) to update the merge table daily. The process worked for quite some time, but now it no longer works. I suspect the process has been broken down for a month or more.

Everything seems to work on the code side, no error messages. I also debugged the process from Visual Studio without any problems - it just works from the client side.

In case it is useful to use the C # method that I use:

fusiontablesService.Table.ReplaceRows(tableId, stream, "application/octet-stream").Upload();

The table I'm trying to update is https://fusiontables.google.com/DataSource?docid=1ndrFm1g0iZpz5gszjz5Ij9r_KiQbNYRXVM2JNfv3

The column UpdatedUtcindicates that several updated rows are passing, but not all of them.

If I export the CSV stream to a physical file and manually create a new Fusion table via the web interface, this works great and displays all the missing data that I expect there.

Here's a zipped CSV file if useful - http://www.paydirt.co.nz/stackoverflow/GoldPermits.zip

Fusion. CSV - https://www.google.com/fusiontables/DataSource?docid=1Udnre88O8e1zokvnhrkmqdY7BbYD2OQtELdyz3uG

:

, :

PERMIT_NUMBER : 60304 60247.

, , ? , , - ?

/ .

Answer 1

fusiontablesService.Table.ReplaceRows(...).Upload() Google.Apis.Upload.ResumableUpload.ResumableUploadProgress, Status Exception, .

:

{Google.Apis.Upload.ResumableUpload.ResumableUploadProgress}
    BytesSent: 10485760
    Exception: {"Google.Apis.Requests.RequestError\r\nContent has a different number of columns than the table (line 1). [400]\r\nErrors [\r\n\tMessage[Content has a different number of columns than the table (line 1).] Location[ - ] Reason[badImportNumColumnsMismatch] Domain[fusiontables]\r\n]\r\n"}
    Status: Failed