Articles

Articles of interest to QuickBase folks

Format Parameter: Structured vs. Unstructured

One useful feature youll want to use in the API_DoQuery call is the <fmt>structured</fmt> parameter. By default the query returns are not structured. Basically, youll just get the table name, any DBVars, and the record data with the fields you specified, all with the field names, like this:

<record>
   <business_phone_number>(123) 103-1234 x12345</business_phone_number>
   <email>b@c.com</email>
   <file>car.jpg</file>
   <text>justatest</text>
   <update_id>1206568990479</update_id>
</record

Downloading Files.)

<record>
   <f id="5">112149.bhsv</f>
   <f id="6">(650) 123-1234</f>
   <f id="7">cu@later.com</f>
   <f id="22"> Model_T.jpg
      <url>https://qbdp.quickbase.com/up/bdb5rjd6g/g/rz/ey/va/Model_T.jpg</       url>
   </f>
   
<update_id>1206568990479</update_id>
</record>

Using structured format, youll also get some of the same information about the table as if you called API_GetSchema: table dbid, metadata information, a list of all saved queries you can use, the field properties (including field help, which could be used for tooltips) and the default values for all the fields you asked for in your query. Then, in the field returns themselves, the field data is presented in a more compact form so you can immediately spot the fid and the actual field value.

Comments

Post new comment

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.

© 1997-2014 Intuit Inc. All Rights Reserved.

Online Database VeriSign Secured Web Based Software TRUSTe Certification Online Database SSAE Audit