Discussions

Expand all | Collapse all

Error 22: Sign in Required after multiple submissions

  • 1.  Error 22: Sign in Required after multiple submissions

    Posted 07-12-2018 13:45
    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!


  • 2.  RE: Error 22: Sign in Required after multiple submissions

    Posted 07-13-2018 01:59
    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


  • 3.  RE: Error 22: Sign in Required after multiple submissions

    Posted 07-13-2018 12:16
    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!