question

Upvotes
alistair.thomson avatar image
1 ●0 ●1 ●3

How to get the next release date with DDL FTP request?

I am attempting to get the next release date for CPI and RPI.

In my request I specify

{LOGON} (REMOVED)

{FORMAT}

{EXTRACTION} X1

{TRIGGER}

NOW

{FORMAT}

SRVRFILEPREFIX=TEST

DCDEFLT=Y

MERGE=Y

TRAN=N

MNEMONIC=Y

NAME=Y

{REQTYPE} S

{DATATYPES}

DS.NDOR1_DATE

DS.NDOR1_REF_PERIOD

{INSTRUMENTS}

UKCHAW..

UKCONPRCF


And I expect it to report back the next release date for UKCHAW.. and UKCONPRCF (RPI and CPI).


The validation output reports

Extraction Definition X1 NOW

Seq 1 Static Datatypes: 0 Stocks: 2

REJECTED - SYNTAX

** End of Extraction Summary **

{EXTRACTION} X1

{TRIGGER}

{FORMAT}

{REQTYPE} S 00001

{DATATYPES}

DS.NDOR1_DATE

********* INVALID DATATYPE

DS.NDOR1_REF_PERIOD

********* INVALID DATATYPE

********* NO VALID STATIC DATATYPES

{INSTRUMENTS}

** End of Errors **

** End of Validation Report **


Where am I going wrong?


datastream-apidsws-api
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.

2 Answers

Upvotes
Jirapongse avatar image
38.1k ●69 ●35 ●53

@alistair.thomson

The DS.NDOR1 is a compound datatype.

Please try the following request. 

{DATATYPES}
DS.NDOR1
{INSTRUMENTS}
UKCHAW..
UKCONPRCF


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.

alistair.thomson avatar image alistair.thomson

Thanks. I have tried the suggested solution. I now see this in the validation output:


Seq 1 Static Datatypes: 0 Stocks: 2

REJECTED - SYNTAX

** End of Extraction Summary **

{EXTRACTION} X3

{TRIGGER}

{FORMAT}

{REQTYPE} S 00001

{DATATYPES}

DS.NDOR1

********* INVALID DATATYPE

********* NO VALID STATIC DATATYPES

{INSTRUMENTS}

** End of Errors **

** End of Validation Report **

Upvotes
alistair.thomson avatar image
1 ●0 ●1 ●3

Thanks. I have tried the suggested solution. I now see this in the validation output:


Seq 1 Static Datatypes: 0 Stocks: 2

REJECTED - SYNTAX

** End of Extraction Summary **

{EXTRACTION} X3

{TRIGGER}

{FORMAT}

{REQTYPE} S 00001

{DATATYPES}

DS.NDOR1

********* INVALID DATATYPE

********* NO VALID STATIC DATATYPES

{INSTRUMENTS}

** End of Errors **

** End of Validation Report **

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.

Jirapongse avatar image Jirapongse

@alistair.thomson

Please contact the Refinitiv Datastream Data Loader support team directly via MyRefinitv to verify the problem.

1631068320925.png

1631068320925.png (18.0 KiB)
Click below to post an Idea Post Idea