Apptoken gives error 22 "sign-in required" for some tables, not for others

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered

When using the QuickBase Ruby client and do the following (information obscured by asterisks):


qbc = QuickBase::Client.init("org" => '****', "apptoken" => '*****')


and do:


db_id = '****' # dbid of a table

qbc.getSchema(db_id)


I get the error:


Error code: 22 text: Sign-in required: detail: The page you have requested can be viewed only by users who have signed in. Please sign in to proceed.

If I change the db_id to a  dbid of a specific other table in the same app, I get back a valid schema.

What is going on?


Thanks,

--Allan
Photo of Allan Schougaard

Allan Schougaard

  • 80 Points 75 badge 2x thumb

Posted 1 year ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 53,842 Points 50k badge 2x thumb
Maybe you need to use a usertoken to do the authentication.

https://help.quickbase.com/api-guide/...
Allan
It's possible that one table is open to anyone on the internet and the second table is not.  Have you tried using the URL form to see if you can access both tables using the login you are sending?  
Neil
Photo of Allan Schougaard

Allan Schougaard

  • 80 Points 75 badge 2x thumb
Dear Neil: thank you so much for responding!
That is indeed an explanation. I found this reference: https://community.quickbase.com/quickbase/topics/i-am-trying-to-make-one-form-in-a-table-public-and-...

Though, eventually I arrived at authenticating using the QuickBase Client authenticate method.

Many thanks indeed!
--Allan
Awesome - you are welcome