List Wallets

<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="#how-to-use-coinbase-custody-data-in-excel--googlesheets-with-cryptosheets">How to use Coinbase Custody data in Excel &#x26; Googlesheets with Cryptosheets</a></li><li class="toc-item toc-item-h2"><a class="toc-link toc-link-h2" href="#example-parameters">Example Parameters:</a></li><li class="toc-item toc-item-h2"><a class="toc-link toc-link-h2" href="#usage">Usage</a><ol class="toc-level toc-level-2"><li class="toc-item toc-item-h3"><a class="toc-link toc-link-h3" href="#setup">Setup</a></li><li class="toc-item toc-item-h3"><a class="toc-link toc-link-h3" href="#using-the-console">Using the console</a></li><li class="toc-item toc-item-h3"><a class="toc-link toc-link-h3" href="#using-custom-functions">Using custom functions</a></li><li class="toc-item toc-item-h3"><a class="toc-link toc-link-h3" href="#using-templates">Using templates</a></li></ol></li><li class="toc-item toc-item-h2"><a class="toc-link toc-link-h2" href="#helpful-resources">Helpful Resources:</a></li></ol></nav><blockquote> <p>Get a list of all wallets associated with the account.</p> </blockquote> <h2 id="how-to-use-coinbase-custody-data-in-excel--googlesheets-with-cryptosheets">How to use Coinbase Custody data in Excel &#x26; Googlesheets with Cryptosheets</h2> <p>This article demonstrates three examples of how to pull Coinbase Custody data into your spreadsheet using the <code>side panel console</code>, <code>custom functions</code> and <code>templates</code>.</p> <p>Explore more Coinbase Custody endpoints [here](<a href=""></a> Custody)</p> <h2 id="example-parameters">Example Parameters:</h2> <ul> <li>CB-ACCESS-KEY: <code>Your CB-ACCESS-KEY</code></li> <li>currency: <code>btc</code></li> <li>limit: <code>25</code></li> <li>CB-ACCESS-PASSPHRASE: <code>Your Passphrase</code></li> </ul> <h2 id="usage">Usage</h2> <p>Cryptosheets data can be pulled through multiple surfaces:</p> <h3 id="setup">Setup</h3> <ol> <li> <p>Install the Cryptosheets add-in from Microsoft [AppSource Store](<a href=""></a> Custody)</p> </li> <li> <p>Make sure you are logged into your Cryptosheets account</p> </li> </ol> <h3 id="using-the-console">Using the console</h3> <ol> <li>From the Cryptosheets ribbon click <code>data</code></li> <li>Type in type in "Coinbase Custody..." then click on <code>List Wallets</code> </li> <li>Scroll through the console parameters and input your values</li> <li>Select the cell you want to place the data into</li> <li>Click <code>make request</code></li> </ol> <p><a href=""><img src="" alt="img"></a></p> <h3 id="using-custom-functions">Using custom functions</h3> <ol> <li>In any cell type the following: <code>=CS.QUERY("Coinbase Custody","List Wallets",{"CB-ACCESS-KEY","Your CB-ACCESS-KEY";"currency","btc";"limit","25";"CB-ACCESS-PASSPHRASE","Your Passphrase"})</code></li> <li>In any console, after selecting the parameters to configure the query string as desired, simply click the radio button to toggle the the <code>function/formula builder</code>, then click the <code>clipboard icon</code> to copy the full formula string and paste it into any cell <a href="">see detailed examples and tutorial</a></li> </ol> <blockquote> <p><strong>Hint</strong>: If you need help remembering the exact parameters for any function, you can always just type in any cell: <code>=CS.PARAMETERS("Coinbase Custody","List Wallets")</code></p> </blockquote> <h3 id="using-templates">Using templates</h3> <ol> <li>From the Cryptosheets ribbon click <code>templates</code> OR click on the <code>templates tab</code> in the browse section</li> <li>Load the template called <code>Query Builder</code> and type Coinbase Custody and List Wallets</li> <li>You can also try searching "Coinbase Custody..." for other templates specific or related to <code>Get Gains</code> </li> </ol> <p><a href="">Signing up for Cryptosheets is free</a> get crypto data in 30 seconds or less</p> <blockquote> <p>Note: you must have one of the <a href="">supported versions</a> of Microsoft Office or Excel for custom functions to work. Learn more <a href="">here</a></p> </blockquote> <h2 id="helpful-resources">Helpful Resources:</h2> <p>Visit the API documentation for Coinbase Custody <a href="">here</a></p> <p>Troubleshooting: please reference the following troubleshooting code: QUE-1708-1927. Learn more <a href="">here</a></p> <hr> <p>Tags: endpoint</p>