在返回JSON以插入SQLite数据库时使用offset和limit

Question

我正在尝试如何使用python从api获取json并将其插入SLQlite数据库。对于有限数量的记录，我可以这样做，但面临的问题是，我使用的api需要限制和偏移量来获取大量记录。我需要一些关于python的帮助-谢谢你的建议。在

json是这样的：

{ "meta": {
        "result_count":1025 ,
        "cluster_counts" : {},
        "clusters" : [] ,
        "group_details": [] },
  "records": [
    {
        "pk": 19577,
        "model": "collection.museumobject",
        "fields": {
            "primary_image_id": "2006AJ6728",
            "rights": 3,
            "year_start": 1600,
            "object_number": "O61539",
            "artist": "Fiamengo, Iacopo",
            "museum_number": "W.36:1, 2-1981",
            "object": "Cabinet",
            "longitude": "14.25185000",
            "last_processed": "2016-07-30 05:37:55",
            "event_text": "",
            "place": "Naples",
            "location": "Europe 1600-1815, room 6, case CA11",
            "last_checked": "2016-07-30 05:37:55",
            "museum_number_token": "w361981",
            "latitude": "40.83990100",
            "title": "",
            "date_text": "about 1600 (Made)\nca. 1600 (made)",
            "slug": "cabinet-fiamengo-iacopo",
            "sys_updated": "2016-07-07 00:00:00",
            "collection_code": "FWK"
        }
    }

我的代码尝试是：

^{pr2}$