302 Found

Found

The document has moved here.

Reply to comment

Description: 
This is a Visual Basic wrapper written to simplify interaction with the QuickBase HTTP API

Details are at https://github.com/QuickbaseAdmirer/QuickBase---Visual-Basic-SDK

 

The Visual Basic project group contained in the zip file has a TestHarness application that exercises the most popular methods of the QuickBaseClient class module also contained in the project group.

NOTE: The VB SDK does not yet support application tokens. You must leave application tokens disabled for the application your scripts are calling. If tokens are required, disable them manually.
- read about tokens: https://www.quickbase.com/help/app_tokens.html
- read how to disable tokens: https://www.quickbase.com/help/app_tokens_disable.html

You can also see the QuickBaseClient class module in action and look at the code using it in:

QuickBase Desktop (bidirectionally sync QuickBase tables with MS Access):
http://quickbase.intuit.com/developer/node/2200

QuickBase Download (download QuickBase tables to specific worksheets in Excel):
http://quickbase.intuit.com/developer/node/2154

QuickBase Exact Forms.dot (MS Word template for customizing QuickBase records):
https://www.quickbase.com/dot/QuickBase%20Exact%20Forms.dot

Note that you can include the functionality of QuickBaseClient directly into your VB or VBA project by importing two files:

QuickBaseClient.cls
WINAPIDeclares.bas

Then you'll need to do two more things:

Set the conditional compilation argument. From the VBA window choose the Tools menu and select Properties and then on the General tab fill the Conditional Compilation Arguments text box with:

WININET = 1

Include a reference to "Microsoft XML, version 2.0". In the VBA window select the Tools menu and choose References. Then check the check box next to "Microsoft XML, version 2.0".

The above is the equivalent of selecting a reference to "QuickBase HTTP API Wrapper" (which refers to QuickBase.dll). So you'll want to make sure you do not have the checkbox next to "QuickBase HTTP API Wrapper" checked in the Tools->References menu if you include QuickBaseClient.cls in your project.

Installation Notes

The Visual Basic project group contained in the zip archive 'qdbvbsdk.zip' has two projects.
1. A class module which compiles to a dll:

quickbase.dll

This dll contains QuickBase.QuickBaseClient. The project description for this class module is:

QuickBase HTTP API Wrapper

This class requires MSXML2.0 which comes with IE5 or greater. It uses the WinINET API so no URL control is required.

2. A small GUI project that exercises many of the public methods of QuickBase.QuickBaseClient.

Updates

12.15.2004

Supports anonymous access.

12.13.2004

Added methods to list, retrieve and save database pages.

11.10.2003

httpContentLengthProgress and httpContentLength now work in file download mode. Also conversion of dates from QuickBase to Microsoft format is more efficent.

11.5.2003

HTTP data downloading is much faster for large amounts of data. Also two public variables report on the data download progress. httpContentLengthProgress starts at zero and increases until it reaches httpContentLength. Both variables are zero if no download is in progress.

4.10.2003

Now supporting file uploads to file attachment fields. Please examine the included test application "QuickBaseClientTestHarness" to see how file uploads are perfomed with the AddRecord and EditRecord methods.

09.26.2002

This version handles the new file attachment URLs properly.

05.02.2002

Public methods parameters are now call by value instead of call by reference which allows the QuickBase.dll to be called from VC++.

Also a new property called 'errordetail' provides more details on errors like which field is involved instead of just specifying that a field is involved.

08.15.2001

AddRecord, AddRecordByArray and EditRecord functions return the update id now implemented by the QuickBase HTTP API. Also the EditRecord method now accepts an update id as an input parameter and will return an error if the record has been edited since the time of the creation of update id.

Performance and error handling of the HTTP connection has been improved.

Reply

The content of this field is kept private and will not be shown publicly.
Type the characters you see in this picture. (verify using audio)
Type the characters you see in the picture above; if you can't read them, submit the form and a new image will be generated. Not case sensitive.
302 Found

Found

The document has moved here.