Records Missing when fetching data from JET API for vessel movement history

ayerajothi
ayerajothi
in App Studio

Hi Team,

We fetched Vessel Movement History data from EIKON using JET API. In EIKON we have parameters to filter the data. The parameters are 48 hours, 7 days, 14 days, etc. But while fetching using JET API we are unable to send the hours parameter. While fetching the data using JET API, some records are missed when cross checking with Vessel Movement History Data in EIKON. Please help us resolve this issue.

Example Code as below, 

{
"instruments": ["9349679"],
"fields": [{
"name": "TR.AssetLocationDate"
},
{
"name": "TR.AssetDestination"
},
{
"name": "TR.AssetETA"
},
{
"name": "TR.AssetDateTime"
},
{
"name": "TR.AssetSpeed"
},
{
"name": "TR.AssetLocationDraught"
},
{
"name": "TR.AssetLocationType"
}],
"parameters": {
"SDate": "1",
"EDate": "-6", //This fetches for the past 7 days
"VT": "true"
}
}
Tagged:

Best Answer

  • Zhenya Kovalyov
    Zhenya Kovalyov
    Answer ✓

    48 hours is essentially 2 days, use something like this. The data that is returned is the same, JET API returns more points due to the 2 days calculation methodology. Last point returned at the moment with Eikon is 13/10/2017 23:38:00, while the API gives you 2017-10-14T01:14:48Z. If you want to display more points and filter manually, you can change eDate to -2.

    {
        "instruments":["9349679"],
        "fields":[
            {"name":"TR.AssetLocationDate"},
            {"name":"TR.AssetDestination"},
            {"name":"TR.AssetETA"},
            {"name":"TR.AssetSpeed"},
            {"name":"TR.AssetLocationDraught"},
            {"name":"TR.AssetLocationType"}
        ],
        "parameters":{
            "SDate": 0,
            "EDate": -1,
            "VT":true
        }
    }

Categories