=CS.QUERYA

Use Case Scenarios

QUERYA - Syntax

Function arguments

Function argume...

PARAMETERS - Ab...

QUERYA - Examples

Troubleshooting

Additional Reso...

## =CS.QUERYA

In its simplest form, the QUERYA function says
```
=CS.QUERYA(what provider, what endpoint, what parameters, what arguments)
```

![image](https://res.cloudinary.com/cryptosheets/image/upload/cryptosheets-docs/excel/functions/csQUERYA-syntax.png)

![image](https://res.cloudinary.com/cryptosheets/image/upload/cryptosheets-docs/excel/functions/csQUERYA-autocomplete.png)

![image](https://res.cloudinary.com/cryptosheets/image/upload/cryptosheets-docs/google/functions/csQUERYA-autocomplete.png)


### Use Case Scenarios
> Use =CS.QUERYA() when you need maximum flexibility across all available providers including the ability to call any of their specific endpoints or datasets. This function is a more advanced & flexible version of the original CS.QUERY custom function. QUERYA can take any combination of any parameters and/or <linkify text="Global Arguments"></linkify> and in any order as long as each input and value are paired. It also allows you to combine relative and absolute references in the same input and value pairs without having to use a nested array wrapped in {curly brackets}. This seemingly minor detail is incredibly important in the certain situations making CS.QUERYA a powerful tool to have.

---

## QUERYA - Syntax
### Function arguments
	
Arguments: `=CS.QUERYA("provider","endpoint","parameters","parameterValues","args","argValues")
`
	
Example Values: `=CS.QUERYA("Cryptunit","Earnings Auto","device","GPU")`

### Function argument descriptions

![image](https://res.cloudinary.com/cryptosheets/image/upload/cryptosheets-docs/excel/functions/csQUERYA-syntax-autocomplete.png)

![image](https://res.cloudinary.com/cryptosheets/image/upload/cryptosheets-docs/excel/functions/csQUERYA-syntax-example.gif)

- **provider**: Data provider, ex. Cryptunit. [string] required
- **endpoint**: Data endpoint of provider, ex. 'earnings-auto'. [string] required
- **parameters**: List of path and query parameters in comma separated pairs in  any order [string] optional
- **args**: Optional: <linkify text="Global Arguments"></linkify>, ex. limit, fields [any] optional

### PARAMETERS - Absolute vs. Relative
**Absolute Parameter Values**

Formulas using **absolute values** for arguments with multiple parameters using CS.QUERYA can be referenced anywhere in the formula query string as long as they are paired together:

`=CS.QUERYA("Cryptunit","Earnings Auto","device","GPU")`

**Relative Parameter Values**

Formulas using **referenced values** for arguments with multiple parameters using CS.QUERYA can be referenced anywhere and in any order within the formula query string as long as they are paired together:

`=CS.QUERYA("provider","endoint","arg","argValue","parameter","parameterValue"...)`

**Combining Relative AND Absolute Parameter Values**

One of the features about CS.QUERYA vs CS.QUERY that makes it so flexible is the ability to combine any configuration of relative and absolute values at any point in the formula query string without being bound by {"nested:arrays"} as long as they are paired together:

`=CS.QUERYA("provider","endoint","arg","argValue","parameter","parameterValue"...)`


![image](https://res.cloudinary.com/cryptosheets/image/upload/cryptosheets-docs/excel/functions/csQUERYA-relative-cells.png)

![image](https://res.cloudinary.com/cryptosheets/image/upload/cryptosheets-docs/excel/functions/csQUERYA-relative-example.gif)

<a href="https://app.cryptosheets.com/#/browse" rel="noopener noreferrer" target="_blank">Click here</a> to search for data providers and endpoints

---

## QUERYA - Examples

**TIP**: _Try copying + pasting the example formulas directly into your worksheet_

**Example 1:**

> <inline-code functionvalue='=CS.QUERYA("CryptUnit","earnings auto","_fields","coin_ticker,reward_day_usd,reward_month_usd","device","GPU","hashrate","5000")'>=CS.QUERYA("CryptUnit","earnings auto","_fields","coin_ticker,reward_day_usd,reward_month_usd","device","GPU","hashrate","5000")</inline-code>

![image](https://res.cloudinary.com/cryptosheets/image/upload/cryptosheets-docs/excel/functions/csQUERYA-example1.png)

**Example 2:**

> <inline-code functionvalue='=CS.QUERYA("Compound","governance accounts","_fields","display_name,vote_weight,votes")'>=CS.QUERYA("Compound","governance accounts","_fields","display_name,vote_weight,votes")</inline-code>

![image](https://res.cloudinary.com/cryptosheets/image/upload/cryptosheets-docs/excel/functions/csQUERYA-example2.png)

**Example 3:**

> <inline-code functionvalue='=CS.QUERYA("Paradigm","performance","_fields","symbol,sharpe1MLibor")'>=CS.QUERYA("Paradigm","performance","_fields","symbol,sharpe1MLibor")</inline-code>

![image](https://res.cloudinary.com/cryptosheets/image/upload/cryptosheets-docs/excel/functions/csQUERYA-example3.png)

**Example 4:**

![image](https://res.cloudinary.com/cryptosheets/image/upload/cryptosheets-docs/excel/functions/csQUERYA-example4.gif)

### 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. <a href="https://support.office.com/en-us/article/function-arguments-65b29fb5-ec7b-4c0b-a54b-a67923571519" rel="noopener noreferrer" target="_blank">Check Excels help sections</a>
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_

- <a href="https://docs.microsoft.com/en-us/office/dev/add-ins/concepts/browsers-used-by-office-web-add-ins" rel="noopener noreferrer" target="_blank">Web browsers used by add-ins</a>
- <a href="https://docs.microsoft.com/en-us/office/dev/add-ins/develop/office-versions-and-requirement-sets" rel="noopener noreferrer" target="_blank">Office versions and requirement sets</a>
- <a href="https://docs.microsoft.com/en-us/office/dev/add-ins/develop/office-versions-and-requirement-sets#how-to-check-your-office-version" rel="noopener noreferrer" target="_blank">How to check your Office version</a>
- <a href="https://docs.microsoft.com/en-us/office/dev/add-ins/develop/install-latest-office-version" rel="noopener noreferrer" target="_blank">Install the latest version of Office</a>
- <a href="https://docs.microsoft.com/en-us/office/dev/add-ins/excel/custom-functions-architecture" rel="noopener noreferrer" target="_blank">Custom Function Requirements</a>

_For Googlesheets_

- <a href="https://developers.google.com/apps-script/guides/services/quotas" rel="noopener noreferrer" target="_blank">Throughput Quotas & Limits</a>

Use the QUERYA function to query function to pull any endpoint from any available provider

How to use QUERYA in Excel & Googlesheets

QUERYA