VBD data availability issue

Ayan
Ayan Contributor

Exchange File type

EUX CORP

EUX REF

EUX Instruments

CBT CORP

CBT REF

CBT Instruments

The above mentioned files types are not availble for the date 07-08-2017. We tried to get the entire list of files for the exchanges CBT and EUX. Also there is no link at the end of the list using which we could get next set of files. We use below queries for the same.

EUX:

curl -k -X GET -H "Content-Type: application/json" -H "Prefer: respond-async" -H "Accept-Charset: UTF-8" -H "Authorization: Token xxxxxxxxxxx" https://10.192.6.221/RestApi/v1/StandardExtractions/UserPackageDeliveryGetUserPackageDeliveriesByPackageId(PackageId='0x04f21a8d1c059cb1')

CBT:

curl -k -X GET -H "Content-Type: application/json" -H "Prefer: respond-async" -H "Accept-Charset: UTF-8" -H "Authorization: Token xxxxxxxxxxx" https://10.192.6.221/RestApi/v1/StandardExtractions/UserPackageDeliveryGetUserPackageDeliveriesByPackageId(PackageId='0x04f21a8d18559cb1')

Please let us know if we are missing anything.

Best Answer

  • Jirapongse
    Jirapongse ✭✭✭✭✭
    Answer ✓

    The response contains the "@odata.nextlink" field.

    ...
    {
    "PackageDeliveryId": "0x05d3d45a02bb3026",
    "UserPackageId": "0x04f21a8d1c059cb1",
    "SubscriptionId": "0x0400dc1d24a00cb4",
    "Name": "EUX-2017-08-09-NORMALIZEDLL2-Data-2-of-2.csv.gz",
    "ReleaseDateTime": "2017-08-10T01:00:00.000Z",
    "FileSizeBytes": 44668593,
    "Frequency": "Daily",
    "ContentMd5": "c3dad82ab5881a73c8e6d18ae0d8de81"
    }
    ],
    "@odata.nextlink": "https:\/\/hosted.datascopeapi.reuters.com\/RestApi\/v1\/StandardExtractions\/UserPackageDeliveryGetUserPackageDeliveriesByPackageId(PackageId='0x04f21a8d1c059cb1')?$skiptoken='MjAxNy0wOC0wOVQyMjo1MjoxMS42OTAwMDAw'"
    }
    ...

    {
    "PackageDeliveryId": "0x05d4cd8dbddb3036",
    "UserPackageId": "0x04f21a8d18559cb1",
    "SubscriptionId": "0x0400dc1d24a00cb4",
    "Name": "CBT-2017-08-12-NORMALIZEDLL2-Data-2-of-3.csv.gz",
    "ReleaseDateTime": "2017-08-13T03:00:00.000Z",
    "FileSizeBytes": 217,
    "Frequency": "Daily",
    "ContentMd5": "d077458a8e50482b8982349893877b7c"
    }
    ],
    "@odata.nextlink": "https:\/\/hosted.datascopeapi.reuters.com\/RestApi\/v1\/StandardExtractions\/UserPackageDeliveryGetUserPackageDeliveriesByPackageId(PackageId='0x04f21a8d18559cb1')?$skiptoken='MjAxNy0wOC0xMlQyMzoyNzoxOS4wMDYwMDAw'"
    }

    To get the next page, you need to use GET request with the URL in "@odata.nextlink" field.

    However, you can change the number of entries returned in the response by specifying odata.maxpagesize in the Prefer header.

    -H "Prefer: odata.maxpagesize=500; respond-async"

    The default maxpagesize is 250.

Answers