exact search with cases/search api
hi, im trying to do a cases search with cases/search api, my query body is this:
{
"query": "primaryName=='google'",
"detailLevel": "CASE_AND_RESULTS_AND_AGGREGATED_RESULTS",
"sort": [
{
"columnName": "creationDate",
"order": "DESCENDING"
}
],
"pagination": {
"itemsPerPage": 25,
"pageReference": null
}
}
the problem is that this is a fussy search, it will return results with similar cases like 'google llc', 'google Ireland', 'google ltd', 'GOOGLE ASIA PACIFIC PTE LTD' etc, but we want exact search so that only cases for 'google' are returned, how can we achieve this?
Best Answer
-
William,
You can find out if a case exists or not by calling on endpoint: SEQ-case-check-caseid-availablity: Check caseId availability (HEAD https://api-worldcheck.refinitiv.com/v2/caseIdentifiers?caseId={
{available-case-id}})For this endpoint, you would need to enter the case Id. If you get a 200 successful HTTP response, it means that the case exists already. If you receive a 404 Not Found HTTP response, then it means that the case Id does not exist.
Keep in mind that when creating a case, if you don't input a string in the request body, then one is automatically created when you send the request. There's the option to input your own case Id to meet your needs and to possibly make the case Id search more straightforward. You can find more information about this endpoint here: World-Check One API Documentation
Please let me know if you have any further questions.
Regards,
Judith0
Answers
-
Hi @williamtang - thank you for your question. I am currently working on on your query, and will have a response by tomorrow. Thank you for your patience.
Blessings,
Judith
0 -
Hi @williamtang - thank you for your patience as I gathered more information about your request. The only way that you could get an exact match is if you include the caseId in your query like so: "query": "primaryName=in=(Adobe) and caseId=in=(5jb6qmaavm0x1ig2hu5qz6mtg)"
However, this sort of defeats the purpose of the search since you would already provide the case ID. Currently, the API is taking a fuzzy search and there is not another way to get an exact match. Apologies for any inconvenience this may cause you, but please let me know if you have any further questions.Blessings,
Judith
0 -
hi Judith, thanks for the quick update. our process is: if case existing, then do a rescreen request and otherwise, create a new case and screen request. if the search can only do fussy search, how can we know for sure that the case exists or not?
0 -
the thing is we are not keeping track of the case ids, we are using search to find the case id. what about if we use cases/search to fussy search and loop through the returned results to see if there is an exact match, would this work?
0 -
@williamtang - it might be worth trying, but I cannot guarantee that it would work as I only use Postman to work with the API.
0
Categories
- All Categories
- 6 AHS
- 37 Alpha
- 161 App Studio
- 4 Block Chain
- 4 Bot Platform
- 16 Connected Risk APIs
- 47 Data Fusion
- 30 Data Model Discovery
- 608 Datastream
- 1.3K DSS
- 577 Eikon COM
- 4.9K Eikon Data APIs
- 7 Electronic Trading
- Generic FIX
- 7 Local Bank Node API
- Trading API
- 2.7K Elektron
- 1.3K EMA
- 236 ETA
- 519 WebSocket API
- 33 FX Venues
- 10 FX Market Data
- 1 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 20 Messenger Bot
- 2 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 59 Open Calais
- 264 Open PermID
- 39 Entity Search
- 2 Org ID
- PAM
- PAM - Logging
- 8.4K Private Comments
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 20 RDMS
- 1.4K Refinitiv Data Platform
- 367 Refinitiv Data Platform Libraries
- 3 Refinitiv Due Diligence
- LSEG Due Diligence Portal API
- 3 Refinitiv Due Dilligence Centre
- Rose's Space
- 1.1K Screening
- 18 Qual-ID API
- 13 Screening Deployed
- 23 Screening Online
- 10 World-Check Customer Risk Screener
- 990 World-Check One
- 44 World-Check One Zero Footprint
- 45 Side by Side Integration API
- Test Space
- 3 Thomson One Smart
- 1.2K TR Internal
- Global Hackathon 2015
- 2 Specialists Who Code
- 10 TR Knowledge Graph
- 150 Transactions
- 142 REDI API
- 1.7K TREP APIs
- 4 CAT
- 21 DACS Station
- 117 Open DACS
- 1.1K RFA
- 103 UPA
- 172 TREP Infrastructure
- 224 TRKD
- 886 TRTH
- 5 Velocity Analytics
- 5 Wealth Management Web Services
- 59 Workspace SDK
- 9 Element Framework
- 5 Grid
- 13 World-Check Data File
- Yield Book Analytics
- 46 中文论坛