QPR ProcessAnalyzer API: Difference between revisions

From QPR ProcessAnalyzer Wiki
Jump to navigation Jump to search
 
(144 intermediate revisions by 3 users not shown)
Line 1: Line 1:
QPR ProcessAnalyzer Web Service API (Application Programming Interface) can be used to automate operations and to create integration with other applications.
QPR ProcessAnalyzer API can be used to build integrations with other applications and automate operations in the process mining system.


== Functions in the Web Service API ==
QPR ProcessAnalyzer API is a JSON based API following the REST design principles. All methods (except the [[Web_API:_Token|token]] and [[Web_API:_Serverinfo|serverinfo]]) require a prior login to establish a session. The session is initialized with the [[Web_API:_Token|token]] call with username and password, and the access token is returned as a response for a successful login. The methods requiring prior authenticated session, need to have a HTTP request header ''Authorization'' with value ''Bearer <access token>'' to identify the session.
The following functions are available:
* [[QPR ProcessAnalyzer API: GetModel|GetModel]]: Can be used to query QPR ProcessAnalyzer model related information.
* [[QueryObjectProperties (API)|QueryObjectProperties]] returns all the listed properties queried for all the listed objects identified by unique identifiers.
* [[QPR ProcessAnalyzer API: SetModel|SetModel]]: Can be used to set model related information.
* [[ValidateModel (API)|ValidateModel]] can be used to perform all the pending tasks stored in the work queue of the given model.


== Common Properties for all Object Types ==
Url for calling the API has the following form (replace the server hostname with a correct one):
The following properties are supported by all ProcessAnalyzer object types. These properties are used in the '''properties''' parameter of the [[QueryObjectProperties (API)|QueryObjectProperties]] function:
<pre>
* '''typename''': Name of the type of the object.
https://customer.onqpr.com/qprpa/api/<methodName>
* '''name''': Name of the given object.
</pre>
* '''properties''': List of all the supported properties for given object.
* '''relatedcount''': Integer number of how many child nodes there are in the next level of given hierarchy. This is 0 if the element doesn't support the relation or there are no child objects for the given object in given hierarchy. Requires hierarchy-parameter to be defined.


