blocks|key|90042|text|如果您的项目在2018年3月30日之前使用了url缩短服务|type|unstyled|depth|inlineStyleRanges|entityRanges|data|90043|而不是|90044|www.google.com|code-block|syntax|javascript|90045|使用|90046|https://www.google.com|90047|参考：https://developers.google.com/url-shortener/v1/url/insert|offset|length|90048|但如果您的项目是在2018年3月30日或之后创建的|90049|来自https://developers.google.com/url-shortener/v1/|90050|90051|从2018年3月30日开始，我们将拒绝支持goo.gl+URL+shortener。有关详细的时间表和替代方案，请参阅此blog+post。|blockquote|90052|90053|90054|为了清楚起见，请注意，在链接的博客帖子中：|90055|面向开发人员的|90056|+|90057|90058|从2018年5月30日开始，只有在今天之前访问过URL+Shortener+API的项目才能创建短链接。|90059|entityMap|0|LINK|mutability|MUTABLE|url|https://developers.google.com/url-shortener/v1/url/insert|1|https://developers.google.com/url-shortener/v1/|2|https://developers.googleblog.com/2018/03/transitioning-google-url-shortener.html^0|0|0|0|0|0|3|1L|0|0|0|2|1B|1|0|0|1O|9|2|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|1L|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|1M|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|1N|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|1O|8|@]|9|@]|A|$]]|$1|K|3|L|5|F|7|1P|8|@]|9|@]|A|$G|H]]|$1|M|3|N|5|6|7|1Q|8|@]|9|@$O|1R|P|1S|1|1T]]|A|$]]|$1|Q|3|R|5|6|7|1U|8|@]|9|@]|A|$]]|$1|S|3|T|5|6|7|1V|8|@]|9|@$O|1W|P|1X|1|1Y]]|A|$]]|$1|U|3|-4|5|6|7|1Z|8|@]|9|@]|A|$]]|$1|V|3|W|5|X|7|20|8|@]|9|@$O|21|P|22|1|23]]|A|$]]|$1|Y|3|-4|5|6|7|24|8|@]|9|@]|A|$]]|$1|Z|3|-4|5|6|7|25|8|@]|9|@]|A|$]]|$1|10|3|11|5|6|7|26|8|@]|9|@]|A|$]]|$1|12|3|13|5|6|7|27|8|@]|9|@]|A|$]]|$1|14|3|15|5|X|7|28|8|@]|9|@]|A|$]]|$1|16|3|-4|5|6|7|29|8|@]|9|@]|A|$]]|$1|17|3|18|5|6|7|2A|8|@]|9|@]|A|$]]|$1|19|3|-4|5|6|7|2B|8|@]|9|@]|A|$]]]|1A|$1B|$5|1C|1D|1E|A|$1F|1G]]|1H|$5|1C|1D|1E|A|$1F|1I]]|1J|$5|1C|1D|1E|A|$1F|1K]]]]

<p>If the url shortener service was used in your project before March 30,2018</p>

<p>Instead of </p>

<pre><code>www.google.com
</code></pre>

<p>use</p>

<pre><code>https://www.google.com
</code></pre>

<p>Reference: <a href="https://developers.google.com/url-shortener/v1/url/insert" rel="nofollow noreferrer">https://developers.google.com/url-shortener/v1/url/insert</a></p>

<p>but if your project was created on or after March 30, 2018 </p>

<p>From <a href="https://developers.google.com/url-shortener/v1/" rel="nofollow noreferrer">https://developers.google.com/url-shortener/v1/</a></p>

<blockquote>
  <p>Starting March 30, 2018, we will be turning down support for goo.gl URL shortener. Please see this <a href="https://developers.googleblog.com/2018/03/transitioning-google-url-shortener.html" rel="nofollow noreferrer">blog post</a> for detailed timelines and alternatives.</p>
</blockquote>

<p>Just to be clear, please note, from the linked blog post:</p>

<blockquote>
  <p><strong>For developers</strong></p>
  
  <p>Starting May 30, 2018, only projects that have accessed URL Shortener
  APIs before today can create short links.</p>
</blockquote>


