Discussions

Expand all | Collapse all

API Tool In Excel

Eliza Eliza04-13-2013 04:28

  • 1.  API Tool In Excel

    Posted 03-26-2013 04:03
    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


    ">https://d2r1vs3d9006ap.cloudfront.net/import_topic_images/37815/original.jpg">">https://d2r1vs3d9006ap.cloudfront.net/import_topic_images/37816/original.jpg">">https://d2r1vs3d9006ap.cloudfront.net/import_topic_images/37817/original.jpg">


  • 2.  RE: API Tool In Excel

    Posted 04-13-2013 04:28
    Thanks Ken!


  • 3.  RE: API Tool In Excel

    Top
    Contributor
    Posted 04-15-2013 13:27
    Awesome!
    This helps me from having to manually build and run all of my calls from a dev console or browser.
    Thanks for sharing!


  • 4.  RE: API Tool In Excel

    Top
    Contributor
    Posted 04-18-2013 17:04
    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)


  • 5.  RE: API Tool In Excel

    Posted 11-16-2014 13:31
    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?


  • 6.  RE: API Tool In Excel



  • 7.  RE: API Tool In Excel

    Silver
    Contributor
    Posted 06-02-2017 12:02
    Hi Ken,

    I have used your new link but it is giving me this error?
    ">https://d2r1vs3d9006ap.cloudfront.net/s3_images/1604846/RackMultipart20170602-25759-1feanik-image_inline.png?1496404920">

    I am using Excel 2013.

    Thank you in advance.

    Gaurav


  • 8.  RE: API Tool In Excel

     
    Posted 06-02-2017 13:37
    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



  • 9.  RE: API Tool In Excel

    Silver
    Contributor
    Posted 10-16-2016 03:03
    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?


  • 10.  RE: API Tool In Excel

     
    Posted 10-25-2016 14:22


  • 11.  RE: API Tool In Excel

    Silver
    Contributor
    Posted 10-25-2016 20:19
    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?


  • 12.  RE: API Tool In Excel

    Posted 07-21-2017 06:51
    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


  • 13.  RE: API Tool In Excel

    Posted 05-22-2019 21:46
    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


  • 14.  RE: API Tool In Excel

     
    Posted 06-10-2019 19:57
    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">https://www.dropbox.com/s/4x7jt5nzx54p5cl/QBDownload.zip?dl=0">https://www.dropbox.com/s/4x7jt5nzx54p5cl/QBDownload.zip?dl=0

    Ken



  • 15.  RE: API Tool In Excel

    Silver
    Contributor
    Posted 06-11-2019 05:43
    Thank you, Ken, for fixing the compile error and sharing the updated version.

    Regards,
    Gaurav Sharma