Skip to content

Instantly share code, notes, and snippets.

@L480

L480/api-call-trash-can-collection-date.md

Last active May 23, 2024 09:26
Show Gist options
  • Save L480/f6071b9e93094246296fbcad8a13a635 to your computer and use it in GitHub Desktop.
Save L480/f6071b9e93094246296fbcad8a13a635 to your computer and use it in GitHub Desktop.
Download ZIP
API call to get trash can collection date in Lübeck (including gelber Sack)
Raw
api-call-trash-can-collection-date.md

Abfuhrtermine der Entsorgungsbetriebe Lübeck (inkl. gelbe Säcke über Veolia)

Der Request wurde aus der MeinLÜBECK iOS App gecaptured. Die MeinLÜBECK App basiert auf der Whitelabel-Lösung endios one.

Request

Der Bearer Token ist statisch und hardcoded in der MeinLÜBECK App. Teilweise fehlen Abholdaten für einige Hausnummern, daher muss manchmal die Hausnummer vom Nachbarn genutzt werden.

curl -X POST https://api.endios.one/v1/connect?name=GarbageCalendarV3&widgetId=11935 \
  -H 'Content-Type: application/json' \
  -H 'Authorization: Bearer eyJlbmMiOiJBMTI4R0NNIiwiYWxnIjoiUlNBLU9BRVAtMjU2In0.ooQgQ3cn7rNYrUAzMCNWgOrylZAQGlYVDTHzl1F0W4tjpjqxacqYmEAP-RpOM3pAz0zMnSRNQTxlXO4Kz6JK_C4RgEPfwBBjXyztBt8wFi-ZRNZrG45XUDw4E966cAq2zVrImlcznmjgIHqZKlEAxxsfsQypbHQ5-57YLG5_4AKHSq3WpybpHDsTJLu9_0X-5cQQrscc6Q-KRXBi1jSXTbSvxp9w98j9S-YHRjnVHgMJWGjPA6Weru412XaLrk2Dc-OWY-GfMRNoIXstTIaDSsK8hncgZ81nCIn-Ur1Cvw26CAILYtCBkT-C82c0Q45T6LkHAOZ5scto_LfZ7W4mEA.je4kfb-NUg7DG3dY.AFVQuH4zar9REl6BR11j6dxH1POkM-uh-s7tQvTQQDajye-__vSDCHT1EC6I7uS5vcztEak_KqyVCgNSk0voQ0pc.eu0EwrsEY5E96-lzGGRl8A' \
  -d '{
    "search": {
      "zipCode": "23569",
      "streetName": "Pommernring - 11 - D"
    },
    "operation": "GARBAGE_DATA_BY_ZIP_AND_STREET_LIST"
  }'

Response

Das Abholdatum kann aus dem JSON Property collectionDate entnommen werden. Der Unix Timestamp (in milliseconds) kann per date -r $((<number> / 1000)) (zumindest auf Systemen mit GNU Coreutils) konvertiert werden.

