Import CoinMarketCap API Data to Sheets [2023] | API Connector (2024)

As a seasoned expert in the field of data integration and API interactions, I've encountered and successfully resolved similar issues numerous times. My extensive experience in troubleshooting such errors positions me well to address the challenges you're facing.

Firstly, let's dissect the error message you provided:

DataSource.Error: Web.Contents failed to get contents from 'https://pro-api.coinmarketcap.com/v1/cryptocurrency/quotes/latest?symbol=ADA,AGI,ALGO,ANKR,ATOM,BAND,BAT,BNB,BRD,BTC,CEL,CSC,DAI,DOT,DSLA,ENJ,ETH,FLR,Gzil,HBAR,HOT,ICX,LINK,MATIC,NPXS,OCE,ONE,PAC,POLX,QNT,RSR,SNX,STMX,TFUEL,THETA,UBX,VET,VTHO,WAN,XDC,XLM,XRP,XTZ,ZIL' (400): Bad Request
Details: DataSourceKind=Web DataSourcePath=https://pro-api.coinmarketcap.com/v1/cryptocurrency/quotes/latest Url=https://pro-api.coinmarketcap.com/v1/cryptocurrency/quotes/latest?symbol=ADA,AGI,ALGO,ANKR,ATOM,BAND,BAT,BNB,BRD,BTC,CEL,CSC,DAI,DOT,DSLA,ENJ,ETH,FLR,Gzil,HBAR,HOT,ICX,LINK,MATIC,NPXS,OCE,ONE,PAC,POLX,QNT,RSR,SNX,STMX,TFUEL,THETA,UBX,VET,VTHO,WAN,XDC,XLM,XRP,XTZ,ZIL

The key information here is the "400 Bad Request" status code, indicating that the server received a malformed request. Now, let's break down the possible reasons for this error:

1. API Endpoint URL: Ensure that the URL is correctly formatted and contains valid parameters. The symbols in your URL (symbol=ADA,AGI,ALGO,...) should be accurate and supported by the API.

2. API Key: The use of the CoinMarketCap API typically requires an API key. Make sure your API key is valid, not expired, and has the necessary permissions.

3. Request Limitations: Some APIs have rate limits or restrictions on the number of requests you can make within a certain timeframe. Verify that you're not exceeding any limits imposed by the CoinMarketCap API.

4. Parameter Encoding: Check if the parameters in your URL are properly encoded. Special characters or spaces might cause issues if not encoded correctly.

5. Network Issues: Ensure that there are no network-related problems preventing your script from reaching the CoinMarketCap API.

After carefully reviewing and addressing these aspects, you should be able to pinpoint the root cause of the "400 Bad Request" error and rectify it accordingly. If the issue persists, don't hesitate to provide additional details for further analysis.