How to create a URL Query

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered
Photo of Shontay

Shontay

  • 490 Points 250 badge 2x thumb

Posted 3 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 64,658 Points 50k badge 2x thumb
Perhaps you need to supply the application token in the format

&apptoken=xxxxxxxxxxxxx

Where the xxxxx cab be generated by settings and app properties.

Also I think it's supposed to be

?act=API_ .......

Not

?a=API_......
Photo of Shontay

Shontay

  • 490 Points 250 badge 2x thumb
"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.' '}"


now I am getting the message below:
<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 David Maskasky

David Maskasky

  • 100 Points 100 badge 2x thumb
It looks like it you have literally coded the string 'auth_ticket'.  If you are executing this from your browser and have already signed in, you do not need to specify the ticket.
If you are running this from something other than a browser such as Python, you will need to capture the ticket from API_Authenticate.  Please keep in mind that API_Authenticate does not work for SAML-enabled users.  If you don't know what that means, then you likely don't have to worry about it.  If you do, then you can now user user tokens, a new feature of Quickbase!  Please let me know if you need any more help with this.