Forum Discussion

krishnanchittur's avatar
krishnanchittur
Qrew Member
7 years ago

Looking for simplest example to access quickbase using python

Can someone point me to examples that show how a quickbase/db can be accessed from the command line/using python -?  We would like to access, add, delete, change records and create reports - and in ad...
APIs and custom code
App builders
Quickbase Automations
PushpakumarGnan's avatar
PushpakumarGnan
Qrew Member
6 years ago
Hi Austin,

I changed the code to the table_id and ran the script. Still i have the following error. Can you please help?

>>> qbc.doquery(qid=1,database='bp7ejv2ma');

Traceback (most recent call last):

  File "<stdin>", line 1, in <module>

  File "/anaconda3/lib/python3.7/site-packages/pyqb/__init__.py", line 150, in doquery

    res = self.__request('DoQuery', database, req)

  File "/anaconda3/lib/python3.7/site-packages/pyqb/__init__.py", line 112, in __request

    raise ResponseError('Received err #{0} : {1}'.format(errcode, errtext))

pyqb.ResponseError: Received err #83 : Invalid error code: 83



------------------------------
Pushpakumar Gnana
------------------------------
AustinK's avatar
AustinK
Qrew Commander
6 years ago
If for some reason the library above is failing there is also the example at the bottom of this post on how to do this with Requests. It is a little more involved but the example file should have everything you need.

What Python version are you using for this? Looking at pyqb it has some potential issues with newer Pythons but not much is documented. I am testing it again myself and running into some issues using the newest Python. It worked fine for me before. I will let you know if I find anything out.

So far I have tried to authenticate via username and password, user token, and app token. None of them seemed to work but I may be missing something easy here.