all() method gives an empty list for a json file that contains data

s1782662

Hi,

I have a JSON file that contains the data {"standard": {"1": {"category": "sport", "name": "climbing"}}}. And i instantiate TinyDB('specifying the path to the json'). so
db = TinyDb('db.json').

Now If I want to retrieve all the documents, I chose the method all(). The result is an empty list. Am I doing anything wrong here?. I believe the expected result is
[{"category": "sport", "name": "climbing"}]. Please help me if I am making any wrong?

msiemens

Hey s1782662 !

The default table of TinyDB is _default. To access the data you have, you need to access it using the standard table, as defined by your file:

db = TinyDB('test.json')
table = db.table('standard')
print(table.all())

This should work ?

Cheers!