> FOAM provides the tools to enable a crowdsourced map and decentralized location services. Find examples for accessing every **FOAM** endpoint using **Cryptosheets** through: - `side panel console` - `custom functions` (Excel & Googlesheets) - `templates` ## Excel

| App Url | Docs Url | Name | Example | Parameters | # of Parameters | | --------------------------------------------------------------------------------------- | ---------------------------------------------------------------------------------------- | --------------------------- | --------------------------------------------------- | -------- | ----------- | | Try It | [Docs](/providers/foam/config-contracts) | **Config Contracts** | =CS.QUERY("FOAM","Config Contracts") | =CS.PARAMETERS("FOAM","Config Contracts") | 0 | | Try It | [Docs](/providers/foam/config-network) | **Config Network** | =CS.QUERY("FOAM","Config Network") | =CS.PARAMETERS("FOAM","Config Network") | 0 | | Try It | [Docs](/providers/foam/transaction) | **Transaction** | =CS.QUERY("FOAM","Transaction") | =CS.PARAMETERS("FOAM","Transaction") | 5 | | Try It | [Docs](/providers/foam/challenge-ipfs-ipfs-hash) | **Challenge Ipfs Ipfs Hash** | =CS.QUERY("FOAM","Challenge Ipfs Ipfs Hash") | =CS.PARAMETERS("FOAM","Challenge Ipfs Ipfs Hash") | 1 | | Try It | [Docs](/providers/foam/challenge-ipfs) | **Challenge Ipfs** | =CS.QUERY("FOAM","Challenge Ipfs") | =CS.PARAMETERS("FOAM","Challenge Ipfs") | 1 | | Try It | [Docs](/providers/foam/challenge-poll-i-d-doc) | **Challenge Poll I D Doc** | =CS.QUERY("FOAM","Challenge Poll I D Doc") | =CS.PARAMETERS("FOAM","Challenge Poll I D Doc") | 1 | | Try It | [Docs](/providers/foam/challenge-poll-i-d-voters) | **Challenge Poll I D Voters** | =CS.QUERY("FOAM","Challenge Poll I D Voters") | =CS.PARAMETERS("FOAM","Challenge Poll I D Voters") | 1 | | Try It | [Docs](/providers/foam/challenge-contract) | **Challenge Contract** | =CS.QUERY("FOAM","Challenge Contract") | =CS.PARAMETERS("FOAM","Challenge Contract") | 4 | | Try It | [Docs](/providers/foam/token-transfers) | **Token Transfers** | =CS.QUERY("FOAM","Token Transfers") | =CS.PARAMETERS("FOAM","Token Transfers") | 4 | | Try It | [Docs](/providers/foam/token-holders) | **Token Holders** | =CS.QUERY("FOAM","Token Holders") | =CS.PARAMETERS("FOAM","Token Holders") | 1 | | Try It | [Docs](/providers/foam/poi-map) | **Poi Map** | =CS.QUERY("FOAM","Poi Map") | =CS.PARAMETERS("FOAM","Poi Map") | 7 | | Try It | [Docs](/providers/foam/poi-details-listing-hash) | **Poi Details Listing Hash** | =CS.QUERY("FOAM","Poi Details Listing Hash") | =CS.PARAMETERS("FOAM","Poi Details Listing Hash") | 1 | | Try It | [Docs](/providers/foam/poi-listing-hash) | **Poi Listing Hash** | =CS.QUERY("FOAM","Poi Listing Hash") | =CS.PARAMETERS("FOAM","Poi Listing Hash") | 1 | | Try It | [Docs](/providers/foam/poi-invalid) | **Poi Invalid** | =CS.QUERY("FOAM","Poi Invalid") | =CS.PARAMETERS("FOAM","Poi Invalid") | 0 | | Try It | [Docs](/providers/foam/poi-ipfs-hash) | **Poi Ipfs Hash** | =CS.QUERY("FOAM","Poi Ipfs Hash") | =CS.PARAMETERS("FOAM","Poi Ipfs Hash") | 1 | | Try It | [Docs](/providers/foam/poi-ipfs-raw-hash) | **Poi Ipfs Raw Hash** | =CS.QUERY("FOAM","Poi Ipfs Raw Hash") | =CS.PARAMETERS("FOAM","Poi Ipfs Raw Hash") | 1 | | Try It | [Docs](/providers/foam/poi-ipfs) | **Poi Ipfs** | =CS.QUERY("FOAM","Poi Ipfs") | =CS.PARAMETERS("FOAM","Poi Ipfs") | 1 | | Try It | [Docs](/providers/foam/poi-address) | **Poi Address** | =CS.QUERY("FOAM","Poi Address") | =CS.PARAMETERS("FOAM","Poi Address") | 2 | | Try It | [Docs](/providers/foam/poi-filtered) | **Poi Filtered** | =CS.QUERY("FOAM","Poi Filtered") | =CS.PARAMETERS("FOAM","Poi Filtered") | 11 | | Try It | [Docs](/providers/foam/poi-removed-details-listing-hash) | **Poi Removed Details Listing Hash** | =CS.QUERY("FOAM","Poi Removed Details Listing Hash") | =CS.PARAMETERS("FOAM","Poi Removed Details Listing Hash") | 1 | | Try It | [Docs](/providers/foam/poi-listing) | **Poi Listing** | =CS.QUERY("FOAM","Poi Listing") | =CS.PARAMETERS("FOAM","Poi Listing") | 3 | | Try It | [Docs](/providers/foam/signal-details-cst-hash) | **Signal Details Cst Hash** | =CS.QUERY("FOAM","Signal Details Cst Hash") | =CS.PARAMETERS("FOAM","Signal Details Cst Hash") | 1 | | Try It | [Docs](/providers/foam/signal-map) | **Signal Map** | =CS.QUERY("FOAM","Signal Map") | =CS.PARAMETERS("FOAM","Signal Map") | 6 | | Try It | [Docs](/providers/foam/user-address-assets) | **User Address Assets** | =CS.QUERY("FOAM","User Address Assets") | =CS.PARAMETERS("FOAM","User Address Assets") | 1 | | Try It | [Docs](/providers/foam/user-address-votes-revealed) | **User Address Votes Revealed** | =CS.QUERY("FOAM","User Address Votes Revealed") | =CS.PARAMETERS("FOAM","User Address Votes Revealed") | 1 | | Try It | [Docs](/providers/foam/user-address-votes-locked) | **User Address Votes Locked** | =CS.QUERY("FOAM","User Address Votes Locked") | =CS.PARAMETERS("FOAM","User Address Votes Locked") | 1 | | Try It | [Docs](/providers/foam/user-address-votes-claimable) | **User Address Votes Claimable** | =CS.QUERY("FOAM","User Address Votes Claimable") | =CS.PARAMETERS("FOAM","User Address Votes Claimable") | 1 | | Try It | [Docs](/providers/foam/search-poi) | **Search Poi** | =CS.QUERY("FOAM","Search Poi") | =CS.PARAMETERS("FOAM","Search Poi") | 6 | | Try It | [Docs](/providers/foam/search-text) | **Search Text** | =CS.QUERY("FOAM","Search Text") | =CS.PARAMETERS("FOAM","Search Text") | 5 | | Try It | [Docs](/providers/foam/stats-global) | **Stats Global** | =CS.QUERY("FOAM","Stats Global") | =CS.PARAMETERS("FOAM","Stats Global") | 0 |

