API_DoQuery Response Different in Web vs Terminal AppToken/UserToken

Question

Hi,Having trouble getting a DoQuery result to work with curl in terminal.&nbsp; Trying to do this way to then parse out for what I actually need.&nbsp; End goal is:
1) user scans a QR code with a client2) client sends the QR code to QuickBase3) QuickBase returns with an image URL corresponding to that QR code4) client displays the image to the user
When I do the call in the web browser with apptoken, I get the expected result (needs to be logged in).&nbsp; When I do the call in terminal with usertoken, I get a response but the response doesn't have any data in the response.&nbsp; &nbsp;Any ideas?(I also noticed I needed to use %27 instead of quotes in the web browser)I am searching field 6 to see if "1427445" is contained in that field and field 6 contains "alternate10"expected response is the file name and the URLInterestingly, when I did an API_Authenticate, and then tried in terminal with apptoken and ticket, I still got the same result!!!Web Browser:
https://domain.quickbase.com/db/table?a=API_DoQuery&amp;apptoken=xxxxxxxxxxxxxxxxxxxxx&amp;includeRids=1&amp;query={%276%27.CT.%271427445%27}AND{%276%27.CT.%27alternate10%27}&amp;clist={26.6.52}Result ( This works ):
&lt;qdbapi&gt;
&lt;action&gt;API_DoQuery&lt;/action&gt;

&lt;errcode&gt;0&lt;/errcode&gt;

&lt;errtext&gt;No error&lt;/errtext&gt;

&lt;dbinfo&gt;

&lt;name&gt;Assets&lt;/name&gt;

&lt;desc&gt;Assets available in AEM / ASC.&lt;/desc&gt;

&lt;/dbinfo&gt;

&lt;variables&gt;&nbsp;&lt;/variables&gt;

&lt;chdbids&gt;&nbsp;&lt;/chdbids&gt;

&lt;record&nbsp;rid="1158942"&gt;

&lt;filename&gt;s7-1427445_alternate10.psd&lt;/filename&gt;

&lt;social_url&gt;RESPONDS WITH THE URL TO AN ASSET WHICH I NEED SUCCESSFULLY&lt;/social_url&gt;

&lt;update_id&gt;1631916573812&lt;/update_id&gt;

&lt;/record&gt;

&lt;/qdbapi&gt;
Terminal:
curl "https://domain.quickbase.com/db/table?a=API_DoQuery&amp;usertoken=xxxxxxxxxxxxxx&amp;includeRids=1&amp;query={'6'.CT.'1427445'}AND{'6'.CT.'alternate10'}&amp;clist={26.6.52}"
Response ( does not work ):
&lt;?xml version="1.0" ?&gt;&lt;qdbapi&gt; &lt;action&gt;API_DoQuery&lt;/action&gt; &lt;errcode&gt;0&lt;/errcode&gt; &lt;errtext&gt;No error&lt;/errtext&gt;&lt;dbinfo&gt;&lt;name&gt;Assets&lt;/name&gt;&lt;desc&gt;Assets available in AEM / ASC.&lt;/desc&gt;&lt;/dbinfo&gt;&lt;variables&gt;&lt;/variables&gt;&lt;chdbids&gt;&lt;/chdbids&gt;&lt;/qdbapi&gt;
&nbsp;------------------------------Geoff Barrenger------------------------------

geoffbarrenger · Answer

Hi - Just in case anyone else searches and finds this, figured it out:
curl -X POST 'https://domain/db/table' -H 'Content-Type: application/xml' -H 'Content-Length:' -H 'QUICKBASE-ACTION: API_DoQuery' -d ' &lt;qdbapi&gt; &lt;usertoken&gt;xxxxxxxxxxxxxxxx&lt;/usertoken&gt; &lt;query&gt;{6.CT.1427445}AND{99.EX.TRUE}&lt;/query&gt; &lt;clist&gt;74.104.52&lt;/clist&gt; &lt;slist&gt;98&lt;/slist&gt; &lt;/qdbapi&gt;'The XML format doesn't return correctly in terminal - but if you pass it as xml you can get the desired result.&nbsp; I still don't know why the URL version doesn't work as well - probably a formatting or quotations issue, but this turned out great.&nbsp; &nbsp;------------------------------Geoff Barrenger------------------------------

Forum Discussion

API_DoQuery Response Different in Web vs Terminal AppToken/UserToken

1 Reply