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	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

Operation ID:

ExecuteAction

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

Operation ID:

RunQuery

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

The outputs of this operation are dynamic.

Validate Lookup

Operation ID:

ValidateLookup

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

The outputs of this operation are dynamic.

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