Business
Jobs
  • About Us
  • Solutions
    • Job Postings
      Post your job and receive qualified candidates in 48h.
    • Candidate Assessments
      500+ technical and psychological tests, plus anti-fraud.
    • Headhunting
      Tailor-made executive search from start to finish.
    • Payroll + EOR
      Payroll dispersal and EOR across 15+ LATAM countries.
  • Pricing
  • Jobs

0

406
Views
Request failed for https://api.coingecko.com returned code 429. Truncated server response: error code: 1015

I'm working with getting crypto pricing on my google sheet but I keep getting an error message. I've looked around and haven't really come across anything for CoinGecko. Below is the error message. "Exception: Request failed for https://api.coingecko.com returned code 429. Truncated server response: error code: 1015 (use muteHttpExceptions option to examine full response) (line 843).".

Here is the code starting line 843 to 865

var res = await UrlFetchApp.fetch(url);
var content = res.getContentText();
var parsedJSON = JSON.parse(content);

var data=[]
if (type=="price"){
  for (var i = parsedJSON['prices'].length - 1; i >= 0; i--) {
    data.push([toDateNum(parsedJSON['prices'][i][0]),parsedJSON['prices'][i][1]]);
    };}
else if (type=="volume")
{ for (var i = parsedJSON['total_volumes'].length - 1; i >= 0; i--) {
    data.push([toDateNum(parsedJSON['total_volumes'][i][0]),parsedJSON['total_volumes'][i][1]]);
    };}
else if (type=="marketcap")
{ for (var i = parsedJSON['market_caps'].length - 1; i >= 0; i--) {
    data.push([toDateNum(parsedJSON['market_caps'][i][0]),parsedJSON['market_caps'][i][1]]);
    };}
else 
{ data="Error";}

if (data!="Error")
  cache.put(id_cache, JSON.stringify(data),expirationInSeconds);
return data;

Any insight would be great. Here's the link to the GS to see entire code in apps script.https://docs.google.com/spreadsheets/d/1Jtfcw7qLWbMcHfSWfJcExBVo3DRI1iP74wPBdPeybWA/edit#gid=388229362

about 4 years ago · Juan Pablo Isaza
1 answers
Answer question

0

When you have the spreadsheed and need to past number 1 line they told you, change the number from 250 to 251. IT WILL WORK

From =ImportJSON("https://api.coingecko.com/api/v3/coins/markets?vs_currency=usd&order=market_cap_desc&per_page=250&page=1&sparkline=false","/name,/current_price,/market_cap,/price_change,/total_volume,/high_24h,/low_24h","noTruncate",doNotDelete!$A$1)

To =ImportJSON("https://api.coingecko.com/api/v3/coins/markets?vs_currency=usd&order=market_cap_desc&per_page=251&page=1&sparkline=false","/name,/current_price,/market_cap,/price_change,/total_volume,/high_24h,/low_24h","noTruncate",doNotDelete!$A$1)

about 4 years ago · Juan Pablo Isaza Report
Answer question
Find remote jobs

Discover the new way to find a job!

Top jobs
Top job categories
Business
Post vacancy Pricing Sales
Legal
Terms and conditions Privacy policy
© 2026 PeakU Inc. All Rights Reserved.
Andres GPT
Show me some job opportunities
There's an error!