RegoLink for Clarity PPM
RegoLink Clarity PPM connector that allows organizations to integrate with Clarity PPM to read and load data through a robust mechanism of actions and validations
This connector is available in the following products and regions:
Service | Class | Regions |
---|---|---|
Logic Apps | Standard | All Logic Apps regions except the following: - Azure China regions |
Power Automate | Premium | All Power Automate regions except the following: - China Cloud operated by 21Vianet |
Power Apps | Premium | All Power Apps regions except the following: - China Cloud operated by 21Vianet |
Contact | |
---|---|
[email protected] |
Connector Metadata | |
---|---|
Publisher | Rego Consulting Corporation |
Website | https://www.broadcom.com/products/software/business-management/clarity-project-portfolio-management-software |
Privacy policy | https://regoconsulting.com/ |
Note
Below documentation might be incomplete due to proprietary API functionality. Please follow RegoLink Connector Documentation to obtain the user guide and connector definition.
Creating a connection
The connector supports the following authentication types:
Default | Parameters for creating connection. | All regions | Not shareable |
Default
Applicable: All regions
Parameters for creating connection.
This is not shareable connection. If the power app is shared with another user, another user will be prompted to create new connection explicitly.
Name | Type | Description | Required | ||
---|---|---|---|---|---|
Clarity PPM Password | securestring | The Clarity PPM Password for this api | True | ||
Clarity PPM URL | Clarity PPM User | securestring | The Clarity PPM URL | Clarity PPM User for this api | True |
Throttling Limits
Name | Calls | Renewal Period |
---|---|---|
API calls per connection | 100 | 60 seconds |
Actions
Execute Action |
Performs a XOG operation with the parameters and field mappings provided |
Run Query |
Returns a list of all the records provided by the NSQL Query. Allows users to filter by the NSQL parameters and use all columns as part of the response. |
Validate Lookup |
Returns the lookup values for the parameters provided. Allows to validate a single value by ID or Label, or retrieve the list of all available values |
Execute Action
Performs a XOG operation with the parameters and field mappings provided
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
Actions
|
actionID | True | string |
Select Action |
Action Dynamic Schema
|
dynamicActionSchema | dynamic |
Dynamic Schema of items in selected action |
Returns
Execute Action Response (JSON)
- response
- ExecuteActionOK
Run Query
Returns a list of all the records provided by the NSQL Query. Allows users to filter by the NSQL parameters and use all columns as part of the response.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
Queries
|
queryID | True | string |
Select Query |
Query DynamicValuesSchema
|
GetDynamicValuesSchema | dynamic |
Parameters/operations/order by/pagination of the selected query |
Returns
Validate Lookup
Returns the lookup values for the parameters provided. Allows to validate a single value by ID or Label, or retrieve the list of all available values
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
LookupType
|
LookupType | True | string |
Select Lookup Type |
Lookup
|
LookupId | True | string |
Select Lookup |
Operation
|
LookupFilterOperator | True | string |
Select Operation |
Label
|
Name | string |
Lookup Label |
|
ID
|
Id | string |
Lookup ID |
|
Return First Record Only
|
ReturnFirstRecord | string |
Return First Record Only |
Returns
Definitions
ExecuteActionOK
Execute Action Response (JSON)
Name | Path | Type | Description |
---|---|---|---|
Failed
|
Failed | integer |
Number of failure records |
Inserted
|
Inserted | integer |
Number of inserted records |
Messages
|
Messages | string |
Response warning messages |
Request
|
Request | string |
Request XML definition |
Response
|
Response | string |
Response XML |
Status
|
Status | integer |
Response Status (0: Failure - 1: Success - 2: Error) |
Total
|
Total | integer |
Total number of records |
Updated
|
Updated | integer |
Number of updated records |