TRTH api error for EOD

Hi,
One of client use TRTH api to require EOD data.
He wants to create a template for his EOD data, but always get the response with bad request.
Could you help him to find out what's going on? Thank you
There are part of the Java code:
JSONArray array = new JSONArray();
fieldList.forEach(field -> {
array.put( new JSONObject()
.put("FieldName", field)
.put( "Format", JSONObject.NULL));
});
HttpPost httppost = new HttpPost(urlHost + "/Extractions/TickHistoryIntradayElektronTimeseriesTemplates");
httppost.addHeader("content-type", "application/json;odata.metadata=minimal");
httppost.addHeader("Authorization", "Token " + sessionToken);
// Note: content fields are specific to each report template type
//
JSONOrderedObject TickTemplateJSONObject = new JSONOrderedObject().put("@odata.type",
"#ThomsonReuters.Dss.Api.Extractions.ReportTemplates.TickHistoryElektronTimeseriesReportTemplate")
.put("ShowColumnHeaders", false)
.put("Name", reportTemplateName)
.put("Headers", new JSONArray())
.put("Trailers", new JSONArray())
.put("ContentFields", array)
.put("Condition", new JSONOrderedObject()
.put( "MessageTimeStampIn", "GmtUtc" )
.put( "ApplyCorrectionsAndCancellations", true )
.put( "ReportDateRangeType", "Range" )
.put("QueryStartDate", startDate).put("QueryEndDate", endDate));
logger.info("Tick template creation JSON request content:\n" + TickTemplateJSONObject.toString());
StringEntity requestBody = new StringEntity(TickTemplateJSONObject.toString());
httppost.setEntity(requestBody);
ResponseHandler<String> responseHandler = new BasicResponseHandler();
String response = httpclient.execute(httppost, responseHandler);
JSONObject jsonResponse = new JSONObject(response);
StringWriter out = new StringWriter();
jsonResponse.write(out);
logger.info("JSON response contents:\n" + out);
reportTemplateId = jsonResponse.getString("ReportTemplateId");
Response with bad request:
Exception in thread "main" org.apache.http.client.HttpResponseException: Bad Request
at org.apache.http.impl.client.AbstractResponseHandler.handleResponse(AbstractResponseHandler.java:70)
at org.apache.http.impl.client.BasicResponseHandler.handleResponse(BasicResponseHandler.java:66)
at org.apache.http.impl.client.BasicResponseHandler.handleResponse(BasicResponseHandler.java:52)
at org.apache.http.impl.client.CloseableHttpClient.execute(CloseableHttpClient.java:223)
at org.apache.http.impl.client.CloseableHttpClient.execute(CloseableHttpClient.java:165)
at org.apache.http.impl.client.CloseableHttpClient.execute(CloseableHttpClient.java:140)
at com.algoone.quotation.trth.EODRequest.createTrthTickReportTemplate(EODRequest.java:146)
at com.algoone.quotation.trth.EODRequest.run(EODRequest.java:54)
at com.algoone.quotation.trth.EODRequest.main(EODRequest.java:36)
Best Answer
-
Please see the following comments on the code.
- The URI is not correct. The URI should be "/Extractions/ElektronTimeseriesReportTemplates"
- The "@odata.type" element is not correct. It should be "#ThomsonReuters.Dss.Api.Extractions.ReportTemplates.ElektronTimeseriesReportTemplate"
- The "MessageTimeStampIn" and "ApplyCorrectionsAndCancellations" conditions are not supported for this request. They need to be removed.
For usage example, the client can refer to REST API Reference Tree.
Anyway, the client can also verify the issue with Postman by using the JSON content request generated by the application.
0
Categories
- All Categories
- 3 Polls
- 6 AHS
- 36 Alpha
- 166 App Studio
- 6 Block Chain
- 4 Bot Platform
- 18 Connected Risk APIs
- 47 Data Fusion
- 34 Data Model Discovery
- 687 Datastream
- 1.4K DSS
- 621 Eikon COM
- 5.2K Eikon Data APIs
- 10 Electronic Trading
- Generic FIX
- 7 Local Bank Node API
- 3 Trading API
- 2.9K Elektron
- 1.4K EMA
- 254 ETA
- 557 WebSocket API
- 38 FX Venues
- 14 FX Market Data
- 1 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 23 Messenger Bot
- 3 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 60 Open Calais
- 276 Open PermID
- 44 Entity Search
- 2 Org ID
- 1 PAM
- PAM - Logging
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 22 RDMS
- 1.9K Refinitiv Data Platform
- 669 Refinitiv Data Platform Libraries
- 4 LSEG Due Diligence
- LSEG Due Diligence Portal API
- 4 Refinitiv Due Dilligence Centre
- Rose's Space
- 1.2K Screening
- 18 Qual-ID API
- 13 Screening Deployed
- 23 Screening Online
- 12 World-Check Customer Risk Screener
- 1K World-Check One
- 46 World-Check One Zero Footprint
- 45 Side by Side Integration API
- 2 Test Space
- 3 Thomson One Smart
- 10 TR Knowledge Graph
- 151 Transactions
- 143 REDI API
- 1.8K TREP APIs
- 4 CAT
- 27 DACS Station
- 121 Open DACS
- 1.1K RFA
- 104 UPA
- 193 TREP Infrastructure
- 229 TRKD
- 917 TRTH
- 5 Velocity Analytics
- 9 Wealth Management Web Services
- 90 Workspace SDK
- 11 Element Framework
- 5 Grid
- 18 World-Check Data File
- 1 Yield Book Analytics
- 48 中文论坛