How to fetch required data from Silk Central via Excel VBA Macros
I was using HP-ALM OTA API and JIRA REST API to fetch combined status report.
Now, my new project is using Silk Central and requested me to setup the same report.
I searched web and could not find info which I can use.
Could you please let me know if there is anything which might help me fetch Silk Central data into Excel directly via VBA Macros like HP-ALM OTA API/JIRA REST API.
Thanks in advance.
I am not sure how exactly your old report and the environment looks like. But one thing you might check is the reportData interface, which allows you to get the data of any report with a simple HTTP request. Find more about it here:
Thanks a lot Hubert.
Hope I will be able to parse the values from csv/xml using VBA.
Could you please point out to me an example where I can use User ID and PWD instead of webServiceToken.
You can generate a web service token for the currently logged-in user on the user settings page:
Frontendserver url: http://yourfrontendserver:19120/silk
Project ID: 4
Report ID: 17
Webservice token: 1111111-2222-3333-4444-55555555
Result type: CSV
This would then be: