0xAPI

<nav class="toc"><ol class="toc-level toc-level-1"><li class="toc-item toc-item-h2"><a class="toc-link toc-link-h2" href="#excel">Excel</a></li><li class="toc-item toc-item-h2"><a class="toc-link toc-link-h2" href="#google-sheets">Google Sheets</a></li></ol></nav><blockquote> <p>The 0x API is the easiest way to source liquidity from 0x Mesh as well as on-chain sources such as Kyber, Uniswap, Oasis, Curve and other decentralized exchange networks. </p> </blockquote> <p>Find examples for accessing every <strong>0xAPI</strong> endpoint using <strong>Cryptosheets</strong> through:</p> <ul> <li><code>side panel console</code></li> <li><code>custom functions</code> (Excel &#x26; Googlesheets)</li> <li><code>templates</code></li> </ul> <h2 id="excel">Excel</h2> <table> <thead> <tr> <th>App Url</th> <th>Docs Url</th> <th>Name</th> <th>Example</th> <th>Parameters</th> <th># of Parameters</th> </tr> </thead> <tbody> <tr> <td>Try It</td> <td><a href="/providers/0xapi/quotes">Docs</a></td> <td><strong>Quotes</strong></td> <td>=CS.QUERY("0xAPI","Quotes")</td> <td>=CS.PARAMETERS("0xAPI","Quotes")</td> <td>8</td> </tr> <tr> <td>Try It</td> <td><a href="/providers/0xapi/tokens">Docs</a></td> <td><strong>Tokens</strong></td> <td>=CS.QUERY("0xAPI","Tokens")</td> <td>=CS.PARAMETERS("0xAPI","Tokens")</td> <td>0</td> </tr> <tr> <td>Try It</td> <td><a href="/providers/0xapi/prices">Docs</a></td> <td><strong>Prices</strong></td> <td>=CS.QUERY("0xAPI","Prices")</td> <td>=CS.PARAMETERS("0xAPI","Prices")</td> <td>1</td> </tr> <tr> <td>Try It</td> <td><a href="/providers/0xapi/meta-price">Docs</a></td> <td><strong>Meta Price</strong></td> <td>=CS.QUERY("0xAPI","Meta Price")</td> <td>=CS.PARAMETERS("0xAPI","Meta Price")</td> <td>7</td> </tr> <tr> <td>Try It</td> <td><a href="/providers/0xapi/meta-quote">Docs</a></td> <td><strong>Meta Quote</strong></td> <td>=CS.QUERY("0xAPI","Meta Quote")</td> <td>=CS.PARAMETERS("0xAPI","Meta Quote")</td> <td>7</td> </tr> <tr> <td>Try It</td> <td><a href="/providers/0xapi/sra-asset-pairs">Docs</a></td> <td><strong>SRA Asset Pairs</strong></td> <td>=CS.QUERY("0xAPI","SRA Asset Pairs")</td> <td>=CS.PARAMETERS("0xAPI","SRA Asset Pairs")</td> <td>2</td> </tr> <tr> <td>Try It</td> <td><a href="/providers/0xapi/sra-orders">Docs</a></td> <td><strong>SRA Orders</strong></td> <td>=CS.QUERY("0xAPI","SRA Orders")</td> <td>=CS.PARAMETERS("0xAPI","SRA Orders")</td> <td>0</td> </tr> <tr> <td>Try It</td> <td><a href="/providers/0xapi/sra-order-by-hash">Docs</a></td> <td><strong>SRA Order by Hash</strong></td> <td>=CS.QUERY("0xAPI","SRA Order by Hash")</td> <td>=CS.PARAMETERS("0xAPI","SRA Order by Hash")</td> <td>1</td> </tr> <tr> <td>Try It</td> <td><a href="/providers/0xapi/sra-orderbook">Docs</a></td> <td><strong>SRA OrderBook</strong></td> <td>=CS.QUERY("0xAPI","SRA OrderBook")</td> <td>=CS.PARAMETERS("0xAPI","SRA OrderBook")</td> <td>2</td> </tr> <tr> <td>Try It</td> <td><a href="/providers/0xapi/sra-fee-recipients">Docs</a></td> <td><strong>SRA Fee Recipients</strong></td> <td>=CS.QUERY("0xAPI","SRA Fee Recipients")</td> <td>=CS.PARAMETERS("0xAPI","SRA Fee Recipients")</td> <td>0</td> </tr> </tbody> </table> <h2 id="google-sheets">Google Sheets</h2> <table> <thead> <tr> <th>App Url</th> <th>Docs Url</th> <th>Name</th> <th>Example</th> <th>Parameters</th> <th># of Parameters</th> </tr> </thead> <tbody> <tr> <td>Try It</td> <td><a href="/providers/0xapi/quotes">Docs</a></td> <td><strong>Quotes</strong></td> <td>=CSQUERY("0xAPI","Quotes")</td> <td>=CSPARAMETERS("0xAPI","Quotes")</td> <td>8</td> </tr> <tr> <td>Try It</td> <td><a href="/providers/0xapi/tokens">Docs</a></td> <td><strong>Tokens</strong></td> <td>=CSQUERY("0xAPI","Tokens")</td> <td>=CSPARAMETERS("0xAPI","Tokens")</td> <td>0</td> </tr> <tr> <td>Try It</td> <td><a href="/providers/0xapi/prices">Docs</a></td> <td><strong>Prices</strong></td> <td>=CSQUERY("0xAPI","Prices")</td> <td>=CSPARAMETERS("0xAPI","Prices")</td> <td>1</td> </tr> <tr> <td>Try It</td> <td><a href="/providers/0xapi/meta-price">Docs</a></td> <td><strong>Meta Price</strong></td> <td>=CSQUERY("0xAPI","Meta Price")</td> <td>=CSPARAMETERS("0xAPI","Meta Price")</td> <td>7</td> </tr> <tr> <td>Try It</td> <td><a href="/providers/0xapi/meta-quote">Docs</a></td> <td><strong>Meta Quote</strong></td> <td>=CSQUERY("0xAPI","Meta Quote")</td> <td>=CSPARAMETERS("0xAPI","Meta Quote")</td> <td>7</td> </tr> <tr> <td>Try It</td> <td><a href="/providers/0xapi/sra-asset-pairs">Docs</a></td> <td><strong>SRA Asset Pairs</strong></td> <td>=CSQUERY("0xAPI","SRA Asset Pairs")</td> <td>=CSPARAMETERS("0xAPI","SRA Asset Pairs")</td> <td>2</td> </tr> <tr> <td>Try It</td> <td><a href="/providers/0xapi/sra-orders">Docs</a></td> <td><strong>SRA Orders</strong></td> <td>=CSQUERY("0xAPI","SRA Orders")</td> <td>=CSPARAMETERS("0xAPI","SRA Orders")</td> <td>0</td> </tr> <tr> <td>Try It</td> <td><a href="/providers/0xapi/sra-order-by-hash">Docs</a></td> <td><strong>SRA Order by Hash</strong></td> <td>=CSQUERY("0xAPI","SRA Order by Hash")</td> <td>=CSPARAMETERS("0xAPI","SRA Order by Hash")</td> <td>1</td> </tr> <tr> <td>Try It</td> <td><a href="/providers/0xapi/sra-orderbook">Docs</a></td> <td><strong>SRA OrderBook</strong></td> <td>=CSQUERY("0xAPI","SRA OrderBook")</td> <td>=CSPARAMETERS("0xAPI","SRA OrderBook")</td> <td>2</td> </tr> <tr> <td>Try It</td> <td><a href="/providers/0xapi/sra-fee-recipients">Docs</a></td> <td><strong>SRA Fee Recipients</strong></td> <td>=CSQUERY("0xAPI","SRA Fee Recipients")</td> <td>=CSPARAMETERS("0xAPI","SRA Fee Recipients")</td> <td>0</td> </tr> </tbody> </table> <p><a href="https://app.cryptosheets.com/#/register">Signing up for Cryptosheets is free</a> get crypto data in 30 seconds or less</p> <p><strong>Get Cryptosheets for Microsoft Excel</strong></p> <p><strong>Get Cryptosheets for Googlesheets</strong></p> <p>*Note: you must have one of the <a href="https://docs.microsoft.com/en-us/office/dev/add-ins/excel/custom-functions-architecture">supported versions</a> of Microsoft Office or Excel for custom functions to work</p> <p><strong>Click here</strong> for additional documentation from 0xAPI</p> <p>Learn more <a href="https://intercom.help/cryptosheets/en/">here</a></p> <hr> <p>Tags: 0xAPI</p>