For a deeper look into our DataScope Select SOAP API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials

question

Upvotes
Accepted
Beera.Rajesh avatar image
262 ●8 ●9 ●15

In DSS Scheduled Workflow, I am trying to create a schedule where Triggered By : Data Availability.


I am able to do only below FIXED TIME trigger only: I would like to set Triggered By Data Avaiability:

{

"Name": "IBMN-EOD",

"TimeZone": "Coordinated Universal Time",

"Recurrence": {

"@odata.type": "#ThomsonReuters.Dss.Api.Extractions.Schedules.WeeklyRecurrence",

"Days": [

"Monday",

"Tuesday",

"Wednesday",

"Thursday",

"Friday"

]

},

"Trigger": {

"@odata.type": "#ThomsonReuters.Dss.Api.Extractions.Schedules.TimeTrigger",

"LimitReportToTodaysData": false,

"At": [

{

"Hour": "03",

"Minute": "0"

}

]

},

"ListId": "0x0738d4ccb076cd21",

"ReportTemplateId": "0x0738d4e52486cd21"

}


dss-rest-apidatascope-selectdss
triggered-by-data-availability.png (58.3 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

1 Answer

Upvotes
Accepted
Jirapongse avatar image
38.1k ●71 ●35 ●53

@Beera.Rajesh

We have an article: Data Availability Trigger for EOD Pricing Extraction in DataScope Select.

It demonstrates how to extract End of Day data using Data Availability trigger and extract data at the estimated data availability time. I hope this answer helps you.

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Beera.Rajesh avatar image Beera.Rajesh

Thank you, Jirapongse.I am able to create a schedule based on Data Availability. However, the article talks only about .P trigger<Use initial end of day prices >.

How about .E file trigger which mean<Use validated end of day prices >. If I want output file triggered based on Validated End Of Day Prices?

veerapath.rungruengrayubkul avatar image veerapath.rungruengrayubkul

@Beera.Rajesh

You need to add "IsErrorCorrected" in ExtendedTriggerInformation for "Use validated end of day prices". Below is the sample.

{
  "Name": "eodTriggerZ",
  "TimeZone": "Central Standard Time",
  "Recurrence": {
    "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.Schedules.SingleRecurrence",
    "ExtractionDateTime": "2020-08-24T00:00:00.000Z",
    "IsImmediate": false
  },
  "Trigger": {
    "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.Schedules.DataAvailabilityTrigger",
    "LimitReportToTodaysData": true,
    "ExtendedInformation": {
    "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.Schedules.EndOfDayExtendedTriggerInformation",
      "IsErrorCorrected": true,
      "IsDelta": false
    }
  },    
  "ListId": "{
                   {listId}}",
  "ReportTemplateId": "{
                   {reportTemplateId}}"
}

1598262137214.png (62.5 KiB)
Click below to post an Idea Post Idea