Skip to main content
Question

API Tool In Excel

  • March 26, 2013
  • 0 replies
  • 404 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
    • April 13, 2013
    Thanks Ken!
    • ArchiveUser
    • Registered
    • April 15, 2013
    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
    • April 18, 2013
    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
    • November 16, 2014
    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
    • November 19, 2014
    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
    • October 16, 2016
    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
    • October 25, 2016
    Here's a link to instructions for QBDownload:

    https://www.dropbox.com/s/tut64bdyoxjndnq/QBDownLoad%20Instructions.docx?dl=0
    • ArshadKhwaja
    • Registered
    • October 26, 2016
    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
    • July 21, 2017
    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
    • September 6, 2023

    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