Example: Reviewing Process Statuses with Certify Results API

This example shows you how to review the number of Certify processes that are complete or in development with Certify Results API.

Prerequisites

  1. Update processes with the appropriate development status in the Certify Process Editor.

  2. Generate a token in Certify Results API. For more information, see Generating a Token in Certify Results API.
  3. If Microsoft® Excel® is going to be used to access data from Certify Results API, install the Microsoft Power Query plug-in. For more information, see https://support.microsoft.com/en-us/office/introduction-to-microsoft-power-query-for-excel-6e92e2f4-2079-4e1f-bad5-89f6269cd605 and https://www.microsoft.com/en-us/download/details.aspx?id=39379&CorrelationId=0a1fb29a-5281-4097-b3e6-431367168cc1.

API Endpoints

Microsoft Excel Example

  1. Open Certify Results API Swagger page:

    http(s)://yourdomain/CertifyResultsAPI/swagger/ui/index

  2. Generate a token. For more information, see Generating a Token in Certify Results API.

  3. Add the API token to Swagger.

  4. Enter the required inputs to the GET /api/v1/projects/{projectName}/Process/Folder/{processFolder} endpoint as described in the above API Endpoints section.

  5. Click the Try it out! button.

  6. Copy the URL that was generated in the Request URL section.

    Example:

    http://certifydemo/CertifyResultsAPI/api/v1/projects/Functional%20Tests/Process/Folder/%2FFunctional%20Tests%2F1-%20Regression%20Tests

  7. Open Microsoft Excel.

  8. Click the Data tab.

  9. From the Data tab, click the From Web button.

    The From Web dialog opens.

  10. Select the Advanced option.

  11. In the URL parts field, paste the resultsAPIResultsFolderUrl value.

  12. From the HTTP request header parameters (optional) field, enter token.

  13. In the second field, paste the resultsAPIToken value.

  14. Click OK.

  15. From the Query window in Microsoft Excel, edit the query name to Process Development Status.

  16. Click the To Table button to expand the data.

    The To Table dialog opens.

  17. Click OK.

  18. In the Queries window, click the Expand button on the right corner of the first column.

  19. Select the following columns:
  20. ProcessID
  21. ProcessName
  22. ProcessFullName
  23. DevelopmentStatus
  24. CreatedByUser
  25. ModifiedByUser

  1. (Optional) Expand the UserName column and select the two following columns:
  2. CreatedByUser
  3. ModifiedByUser

  1. Click the Close & Load button.

    A new sheet with the tabular data is populated.

    The data can be used to create pivot tables and charts using Excel.

  2. Save the file.

  3. In the Data tab, click the Refresh All button to pull live data.

 

Related Topics Link IconRelated Topics