Articles of interest to QuickBase folks
There are two ways to download a file.
The first and easiest way to download an attached file can be used if you know the database ID, the record ID, the Field ID of the file field you are attaching to, and the version ID.
To use this type of download, you use a GET request using this URL format:
replacing DBID with your TABLE dbid (not the application dbid!) , RID with the rid of the record with the File attachment, FID witht the fid of the File attachment field, and VID with the version ID of the file. Specifying 0 (zero) for the VID always gets you the most recent version.
If you use file attachments, you should know about the QuickBase version feature. Take a peek at the QuickBase online help for more information.
An alternate way to get the file is to use a different GET. This way uses a GET containing the URL of the file attachment, using no IDs other than the table dbid. The trick is getting the URL of the file attachement. How do you get that? You get the file attachment URL back from a call to API_DoQuery if you set its <fmt> parameter to structured. (The URL comes back, surprisingly in the <url></url> tags)
Heres a typical URL that you would use in this second way of doing a GET:
Browse by Category
Knowledge Base Categories
- Accounts (35)
- Application (45)
- E-Mail (7)
- Fields (42)
- Forms (20)
- Formulas (18)
- General (71)
- Other Product (7)
- Pages (1)
- Product (5)
- Reports (15)
- Roles (4)
- Search (1)
- Tables (6)