Skip to main content

Frequently Asked Questions

  • I'm copying your examples, but I'm getting Formula parse error?
    • Our docs and examples are in English. Depending on your language setting you might need to use semi-colons ( ; ) instead of ( , ).
  • How do I handle a boolean result?
    • CALLINT will return 1 for true and 0 for false.
  • Do I need to pass a blocknumber?
    • No, it will default to the latest.
  • How do I make sure I'm getting the latest data?
    • Set the blocknumber to "latest".
  • Why does it take a few minutes for data to load sometimes?
    • If you are opening a previously made Google Sheet that has many calls, you'll need to wait a minute or two for everything to get populated. It might take longer if most of the cells reference each other because Google isn't clever enough to wait for the dependent cells to complete their queries before trying them.
  • How can I convert a number to a hex to pass into a function that is looking for bytes32?
    • Google Sheets has =DEC2HEX(number), which will return the hex value, but then you'll need to use concact to add the prefix. For example: =CALLINT("2","0xa26e80e7Dea86279c6d778D702Cc413E6CFfA777","getTotalStakeDelegatedToPool(bytes32)",CONCAT("0x000000000000000000000000000000000000000000000000000000000000000",DEC2HEX(2)))*10^-18