blocks|key|92333|text|事实证明，就像鲁本提到的那样，Google+has+moved+away+from+their+URL+shortener。因此，经过大量的研究和测试，以下是解决方案：|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|92334|第一步|92335|将Google+Cloud+Project迁移到Firebase或创建一个新的Firebase项目。请参阅步骤here|92336|第二步|92337|创建一个虚拟项目，以便为缩写创建一个基本URL。请参阅this+youtube+video|92338|第三步|92339|获取Web+API+Key+from+your+new+Firebase+Project+(不是您刚刚创建的应用程序)|92340|第四步|92341|检查屏幕上的左侧菜单，然后导航到Grow>Dynamic+Links。您应该会看到您创建的新应用程序和应用程序顶部的URL。这将成为新的缩短URL的基础。|92342|第五步|92343|在Google+Sheets中的代码构建器中创建Google+Apps脚本中的代码。下面是为我工作的代码(我将url传入此函数)(此代码基于找到的答案here)：|92344|function+api_call(url){
++var+req='https://firebasedynamiclinks.googleapis.com/v1/shortLinks?key=[YOUR+PROJECT+WEB+API+KEY+FROM+STEP+3]';
++var+formData+=+{
++++"longDynamicLink":+"[YOUR+APPLICATION+URL+BASE+FROM+STEP+4]?link="+%2B+url,
++++"suffix"+:+{
++++++"option"+:+"UNGUESSABLE"+
++++}
++};
++var+options+=+{
++++'method':+'post',
++++'contentType':+'application/json',
++++'payload':+JSON.stringify(formData)

++};

++var+response+=+UrlFetchApp.fetch(req,+options);
++var+res=JSON.parse(response);

++return+res.shortLink;
}|code-block|syntax|javascript|92345|更多信息|92346|92347|Documentation+on+Creating+Dynamic+Links+in+Firebase|ordered-list-item|92348|Documentation+on+using+UrlFetchApp()+in+Google+Apps+Script|92349|92350|entityMap|0|LINK|mutability|MUTABLE|url|https://developers.googleblog.com/2018/03/transitioning-google-url-shortener.html|1|https://firebase.google.com/support/guides/url-shortener|2|https://www.youtube.com/watch?v=YBGKT6W4vyg|3|https://firebase.google.com/docs/dynamic-links/rest?authuser=0|4|https://webapps.stackexchange.com/questions/76050/google-sheets-function-to-get-a-shortened-url-from-bit-ly-or-goo-gl-etc|5|6|https://developers.google.com/apps-script/reference/url-fetch/url-fetch-app^0|F|1A|0|0|0|1J|4|1|0|0|R|I|2|0|0|2|16|3|0|0|0|0|23|4|4|0|0|0|0|0|1F|5|0|0|1M|6|0|0^^$0|@$1|2|3|4|5|6|7|1U|8|@]|9|@$A|1V|B|1W|1|1X]]|C|$]]|$1|D|3|E|5|6|7|1Y|8|@]|9|@]|C|$]]|$1|F|3|G|5|6|7|1Z|8|@]|9|@$A|20|B|21|1|22]]|C|$]]|$1|H|3|I|5|6|7|23|8|@]|9|@]|C|$]]|$1|J|3|K|5|6|7|24|8|@]|9|@$A|25|B|26|1|27]]|C|$]]|$1|L|3|M|5|6|7|28|8|@]|9|@]|C|$]]|$1|N|3|O|5|6|7|29|8|@]|9|@$A|2A|B|2B|1|2C]]|C|$]]|$1|P|3|Q|5|6|7|2D|8|@]|9|@]|C|$]]|$1|R|3|S|5|6|7|2E|8|@]|9|@]|C|$]]|$1|T|3|U|5|6|7|2F|8|@]|9|@]|C|$]]|$1|V|3|W|5|6|7|2G|8|@]|9|@$A|2H|B|2I|1|2J]]|C|$]]|$1|X|3|Y|5|Z|7|2K|8|@]|9|@]|C|$10|11]]|$1|12|3|13|5|6|7|2L|8|@]|9|@]|C|$]]|$1|14|3|-4|5|6|7|2M|8|@]|9|@]|C|$]]|$1|15|3|16|5|17|7|2N|8|@]|9|@$A|2O|B|2P|1|2Q]]|C|$]]|$1|18|3|19|5|17|7|2R|8|@]|9|@$A|2S|B|2T|1|2U]]|C|$]]|$1|1A|3|-4|5|6|7|2V|8|@]|9|@]|C|$]]|$1|1B|3|-4|5|6|7|2W|8|@]|9|@]|C|$]]]|1C|$1D|$5|1E|1F|1G|C|$1H|1I]]|1J|$5|1E|1F|1G|C|$1H|1K]]|1L|$5|1E|1F|1G|C|$1H|1M]]|1N|$5|1E|1F|1G|C|$1H|1O]]|1P|$5|1E|1F|1G|C|$1H|1Q]]|1R|$5|1E|1F|1G|C|$1H|1O]]|1S|$5|1E|1F|1G|C|$1H|1T]]]]

<p>As it turns out, like Ruben mentioned, <a href="https://developers.googleblog.com/2018/03/transitioning-google-url-shortener.html" rel="nofollow noreferrer">Google has moved away from their URL shortener</a>. So after much research ans testing here is the solution:</p>

<h1>Step 1</h1>

<p>Migrate Google Cloud Project over to Firebase or create a new Firebase Project. See steps <a href="https://firebase.google.com/support/guides/url-shortener" rel="nofollow noreferrer">here</a></p>

<h1>Step 2</h1>

<p>Create a dummy project in order to create a base URL for the shortening. See <a href="https://www.youtube.com/watch?v=YBGKT6W4vyg" rel="nofollow noreferrer">this youtube video</a></p>

<h1>Step 3</h1>

