1 Reply Latest reply on Aug 31, 2007 6:51 AM by acrocker

    Flex and Intuit QuickBase

    Jarred@Intuit
      I'm using an http service object to open a connection to the Intuit QuickBase API, but the Flex error checker doesnt like
      the use of QuicKBase's query language in the XML. Any ideas on how to get around this?

      See the <query> parameter, it wont allow me to use { }

      <mx:HTTPService id="QueryQBase" url="https://www.quickbase.com/db/bcm8g4h74?act=API_DoQuery" method="POST">
      <mx:request>
      <query>{3.GT.1}</query>
      <fmt>structured</fmt>
      <clist>7.8.10.24</clist>
      <slist>6</slist>
      <options>sortorder-A</options>
      </mx:request>
      </mx:HTTPService>
        • 1. Flex and Intuit QuickBase
          acrocker
          To use curly bracers you will need to setup a var in the action script:

          <mx:Script>
          <![CDATA[
          [Bindable]
          public var query:String="{'11'.EX.'1'}";

          ]]>
          </mx:Script>

          So the HTTPService call to QuickBase would look something like this:

          <mx:HTTPService id="srvComment" url="https://www.quickbase.com/db/bcunhqa6u">
          <mx:request>
          <a>API_DoQuery</a>
          <query>{query}</query> <!-- {'7'.EX.'Fred'} -->
          <clist>6.7.8.9.11.12.1</clist>
          <slist>1</slist>
          <fmt>flat</fmt>
          <options>sortorder-D</options>
          <username>{user.text}</username>
          <password>{pwd.text}</password>
          </mx:request>
          </mx:HTTPService>

          Also, in case people don't know the QuickBase API is here:
          QuickBase API

          The API also shows well formed querys.

          Cheers!