Recent Issues QB API through Java HttpClient

  • 0
  • 1
  • Question
  • Updated 10 months ago
  • In Progress
We've been experiencing some weird issues lately related to the Quickbase API and accessing it via a java httpClient.  We've used the API for ~7 years now and recently, our requests have stopped working for some reason.  They seem to be working after a restart for approximately 8 hours and then just stop working afterward, no exceptions, no indication of the cause. 

Has anyone experienced anything similar?  Anyone have any solutions?

For reference, we make a GET request to the API_Authenticate and then utilizing the API_DoQuery api to query tables in the Quickbase.  We do this for every request so I don't think it would be a session timeout issue unless something has changed on the QB side.

Thanks in advance,
Brett
Photo of Brett

Brett

  • 110 Points 100 badge 2x thumb

Posted 10 months ago

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

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 27,954 Points 20k badge 2x thumb
Might you be hitting a quota on the number of API calls you are making per day? Hard to debug without access to server logs. Unless someone else has had the same problem and found a resolution your probably have to go through support. If they get you a resolution I would like to know learn what the issue was.
Photo of Evan Martinez

Evan Martinez, Community Manager

  • 9,264 Points 5k badge 2x thumb
Hi Brett,

Dan is correct that your best bet for a first step is to submit a ticket to our Support Team so that they can help you to look into those API calls and try to identify where in the process they are failing. They can help you to check for errors that might not be getting caught on your end. Quick Base Support can be accessed by clicking the Help Question Mark at the top right hand corner of the screen when signed into an application or from the My Apps page. Once the help page opens up you would select manage support cases.



Thank you very much for your time today Brett.
Photo of Brett

Brett

  • 110 Points 100 badge 2x thumb
Thanks, I reached out to support and they told me to reach out here...
Photo of Evan Martinez

Evan Martinez, Community Manager

  • 9,264 Points 5k badge 2x thumb
When you run these calls Brett what error messages are you getting back when they fail?
Photo of Brett

Brett

  • 110 Points 100 badge 2x thumb
None, unfortunately it simply isn't returning any data.  It could be a lack of logging on our side but it's hard to tell.  I'm starting to thing that the API_Authenticate doesn't refresh the ticket each time it's called which is allowing our httpClient's session to expire and simply denying the requests afterward.  It would have been a change on the QB side as we've always done it this way but can't find any details. 
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 27,694 Points 20k badge 2x thumb
You need to log the XML response returned by API_Authenticate. It will look like this:
<qdbapi>
  <action>api_authenticate</action>
  <errcode>0</errcode>
  <errtext>No error</errtext>
  <ticket>2_beeinrxmv_dpvx_b_crf8ttndjwyf9bui94rhciirqcs</ticket>
  <userid>112245.efy7</userid>
</qdbapi>
I don't know the range of errors off the top of my head because it is hard to get the credentials wrong and I have never had a problem.

Something changed either on your end or theirs.

https://help.quickbase.com/api-guide/index.html#authenticate.html
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 27,694 Points 20k badge 2x thumb
BTW, it would be extremely unlikely to me that QuickBase would not return a new ticket each and every time you call API_Authenticate.
Photo of Evan Martinez

Evan Martinez, Community Manager

  • 9,264 Points 5k badge 2x thumb
I would agree with Dan to my understanding API_Authenticate is set up to return a new ticket for each call. What time interval do you set your API_Authenticate tickets to?
(Edited)