How to download daily congestion data by anchorage zone in excel or API?

How to download daily congestion data by anchorage zone by API?

1727428004510.png

Please see the Daily Congestion section. We can download it via excel but is there a way to code that file into API?


Or is there a API that lets you show the congestion data that is arranged by anchorage zone?

Best Answer

  • Jirapongse
    Jirapongse ✭✭✭✭✭
    Answer ✓

    @marceugene.belen

    Thank you for reaching out to us.

    I checked the Excel file. It contains a list of instruments and the Data Retrieval Example sheet that uses RDP.HistoricalPricing to retrieve historical data. The API can be used to retrieve the same historical data as RDP.HistoricalPricing. You can use the LSEG Data Library for Python and the examples are on GitHub.

    Morever, you can use the Search feature in the API to search for instruments. For example:

    df = ld.discovery.search(
            view = ld.discovery.Views.PHYSICAL_ASSETS,
            query = f"Durban Anchorage",
            #select = "DocumentTitle,AssetCategory,RIC,RCSAssetCategoryName",
            top = 500
        )
    df

    1727857625994.png

    For more information, please refer to the Building Search into your Application Workflow article.