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 |
|---|---|---|
| Copilot Studio | Premium | All Power Automate regions except the following: - China Cloud operated by 21Vianet |
| Logic Apps | Standard | All Logic Apps regions except the following: - Azure China regions |
| Power Apps | Premium | All Power Apps regions except the following: - China Cloud operated by 21Vianet |
| Power Automate | Premium | All Power Automate regions except the following: - China Cloud operated by 21Vianet |
| Contact | |
|---|---|
| technicalsupport@regoconsulting.com |
| 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 |