302 Found

Found

The document has moved here.

Knowledge Base

Our Knowledge Base covers a wide variety of technical topics, from the basic to the complex.

How can I pull data from my QuickBase application into an ASP page?

Use the code below, substituting your own QuickBase information for the information shown in the URL statement.

<%
response.buffer=true
'*****open connection'
set DataConn=Server.CreateObject("Microsoft.XMLHTTP")
dim URL
dim cellString
%>

<%
URL = "http://www.quickbase.com/db/bav3qab6n?a=API_DoQuery&amp;qid=6&amp;fmt=structured"
DataConn.Open "GET", URL, false
DataConn.Send
set responseXML = DataConn.responseXML
set recordNodes = responseXML.selectNodes("/*/table/records/record")
%>

<table border="0" cellspacing="0" cellpadding="10" width="190">
<tr>
<td class="rightnav">Customer Stories</td>
<tr/>
<tr>
<td>
<%for i = 0 to recordNodes.length - 1
   set templateName = recordNodes(i).selectSingleNode("f[1]")
   set templateURL  = recordNodes(i).selectSingleNode("f[2]")
   cellString = "<a href=" &amp; templateURL.text &amp; ">" &amp; templateName.text &amp; "</a>"
   Response.write(cellString &amp; "<br>")
  next 
%>
</td>
</tr>
</table>

NOTE: QuickBase recommends that you use application tokens when working with API calls (read more about tokens at https://www.quickbase.com/help/app_tokens.html).

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.
302 Found

Found

The document has moved here.