URL Query Issue

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

I keep getting the blow message:


"https://winbroadband.quickbase.com/db/bkwehb3a5?act=API_DoQuery&includeRids=1\n&ticket=auth_ticket&apptoken=cf54iynbmn3sp8dzyt5w2cspbqvh&udata=mydata&query={'58'.LTE.'7'}AND{'10'.EX.' '}"


<qdbapi>
<action>API_DoQuery</action>
<errcode>4</errcode>
<errtext>Bad ticket</errtext>
<errdetail>Your ticket was not formatted correctly.</errdetail>
<udata>mydata</udata>
</qdbapi>

Photo of Shontay

Shontay

  • 490 Points 250 badge 2x thumb

Posted 3 years ago

  • 0
  • 1
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,044 Points 20k badge 2x thumb
If you are logged into QuickBase and accessing the API through the browser  you do not need to send the ticket. Under these circumstances the ticket will be sent automatically as a http-only secure cookie.
Photo of Shontay

Shontay

  • 490 Points 250 badge 2x thumb
So how do I fix the issue, I am new to API calls
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,044 Points 20k badge 2x thumb
remove the ticket from the url.
Photo of Shontay

Shontay

  • 490 Points 250 badge 2x thumb
Thanks, I removed the ticket and it returned the HTML code how do I return an actual query report
Photo of Shontay

Shontay

  • 490 Points 250 badge 2x thumb
So my question is how do you add style
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,044 Points 20k badge 2x thumb
The historic answer would be to use a XSLT stylesheet but nobody does that anymore. Instead call you API from JavaScript instead of redirecting to the API URL. XML is not intended to be displayed in the browser directly.