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.
Original Message:
Sent: 01-03-2020 10:52
From: Pushpakumar Gnana
Subject: Looking for simplest example to access quickbase using python
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
Original Message:
Sent: 01-02-2020 14:10
From: Austin K
Subject: Looking for simplest example to access quickbase using python
The error is saying one of your variables is a NoneType. So one of them is not being populated as you expect it to be.
You have no other issues with the code? Do you know if you are able to authenticate fine?
I think I may have made a slight mistake and you may need to do this command instead, as there is no database being set. Assuming you used my exact code above without any changes. The "database" part just needs to be your table ID.
qbc.doquery(qid=1, database='your_database')
Original Message:
Sent: 01-01-2020 06:51
From: Pushpakumar Gnana
Subject: Looking for simplest example to access quickbase using python
i am trying to retrieve a report from the app. it is a list all report from the test table
------------------------------
Pushpakumar Gnana
Original Message:
Sent: 01-01-2020 06:51
From: Pushpakumar Gnana
Subject: Looking for simplest example to access quickbase using python
Hi Austin,
I tried executing the commands you gave me and i get the following error. Is that something you can help me?
>>> qbc.doquery(qid=1);
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 95, in __request
url = self.url + "/db/" + db
TypeError: can only concatenate str (not "NoneType") to str
>>>
------------------------------
Pushpakumar Gnana
Original Message:
Sent: 11-26-2019 11:08
From: Austin K
Subject: Looking for simplest example to access quickbase using python
If you follow the instructions listed in the link of the post you replied to you should be able to get to the point where you extract information from Quickbase. In the link it is the first 2 things listed. "Create the client" first and then you can do one of the things below that, DoQuery sounds like what you want. So set up your Python file as the link shows.
import pyqb# def Client(url="http://www.quickbase.com", database=None, proxy=None, user_token=None):qbc = pyqb.Client(url='http://my_domain.quickbase.com')# Below authenticate is not required if `user_token` argument is passed to pyqb.Client() aboveqbc.authenticate(username='myusername', password='mypassword')
# doquery(query=None, qid=None, qname=None, database=None, fields=None, fmt=False, rids=False, sort_fields=None, options=False):qbc.doquery(qid=64)qbc.doquery(query='{"6".EX."myval"}', database='asdfasdf')qbc.doquery(qid=64, fields=["3", "4"], fmt=True, rids=False)
If you need more context on what the "6".EX."myval" and other parts mean then the QuickBase api help docs should get you there. You can choose to grab a saved report or do your own query. https://help.quickbase.com/api-guide/do_query.html
Is there any specific part that you need help with? Some part you have attempted but not been able to get to work? Maybe post the code you have tried that failed and someone can help you fix it.
When you say you would like the code to extract the data and save it in the same place as the csv do you mean save to the same place your browser would save a csv if you clicked "Save as csv" on a report? Like your downloads folder? I assume you want the data to also be the same exact csv format as you would get from QuickBase? You may need to create the csv in code then, depending on what is returned via Python. I would assume you will get XML returned though.
The post below mine by David Choi is a great example of how to connect to QuickBase without using a library like the one above. So you are not limited to what the library can do, you can make whatever API call you need. It is more involved though and probably more difficult at times.
Original Message:
Sent: 11-26-2019 08:17
From: Pushpakumar Gnanadurai
Subject: Looking for simplest example to access quickbase using python
Hi All,
Can you please let me know the steps to follow to extract data using python from quickbase
My ask is to create a python code that extracts the data from the report and save in the same location as csv file?
Can some one help me in this.
Thanks
Pushpakumar
------------------------------
Pushpakumar Gnanadurai
Original Message:
Sent: 08-06-2019 15:54
From: Andrew Ryder
Subject: Looking for simplest example to access quickbase using python
Hi,
Been using pyqb (https://github.com/sjmh/pyqb) for all of my python work w/the Quickbase API. It's not complete, but easy to fork and add to.