0

I have a Google API Picker which I am using to get the ID of a file, so that data can be imported into the new workbook. This has been running successfully for about 4 weeks, but this week it has stopped running the callback functions, which saves the file ID to a sheet and then closes the picker. (See code below for the HTML page.)

All that I have done, since the picker last worked correctly, was to make some changes to variable and function names. And none that shoul dhave affected the picker.

Here is the link to my workbook:

https://docs.google.com/spreadsheets/d/1jYA3mLJiJmeK96EXPhB0j5iceKhSa9gBs3OLiYm79Y4/edit?usp=sharing

Thank you in advance for your assistance in this matter. It had been driving ma crazy for the last few days.

<!DOCTYPE html>
<html>

<head>
  <link rel="stylesheet" href="https://ssl.gstatic.com/docs/script/css/add-ons.css" />
  <script type="text/javascript">
    var DIALOG_DIMENSIONS = {width: 600,height: 425,};
    var ImportCallback = false;

      function loadAPI()
      {
        gapi.load('picker',
          {
            callback: function () 
              {
                ImportCallback = true;
              },
          });
        google.script.run.withSuccessHandler(CreatePicker).withFailureHandler(ShowError).GetOAuthToken();
      }

    function CreatePicker(token)
      {
        if (ImportCallback && token)
          {
            var picker = new google.picker.PickerBuilder()
            .addView(google.picker.ViewId.SPREADSHEETS)
            .hideTitleBar()
            .setOAuthToken(token)
            .setCallback(ImportCallback)
            .setOrigin(google.script.host.origin)
            .setSize(DIALOG_DIMENSIONS.width - 2,DIALOG_DIMENSIONS.height - 2)
            .build();
            picker.setVisible(true);
          }
        else
          {
            ShowError('Unable to load the file picker.');
          }
      }

    function ImportCallback(data)
      {
        var action = data[google.picker.Response.ACTION];
        if (action == google.picker.Action.PICKED)
          {
            var doc = data[google.picker.Response.DOCUMENTS][0];
            var id = doc[google.picker.Document.ID];
            google.script.run.StorePreviousFileID({ fileId: id });
            google.script.host.close();
          }
        else if (action == google.picker.Action.CANCEL)
          {
            google.script.run.ImportCancelledAlert();
            google.script.host.close();
          }
      }

    function ShowError(message)
      {
        document.getElementById('result').innerHTML = 'Error: ' + message;
      }
  </script>
</head>

<body>
  <div>
    <p id="result"></p>
  </div>
  <script type="text/javascript" src="https://apis.google.com/js/api.js?onload=loadAPI"></script>
</body>

</html>

I was told that since the picker was not throwing any errors in Apps Script, to check the Console log in my browser, when running the funtion "Import/Restore Data", from the "FAP Menus" toolbar. The following is what is displayed in the Console, while running the API picker HTML page.

The resource <URL> was preloaded using link preload but not used within a few seconds from the window's load event. Please make sure it has an appropriate as value and it is preloaded intentionally.

