# Moralis

{% hint style="success" %}
Moralis Google Sheets template and tutorial video coming soon!
{% endhint %}

| Formulas                                                                                                                                                                                                                                                                                                                                                   |
| ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| <p><strong>=Moralis(</strong> <a href="../options"><strong>"options"</strong></a><strong>)</strong></p><p>Interact with the <a href="https://moralis.io/">Moralis</a> API using only the SheetLink <a href="../options">"options"</a></p>                                                                                                                  |
| <p><strong>=Moralis\_GetBlock( "chain", "block\_number\_or\_hash", "options")</strong><br>Gets the contents of a block by block hash</p>                                                                                                                                                                                                                   |
| <p><strong>=Moralis\_GetBlockDate( "chain", "date", "options")</strong><br>Gets the closest block of the provided date</p>                                                                                                                                                                                                                                 |
| <p><strong>=Moralis\_GetAddressLogs( "chain", "address", "options")</strong><br>Gets the logs from an address</p>                                                                                                                                                                                                                                          |
| <p><strong>=Moralis\_GetHashTransactions( "chain", "transaction\_hash", "options")</strong><br>Gets NFT transfers by block number or block hash</p>                                                                                                                                                                                                        |
| <p><strong>=Moralis\_GetBlockNFTTransactions( "chain", "block\_number\_or\_hash", "options")</strong><br>Gets the contents of a block transaction by hash</p>                                                                                                                                                                                              |
| <p><strong>=Moralis\_GetAddressNFTsFormatDecimal( "chain", "address", "options")</strong><br>Gets native transactions in descending order based on block number</p>                                                                                                                                                                                        |
| <p><strong>=Moralis\_GetAddressTransactions( "chain", "address", "options")</strong><br>Gets native balance for a specific address</p>                                                                                                                                                                                                                     |
| <p><strong>=Moralis\_GetAddressNativeBalance( "chain", "address", "options")</strong><br>Gets token balances for a specific address</p>                                                                                                                                                                                                                    |
| <p><strong>=Moralis\_GetAddressTokenBalance( "chain", "address", "options")</strong><br>Gets ERC20 token transactions in descending order based on block number</p>                                                                                                                                                                                        |
| <p><strong>=Moralis\_GetAddressTokenTransactions( "chain", "address", "options")</strong><br>Gets NFTs owned by the given address</p>                                                                                                                                                                                                                      |
| <p><strong>=Moralis\_GetAddressNFTTransactions( "chain", "address", "options")</strong><br>Gets the transfers of the tokens matching the given parameters</p>                                                                                                                                                                                              |
| <p><strong>=Moralis\_GetTokenMetadata( "chain", "token\_address", "options")</strong><br>Returns metadata (name, symbol, decimals, logo) for a given token contract address.</p>                                                                                                                                                                           |
| <p><strong>=Moralis\_GetTokenSymbolMetadata( "chain", "symbol", "options")</strong><br>Returns metadata (name, symbol, decimals, logo) for a given symbol</p>                                                                                                                                                                                              |
| <p><strong>=Moralis\_GetTokenAddressPrice( "chain", "token\_address", "options")</strong><br>Returns the price nominated in the native token and usd for a given token contract address.</p>                                                                                                                                                               |
| <p><strong>=Moralis\_GetTokenAddressTransactions( "chain", "token\_address", "options")</strong><br>Gets ERC20 token contract transactions in descending order based on block number</p>                                                                                                                                                                   |
| <p><strong>=Moralis\_GetTokenAddressAllowance( "chain", "token\_address", "owner\_address", "spender\_address", "options")</strong><br>Gets the amount which the spender is allowed to withdraw from the spender</p>                                                                                                                                       |
| <p><strong>=Moralis\_GetNFTSearch( "chain", "query", "options")</strong><br>Gets NFTs that match a given metadata search.</p>                                                                                                                                                                                                                              |
| <p><strong>=Moralis\_GetContractNFTs( "chain", "contract\_address", "options")</strong><br>Gets data, including metadata (where available), for all token ids for the given contract address.</p>                                                                                                                                                          |
| <p><strong>=Moralis\_GetContractNFTTransfers( "chain", "contract\_address", "options")</strong><br>Gets the transfers of the tokens matching the given parameters</p>                                                                                                                                                                                      |
| <p><strong>=Moralis\_GetContractNFTOwners( "chain", "contract\_address", "options")</strong><br>Gets all owners of NFT items within a given contract collection</p>                                                                                                                                                                                        |
| <p><strong>=Moralis\_GetContractNFTMetadata( "chain", "contract\_address", "options")</strong><br>Gets the contract level metadata (name, symbol, base token uri) for the given contract</p>                                                                                                                                                               |
| <p><strong>=Moralis\_GetContractNFTToken( "chain", "contract\_address", "token\_id", "options")</strong><br>Gets data, including metadata (where available), for the given token id of the given contract address.</p>                                                                                                                                     |
| <p><strong>=Moralis\_GetContractNFTTokenOwners( "chain", "contract\_address", "token\_id", "options")</strong><br>Gets all owners of NFT items within a given contract collection</p>                                                                                                                                                                      |
| <p><strong>=Moralis\_GetContractNFTTokenTransfers( "chain", "contract\_address", "token\_id", "options")</strong><br>Gets the transfers of the tokens matching the given parameters</p>                                                                                                                                                                    |
| <p><strong>=Moralis\_GetDomainResolved( "currency", "domain", "options")</strong><br>Resolves an Unstoppable domain and returns the address</p>                                                                                                                                                                                                            |
| <p><strong>=Moralis\_GetLiquidityReserves( "chain", "pair\_address", "options")</strong><br>Get the liquidity reserves for a given pair address</p>                                                                                                                                                                                                        |
| <p><strong>=Moralis\_GetPairAddress( "chain", "exchange", "token0\_address", "token1\_address", "options")</strong><br>Fetches and returns pair data of the provided token0+token1 combination. The token0 and token1 options are interchangable (ie. there is no different outcome in "token0=WETH and token1=USDT" or "token0=USDT and token1=WETH")</p> |

Developers can review the official[ Moralis Documentation](https://docs.moralis.io/moralis-server/web3-sdk/moralis-web3-api-rest) 📖

{% hint style="success" %}
Missing a formula? [Suggest one here](https://www.sheet.link/suggest) 💡
{% endhint %}

{% hint style="info" %}
Note that ["options"](https://docs.sheet.link/formulas/options) are optional, other variables are required 👍
{% endhint %}

### Navigation <a href="#where-to" id="where-to"></a>

| Page                                                                                                                                             |
| ------------------------------------------------------------------------------------------------------------------------------------------------ |
| <p>🚀 <a href="../../quickstart"><strong>Quick Start</strong></a>​</p><p>60 second getting started guide.</p>                                    |
| <p><strong>​</strong><a href="../../faq"><strong>❓ FAQ</strong></a><strong>​</strong></p><p>Answers to frequently asked SheetLink questions.</p> |
| <p>🛠️ <a href="../functions"><strong>Functions</strong></a><strong>​</strong></p><p>Powerful functions unique to SheetLink.</p>                 |
| <p>💪 <a href="../options"><strong>"options"</strong></a><strong>​</strong></p><p>Control the request to and response from any application.</p>  |

## 🚑 Need Help?

You can always contact us via <support@sheet.link> or by messaging us on Twitter [@SheetLink](https://twitter.com/SheetLink)