OGS Cases via API and UI

kbelyaev

Hello!

I'm looking on ongoing monitoring API, and can't understand some cases on PILOT version.

request:

POST https://api-worldcheck.refinitiv.com/v2/cases/ongoingScreeningUpdates
{
    "query": "updateDate>='1980-01-01T00:00:00Z'; (providerType=='WATCHLIST')",
    "pagination": {
        "currentPage": 1,
        "itemsPerPage": 250
    },
    "sort": [
        {
            "columnName": "updateDate",
            "order": "ASCENDING"
        }
    ]
}

Response:

{
    "query": "updateDate>='1980-01-01T00:00:00Z'; (providerType=='WATCHLIST')",
    "sort": [
        {
            "columnName": "updateDate",
            "order": "ASCENDING"
        }
    ],
    "totalResultCount": 26,
    "pagination": {
        "currentPage": 1,
        "itemsPerPage": 250,
        "totalItems": 26
    },
    "results": [
        {
            "caseSystemId": "5jb69uigfy7r1i99ggqdgkvmo",
            "updateDate": "2023-12-24T04:17:21.986Z",
            "numberOfNewResults": 0,
            "numberOfUpdatedResults": 1
        },
        {
            "caseSystemId": "5jb72ggl8ldk1i99g63lf8m2u",
            "updateDate": "2023-12-24T08:46:51.798Z",
            "numberOfNewResults": 0,
            "numberOfUpdatedResults": 1
        },
        {
            "caseSystemId": "5jb85z1vg5t31i99g3qr3ursx",
            "updateDate": "2023-12-24T14:52:08.702Z",
            "numberOfNewResults": 0,
            "numberOfUpdatedResults": 1
        },
        {
            "caseSystemId": "5jb81j8bx5zr1i7o7cq96pg2s",
            "updateDate": "2023-12-28T15:03:45.909Z",
            "numberOfNewResults": 1,
            "numberOfUpdatedResults": 0
        },
        {
            "caseSystemId": "5jb7szfj3b8f1i8cgpzneh6py",
            "updateDate": "2023-12-29T10:48:29.801Z",
            "numberOfNewResults": 1,
            "numberOfUpdatedResults": 0
        },
        {
            "caseSystemId": "5jb6cl602p9o1iafob4zxa98q",
            "updateDate": "2023-12-30T05:03:28.907Z",
            "numberOfNewResults": 1,
            "numberOfUpdatedResults": 0
        },
        {
            "caseSystemId": "5jb6h8vlzjju1i85edsrzi918",
            "updateDate": "2024-01-03T06:00:46.026Z",
            "numberOfNewResults": 0,
            "numberOfUpdatedResults": 1
        },
        {
            "caseSystemId": "5jb81j8bx5zr1i7o7cq96pg2s",
            "updateDate": "2024-01-03T15:15:53.556Z",
            "numberOfNewResults": 1,
            "numberOfUpdatedResults": 0
        },
        {
            "caseSystemId": "5jb6h8vlzjju1i85edsrzi918",
            "updateDate": "2024-01-04T06:08:49.028Z",
            "numberOfNewResults": 1,
            "numberOfUpdatedResults": 0
        },
        {
            "caseSystemId": "5jb81j8bx5zr1i7o7cq96pg2s",
            "updateDate": "2024-01-04T15:20:23.653Z",
            "numberOfNewResults": 3,
            "numberOfUpdatedResults": 0
        },
        {
            "caseSystemId": "5jb69io9rmjb1i8v40vw4o14r",
            "updateDate": "2024-01-07T04:24:41.571Z",
            "numberOfNewResults": 1,
            "numberOfUpdatedResults": 0
        },
        {
            "caseSystemId": "5jb7rk4pf6hn1i7o7a5iqf2r2",
            "updateDate": "2024-01-07T12:43:45.627Z",
            "numberOfNewResults": 1,
            "numberOfUpdatedResults": 0
        },
        {
            "caseSystemId": "5jb7szfj3b8f1i8cgpzneh6py",
            "updateDate": "2024-01-07T13:09:12.525Z",
            "numberOfNewResults": 1,
            "numberOfUpdatedResults": 0
        },
        {
            "caseSystemId": "5jb81j8bx5zr1i7o7cq96pg2s",
            "updateDate": "2024-01-07T14:31:54.422Z",
            "numberOfNewResults": 1,
            "numberOfUpdatedResults": 0
        },
        {
            "caseSystemId": "5jb81j8bx5zr1i7o7c0ls8qc8",
            "updateDate": "2024-01-07T14:32:03.974Z",
            "numberOfNewResults": 1,
            "numberOfUpdatedResults": 0
        },
        {
            "caseSystemId": "5jb7szfj3b8f1i8cgpzneh6py",
            "updateDate": "2024-01-09T13:11:48.139Z",
            "numberOfNewResults": 2,
            "numberOfUpdatedResults": 0
        },
        {
            "caseSystemId": "5jb6h8vlzjju1i85edsrzi918",
            "updateDate": "2024-01-10T05:55:54.601Z",
            "numberOfNewResults": 0,
            "numberOfUpdatedResults": 1
        },
        {
            "caseSystemId": "5jb6mk9lwv2n1i85edsrzkbkz",
            "updateDate": "2024-01-10T06:43:34.990Z",
            "numberOfNewResults": 0,
            "numberOfUpdatedResults": 1
        },
        {
            "caseSystemId": "5jb73puatur91iafr1ioe14n8",
            "updateDate": "2024-01-10T09:12:46.318Z",
            "numberOfNewResults": 1,
            "numberOfUpdatedResults": 0
        },
        {
            "caseSystemId": "5jb81j8bx5zr1i7o7cq96pg2s",
            "updateDate": "2024-01-10T12:14:03.859Z",
            "numberOfNewResults": 2,
            "numberOfUpdatedResults": 0
        },
        {
            "caseSystemId": "5jb6h8vlzjju1i85edsrzi918",
            "updateDate": "2024-01-11T05:48:28.780Z",
            "numberOfNewResults": 0,
            "numberOfUpdatedResults": 1
        },
        {
            "caseSystemId": "5jb6mk9lwv2n1i85edsrzkbkz",
            "updateDate": "2024-01-11T06:37:01.753Z",
            "numberOfNewResults": 0,
            "numberOfUpdatedResults": 1
        },
        {
            "caseSystemId": "5jb7szfj3b8f1i8cgpzneh6py",
            "updateDate": "2024-01-11T13:14:51.045Z",
            "numberOfNewResults": 1,
            "numberOfUpdatedResults": 0
        },
        {
            "caseSystemId": "5jb81j8bx5zr1i7o7cq96pg2s",
            "updateDate": "2024-01-12T17:59:45.665Z",
            "numberOfNewResults": 1,
            "numberOfUpdatedResults": 0
        },
        {
            "caseSystemId": "5jb6h8vlzjju1i85edsrzi918",
            "updateDate": "2024-01-15T01:42:47.322Z",
            "numberOfNewResults": 0,
            "numberOfUpdatedResults": 1
        },
        {
            "caseSystemId": "5jb7szfj3b8f1i8cgpzneh6py",
            "updateDate": "2024-01-16T14:46:35.287Z",
            "numberOfNewResults": 1,
            "numberOfUpdatedResults": 0
        }
    ]
}

In response I found cases which I didn't find in UI. For example caseId's:

5jb69uigfy7r1i99ggqdgkvmo, 5jb72ggl8ldk1i99g63lf8m2u

And I found caseId in UI, which I didn't find in response:

5jb783or6elt1i8cgpzneh3wv

Can you help me with this cases? On production everything is ok.

anisetti.saikiranreddy01

Hi @kbelyaev ,

Thanks for reaching out to us!

It's not right way to compare the case results which are able to see in your WC1 UI case manager with the response which you are getting from the ongoingScreeningUpdates endpoint.

• When you initiate the endpoint SEQ-case-monitor-ogs: Monitor ongoing screening updates on cases to fetch the ongoing screening updates on cases, if any case has multiple ongoing screening updates you will be able to find multiple update dates of the same caseSystemId in the API response.

Note: Please look at the API response you have pasted above which contains caseStstemId's having multiple OGS updates.

Moreover, to achieve your use case you can utilize the endpoint [SEQ-case-search]: Search for Cases based on specified criteria from our latest postman collection which similarly works as the Case Manager in UI (Please access the following link LSEG World-Check One API to more understand about the caseSearch endpoint)

Thanks