926399698-waffle_js_prod_ritzmaestro.js:93 Unrecognized feature: 'ambient-light-sensor'.
pPn.Ea @ 926399698-waffle_js_prod_ritzmaestro.js:93
t.wV @ 3553640092-waffle_js_prod_core.js:848
t.render @ 3553640092-waffle_js_prod_core.js:848
qPn.Ea @ 926399698-waffle_js_prod_ritzmaestro.js:95
t.wV @ 3553640092-waffle_js_prod_core.js:848
t.render @ 3553640092-waffle_js_prod_core.js:848
t.setVisible @ 3553640092-waffle_js_prod_core.js:946
t.Krc @ 926399698-waffle_js_prod_ritzmaestro.js:127
t.oea @ 3553640092-waffle_js_prod_core.js:376
t.dispatchEvent @ 3553640092-waffle_js_prod_core.js:374
D @ 926399698-waffle_js_prod_ritzmaestro.js:49
t.Ava @ 3553640092-waffle_js_prod_core.js:1075
JBb @ 3553640092-waffle_js_prod_core.js:1891
t.rDb @ 3553640092-waffle_js_prod_core.js:1891
t.hDb @ 3553640092-waffle_js_prod_core.js:1883
bBb @ 3553640092-waffle_js_prod_core.js:1867
t.gDb @ 3553640092-waffle_js_prod_core.js:1862
Fsb @ 3553640092-waffle_js_prod_core.js:1668
av.mq @ 3553640092-waffle_js_prod_core.js:1667
t.aec @ 3553640092-waffle_js_prod_core.js:1861
t.oea @ 3553640092-waffle_js_prod_core.js:376
t.dispatchEvent @ 3553640092-waffle_js_prod_core.js:374
JHa @ 3553640092-waffle_js_prod_core.js:450
t.Evb @ 3553640092-waffle_js_prod_core.js:449
b @ 3553640092-waffle_js_prod_core.js:437
t.q5b @ 3553640092-waffle_js_prod_core.js:449
XMLHttpRequest.send (async)
t.send @ 3553640092-waffle_js_prod_core.js:447
WAb @ 3553640092-waffle_js_prod_core.js:1861
XAb @ 3553640092-waffle_js_prod_core.js:1860
t.mDb @ 3553640092-waffle_js_prod_core.js:1880
(anonymous) @ 3553640092-waffle_js_prod_core.js:1859
b @ 3553640092-waffle_js_prod_core.js:437
setTimeout (async)
c.<computed> @ 3553640092-waffle_js_prod_core.js:438
OAb @ 3553640092-waffle_js_prod_core.js:1859
ABb @ 3553640092-waffle_js_prod_core.js:1879
t.nMa @ 3553640092-waffle_js_prod_core.js:1885
t.gDb @ 3553640092-waffle_js_prod_core.js:1863
t.aec @ 3553640092-waffle_js_prod_core.js:1861
t.oea @ 3553640092-waffle_js_prod_core.js:376
t.dispatchEvent @ 3553640092-waffle_js_prod_core.js:374
JHa @ 3553640092-waffle_js_prod_core.js:450
t.Evb @ 3553640092-waffle_js_prod_core.js:449
b @ 3553640092-waffle_js_prod_core.js:437
t.q5b @ 3553640092-waffle_js_prod_core.js:449
926399698-waffle_js_prod_ritzmaestro.js:93 Unrecognized feature: 'ambient-light-sensor'.
pPn.Ea @ 926399698-waffle_js_prod_ritzmaestro.js:93
t.wV @ 3553640092-waffle_js_prod_core.js:848
t.render @ 3553640092-waffle_js_prod_core.js:848
qPn.Ea @ 926399698-waffle_js_prod_ritzmaestro.js:95
t.wV @ 3553640092-waffle_js_prod_core.js:848
t.render @ 3553640092-waffle_js_prod_core.js:848
t.setVisible @ 3553640092-waffle_js_prod_core.js:946
t.Krc @ 926399698-waffle_js_prod_ritzmaestro.js:127
t.oea @ 3553640092-waffle_js_prod_core.js:376
t.dispatchEvent @ 3553640092-waffle_js_prod_core.js:374
D @ 926399698-waffle_js_prod_ritzmaestro.js:49
t.Ava @ 3553640092-waffle_js_prod_core.js:1075
JBb @ 3553640092-waffle_js_prod_core.js:1891
t.rDb @ 3553640092-waffle_js_prod_core.js:1891
t.hDb @ 3553640092-waffle_js_prod_core.js:1883
bBb @ 3553640092-waffle_js_prod_core.js:1867
t.gDb @ 3553640092-waffle_js_prod_core.js:1862
Fsb @ 3553640092-waffle_js_prod_core.js:1668
av.mq @ 3553640092-waffle_js_prod_core.js:1667
t.aec @ 3553640092-waffle_js_prod_core.js:1861
t.oea @ 3553640092-waffle_js_prod_core.js:376
t.dispatchEvent @ 3553640092-waffle_js_prod_core.js:374
JHa @ 3553640092-waffle_js_prod_core.js:450
t.Evb @ 3553640092-waffle_js_prod_core.js:449
b @ 3553640092-waffle_js_prod_core.js:437
t.q5b @ 3553640092-waffle_js_prod_core.js:449
XMLHttpRequest.send (async)
t.send @ 3553640092-waffle_js_prod_core.js:447
WAb @ 3553640092-waffle_js_prod_core.js:1861
XAb @ 3553640092-waffle_js_prod_core.js:1860
t.mDb @ 3553640092-waffle_js_prod_core.js:1880
(anonymous) @ 3553640092-waffle_js_prod_core.js:1859
b @ 3553640092-waffle_js_prod_core.js:437
setTimeout (async)
c.<computed> @ 3553640092-waffle_js_prod_core.js:438
OAb @ 3553640092-waffle_js_prod_core.js:1859
ABb @ 3553640092-waffle_js_prod_core.js:1879
t.nMa @ 3553640092-waffle_js_prod_core.js:1885
t.gDb @ 3553640092-waffle_js_prod_core.js:1863
t.aec @ 3553640092-waffle_js_prod_core.js:1861
t.oea @ 3553640092-waffle_js_prod_core.js:376
t.dispatchEvent @ 3553640092-waffle_js_prod_core.js:374
JHa @ 3553640092-waffle_js_prod_core.js:450
t.Evb @ 3553640092-waffle_js_prod_core.js:449
b @ 3553640092-waffle_js_prod_core.js:437
t.q5b @ 3553640092-waffle_js_prod_core.js:449
926399698-waffle_js_prod_ritzmaestro.js:93 Unrecognized feature: 'speaker'.
pPn.Ea @ 926399698-waffle_js_prod_ritzmaestro.js:93
t.wV @ 3553640092-waffle_js_prod_core.js:848
t.render @ 3553640092-waffle_js_prod_core.js:848
qPn.Ea @ 926399698-waffle_js_prod_ritzmaestro.js:95
t.wV @ 3553640092-waffle_js_prod_core.js:848
t.render @ 3553640092-waffle_js_prod_core.js:848
t.setVisible @ 3553640092-waffle_js_prod_core.js:946
t.Krc @ 926399698-waffle_js_prod_ritzmaestro.js:127
t.oea @ 3553640092-waffle_js_prod_core.js:376
t.dispatchEvent @ 3553640092-waffle_js_prod_core.js:374
D @ 926399698-waffle_js_prod_ritzmaestro.js:49
t.Ava @ 3553640092-waffle_js_prod_core.js:1075
JBb @ 3553640092-waffle_js_prod_core.js:1891
t.rDb @ 3553640092-waffle_js_prod_core.js:1891
t.hDb @ 3553640092-waffle_js_prod_core.js:1883
bBb @ 3553640092-waffle_js_prod_core.js:1867
t.gDb @ 3553640092-waffle_js_prod_core.js:1862
Fsb @ 3553640092-waffle_js_prod_core.js:1668
av.mq @ 3553640092-waffle_js_prod_core.js:1667
t.aec @ 3553640092-waffle_js_prod_core.js:1861
t.oea @ 3553640092-waffle_js_prod_core.js:376
t.dispatchEvent @ 3553640092-waffle_js_prod_core.js:374
JHa @ 3553640092-waffle_js_prod_core.js:450
t.Evb @ 3553640092-waffle_js_prod_core.js:449
b @ 3553640092-waffle_js_prod_core.js:437
t.q5b @ 3553640092-waffle_js_prod_core.js:449
XMLHttpRequest.send (async)
t.send @ 3553640092-waffle_js_prod_core.js:447
WAb @ 3553640092-waffle_js_prod_core.js:1861
XAb @ 3553640092-waffle_js_prod_core.js:1860
t.mDb @ 3553640092-waffle_js_prod_core.js:1880
(anonymous) @ 3553640092-waffle_js_prod_core.js:1859
b @ 3553640092-waffle_js_prod_core.js:437
setTimeout (async)
c.<computed> @ 3553640092-waffle_js_prod_core.js:438
OAb @ 3553640092-waffle_js_prod_core.js:1859
ABb @ 3553640092-waffle_js_prod_core.js:1879
t.nMa @ 3553640092-waffle_js_prod_core.js:1885
t.gDb @ 3553640092-waffle_js_prod_core.js:1863
t.aec @ 3553640092-waffle_js_prod_core.js:1861
t.oea @ 3553640092-waffle_js_prod_core.js:376
t.dispatchEvent @ 3553640092-waffle_js_prod_core.js:374
JHa @ 3553640092-waffle_js_prod_core.js:450
t.Evb @ 3553640092-waffle_js_prod_core.js:449
b @ 3553640092-waffle_js_prod_core.js:437
t.q5b @ 3553640092-waffle_js_prod_core.js:449
926399698-waffle_js_prod_ritzmaestro.js:93 Unrecognized feature: 'speaker'.
pPn.Ea @ 926399698-waffle_js_prod_ritzmaestro.js:93
t.wV @ 3553640092-waffle_js_prod_core.js:848
t.render @ 3553640092-waffle_js_prod_core.js:848
qPn.Ea @ 926399698-waffle_js_prod_ritzmaestro.js:95
t.wV @ 3553640092-waffle_js_prod_core.js:848
t.render @ 3553640092-waffle_js_prod_core.js:848
t.setVisible @ 3553640092-waffle_js_prod_core.js:946
t.Krc @ 926399698-waffle_js_prod_ritzmaestro.js:127
t.oea @ 3553640092-waffle_js_prod_core.js:376
t.dispatchEvent @ 3553640092-waffle_js_prod_core.js:374
D @ 926399698-waffle_js_prod_ritzmaestro.js:49
t.Ava @ 3553640092-waffle_js_prod_core.js:1075
JBb @ 3553640092-waffle_js_prod_core.js:1891
t.rDb @ 3553640092-waffle_js_prod_core.js:1891
t.hDb @ 3553640092-waffle_js_prod_core.js:1883
bBb @ 3553640092-waffle_js_prod_core.js:1867
t.gDb @ 3553640092-waffle_js_prod_core.js:1862
Fsb @ 3553640092-waffle_js_prod_core.js:1668
av.mq @ 3553640092-waffle_js_prod_core.js:1667
t.aec @ 3553640092-waffle_js_prod_core.js:1861
t.oea @ 3553640092-waffle_js_prod_core.js:376
t.dispatchEvent @ 3553640092-waffle_js_prod_core.js:374
JHa @ 3553640092-waffle_js_prod_core.js:450
t.Evb @ 3553640092-waffle_js_prod_core.js:449
b @ 3553640092-waffle_js_prod_core.js:437
t.q5b @ 3553640092-waffle_js_prod_core.js:449
XMLHttpRequest.send (async)
t.send @ 3553640092-waffle_js_prod_core.js:447
WAb @ 3553640092-waffle_js_prod_core.js:1861
XAb @ 3553640092-waffle_js_prod_core.js:1860
t.mDb @ 3553640092-waffle_js_prod_core.js:1880
(anonymous) @ 3553640092-waffle_js_prod_core.js:1859
b @ 3553640092-waffle_js_prod_core.js:437
setTimeout (async)
c.<computed> @ 3553640092-waffle_js_prod_core.js:438
OAb @ 3553640092-waffle_js_prod_core.js:1859
ABb @ 3553640092-waffle_js_prod_core.js:1879
t.nMa @ 3553640092-waffle_js_prod_core.js:1885
t.gDb @ 3553640092-waffle_js_prod_core.js:1863
t.aec @ 3553640092-waffle_js_prod_core.js:1861
t.oea @ 3553640092-waffle_js_prod_core.js:376
t.dispatchEvent @ 3553640092-waffle_js_prod_core.js:374
JHa @ 3553640092-waffle_js_prod_core.js:450
t.Evb @ 3553640092-waffle_js_prod_core.js:449
b @ 3553640092-waffle_js_prod_core.js:437
t.q5b @ 3553640092-waffle_js_prod_core.js:449
926399698-waffle_js_prod_ritzmaestro.js:93 Unrecognized feature: 'vr'.
pPn.Ea @ 926399698-waffle_js_prod_ritzmaestro.js:93
t.wV @ 3553640092-waffle_js_prod_core.js:848
t.render @ 3553640092-waffle_js_prod_core.js:848
qPn.Ea @ 926399698-waffle_js_prod_ritzmaestro.js:95
t.wV @ 3553640092-waffle_js_prod_core.js:848
t.render @ 3553640092-waffle_js_prod_core.js:848
t.setVisible @ 3553640092-waffle_js_prod_core.js:946
t.Krc @ 926399698-waffle_js_prod_ritzmaestro.js:127
t.oea @ 3553640092-waffle_js_prod_core.js:376
t.dispatchEvent @ 3553640092-waffle_js_prod_core.js:374
D @ 926399698-waffle_js_prod_ritzmaestro.js:49
t.Ava @ 3553640092-waffle_js_prod_core.js:1075
JBb @ 3553640092-waffle_js_prod_core.js:1891
t.rDb @ 3553640092-waffle_js_prod_core.js:1891
t.hDb @ 3553640092-waffle_js_prod_core.js:1883
bBb @ 3553640092-waffle_js_prod_core.js:1867
t.gDb @ 3553640092-waffle_js_prod_core.js:1862
Fsb @ 3553640092-waffle_js_prod_core.js:1668
av.mq @ 3553640092-waffle_js_prod_core.js:1667
t.aec @ 3553640092-waffle_js_prod_core.js:1861
t.oea @ 3553640092-waffle_js_prod_core.js:376
t.dispatchEvent @ 3553640092-waffle_js_prod_core.js:374
JHa @ 3553640092-waffle_js_prod_core.js:450
t.Evb @ 3553640092-waffle_js_prod_core.js:449
b @ 3553640092-waffle_js_prod_core.js:437
t.q5b @ 3553640092-waffle_js_prod_core.js:449
XMLHttpRequest.send (async)
t.send @ 3553640092-waffle_js_prod_core.js:447
WAb @ 3553640092-waffle_js_prod_core.js:1861
XAb @ 3553640092-waffle_js_prod_core.js:1860
t.mDb @ 3553640092-waffle_js_prod_core.js:1880
(anonymous) @ 3553640092-waffle_js_prod_core.js:1859
b @ 3553640092-waffle_js_prod_core.js:437
setTimeout (async)
c.<computed> @ 3553640092-waffle_js_prod_core.js:438
OAb @ 3553640092-waffle_js_prod_core.js:1859
ABb @ 3553640092-waffle_js_prod_core.js:1879
t.nMa @ 3553640092-waffle_js_prod_core.js:1885
t.gDb @ 3553640092-waffle_js_prod_core.js:1863
t.aec @ 3553640092-waffle_js_prod_core.js:1861
t.oea @ 3553640092-waffle_js_prod_core.js:376
t.dispatchEvent @ 3553640092-waffle_js_prod_core.js:374
JHa @ 3553640092-waffle_js_prod_core.js:450
t.Evb @ 3553640092-waffle_js_prod_core.js:449
b @ 3553640092-waffle_js_prod_core.js:437
t.q5b @ 3553640092-waffle_js_prod_core.js:449
926399698-waffle_js_prod_ritzmaestro.js:93 Unrecognized feature: 'vr'.
pPn.Ea @ 926399698-waffle_js_prod_ritzmaestro.js:93
t.wV @ 3553640092-waffle_js_prod_core.js:848
t.render @ 3553640092-waffle_js_prod_core.js:848
qPn.Ea @ 926399698-waffle_js_prod_ritzmaestro.js:95
t.wV @ 3553640092-waffle_js_prod_core.js:848
t.render @ 3553640092-waffle_js_prod_core.js:848
t.setVisible @ 3553640092-waffle_js_prod_core.js:946
t.Krc @ 926399698-waffle_js_prod_ritzmaestro.js:127
t.oea @ 3553640092-waffle_js_prod_core.js:376
t.dispatchEvent @ 3553640092-waffle_js_prod_core.js:374
D @ 926399698-waffle_js_prod_ritzmaestro.js:49
t.Ava @ 3553640092-waffle_js_prod_core.js:1075
JBb @ 3553640092-waffle_js_prod_core.js:1891
t.rDb @ 3553640092-waffle_js_prod_core.js:1891
t.hDb @ 3553640092-waffle_js_prod_core.js:1883
bBb @ 3553640092-waffle_js_prod_core.js:1867
t.gDb @ 3553640092-waffle_js_prod_core.js:1862
Fsb @ 3553640092-waffle_js_prod_core.js:1668
av.mq @ 3553640092-waffle_js_prod_core.js:1667
t.aec @ 3553640092-waffle_js_prod_core.js:1861
t.oea @ 3553640092-waffle_js_prod_core.js:376
t.dispatchEvent @ 3553640092-waffle_js_prod_core.js:374
JHa @ 3553640092-waffle_js_prod_core.js:450
t.Evb @ 3553640092-waffle_js_prod_core.js:449
b @ 3553640092-waffle_js_prod_core.js:437
t.q5b @ 3553640092-waffle_js_prod_core.js:449
XMLHttpRequest.send (async)
t.send @ 3553640092-waffle_js_prod_core.js:447
WAb @ 3553640092-waffle_js_prod_core.js:1861
XAb @ 3553640092-waffle_js_prod_core.js:1860
t.mDb @ 3553640092-waffle_js_prod_core.js:1880
(anonymous) @ 3553640092-waffle_js_prod_core.js:1859
b @ 3553640092-waffle_js_prod_core.js:437
setTimeout (async)
c.<computed> @ 3553640092-waffle_js_prod_core.js:438
OAb @ 3553640092-waffle_js_prod_core.js:1859
ABb @ 3553640092-waffle_js_prod_core.js:1879
t.nMa @ 3553640092-waffle_js_prod_core.js:1885
t.gDb @ 3553640092-waffle_js_prod_core.js:1863
t.aec @ 3553640092-waffle_js_prod_core.js:1861
t.oea @ 3553640092-waffle_js_prod_core.js:376
t.dispatchEvent @ 3553640092-waffle_js_prod_core.js:374
JHa @ 3553640092-waffle_js_prod_core.js:450
t.Evb @ 3553640092-waffle_js_prod_core.js:449
b @ 3553640092-waffle_js_prod_core.js:437
t.q5b @ 3553640092-waffle_js_prod_core.js:449
iframedAppPanel:9 Unrecognized feature: 'vibrate'.
iframedAppPanel:9 Unrecognized feature: 'vibrate'.
userCodeAppPanel:1 Unrecognized feature: 'ambient-light-sensor'.
userCodeAppPanel:1 Unrecognized feature: 'speaker'.
userCodeAppPanel:1 Unrecognized feature: 'vibrate'.
userCodeAppPanel:1 Unrecognized feature: 'vr'.
1907817732-warden_bin_i18n_warden.js:217 Dp {message: 'There was an error during the transport or process…this request. Error code = 10, Path = /wardeninit', name: 'TransportError', stack: 'TransportError: There was an error during the tran…/js/1907817732-warden_bin_i18n_warden.js:206:361)'}
1907817732-warden_bin_i18n_warden.js:104 Net state changed from IDLE to BUSY
1907817732-warden_bin_i18n_warden.js:104 Net state changed from BUSY to IDLE
rpc.js:486 Unknown RPC service: picker
cb=gapi.loaded_0:735 Uncaught TypeError: this.Rb is not a function
    at _.g.e_ (cb=gapi.loaded_0:735:393)
    at d (cb=gapi.loaded_0:212:143)
    at b (cb=gapi.loaded_0:207:1)
_.g.e_ @ cb=gapi.loaded_0:735
d @ cb=gapi.loaded_0:212
b @ cb=gapi.loaded_0:207
cb=gapi.loaded_0:735 Uncaught TypeError: this.Rb is not a function
    at _.g.e_ (cb=gapi.loaded_0:735:393)
    at d (cb=gapi.loaded_0:212:143)
    at b (cb=gapi.loaded_0:207:1)
_.g.e_ @ cb=gapi.loaded_0:735
d @ cb=gapi.loaded_0:212
b @ cb=gapi.loaded_0:207
Rubén
  • 34,714
  • 9
  • 70
  • 166
WCrawford
  • 1
  • 1

0 Answers0