ENDPOINTS

Function to pull all possible endpoints by provider

Use Case

When you need to quickly look up all the available endpoints for a given provider

Syntax

=CS.ENDPOINTS( [provider], [globalArgs])

Sample Usage

ENDPOINTS from Cryptocompare

Get a list of available API endpoints from CryptoCompare

Excel

=CS.ENDPOINTS("CryptoCompare",{"_limit","100";"_orderBy","name"})

Google Sheets

=CSENDPOINTS("CryptoCompare",{"_limit","100";"_orderBy","name"})

ENDPOINTS from Glassnode

Get a list of available API endpoints from Glassnode

Excel

=CS.ENDPOINTS("CryptoCompare",{"_limit","500";"_orderBy","name"})

Google Sheets

=CSENDPOINTS("CryptoCompare",{"_limit","500";"_orderBy","name"})

ENDPOINTS from providers with 'defi' in the name

Get a list of ENDPOINTS from providers with 'defi' in the name

Excel

=CS.ENDPOINTS("~defi",{"_limit","500";"_orderBy","name"})

Google Sheets

=CSENDPOINTS("~defi",{"_limit","500";"_orderBy","name"})

For a full list of global parameters, Click Here.

See Also

ENDPOINTS - Function to pull all possible endpoints by provider
EXCHANGES - Get all possible exchanges that are available for Cryptosheets core functions
PARAMETERS - Function to pull all possible parameters by provider and endpoint
PROVIDERS - Function to pull all possible providers available in Cryptosheets
SYMBOLS - Reference endpoint to pull all symbols supported by Cryptosheets core and non core functions

---

Troubleshooting

1. Check your formula syntax for carefully, different functions for the same data may have slightly different required syntax

2. Check the required arguments for your function vs the optional arguments

3. Check your data & API quotas and limits

4. Check your formulas carefully

5. Check your relative references

6. Use Excels error checking tools

7. Check Excels help sections

8. Error Response Codes Reference

   • #N/A OK – Everything worked as expected
   • #BUSY Heavy query and/or unauthorized – Your User/Password API Keys are incorrect
   • #LIMIT Forbidden – You are not subscribed to the data feed requested
   • Other Something else? Reach out to us directly

Additional Resources

For Microsoft Excel

• Web browsers used by add-ins
• Office versions and requirement sets
• How to check your Office version
• Install the latest version of Office
• Custom Function Requirements

For Googlesheets

• Throughput Quotas & Limits