Search code examples
javascriptphpjira-rest-apialmhp-quality-center

Extract data from HP QC to excel using API

I need to extract data from HP QC from backend using PHP or javascript. The data needs to be put on database or excel sheet. Is there any API to do that?

Solution

  • quite common is nowadays the QC REST API, references you can get from the below link at HP:

    http://alm-help.saas.hpe.com/en/12.53/api_refs/REST/webframe.htm#Overview.htm

    With this QC ALM you should be able to retrieve whatever data from QC backend. I am doing that using python requests module and python scripts:

    http://docs.python-requests.org/en/master/

    Anyway you have to write a bit of code before getting your goal done!

    Another API that is also possible to use for this task is the VAPI-XP, mostly used in the past, but also suitable for your goal. Official link below: http://alm-help.saas.hpe.com/en/12.50/online_help/Content/UG/c_vapixp_overview.htm

    Hope this clarify your query! Good luck and have fun!