Error 22: Sign in Required after multiple submissions

Question

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.&nbsp;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!

neilservices · Answer

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_ParametersBut you will be better off using a user token - they do not expire.&nbsp; 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.htmlIf you set one up - you don't need the initial step of authentication - you just use the usertoken in place of the ticket.&nbsp; Also note that usertokens don't require apptokens.Neil

matthewdonovan · Answer

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!

Forum Discussion

Error 22: Sign in Required after multiple submissions

Related Content

Required Field Default Lookups SSN

Interview form using multiple tables

Required Fields

Using Grid Edit to Edit Multiple Records at Once

Master’s Thesis: Request for Quick Feedback on Low-Code Platform Requirements