question

Upvotes
alistair.thomson avatar image
1 ●2 ●4 ●5

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.

wasin.w avatar image   wasin.w

Hello @alistair.thomson

Thank you for your participation in the forum. Is the reply below satisfactory in resolving your query?


If so please can you click the 'Accept' text next to the appropriate reply? This will guide all community members who have a similar question.

Thanks,


AHS

raksina.samasiri avatar image   raksina.samasiri

Hello @alistair.thomson ,

Thank you for your participation in the forum. I found that Case Number 10349245 was raised for this question so I'm closing this thread. If you need any further assistance regarding API usage, please start a new thread.

Thanks,
AHS

2 Answers

· Write an Answer
Upvotes
Jirapongse avatar image
78.8k ●250 ●52 ●74

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

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 ●2 ●4 ●5

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.

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)

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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