Store data from get API into Database using Python 3

Question

I've seen an example on how to store data coming from get API to sqlite db from the following link Insert data into sqlite3 database with API. However, I couldn't understand this part of the code:

drivers = d["MRData"]["DriverTable"]["Drivers"]

Can someone please show me how we can store data from APi as shown in the shared link or at least clarification of that line of the code which I didn't understand?

Thanks

Night King · Accepted Answer · 2020-07-01 08:37:49Z

1

There is a nesting in the d json object. so the above example is accessing the json like this:

d =  { 
    "MrData":{
         "DriverTable":{
             "Drivers":{
                 "familyName": "albert",
                 "permanentNumber": 200
             }
         }
    }
}

I hope this illustrates what is going on

answered Jul 1, 2020 at 8:37

Night King

4654 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

7 Comments

Night King Over a year ago

@Joe does this clarify your confusion

Joe Over a year ago

Thanks Night King. In this case, the Drivers is the name of the table, so what about MrData and DriverTable? what should I replace ["MRData"]["DriverTable"] with? Thanks

Night King Over a year ago

if you go to this link ergast.com/api/f1/2019/drivers.json

Night King Over a year ago

can i see your own json file @Joe

Joe Over a year ago

Can't share the whole api response but this is a snap for it: {'data': {'name': 'edward', 'description': 'my description','date': '01-01-2020','id': 'myStringID'}}

|

Collectives™ on Stack Overflow

Store data from get API into Database using Python 3

1 Answer 1

7 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

7 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related