Coinmarketcap是否阻止了Google的请求？
Coinmarketcap是否阻止了Google的请求？
提问于 2021-12-11 11:03:32
我已经使用了几个月的脚本突然停止工作，因为当我试图从Google脚本访问Coinmarketcap时，我得到了一个403。我的API键没有什么问题，因为我在本地机器的Python脚本中尝试了相同的请求，这是可行的。
这是我的Google脚本：
function coin_price() {
const myGoogleSheetName =
SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Tokens')
// Call CoinMarketCap and let them know who you are.
const coinMarketCapAPICall = {
method: 'GET',
uri: 'https://pro-api.coinmarketcap.com/v1/cryptocurrency/listings/latest',
qs: {
start: '1',
limit: '5000',
convert: 'USD',
},
headers: { 'X-CMC_PRO_API_KEY': '##########' },
json: true,
gzip: true,
muteHttpExceptions: true
}
// Put the coin symbols that you want to follow here.
const myCoinSymbols = ['BTC', 'ETH']
// Let's itereate
for (let i = 0; i < myCoinSymbols.length; i++) {
const coinSymbol = myCoinSymbols[i]
console.log(coinSymbol)
const coinMarketCapUrl = `https://pro-api.coinmarketcap.com/v1/cryptocurrency/quotes/latest?symbol=${coinSymbol}`
const result = UrlFetchApp.fetch(coinMarketCapUrl, coinMarketCapAPICall)
const txt = result.getContentText()
console.warn(txt)
const d = JSON.parse(txt)
const row = i + 2
// Puts a column of at symbols into the sheet at A2.
myGoogleSheetName.getRange(row, 1).setValue(coinSymbol)
// Puts a column of current market price's in dollars into the sheet at B3.
myGoogleSheetName
.getRange(row, 2)
.setValue(d.data[coinSymbol].quote.USD.price)
}
}这是我得到的错误：
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<HTML><HEAD><META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<TITLE>ERROR: The request could not be satisfied</TITLE>
</HEAD><BODY>
<H1>403 ERROR</H1>
<H2>The request could not be satisfied.</H2>
<HR noshade size="1px">
Request blocked.
We can't connect to the server for this app or website at this time. There might be too much traffic or a configuration error. Try again later, or contact the app or website owner.
<BR clear="all">
If you provide content to customers through CloudFront, you can find steps to troubleshoot and help prevent this error by reviewing the CloudFront documentation.
<BR clear="all">
<HR noshade size="1px">
<PRE>
Generated by cloudfront (CloudFront)
Request ID: ##########
</PRE>
<ADDRESS>
</ADDRESS>
</BODY></HTML>Coinmarketcap阻止了Google吗？
回答 1
Stack Overflow用户
发布于 2021-12-13 08:53:39
这是UrlFetchApp的一个常见问题，因为所有请求都来自同一个IP池。
有时候，您可以通过使用指数退避和二项式概率论来解决这个问题(也可以尝试很多次直到它起作用)。
我设法用这种方式使用Binance (完整的github回购here)，但想法是这样的：
function exponentialBackoff(url, params) {
for (let count = 0; count < 50; count++) { // choose your amount
try {
Utilities.sleep((count * count) + (Math.random() * 1000))
const response = UrlFetchApp.fetch(`${endpoint}${query}`, params)
}
catch(e) {
console.info(e)
continue
}
if (response.getResponseCode() === 200) {
return response
}
}
}页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/70314581
复制相关文章
相似问题
腾讯云开发者
Copyright © 2013 - 2026 Tencent Cloud. All Rights Reserved. 腾讯云 版权所有
深圳市腾讯计算机系统有限公司 ICP备案/许可证号：粤B2-20090059 
粤公网安备44030502008569号
腾讯云计算（北京）有限责任公司 京ICP证150476号 | 京ICP备11018762号