I am seeing 202 Accepted with header value “status” => “InProgress” and not “200 OK”.

Beera.Rajesh

Request

Header:

'prefer' => 'respond-async',
'content-type' => 'application/json; odata=minimalmetadata',
'content-length' => 0,'authorization' => 'Token _cehY******'

Body:

{
  "ExtractionRequest":
  {
    "@odata.type":"#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.TickHistoryTimeAndSalesExtractionRequest",
    "ContentFieldNames":[
      "Trade - Price",
      "Trade - Volume"
    ],
    "IdentifierList":
    {
      "@odata.type":"#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",
      "InstrumentIdentifiers":[
        { "Identifier":"VOD.L",
          "IdentifierType":"Ric"
        },
        { "Identifier":"IBM.N",
          "IdentifierType":"Ric"
        }
      ],
      "ValidationOptions":null,
      "UseUserPreferencesForValidationOptions":false
    },
    "Condition":
    {
      "MessageTimeStampIn":"GmtUtc",
      "ApplyCorrectionsAndCancellations":true,
      "ReportDateRangeType":"Range",
      "QueryStartDate":"2017-01-01T09:00:00.000",
      "QueryEndDate":"2017-01-01T10:00:00.000",
      "DisplaySourceRIC":false
    }
  }
}

Response

Code: 202 Accepted

Header:

'x-app-id' => 'Custom.RestApi',
'cache-control' => 'no-cache',
'set-cookie' => 'DSSAPI-COOKIE=R2817038826; path=/',
'date' => 'Thu, 08 Jun 2017 19:19:54 GMT',
'status' => 'InProgress',
'client-ssl-cert-issuer' => '/C=US/O=Symantec Corporation/OU=Symantec Trust Network/CN=Symantec Class 3 Secure Server CA - G4',
'client-ssl-cipher' => 'RC4-SHA',
'client-peer' => '192.165.219.152:443',
'client-date' => 'Thu, 08 Jun 2017 19:19:54 GMT',
'client-ssl-warning' => 'Peer certificate not verified',
'x-request-execution-correlation-id' => '528c84b5-da5f-42ad-9610-77d741818a07',
‘pragma' => 'no-cache',
'server' => 'Microsoft-IIS/7.5',
'client-ssl-socket-class' => 'IO::Socket::SSL',
‘client-response-num' => 1,
'location' => 'https://hosted.datascopeapi.reuters.com/RestApi/v1/Extractions/ExtractRawResult(ExtractionId=\'0x05bfd3812aab3026\')',
'progress' => '',
'content-length' => '0',
'x-app-version' => '11.0.492.64',
'client-ssl-cert-subject' => '/C=US/ST=New York/L=New York/O=Thomson Reuters/CN=hosted.datascopeapi.reuters.com',
'expires' => '-1'

This response just continuously loops. I left it for 2 hours
yesterday with no difference.

Strangely, I ran the job about ten mins ago and it actually
returned something different:

Code: 200 OK

This seems to be the correct response. I just re-ran now and
back to the infinite loop. Any ideas why it does not return something every
time?

Christiaan Meihsl

@Beera.Rajesh

The behavior you see is normal. After using POST to submit an On Demand request, receiving a 202 Accepted means the request was accepted by the server, and is currently being processed. That is why the status is In Progress.

If you POST the same query again you are submitting a second instance of the query.

So, after using POST to submit a request, you will usually receive a 202 Accepted (I say usually, because if the request is very small it might actually complete and return a 200 if it takes less than 30 seconds, but this is a rare occurence). In the 202 header you also have an item called Location, which is an URL. Save it. The next step is to query that URL with a GET, to check the status of the extraction. The location URL looks like this:

https://hosted.datascopeapi.reuters.com/RestApi/v1/Extractions/ExtractRawResult(ExtractionId='0x058dcda3c29b5841')

The GET to the location URL will either return a 202 Accepted or a 200 OK. If you receive a 202 it means the extraction has not yet completed, you must wait, and then repeat the GET query to the location URL, until you receive a 200 OK. Once you receive a 200 OK, then extract the value of the JobId (it looks like this: 0x05a64ba76a4b3036) from the body of the response.

The final step, to retrieve the data, is a GET to a URL of this form:

https://hosted.datascopeapi.reuters.com/RestApi/v1/Extractions/RawExtractionResults('0x05a64ba76a4b3036')/$value

Note that this URL contains the JobId. The response will contain the data you initially requested.

The entire workflow is described in detail in the REST API Tutorial 3.