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
I have figured out part of the issue, on my end anyway. I was using http rather than https, that was all that stopped me from connecting with the authenticate command. 

After connecting I am still have some small issues running doquery. I am unsure if this is an issue with my current realm or what but I will try and check into it later.