Using the API C...

Overview

Learning Modules

API Console Layout

## Using the API Console

### Overview
There are multiple ways to access data in both **<linkify text="Excel"></linkify>**
& **<linkify text="Googlesheets"></linkify>** using the API Console & Query Builder. 

> **Note**: some methods may be limited by your **<linkify text="subscription"></linkify>** or application (ie Excel vs Google Sheets). 

<iframe
  style={{ maxWidth: "570px" }}
  width="570"
  height="350"
  src="https://www.youtube.com/embed/TkpHl9w2gbY"
  frameborder="0"
  allow="accelerometer; autoplay; encrypted-media; gyroscope; picture-in-picture"
  allowfullscreen
></iframe>


### Learning Modules

Click the image below to [watch short tutorials & individual learning modules](https://www.youtube.com/playlist?list=PLBg8GR5ao-azkVyW-optnK7tILh9vecrn) for each part of the API Console & Query Builder including:

1. Console
2. Scenarios
3. Query Builder
4. Global Parameters
5. Endpoint Parameters
6. Output Inspector
7. [Explorer (NEW - UniConsole only)](https://apps.cryptosheets.com/#/uni)

> 👉 [**Click here to see the help center beginner tutorial**](https://intercom.help/cryptosheets/en/articles/3870035-beginner-tutorial)


[![IMG](https://paradigmas.blob.core.windows.net/paradigmas-content/sharex/cryptosheets-docs_console_using-the-console-youtube-tutorials.png)](https://www.youtube.com/playlist?list=PLBg8GR5ao-azkVyW-optnK7tILh9vecrn)


### API Console Layout

The regular API console is broken out into 6 major parts:

1. **[Make Request](https://www.youtube.com/playlist?list=PLBg8GR5ao-azkVyW-optnK7tILh9vecrn)**
2. **[Scenario Search Bar](https://intercom.help/cryptosheets/en/articles/4571225-how-to-use-cryptosheets-scenarios)**
3. **[Query Builder (Request & function builder)](https://www.youtube.com/playlist?list=PLBg8GR5ao-azkVyW-optnK7tILh9vecrn)**
4. **[Global Parameters](https://docs.cryptosheets.com/functions/common)**
5. **[Endpoint Parameters](https://www.youtube.com/playlist?list=PLBg8GR5ao-azkVyW-optnK7tILh9vecrn)**
6. **[Output Inspector](https://www.youtube.com/playlist?list=PLBg8GR5ao-azkVyW-optnK7tILh9vecrn)**

​
![](https://res.cloudinary.com/cryptosheets/image/upload/v1611929157/cryptosheets-docs/console/console-v2-diagram.png)



Learn how to use the various features and modules of the API console & function builder