Expand my Community achievements bar.

Dive into Adobe Summit 2024! Explore curated list of AEM sessions & labs, register, connect with experts, ask questions, engage, and share insights. Don't miss the excitement.

Flex and Intuit QuickBase

Avatar

Former Community Member
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 Reply

Avatar

Level 1
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!