== Object Types ==
Following methods are available:
=== DataTable ===
{| class="wikitable"
The following properties are supported by the DataTable object type:
!'''Method'''
* '''typename''': "DataTable"
! '''Description'''
* '''<column identifier>''': A Data Table column name converted to script name and also prefixed with"custom_" when used as an object property name in QueryObjectProperties. For example: when the Data Table column name is "Actual", the column identifier is "custom_actual".
|-
* All [[QPR ProcessAnalyzer Web Service API#Common Properties for all Object Types|common properties]]
||[[Web_API:_Token|token]]
||Login user using username and password and get a session token as a response.
|-
||[[Web_API:_Signout|api/signout]]
||Logs out a user session.
|-
||[[Web_API:_Expression|api/expression]]
||Runs an expression.
|-
||[[Web_API:_Expression/query|api/expression/query]]
||Runs query written using the expression language and returns result data as response.
|-
||[[Web_API:_Filters|api/filters]]
||Get filters for all models or filters for a single model.
|-
||[[Web_API:_Serverinfo|api/serverinfo]]
||Returns common system information needed by UI, such as the default UI language and in whether SSO has been configured.
|-
||[[Web_API:_Importfile|api/importfile]]
||Import data into datatable from .csv, .xes or .pacm file.
|-
||[[Web_API:_Usersettings|api/usersettings]]
||Save user specific settings to the server.
|-
||[[Web_API:_Operations/terminate|api/operations/terminate]]
||Stops the defined tasks (by the task id) to save computing resources.
|-
||[[Web_API:_Cancel|api/analysis/cancel]]
||Stops currently running tasks (by the task identifier) to save computing resources.
|-
||[[Web_API:_saml2/acs|api/saml2/acs]]
||Identity provider (IdP) will send the SAML 2.0 assertion to this endpoint, which responses with 302 to redirect to QPR ProcessAnalyzer UI.
|-
||[[Web_API:_saml2|api/saml2]]
||Returns the SAML 2.0 service provider (SP) metadata, if SAML 2.0 authentication has been configured.
|}


=== Product ===
In addition, there are methods for
Properties of Product object type:
* [[Web API for Workspace Elements|moving and deleting workspace elements]]
* '''typename''': "product"
* [[Web_API_for_Projects|projects]]
* '''name''': Name of the product (QPR ProcessAnalyzer)
* [[Web_API_for_Dashboards|dashboards]]
* '''version''': Dll version of the Qpr.ProcessAnalyzer.Core.dll
* [[Web_API_for_Models|models]]
* All [[QPR ProcessAnalyzer Web Service API#Common Properties for all Object Types|common properties]]
* [[Web_API_for_Datatables|datatables]]
* [[Web_API_for_Scripts|scripts]]
* [[Web_API_for_User_Management|users, groups and roles]]


Relations of Product object type:
== Examples ==
* '''related''': Returns the related objects. Supported relation hierarchies is '''datatable''' which returns all the projects available for the user.
=== Trigger script run ===
Following function written in Python starts a script in QPR ProcessAnalyzer by calling the REST API. The function does following: (1) login to QPR ProcessAnalyzer, (2) start the script, and (3) log out. The call just starts the script without waiting for it to complete (asynchronous behavior).


=== Project ===
<syntaxhighlight lang="python" line>
Properties of the Project object type:
def startQprProcessAnalyzerScript(serverUrl: str, username: str, password: str, scriptId: int):
* '''typename''': "Project"
  loginData = {
* All [[QPR ProcessAnalyzer Web Service API#Common Properties for all Object Types|common properties]]
    "grant_type": "password",
    "username": username,
    "password": password
  }
  loginResponse = requests.post(
    url = serverUrl + "/token",
    data = loginData
  )
  loginResponse.raise_for_status()
  sessionToken = loginResponse.json().get("access_token")
 
  startScriptResponse = requests.post(
    url = serverUrl + "/api/scripts/run/" + str(scriptId),
    headers = {
      "Authorization": "Bearer " + sessionToken,
      "Content-type": "application/json"
    }
  )
  startScriptResponse.raise_for_status()


Relations of the Project object type:
  logOutResponse = requests.post(
* '''related''': Returns the related objects. Supported relation hierarchies: '''datatable''' which returns all the data tables in given project available for the user.
    url = serverUrl + "/api/signout",
    headers = {
      "Authorization": "Bearer " + sessionToken,
      "Content-type": "application/json"
    }
  )
  logOutResponse.raise_for_status()
</syntaxhighlight>


== Identifying QPR ProcessAnalyzer Objects ==
The function can be called as follows:
QPR ProcessAnalyzer unique identifiers are used to uniquely identify any object in QPR ProcessAnalyzer. The format of a unique identifier is:
<syntaxhighlight lang="python" line>
startQprProcessAnalyzerScript(
  serverUrl = "https://server.onqpr.com/qprpa",
  username = "qpr",
  password = "demo",
  scriptId = 1
)
</syntaxhighlight>
The script id can be found in the scripts list in the Workspace.


'''PA.<type>.<object>'''
=== Synchronize users and groups ===
Following script written in Python updates QPR ProcessAnalyzer users and groups based on the provided dataset. This script can be extended to fetch the user data from an external source (e.g., Azure AD) to implement a complete user management integration between the systems.


In the format, '''<type>''' can be any of the following:
This script performs following steps:
* '''0''': undefined (reserved, do not use)
# Read the provided dataset and store it to in-memory structures.
* '''1''': project
# Read all users from QPR ProcessAnalyzer (including which groups the users belong to). (POST /api/expression/query)
* '''2''': data table
# Read all groups from QPR ProcessAnalyzer. (POST /api/expression/query)
* '''3''': model
# Determine the gap between the current state in the user management and the provided dataset.
* '''4''': filter
# Create new users appearing in the dataset to QPR ProcessAnalyzer. (POST /api/users)
* '''5''': bookmark
# Inactivate non-existing users in the dataset from QPR ProcessAnalyzer. (PUT /api/users)
# Activate existing inactive users in QPR ProcessAnalyzer that exist in the dataset. (PUT /api/users)
# Add users to groups and remove from groups based on the determined gap in the state. (PUT/DELETE /api/users/memberships)


== Example Usage==
Users are queried as follows:
<pre>
<pre>
//login               
{
$.ajax({
  "Dimensions": null,
  "method": "POST",
  "Values": [
  "url": "http://localhost/qprpa/Mainservice.svc/webHttp/Authenticate",
      {
  "dataType": "json", "contentType": "application/json; charset=utf-8",
        "Name": "Id",
  "data": JSON.stringify({
        "Expression": "Id"
    'logOnName': '<username>',
      },
    'password': '<password>',
      {
    'parameters': ''
        "Name": "Name",
  })
        "Expression": "Name"
});                     
      },
      {
        "Name": "IsActive",
        "Expression": "IsActive"
      },
      {
        "Name": "Groups",
        "Expression": "ToJson(OrderByValue(Groups.Id))"
      }
  ],
  "Root": "Users",
  "ContextType": "generic"
}
</pre>


//create user
Groups are queried as follows:
$.ajax({
<pre>
  "method": "POST",
{
  "url": "http://localhost/qprpa/Mainservice.svc/webHttp/SetUser",
  "Dimensions": null,
  "dataType": "json", "contentType": "application/json; charset=utf-8",
  "Values": [
  "data": JSON.stringify({  
      {
    "sessionId": "547c1aa5-e85b-4642-bbb1-8cb656015002",
        "Name": "Id",
    "user": {"Name": "user", "FullName": "first last" },
        "Expression": "Id"
    "parameters": [{"Key": "Password", "Value": "demo"}]
      },
  })
      {
});
        "Name": "Name",
 
        "Expression": "Name"
//add user to group, value 8:12:0 is user:group:member type
      }
$.ajax({
  ],
  "method": "POST",
  "Root": "UserGroups",
  "url": "http://localhost/qprpa/Mainservice.svc/webHttp/ModifyUserRelations",
  "ContextType": "generic"
  "dataType": "json", "contentType": "application/json; charset=utf-8",
}
  "data": JSON.stringify({  
    "sessionId": "749dcbdb-e57b-434b-a739-1f4ddc7ebc30",
    "parameters": [{"Key": "AddGroups", "Value": "8:12:0"}]
  })
});
 
//log off
$.ajax({
  "method": "POST",
  "url": "http://localhost/qprpa/Mainservice.svc/webHttp/LogOff",
  "dataType": "json", "contentType": "application/json; charset=utf-8",
  "data": JSON.stringify({
    "sessionId":"75aa3d08-5ad9-4b0b-8981-7daca98348cd"
  })
});
</pre>
</pre>


== PowerShell example of listing users ==
Request /api/users/memberships body:
<pre>
<pre>
$paService=New-WebServiceProxy –Uri "http://localhost/qprpa/MainService.svc"
{
$connection=$paService.Authenticate("username", "password", @())
  "GroupId": 1,
$token=$connection.GetValue(0).Value
  "MemberId": 2,
$token
  "RoleName": "Member"
$param=@()
}
$users=$paService.GetUsers($token, $null, $param)
$users
$paService | get-member | ? {$_.definition -match "GetAnalysis"}
</pre>
</pre>
<syntaxhighlight lang="python" line>
...
</syntaxhighlight>
__NOTOC__
[[Category: QPR ProcessAnalyzer]]

Latest revision as of 19:04, 13 October 2024

QPR ProcessAnalyzer API can be used to build integrations with other applications and automate operations in the process mining system.

QPR ProcessAnalyzer API is a JSON based API following the REST design principles. All methods (except the token and serverinfo) require a prior login to establish a session. The session is initialized with the token call with username and password, and the access token is returned as a response for a successful login. The methods requiring prior authenticated session, need to have a HTTP request header Authorization with value Bearer <access token> to identify the session.

Url for calling the API has the following form (replace the server hostname with a correct one):

https://customer.onqpr.com/qprpa/api/<methodName>

Following methods are available:

Method Description
token Login user using username and password and get a session token as a response.
api/signout Logs out a user session.
api/expression Runs an expression.
api/expression/query Runs query written using the expression language and returns result data as response.
api/filters Get filters for all models or filters for a single model.
api/serverinfo Returns common system information needed by UI, such as the default UI language and in whether SSO has been configured.
api/importfile Import data into datatable from .csv, .xes or .pacm file.
api/usersettings Save user specific settings to the server.
api/operations/terminate Stops the defined tasks (by the task id) to save computing resources.
api/analysis/cancel Stops currently running tasks (by the task identifier) to save computing resources.
api/saml2/acs Identity provider (IdP) will send the SAML 2.0 assertion to this endpoint, which responses with 302 to redirect to QPR ProcessAnalyzer UI.
api/saml2 Returns the SAML 2.0 service provider (SP) metadata, if SAML 2.0 authentication has been configured.

In addition, there are methods for

Examples

Trigger script run

Following function written in Python starts a script in QPR ProcessAnalyzer by calling the REST API. The function does following: (1) login to QPR ProcessAnalyzer, (2) start the script, and (3) log out. The call just starts the script without waiting for it to complete (asynchronous behavior).

def startQprProcessAnalyzerScript(serverUrl: str, username: str, password: str, scriptId: int):
  loginData = {
    "grant_type": "password",
    "username": username,
    "password": password
  }
  loginResponse = requests.post(
    url = serverUrl + "/token",
    data = loginData
  )
  loginResponse.raise_for_status()
  sessionToken = loginResponse.json().get("access_token")
  
  startScriptResponse = requests.post(
    url = serverUrl + "/api/scripts/run/" + str(scriptId),
    headers = {
      "Authorization": "Bearer " + sessionToken,
      "Content-type": "application/json"
    }
  )
  startScriptResponse.raise_for_status()

  logOutResponse = requests.post(
    url = serverUrl + "/api/signout",
    headers = {
      "Authorization": "Bearer " + sessionToken,
      "Content-type": "application/json"
    }
  )
  logOutResponse.raise_for_status()

The function can be called as follows:

startQprProcessAnalyzerScript(
  serverUrl = "https://server.onqpr.com/qprpa",
  username = "qpr",
  password = "demo",
  scriptId = 1
)

The script id can be found in the scripts list in the Workspace.

Synchronize users and groups

Following script written in Python updates QPR ProcessAnalyzer users and groups based on the provided dataset. This script can be extended to fetch the user data from an external source (e.g., Azure AD) to implement a complete user management integration between the systems.

This script performs following steps:

  1. Read the provided dataset and store it to in-memory structures.
  2. Read all users from QPR ProcessAnalyzer (including which groups the users belong to). (POST /api/expression/query)
  3. Read all groups from QPR ProcessAnalyzer. (POST /api/expression/query)
  4. Determine the gap between the current state in the user management and the provided dataset.
  5. Create new users appearing in the dataset to QPR ProcessAnalyzer. (POST /api/users)
  6. Inactivate non-existing users in the dataset from QPR ProcessAnalyzer. (PUT /api/users)
  7. Activate existing inactive users in QPR ProcessAnalyzer that exist in the dataset. (PUT /api/users)
  8. Add users to groups and remove from groups based on the determined gap in the state. (PUT/DELETE /api/users/memberships)

Users are queried as follows:

{
   "Dimensions": null,
   "Values": [
      {
         "Name": "Id",
         "Expression": "Id"
      },
      {
         "Name": "Name",
         "Expression": "Name"
      },
      {
         "Name": "IsActive",
         "Expression": "IsActive"
      },
      {
         "Name": "Groups",
         "Expression": "ToJson(OrderByValue(Groups.Id))"
      }
   ],
   "Root": "Users",
   "ContextType": "generic"
}

Groups are queried as follows:

{
   "Dimensions": null,
   "Values": [
      {
         "Name": "Id",
         "Expression": "Id"
      },
      {
         "Name": "Name",
         "Expression": "Name"
      }
   ],
   "Root": "UserGroups",
   "ContextType": "generic"
}

Request /api/users/memberships body:

{
  "GroupId": 1,
  "MemberId": 2,
  "RoleName": "Member"
}
...