Skip to main content
Question

API Tool In Excel

  • Mar 26, 2013 8:03 AM UTC
  • 0 replies
  • 432 views
Here's an Excel based API tool I created that allows you to test various Quickbase API's. It was developed as groundwork for a far more ambitious Quickbase/Excel project I?m working on. So if you need something to create, test, or just play with API?s against your Quickbase apps, this may meet your needs. Enjoy!

Ken
http://home.surewest.net/firch/Quickbase/QB_API.xls


    This topic has been closed for replies.

    • ElizaEliza
    • Registered
    • Apr 13, 2013 8:28 AM UTC
    Thanks Ken!
    • ArchiveUser
    • Registered
    • Apr 15, 2013 5:27 PM UTC
    Awesome!
    This helps me from having to manually build and run all of my calls from a dev console or browser.
    Thanks for sharing!
    • ArchiveUser
    • Registered
    • Apr 18, 2013 9:04 PM UTC
    Is there a way to get the password to unlock the VB script. I think this is cool but I wanted to parse out functions based on roles (I.E. remove some code as needed)
    • ArkadyGranik
    • Registered
    • Nov 16, 2014 6:31 PM UTC
    When I am trying to click on Open Quickbase API Form, I get an error message "Compile error in hidden module". Can you please help?
    • KenFirch
    • Registered
    • Nov 19, 2014 12:00 PM UTC
    Try this link:

    https://www.dropbox.com/s/ebfvyd4ip2cwnup/QB_API.xls?dl=0

    https://www.dropbox.com/s/4x7jt5nzx54p5cl/QBDownload.zip?dl=0

    Ken
    • ArshadKhwaja
    • Registered
    • Oct 16, 2016 7:03 AM UTC
    Ken, I successfully downloaded the file and it works fine connecting to App.,  But how could I use this to download data from QB to Excel?
    • KenFirch
    • Registered
    • Oct 25, 2016 6:22 PM UTC
    Here's a link to instructions for QBDownload:

    https://www.dropbox.com/s/tut64bdyoxjndnq/QBDownLoad%20Instructions.docx?dl=0
    • ArshadKhwaja
    • Registered
    • Oct 26, 2016 12:19 AM UTC
    Thanks Ken. I have macros enabled.  Yet I am getting VB error  Runt-ime error '91': Object variable or With block variable not set.  This error occurs after adding my domain and password and trying to authenticate.  Could you kindly help?
    • champMchampM
    • Registered
    • Jul 21, 2017 10:51 AM UTC
    Hi Ken, Thanks for the excellent tool.  Just wonder how to use existing Workbook option. This is badly needed as Filemaker cannot read XLSM files, and process needs to be automated to convert XLSM to XLSX or use existing Workbook option (If you can open Macros, then can adjust it myself and pass it to you).  Kind regards
    Hi Ken,

    I am trying to use this tool to write a macro that pulls from one specific table into Excel repeatedly. Is there any way you can write/point me in the right direction so I can write such a macro? Thank you in advance.

    Best,
    Gaurav
    • PraharshaK
    • Registered
    • Sep 6, 2023 9:13 AM UTC

    Hi Ken,

    I'm trying to make the same application that you did. Can you brief me on how you used an email address and password for authentication and not a user token?

    I'm currently trying to make it easy for the user by entering their Quickbase credentials for the API call, but I only know how to authenticate using user token



    ------------------------------
    Praharsha K
    ------------------------------
    Terms & ConditionsAccessibility statement