Lieutenant Commander
Lieutenant Commander
502 views

How to fetch required data from Silk Central via Excel VBA Macros

Hi,

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.

 

Labels (6)
0 Likes
4 Replies
Micro Focus Expert
Micro Focus Expert

Hi @sunjb,

 

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:

 

https://www.microfocus.com/documentation/silk-central/206/en/silkcentral-help-en/SCTM-F5D3BF86-REPORTDATAINTERFACE-REF.html

 

Regards,

Hubert

0 Likes
Lieutenant Commander
Lieutenant Commander

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.

0 Likes
Micro Focus Expert
Micro Focus Expert

Hi @sunjb,

 

You can generate a web service token for the currently logged-in user on the user settings page:

https://www.microfocus.com/documentation/silk-central/206/en/silkcentral-help-en/SCTM-E0D16C8A-USERSETTINGSPAGE-REF.html#

 

For example:

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:

http://yourfrontendserver:19120/silk/servicesExchange?hid=reportData&reportFilterID=17&type=csv&includeHeaders=false&sid=1111111-2222-3333-4444-55555555&projectID=4

 

Regards,

Hubert

0 Likes
Lieutenant Commander
Lieutenant Commander

Thank you Hubert

Will try this out.

Really appreciate your help 🙂

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.