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

@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:IBM&datatypes=X&datekind=Snapshot&start=&end=&freq=&props= 

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