question

Upvotes
Accepted
1 0 1 0

User Expressions in DSWS

Datastream has a length limit for expressions.

In Datastream for Excel, it's possible to create longer "User Expressions" that are assigned a code, which can then be used in requests to get around this limit

I am wondering if the same is possible for DSWS, or if there is any other solution for getting around the expression length limit?

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.

Hello @James.Bright1 and @paul.bacon,

Could you please help us answer this DSWS question?

Thank you!

Hello @James.Bright1 and @paul.bacon

Can you please help answer this question?

Thanks,

AHS

Please be informed that a reply has been verified as correct in answering the question, and has been marked as such. Thanks, AHS

1 Answer

· Write an Answer
Upvotes
Accepted
78.8k 250 52 74

@emmanuel.wildiers

I couldn't find the expression length limit mentioned in the DSWS documents. It only mentions DSWS USER STATS AND LIMITS.

You can share the expression, and then I can try it on Python DatastreamDSWS.


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

When using the request

ds.get_data(tickers='VOD', fields =['(X(F1FD12)~EB/X(P)~EB)/MAV#(X(F1FD12)~EB/X(P)~EB,3Y)'], kind=0)

the following error is returned:

'Invalid DataType. A datatype should contain between 1 and 45 characters'

There is no error message, however, when using a non-static request (kind=1).

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.