question

Upvotes
Accepted
9 1 1 1

Datastream Web Service "Excel template (DatastreamWebService_Rest.xlsm" question

I have 3 questions on Excel template "DatastreamWebService_Rest.xlsm"

1. Response in “DatastreamResponses” sheet shows the request responses in vertical order for “Get DataBundle” Is it possible to arrange the responses in horizontal or multiple sheet by requests?

2. Does it work properly if the user copies VBA code in Module1 to other Excel file?

3. What is the difference between “Get Data(REST)” bottom and “Get Data(REST_POST)”


Thanks, Midori

datastream-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
Accepted
45.3k 103 44 60

@Midori.Miyata1

Please be informed that DatastreamWebService_Rest.xlsm is just an Excel VBA sample using the Datastream REST web service for getting data.

1. Response in “DatastreamResponses” sheet shows the request responses in vertical order for “Get DataBundle” Is it possible to arrange the responses in horizontal or multiple sheet by requests?

Yes, it is possible but you need to modify the example to arrange the responses in horizontal or multiple sheet by requests

2. Does it work properly if the user copies VBA code in Module1 to other Excel file?

Yes, it will work on other Excel files but you need to modify it to make it work on other Excel files.

3. What is the difference between “Get Data(REST)” bottom and “Get Data(REST_POST)”

The Get Data (REST) uses HTTPS GET passing the request parameters using the URL query string. It looks like:

https://product.datastream.com/dswsclient/V1/DSService.svc/rest/Data?token=<token>&instrument=U%3aIBM&datatypes=X&datekind=Snapshot&start=&end=&freq=&props= 

The Get Data (REST_POST) uses HTTPS POST passing the request parameters using the POST data.

1643360181032.png


1643360181032.png (24.5 KiB)
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
9 1 1 1

Thank you for your reply. I have an additional questions on 1 and 2.

#1 Question: Would you please advise the VB code to arrange the responses in horizontal by requests?

#2 Question : Would you please advise VB code to modify to make it work on other Excel files?

Thanks, Midori

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.