[
    {
        "id": 240008051,
        "creationTime": 1678291037000,
        "modificationTime": 1678291037000,
        "deleted": false,
        "lockVersionNumber": 1,
        "collectionDate": 1700031600000,
        "garbageType": "Gelber Sack",
        "zipCode": "23569",
        "streetName": "Pommernring",
        "numberFrom": "",
        "numberTo": "",
        "extensionFrom": "",
        "extensionTo": "",
        "houseNumberType": "BOTH",
        "garbageGroup": {
            "id": 709,
            "creationTime": 1597410720000,
            "modificationTime": 1597736096000,
            "deleted": false,
            "lockVersionNumber": 4,
            "name": "Gelber Sack",
            "color": "#ffe51e",
            "widgetId": 11935,
            "subTitle": "",
            "title": "Gelber Sack",
            "description": "",
            "subDescription": "",
            "mainMedia": null,
            "additionalMedia": [],
            "types": [
                {
                    "id": 6204,
                    "creationTime": 1678289555000,
                    "modificationTime": 1678289555000,
                    "deleted": false,
                    "garbageType": "Gelber Sack",
                    "garbageGroupId": 709
                }
            ]
        },
        "upload": {
            "id": 917,
            "creationTime": 1678289555000,
            "modificationTime": 1678291778000,
            "deleted": false,
            "fileName": "Abfallkalender Lübeck 23 Gelber Sack (Ganzes Jahr)_1678289554831.csv",
            "url": "https://s3.eu-central-1.amazonaws.com/endios.live.garbage.collection.archive/917.csv",
            "widgetId": 11935,
            "userId": null,
            "toBeDeleted": false,
            "status": "APPROVED",
            "processedRowsCount": 96824,
            "totalRowsCount": 96824,
            "errorCount": null
        }
    },
    {
        "id": 230837665,
        "creationTime": 1676389476000,
        "modificationTime": 1676389476000,
        "deleted": false,
        "lockVersionNumber": 1,
        "collectionDate": 1700031600000,
        "garbageType": "Papiermuell",
        "zipCode": "23569",
        "streetName": "Pommernring",
        "numberFrom": "11",
        "numberTo": "11",
        "extensionFrom": "d",
        "extensionTo": "d",
        "houseNumberType": "BOTH",
        "garbageGroup": {
            "id": 714,
            "creationTime": 1597412522000,
            "modificationTime": 1597736096000,
            "deleted": false,
            "lockVersionNumber": 4,
            "name": "Papiermüll",
            "color": "#1e90ff",
            "widgetId": 11935,
            "subTitle": "",
            "title": "Papiermüll",
            "description": "",
            "subDescription": "",
            "mainMedia": null,
            "additionalMedia": [],
            "types": []
        },
        "upload": {
            "id": 867,
            "creationTime": 1676386548000,
            "modificationTime": 1676451426000,
            "deleted": false,
            "fileName": "11-2023 (Bio, Papier, Rest)_1676386547351.csv",
            "url": "https://s3.eu-central-1.amazonaws.com/endios.live.garbage.collection.archive/867.csv",
            "widgetId": 11935,
            "userId": null,
            "toBeDeleted": false,
            "status": "APPROVED",
            "processedRowsCount": 224258,
            "totalRowsCount": 224258,
            "errorCount": null
        }
    },
    {
        "id": 230922632,
        "creationTime": 1676391703000,
        "modificationTime": 1676391703000,
        "deleted": false,
        "lockVersionNumber": 1,
        "collectionDate": 1701154800000,
        "garbageType": "Biomuell",
        "zipCode": "23569",
        "streetName": "Pommernring",
        "numberFrom": "11",
        "numberTo": "11",
        "extensionFrom": "d",
        "extensionTo": "d",
        "houseNumberType": "BOTH",
        "garbageGroup": {
            "id": 713,
            "creationTime": 1597412503000,
            "modificationTime": 1597736096000,
            "deleted": false,
            "lockVersionNumber": 4,
            "name": "Biomüll",
            "color": "#366f09",
            "widgetId": 11935,
            "subTitle": "",
            "title": "",
            "description": "",
            "subDescription": "",
            "mainMedia": null,
            "additionalMedia": [],
            "types": []
        },
        "upload": {
            "id": 867,
            "creationTime": 1676386548000,
            "modificationTime": 1676451426000,
            "deleted": false,
            "fileName": "11-2023 (Bio, Papier, Rest)_1676386547351.csv",
            "url": "https://s3.eu-central-1.amazonaws.com/endios.live.garbage.collection.archive/867.csv",
            "widgetId": 11935,
            "userId": null,
            "toBeDeleted": false,
            "status": "APPROVED",
            "processedRowsCount": 224258,
            "totalRowsCount": 224258,
            "errorCount": null
        }
    },
    {
        "id": 230928606,
        "creationTime": 1676391848000,
        "modificationTime": 1676391848000,
        "deleted": false,
        "lockVersionNumber": 1,
        "collectionDate": 1701154800000,
        "garbageType": "Restmuell",
        "zipCode": "23569",
        "streetName": "Pommernring",
        "numberFrom": "11",
        "numberTo": "11",
        "extensionFrom": "d",
        "extensionTo": "d",
        "houseNumberType": "BOTH",
        "garbageGroup": {
            "id": 715,
            "creationTime": 1597412548000,
            "modificationTime": 1670858393000,
            "deleted": false,
            "lockVersionNumber": 4,
            "name": "Restmüll",
            "color": "#9b9da0",
            "widgetId": 11935,
            "subTitle": "",
            "title": "Restmüll",
            "description": "",
            "subDescription": "",
            "mainMedia": null,
            "additionalMedia": [],
            "types": []
        },
        "upload": {
            "id": 867,
            "creationTime": 1676386548000,
            "modificationTime": 1676451426000,
            "deleted": false,
            "fileName": "11-2023 (Bio, Papier, Rest)_1676386547351.csv",
            "url": "https://s3.eu-central-1.amazonaws.com/endios.live.garbage.collection.archive/867.csv",
            "widgetId": 11935,
            "userId": null,
            "toBeDeleted": false,
            "status": "APPROVED",
            "processedRowsCount": 224258,
            "totalRowsCount": 224258,
            "errorCount": null
        }
    },
    {
        "id": 240011775,
        "creationTime": 1678291088000,
        "modificationTime": 1678291088000,
        "deleted": false,
        "lockVersionNumber": 1,
        "collectionDate": 1701241200000,
        "garbageType": "Gelber Sack",
        "zipCode": "23569",
        "streetName": "Pommernring",
        "numberFrom": "",
        "numberTo": "",
        "extensionFrom": "",
        "extensionTo": "",
        "houseNumberType": "BOTH",
        "garbageGroup": {
            "id": 709,
            "creationTime": 1597410720000,
            "modificationTime": 1597736096000,
            "deleted": false,
            "lockVersionNumber": 4,
            "name": "Gelber Sack",
            "color": "#ffe51e",
            "widgetId": 11935,
            "subTitle": "",
            "title": "Gelber Sack",
            "description": "",
            "subDescription": "",
            "mainMedia": null,
            "additionalMedia": [],
            "types": [
                {
                    "id": 6204,
                    "creationTime": 1678289555000,
                    "modificationTime": 1678289555000,
                    "deleted": false,
                    "garbageType": "Gelber Sack",
                    "garbageGroupId": 709
                }
            ]
        },
        "upload": {
            "id": 917,
            "creationTime": 1678289555000,
            "modificationTime": 1678291778000,
            "deleted": false,
            "fileName": "Abfallkalender Lübeck 23 Gelber Sack (Ganzes Jahr)_1678289554831.csv",
            "url": "https://s3.eu-central-1.amazonaws.com/endios.live.garbage.collection.archive/917.csv",
            "widgetId": 11935,
            "userId": null,
            "toBeDeleted": false,
            "status": "APPROVED",
            "processedRowsCount": 96824,
            "totalRowsCount": 96824,
            "errorCount": null
        }
    },
    {
        "id": 231729065,
        "creationTime": 1676468669000,
        "modificationTime": 1676468669000,
        "deleted": false,
        "lockVersionNumber": 1,
        "collectionDate": 1702364400000,
        "garbageType": "Biomuell",
        "zipCode": "23569",
        "streetName": "Pommernring",
        "numberFrom": "11",
        "numberTo": "11",
        "extensionFrom": "d",
        "extensionTo": "d",
        "houseNumberType": "BOTH",
        "garbageGroup": {
            "id": 713,
            "creationTime": 1597412503000,
            "modificationTime": 1597736096000,
            "deleted": false,
            "lockVersionNumber": 4,
            "name": "Biomüll",
            "color": "#366f09",
            "widgetId": 11935,
            "subTitle": "",
            "title": "",
            "description": "",
            "subDescription": "",
            "mainMedia": null,
            "additionalMedia": [],
            "types": []
        },
        "upload": {
            "id": 870,
            "creationTime": 1676456888000,
            "modificationTime": 1676472229000,
            "deleted": false,
            "fileName": "12-2023 (Bio, Papier, Rest)_1676456886726.csv",
            "url": "https://s3.eu-central-1.amazonaws.com/endios.live.garbage.collection.archive/870.csv",
            "widgetId": 11935,
            "userId": null,
            "toBeDeleted": false,
            "status": "APPROVED",
            "processedRowsCount": 200396,
            "totalRowsCount": 200396,
            "errorCount": null
        }
    },
    {
        "id": 231734680,
        "creationTime": 1676468828000,
        "modificationTime": 1676468828000,
        "deleted": false,
        "lockVersionNumber": 1,
        "collectionDate": 1702364400000,
        "garbageType": "Restmuell",
        "zipCode": "23569",
        "streetName": "Pommernring",
        "numberFrom": "11",
        "numberTo": "11",
        "extensionFrom": "d",
        "extensionTo": "d",
        "houseNumberType": "BOTH",
        "garbageGroup": {
            "id": 715,
            "creationTime": 1597412548000,
            "modificationTime": 1670858393000,
            "deleted": false,
            "lockVersionNumber": 4,
            "name": "Restmüll",
            "color": "#9b9da0",
            "widgetId": 11935,
            "subTitle": "",
            "title": "Restmüll",
            "description": "",
            "subDescription": "",
            "mainMedia": null,
            "additionalMedia": [],
            "types": []
        },
        "upload": {
            "id": 870,
            "creationTime": 1676456888000,
            "modificationTime": 1676472229000,
            "deleted": false,
            "fileName": "12-2023 (Bio, Papier, Rest)_1676456886726.csv",
            "url": "https://s3.eu-central-1.amazonaws.com/endios.live.garbage.collection.archive/870.csv",
            "widgetId": 11935,
            "userId": null,
            "toBeDeleted": false,
            "status": "APPROVED",
            "processedRowsCount": 200396,
            "totalRowsCount": 200396,
            "errorCount": null
        }
    },
    {
        "id": 240015499,
        "creationTime": 1678291149000,
        "modificationTime": 1678291149000,
        "deleted": false,
        "lockVersionNumber": 1,
        "collectionDate": 1702450800000,
        "garbageType": "Gelber Sack",
        "zipCode": "23569",
        "streetName": "Pommernring",
        "numberFrom": "",
        "numberTo": "",
        "extensionFrom": "",
        "extensionTo": "",
        "houseNumberType": "BOTH",
        "garbageGroup": {
            "id": 709,
            "creationTime": 1597410720000,
            "modificationTime": 1597736096000,
            "deleted": false,
            "lockVersionNumber": 4,
            "name": "Gelber Sack",
            "color": "#ffe51e",
            "widgetId": 11935,
            "subTitle": "",
            "title": "Gelber Sack",
            "description": "",
            "subDescription": "",
            "mainMedia": null,
            "additionalMedia": [],
            "types": [
                {
                    "id": 6204,
                    "creationTime": 1678289555000,
                    "modificationTime": 1678289555000,
                    "deleted": false,
                    "garbageType": "Gelber Sack",
                    "garbageGroupId": 709
                }
            ]
        },
        "upload": {
            "id": 917,
            "creationTime": 1678289555000,
            "modificationTime": 1678291778000,
            "deleted": false,
            "fileName": "Abfallkalender Lübeck 23 Gelber Sack (Ganzes Jahr)_1678289554831.csv",
            "url": "https://s3.eu-central-1.amazonaws.com/endios.live.garbage.collection.archive/917.csv",
            "widgetId": 11935,
            "userId": null,
            "toBeDeleted": false,
            "status": "APPROVED",
            "processedRowsCount": 96824,
            "totalRowsCount": 96824,
            "errorCount": null
        }
    },
    {
        "id": 231740932,
        "creationTime": 1676468964000,
        "modificationTime": 1676468964000,
        "deleted": false,
        "lockVersionNumber": 1,
        "collectionDate": 1702450800000,
        "garbageType": "Papiermuell",
        "zipCode": "23569",
        "streetName": "Pommernring",
        "numberFrom": "11",
        "numberTo": "11",
        "extensionFrom": "d",
        "extensionTo": "d",
        "houseNumberType": "BOTH",
        "garbageGroup": {
            "id": 714,
            "creationTime": 1597412522000,
            "modificationTime": 1597736096000,
            "deleted": false,
            "lockVersionNumber": 4,
            "name": "Papiermüll",
            "color": "#1e90ff",
            "widgetId": 11935,
            "subTitle": "",
            "title": "Papiermüll",
            "description": "",
            "subDescription": "",
            "mainMedia": null,
            "additionalMedia": [],
            "types": []
        },
        "upload": {
            "id": 870,
            "creationTime": 1676456888000,
            "modificationTime": 1676472229000,
            "deleted": false,
            "fileName": "12-2023 (Bio, Papier, Rest)_1676456886726.csv",
            "url": "https://s3.eu-central-1.amazonaws.com/endios.live.garbage.collection.archive/870.csv",
            "widgetId": 11935,
            "userId": null,
            "toBeDeleted": false,
            "status": "APPROVED",
            "processedRowsCount": 200396,
            "totalRowsCount": 200396,
            "errorCount": null
        }
    },
    {
        "id": 231826067,
        "creationTime": 1676471063000,
        "modificationTime": 1676471063000,
        "deleted": false,
        "lockVersionNumber": 1,
        "collectionDate": 1703660400000,
        "garbageType": "Biomuell",
        "zipCode": "23569",
        "streetName": "Pommernring",
        "numberFrom": "11",
        "numberTo": "11",
        "extensionFrom": "d",
        "extensionTo": "d",
        "houseNumberType": "BOTH",
        "garbageGroup": {
            "id": 713,
            "creationTime": 1597412503000,
            "modificationTime": 1597736096000,
            "deleted": false,
            "lockVersionNumber": 4,
            "name": "Biomüll",
            "color": "#366f09",
            "widgetId": 11935,
            "subTitle": "",
            "title": "",
            "description": "",
            "subDescription": "",
            "mainMedia": null,
            "additionalMedia": [],
            "types": []
        },
        "upload": {
            "id": 870,
            "creationTime": 1676456888000,
            "modificationTime": 1676472229000,
            "deleted": false,
            "fileName": "12-2023 (Bio, Papier, Rest)_1676456886726.csv",
            "url": "https://s3.eu-central-1.amazonaws.com/endios.live.garbage.collection.archive/870.csv",
            "widgetId": 11935,
            "userId": null,
            "toBeDeleted": false,
            "status": "APPROVED",
            "processedRowsCount": 200396,
            "totalRowsCount": 200396,
            "errorCount": null
        }
    },
    {
        "id": 231832196,
        "creationTime": 1676471210000,
        "modificationTime": 1676471210000,
        "deleted": false,
        "lockVersionNumber": 1,
        "collectionDate": 1703660400000,
        "garbageType": "Restmuell",
        "zipCode": "23569",
        "streetName": "Pommernring",
        "numberFrom": "11",
        "numberTo": "11",
        "extensionFrom": "d",
        "extensionTo": "d",
        "houseNumberType": "BOTH",
        "garbageGroup": {
            "id": 715,
            "creationTime": 1597412548000,
            "modificationTime": 1670858393000,
            "deleted": false,
            "lockVersionNumber": 4,
            "name": "Restmüll",
            "color": "#9b9da0",
            "widgetId": 11935,
            "subTitle": "",
            "title": "Restmüll",
            "description": "",
            "subDescription": "",
            "mainMedia": null,
            "additionalMedia": [],
            "types": []
        },
        "upload": {
            "id": 870,
            "creationTime": 1676456888000,
            "modificationTime": 1676472229000,
            "deleted": false,
            "fileName": "12-2023 (Bio, Papier, Rest)_1676456886726.csv",
            "url": "https://s3.eu-central-1.amazonaws.com/endios.live.garbage.collection.archive/870.csv",
            "widgetId": 11935,
            "userId": null,
            "toBeDeleted": false,
            "status": "APPROVED",
            "processedRowsCount": 200396,
            "totalRowsCount": 200396,
            "errorCount": null
        }
    },
    {
        "id": 240019223,
        "creationTime": 1678291219000,
        "modificationTime": 1678291219000,
        "deleted": false,
        "lockVersionNumber": 1,
        "collectionDate": 1703746800000,
        "garbageType": "Gelber Sack",
        "zipCode": "23569",
        "streetName": "Pommernring",
        "numberFrom": "",
        "numberTo": "",
        "extensionFrom": "",
        "extensionTo": "",
        "houseNumberType": "BOTH",
        "garbageGroup": {
            "id": 709,
            "creationTime": 1597410720000,
            "modificationTime": 1597736096000,
            "deleted": false,
            "lockVersionNumber": 4,
            "name": "Gelber Sack",
            "color": "#ffe51e",
            "widgetId": 11935,
            "subTitle": "",
            "title": "Gelber Sack",
            "description": "",
            "subDescription": "",
            "mainMedia": null,
            "additionalMedia": [],
            "types": [
                {
                    "id": 6204,
                    "creationTime": 1678289555000,
                    "modificationTime": 1678289555000,
                    "deleted": false,
                    "garbageType": "Gelber Sack",
                    "garbageGroupId": 709
                }
            ]
        },
        "upload": {
            "id": 917,
            "creationTime": 1678289555000,
            "modificationTime": 1678291778000,
            "deleted": false,
            "fileName": "Abfallkalender Lübeck 23 Gelber Sack (Ganzes Jahr)_1678289554831.csv",
            "url": "https://s3.eu-central-1.amazonaws.com/endios.live.garbage.collection.archive/917.csv",
            "widgetId": 11935,
            "userId": null,
            "toBeDeleted": false,
            "status": "APPROVED",
            "processedRowsCount": 96824,
            "totalRowsCount": 96824,
            "errorCount": null
        }
    }
]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment