CODEWITHSUNDEEP
google-apps-scriptgoogle-fusion-tables
ajb1970
ajb1970

Reputation: 31

Import rows in Fusion Tables fails

I can't seem to import rows into Google Fusion correctly. I always get a 503 Backend error. My Google Apps Script code is below.

var getDataURL = 'https://www.googleapis.com/fusiontables/v1/tables/{tableID}/import?key='+{apiKey};

var ssDown = SpreadsheetApp.openById({Spreadsheet ID}).getDataRange().getValues();

var options = { "method" : "post", "contentType" : "application/json", "headers" : { "Authorization" : "Bearer " + {token}, "Accept" : "application/json", }, 'encoding' = 'auto-detect', 'payload' = ssDown.toString(); } };

var output = UrlFetchApp.fetch(getDataURL,options).getContentText();

Upvotes: 1

Views: 729

Answers (1)

ajb1970
ajb1970

Reputation: 31

The issue was caused by careless coding on my part. The correct code is:

var getDataURL = 'https://www.googleapis.com/upload/fusiontables/v1/tables/{tableID}/import';
var options = { "method" : "post",
              "contentType" : "application/octet-stream",
              "headers" : {
                "Authorization" : "Bearer " + {token},
                "Accept" : "application/json",
              },
            }
var ssDown = SpreadsheetApp.openById({sheetID}).getDataRange().getValues().toString();
options.payload = ssDown;
var output = UrlFetchApp.fetch(getDataURL,options).getContentText();

Upvotes: 1

Related Questions