Format Parameter: Structured vs. Unstructured

Articles

Articles of interest to QuickBase folks

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.

Tags:

31316 reads

Comments

Post new comment

Your name: *

E-mail: *

The content of this field is kept private and will not be shown publicly.

Homepage:

Subject:

Comment: *

Input format

Filtered HTML

Web page addresses and e-mail addresses turn into links automatically.
Allowed HTML tags: <a> <p> <hr> <br> <br /> <ul> <ol> <li> <dl> <dt> <dd> <table> <tr> <td> <em> <b> <u> <i> <strong> <font> <del> <ins> <sub> <sup> <quote> <blockquote> <pre> <address> <code> <cite> <embed> <object> <param> <strike> <caption> <img> <h1> <h2> <h3> <h4>
You can enable syntax highlighting of source code with the following tags: <code>, <blockcode>, <c>, <cpp>, <drupal5>, <drupal6>, <java>, <javascript>, <php>, <python>, <ruby>, <xml>. The supported tag styles are: <foo>, [foo].
Images can be added to this post.

Plain Text

Web page addresses and e-mail addresses turn into links automatically.
Allowed HTML tags: <a> <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd>

More information about formatting options

Word verification: * 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.

Articles