Forum Discussion

MatthewDonovan's avatar
MatthewDonovan
Qrew Trainee
6 years ago

Error 22: Sign in Required after multiple submissions

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!
APIs and custom code

2 Replies

Sort By
  • NeilServices's avatar
    NeilServices
    Qrew Member
    6 years ago
    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
  • MatthewDonovan's avatar
    MatthewDonovan
    Qrew Trainee
    6 years ago
    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!