question

Upvotes
1 2 2 4

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 512.0 KiB each and 1.0 MiB total.

Upvotes
47.2k 109 44 60

@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 512.0 KiB each and 1.0 MiB total.

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
1 2 2 4

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 512.0 KiB each and 1.0 MiB total.

@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)