Error 22: Sign in Required after multiple submissions

  • 0
  • 1
  • Question
  • Updated 4 months ago
  • Answered
Hi all!

I have an excel file that submits directly to Quickbase using VBA. I have my login hard coded into the program for the authenicate call. I can run several submissions and then suddenly it tells me that I need to sign-in.

I have apptokens disabled for this app and am using the XML POST API submission. 

Each time I run the script, I grab a new ticket that expires in an hour. Are there limits to the amount of tickets a single user can obtain at a time? If that isn't it, what else might cause this problem?

Thanks!
Photo of Matthew Donovan

Matthew Donovan

  • 130 Points 100 badge 2x thumb

Posted 4 months ago

  • 0
  • 1
Matthew,
The API_Authenticate call has a parameter that allows you to request a 24 hour login - here in the guide:
https://help.quickbase.com/api-guide/index.html#authenticate.html#Request_Parameters

But you will be better off using a user token - they do not expire.  Here is a brief description of usertokens - and how to set them up and use them:
https://help.quickbase.com/user-assistance/create_user_tokens.html

If you set one up - you don't need the initial step of authentication - you just use the usertoken in place of the ticket.  Also note that usertokens don't require apptokens.
Neil
Photo of Matthew Donovan

Matthew Donovan

  • 130 Points 100 badge 2x thumb
Neil,

Thanks for the reply. As I was trying to implement the usertoken, I scanned through the user input of the table. In one of the fields, they used an ampersand of which I initially didn't think a mid-string ampersand would cause a problem... but once I removed it, it worked as intended.

Not sure why that triggered a login error or why that affected the string because it was XML. I'll make sure that I escape that character.

Thanks for the suggestion, and I still plan on implementing it!