<p>Get the <a href="https://firebase.google.com/docs/dynamic-links/rest?authuser=0" rel="nofollow noreferrer">Web API Key from your new Firebase Project</a> (not the app you just created)</p>

<h1>Step 4</h1>

<p>Check the left side menu on the screen and navigate to Grow->Dynamic Links. You should see the new application you created and a URL at the top of the application. This will become the base of the new shortened URLs.</p>

<h1>Step 5</h1>

<p>Create the code in Google Apps Script inside the code builder from within Google Sheets. Here is the code that worked for me (I passed the url into this function) (This code is based on the answer found <a href="https://webapps.stackexchange.com/questions/76050/google-sheets-function-to-get-a-shortened-url-from-bit-ly-or-goo-gl-etc">here</a>):</p>

<pre><code>function api_call(url){
  var req='https://firebasedynamiclinks.googleapis.com/v1/shortLinks?key=[YOUR PROJECT WEB API KEY FROM STEP 3]';
  var formData = {
    "longDynamicLink": "[YOUR APPLICATION URL BASE FROM STEP 4]?link=" + url,
    "suffix" : {
      "option" : "UNGUESSABLE" 
    }
  };
  var options = {
    'method': 'post',
    'contentType': 'application/json',
    'payload': JSON.stringify(formData)

  };

  var response = UrlFetchApp.fetch(req, options);
  var res=JSON.parse(response);

  return res.shortLink;
}
</code></pre>

<h1>Additional Information</h1>

<ol>
<li><a href="https://firebase.google.com/docs/dynamic-links/rest?authuser=0" rel="nofollow noreferrer">Documentation on Creating Dynamic Links in Firebase</a></li>
<li><a href="https://developers.google.com/apps-script/reference/url-fetch/url-fetch-app" rel="nofollow noreferrer">Documentation on using UrlFetchApp() in Google Apps Script</a></li>
</ol>


blocks|key|90088|text|我可以在这里证明@alutz的答案，只需对他们的代码进行一些小的添加/更正。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|90089|如果您有多个自定义参数，请使用encodeURIcomponent()作为输入url，同时将其分配给长动态链接。|90090|"longDynamicLink":+"[YOUR+APPLICATION+URL+BASE+FROM+STEP+4]?link="+%2B+encodeURIcomponent(url),|code-block|syntax|javascript|90091|这使我可以为我的电报机器人传递多个参数，如chat_id、text和parse_mode。|90092|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|N|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|O|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|P|8|@]|9|@]|A|$]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

<p>I can attest to @alutz's answer here with a small addition/correction to their code.</p>
<p>Use encodeURIcomponent() for the input url while assigning it to the Long Dynamic Link in case you have more than one custom parameters.</p>
<pre><code>&quot;longDynamicLink&quot;: &quot;[YOUR APPLICATION URL BASE FROM STEP 4]?link=&quot; + encodeURIcomponent(url),
</code></pre>
<p>This allowed me to pass in multiple arguments for my telegram bot like chat_id, text and parse_mode.</p>


<p>I am trying to create a small application in in Google Sheets to sorten URLs on my personal google account. I am using the following code which I found here: <a href="https://webapps.stackexchange.com/questions/76050/google-sheets-function-to-get-a-shortened-url-from-bit-ly-or-goo-gl-etc">Google Sheets Function to get a shortened URL (from Bit.ly or goo.gl etc.)</a></p>
<pre><code>function onOpen() {
  SpreadsheetApp.getUi()
    .createMenu(&quot;Shorten&quot;)
    .addItem(&quot;Go !!&quot;,&quot;rangeShort&quot;)
    .addToUi()  
}

function rangeShort() {
  var range = SpreadsheetApp.getActiveRange(), data = range.getValues();
  var output = [];
  for(var i = 0, iLen = data.length; i &lt; iLen; i++) {
    //var url = UrlShortener.Url.insert({longUrl: data[i][0]});
    var url = UrlShortener.Url.insert({longUrl: 'www.google.com'});
    output.push([url.id]);
  }
  range.offset(0,1).setValues(output);
}
</code></pre>
<p>I created a new Google Cloud Project and enabled the URL shortener API in the project and on the Google sheet. The problem is that when I try and run the code I get an err on the line: <code>var url = UrlShortener.Url.insert({longUrl: 'www.google.com'});</code></p>
<blockquote>
<p>error 403, message:forbidden</p>
</blockquote>
<p>when i try an execute the rangeShort() function. I have no idea how to fix this. Any ideas would be most appreciated! Thanks!</p>


Google Sheets Advanced Google Services URL Shortener 403 Error: Forbidden

JSON

我正在尝试在Google Sheets中创建一个小应用程序来排序我个人google帐户上的URL。我使用了以下代码，它是我在这里找到的：function onOpen() {  SpreadsheetApp.getUi()    .createMenu("Shorten")    .addItem("Go !!","r...

问Google Sheets高级Google Services URL Shortener 403错误:已禁用
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问Google Sheets高级Google Services URL Shortener 403错误:已禁用EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问Google Sheets高级Google Services URL Shortener 403错误:已禁用
EN