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

Find more posts tagged with

datastream-api

Accepted answers

Jirapongse

@Midori.Miyata1

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

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=&lt;token&gt;&amp;instrument=U:IBM&amp;datatypes=X&amp;datekind=Snapshot&amp;start=&amp;end=&amp;freq=&amp;props=

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

All comments

Jirapongse

@Midori.Miyata1

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

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=&lt;token&gt;&amp;instrument=U:IBM&amp;datatypes=X&amp;datekind=Snapshot&amp;start=&amp;end=&amp;freq=&amp;props=

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

Midori.Miyata1

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

EXPLORE OUR SITES