## Google Sheets

| App Url | Docs Url | Name | Example | Parameters | # of Parameters | | --------------------------------------------------------------------------------------- | ---------------------------------------------------------------------------------------- | --------------------------- | ------------------------------------------------------------------------------------------------------------------------------ | -------- | ----------- | | Try It | [Docs](/providers/foam/config-contracts) | **Config Contracts** | =CSQUERY("FOAM","Config Contracts") | =CSPARAMETERS("FOAM","Config Contracts") | 0 | | Try It | [Docs](/providers/foam/config-network) | **Config Network** | =CSQUERY("FOAM","Config Network") | =CSPARAMETERS("FOAM","Config Network") | 0 | | Try It | [Docs](/providers/foam/transaction) | **Transaction** | =CSQUERY("FOAM","Transaction") | =CSPARAMETERS("FOAM","Transaction") | 5 | | Try It | [Docs](/providers/foam/challenge-ipfs-ipfs-hash) | **Challenge Ipfs Ipfs Hash** | =CSQUERY("FOAM","Challenge Ipfs Ipfs Hash") | =CSPARAMETERS("FOAM","Challenge Ipfs Ipfs Hash") | 1 | | Try It | [Docs](/providers/foam/challenge-ipfs) | **Challenge Ipfs** | =CSQUERY("FOAM","Challenge Ipfs") | =CSPARAMETERS("FOAM","Challenge Ipfs") | 1 | | Try It | [Docs](/providers/foam/challenge-poll-i-d-doc) | **Challenge Poll I D Doc** | =CSQUERY("FOAM","Challenge Poll I D Doc") | =CSPARAMETERS("FOAM","Challenge Poll I D Doc") | 1 | | Try It | [Docs](/providers/foam/challenge-poll-i-d-voters) | **Challenge Poll I D Voters** | =CSQUERY("FOAM","Challenge Poll I D Voters") | =CSPARAMETERS("FOAM","Challenge Poll I D Voters") | 1 | | Try It | [Docs](/providers/foam/challenge-contract) | **Challenge Contract** | =CSQUERY("FOAM","Challenge Contract") | =CSPARAMETERS("FOAM","Challenge Contract") | 4 | | Try It | [Docs](/providers/foam/token-transfers) | **Token Transfers** | =CSQUERY("FOAM","Token Transfers") | =CSPARAMETERS("FOAM","Token Transfers") | 4 | | Try It | [Docs](/providers/foam/token-holders) | **Token Holders** | =CSQUERY("FOAM","Token Holders") | =CSPARAMETERS("FOAM","Token Holders") | 1 | | Try It | [Docs](/providers/foam/poi-map) | **Poi Map** | =CSQUERY("FOAM","Poi Map") | =CSPARAMETERS("FOAM","Poi Map") | 7 | | Try It | [Docs](/providers/foam/poi-details-listing-hash) | **Poi Details Listing Hash** | =CSQUERY("FOAM","Poi Details Listing Hash") | =CSPARAMETERS("FOAM","Poi Details Listing Hash") | 1 | | Try It | [Docs](/providers/foam/poi-listing-hash) | **Poi Listing Hash** | =CSQUERY("FOAM","Poi Listing Hash") | =CSPARAMETERS("FOAM","Poi Listing Hash") | 1 | | Try It | [Docs](/providers/foam/poi-invalid) | **Poi Invalid** | =CSQUERY("FOAM","Poi Invalid") | =CSPARAMETERS("FOAM","Poi Invalid") | 0 | | Try It | [Docs](/providers/foam/poi-ipfs-hash) | **Poi Ipfs Hash** | =CSQUERY("FOAM","Poi Ipfs Hash") | =CSPARAMETERS("FOAM","Poi Ipfs Hash") | 1 | | Try It | [Docs](/providers/foam/poi-ipfs-raw-hash) | **Poi Ipfs Raw Hash** | =CSQUERY("FOAM","Poi Ipfs Raw Hash") | =CSPARAMETERS("FOAM","Poi Ipfs Raw Hash") | 1 | | Try It | [Docs](/providers/foam/poi-ipfs) | **Poi Ipfs** | =CSQUERY("FOAM","Poi Ipfs") | =CSPARAMETERS("FOAM","Poi Ipfs") | 1 | | Try It | [Docs](/providers/foam/poi-address) | **Poi Address** | =CSQUERY("FOAM","Poi Address") | =CSPARAMETERS("FOAM","Poi Address") | 2 | | Try It | [Docs](/providers/foam/poi-filtered) | **Poi Filtered** | =CSQUERY("FOAM","Poi Filtered") | =CSPARAMETERS("FOAM","Poi Filtered") | 11 | | Try It | [Docs](/providers/foam/poi-removed-details-listing-hash) | **Poi Removed Details Listing Hash** | =CSQUERY("FOAM","Poi Removed Details Listing Hash") | =CSPARAMETERS("FOAM","Poi Removed Details Listing Hash") | 1 | | Try It | [Docs](/providers/foam/poi-listing) | **Poi Listing** | =CSQUERY("FOAM","Poi Listing") | =CSPARAMETERS("FOAM","Poi Listing") | 3 | | Try It | [Docs](/providers/foam/signal-details-cst-hash) | **Signal Details Cst Hash** | =CSQUERY("FOAM","Signal Details Cst Hash") | =CSPARAMETERS("FOAM","Signal Details Cst Hash") | 1 | | Try It | [Docs](/providers/foam/signal-map) | **Signal Map** | =CSQUERY("FOAM","Signal Map") | =CSPARAMETERS("FOAM","Signal Map") | 6 | | Try It | [Docs](/providers/foam/user-address-assets) | **User Address Assets** | =CSQUERY("FOAM","User Address Assets") | =CSPARAMETERS("FOAM","User Address Assets") | 1 | | Try It | [Docs](/providers/foam/user-address-votes-revealed) | **User Address Votes Revealed** | =CSQUERY("FOAM","User Address Votes Revealed") | =CSPARAMETERS("FOAM","User Address Votes Revealed") | 1 | | Try It | [Docs](/providers/foam/user-address-votes-locked) | **User Address Votes Locked** | =CSQUERY("FOAM","User Address Votes Locked") | =CSPARAMETERS("FOAM","User Address Votes Locked") | 1 | | Try It | [Docs](/providers/foam/user-address-votes-claimable) | **User Address Votes Claimable** | =CSQUERY("FOAM","User Address Votes Claimable") | =CSPARAMETERS("FOAM","User Address Votes Claimable") | 1 | | Try It | [Docs](/providers/foam/search-poi) | **Search Poi** | =CSQUERY("FOAM","Search Poi") | =CSPARAMETERS("FOAM","Search Poi") | 6 | | Try It | [Docs](/providers/foam/search-text) | **Search Text** | =CSQUERY("FOAM","Search Text") | =CSPARAMETERS("FOAM","Search Text") | 5 | | Try It | [Docs](/providers/foam/stats-global) | **Stats Global** | =CSQUERY("FOAM","Stats Global") | =CSPARAMETERS("FOAM","Stats Global") | 0 |

[Signing up for Cryptosheets is free](https://app.cryptosheets.com/#/register) get crypto data in 30 seconds or less **Get Cryptosheets for Microsoft Excel** **Get Cryptosheets for Googlesheets** \*Note: you must have one of the [supported versions](https://docs.microsoft.com/en-us/office/dev/add-ins/excel/custom-functions-architecture) of Microsoft Office or Excel for custom functions to work **Click here** for additional documentation from FOAM Learn more [here](https://intercom.help/cryptosheets/en/) --- Tags: `FOAM` `provider`