API Tool In Excel

  • 1
  • 2
  • Question
  • Updated 1 month ago
  • Answered
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


Photo of KenFirch

KenFirch

  • 10 Points

Posted 6 years ago

  • 1
  • 2
Photo of Eliza

Eliza

  • 60 Points
Thanks Ken!
Photo of Addam

Addam

  • 0 Points
Awesome!
This helps me from having to manually build and run all of my calls from a dev console or browser.
Thanks for sharing!
Photo of Kevin

Kevin

  • 0 Points
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)
Photo of Arkady

Arkady

  • 142 Points 100 badge 2x thumb
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?
Photo of Ken

Ken

  • 200 Points 100 badge 2x thumb
Hi Ken,

I have used your new link but it is giving me this error?


I am using Excel 2013.

Thank you in advance.

Gaurav
Photo of Ken

Ken

  • 200 Points 100 badge 2x thumb
Gaurav,  I also use Office 2013 (15.0).  Below lists the VBA references used, which are very common.  Make sure they are available on your device.

Ken

Photo of Arshad Khwaja

Arshad Khwaja

  • 3,152 Points 3k badge 2x thumb
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?
Photo of Ken

Ken

  • 200 Points 100 badge 2x thumb
Photo of Arshad Khwaja

Arshad Khwaja

  • 3,152 Points 3k badge 2x thumb
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?
Photo of champM

champM

  • 104 Points 100 badge 2x thumb
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
Photo of Gaurav Gawankar

Gaurav Gawankar

  • 60 Points
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
Photo of Ken

Ken

  • 200 Points 100 badge 2x thumb
Gaurav, please email me at kenfirch at yahoo.com for more help.

I also updated the Excel files to work on both 32 and 64 bit, which should fix the complie error.

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

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

Ken

Thank you, Ken, for fixing the compile error and sharing the updated version.

Regards,
Gaurav Sharma