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
Hi @Midori.Miyata1,
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
Please be informed that a reply has been verified as correct in answering the question, and has been marked as such.
Thanks,
AHS
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.
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
