Profisee (Preview)
The Profisee Power Platform Custom Connector enables a Profisee customer to interface with Microsoft Apps, Copilot Studio, or other that can utilize a Power Platform connector. One must have access to a Profisee instance with a current product license and an active Microsoft Azure subscription. This custom connector offers the following Profisee master data operations: create entity and attribute, create/update/delete records, get metadata, and update a color theme.
This connector is available in the following products and regions:
| Service | Class | Regions |
|---|---|---|
| Copilot Studio | Premium | All Power Automate regions except the following: - US Government (GCC) - US Government (GCC High) - China Cloud operated by 21Vianet - US Department of Defense (DoD) |
| Logic Apps | Standard | All Logic Apps regions except the following: - Azure Government regions - Azure China regions - US Department of Defense (DoD) |
| Power Apps | Premium | All Power Apps regions except the following: - US Government (GCC) - US Government (GCC High) - China Cloud operated by 21Vianet - US Department of Defense (DoD) |
| Power Automate | Premium | All Power Automate regions except the following: - US Government (GCC) - US Government (GCC High) - China Cloud operated by 21Vianet - US Department of Defense (DoD) |
| Contact | |
|---|---|
| Name | Profisee Support |
| URL | https://profisee.com/support |
| support@profisee.com |
| Connector Metadata | |
|---|---|
| Publisher | Profisee |
| Website | https://profisee.com |
| Privacy policy | https://profisee.com/privacy/ |
| Categories | AI;Data |
Profisee Master Data Management
Connector Overview
Profisee is a Master Data Management (MDM) platform that helps organizations manage their data effectively. It offers features such as integration, stewardship, governance, data quality, and workflow automation, ensuring data consistency and reliability across systems. Profisee helps deliver quantifiable cost savings and operational efficiencies by addressing data management challenges. It is designed to accept master data from any source, allowing for matching, merging, and synchronization of data.
This connector is based on the Profisee REST API and provides the ability to perform the following operations:
- Request details for one or more records from your Profisee instance given the entity name.
- Create master data records within a Profisee entity.
- Update master data records within a Profisee entity.
- Delete records within a Profisee entity.
- Create an entity.
- Create an attribute within a Profisee entity.
- Update the Profisee theme (color scheme).
- Request data quality issues for a Profisee entity.
- Request metadata for Profisee entities and attributes.
Prerequisites
You will need the following to proceed:
A Microsoft Azure subscription with permissions to create and/or configure an App Registration.A Profisee license with Super Administrator rights.Access to the Microsoft Power Platform with sufficient permissions to deploy the connector.
Deployment instructions
Please use these instructions to deploy this connector as custom connector in Microsoft Power Automate and Power Apps.
Authenticate your custom connector with Microsoft Entra ID
Create an App Registration
- Sign in to the Azure portal. If you have more than one Microsoft Entra ID tenant, make sure you're signed in to the correct directory by verifying that your user name appears in the upper-right corner.
- On the left pane, select All services. In the Filter box, enter Microsoft Entra ID, and then select Microsoft Entra ID.
- On the left pane of the Microsoft Entra ID blade, expand Manage and select App registrations.
- Select new registration.
- Give it a name and select the supported account type single tenant / multitenant based on your needs.
- Copy the Application ID, because you need it later.
- On the left pane of the App registrations blade, expand Manage and select API permissions.
- Select add permission.
- Under Delegated permissions, select Access Azure Resource Manager as organization users > Select -> Add permission.
- Go to Certificates & secrets -> add new client secret -> provide description and expiration date and click add.
- Copy the secret value you need it later.
There's one more step to complete in the Azure portal, but first you create a custom connector.
Configure Custom Connector
Access the Custom Connector Security tab in the Power Platform.
- On the Security page, select authentication type as OAuth 2.0.
- Identity provider -> Microsoft Active Directory.
- Enter Microsoft Entra ID information for the application:
- Under Client id, enter the Microsoft Entra ID application ID value you copied earlier.
- For Client secret, use the value you copied earlier.
- For Resource URL, enter https://management.core.windows.net/ Be sure to include the resource URL exactly as written, including the trailing slash.
After entering security information, select the check mark (✓) next to the flow name at the top of the page to create the custom connector.
- On the Security page, the Redirect URL field is now populated. Copy this URL so you can use it in the next section of this tutorial.
Add the redirect URL to the app registration
Select Azure Active Directory (Microsoft Entra ID), then select your app. Select Authentication from left menu, then select Add a platform -> Web Add the value you copied from the Redirect URI field in the custom connector (e.g., https://global.consent.azure-apim.net/redirect/samplecustomconnector123-5f98284236d845b802-5f21c6202f06d65e16) to the Redirect URIs then click Configure.
Other information
This link provides an overview of configuring custom connectors and Microsoft Azure Entra ID Microsoft Learn.
Profisee Support
Submit questions or request help at Profisee Support (requires an active Profisee subscription with entitlements enabled).
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.
Throttling Limits
| Name | Calls | Renewal Period |
|---|---|---|
| API calls per connection | 100 | 60 seconds |
Actions
| Create a new attribute |
This request creates a new attribute for the specified entity, attribute type, and other details. |
| Create a new entity |
This request creates a new entity with the specified name, description, icon name, and file categories. |
| Create records by entity name |
This request creates one or more records for a Profisee entity given the entity name and code values. |
| Delete a record from an entity |
This request deletes a record from a Profisee entity given the entity name and record code. |
| Get attributes metadata by entity name |
This request returns metadata for attributes given an entity name. |
| Get data quality issues by entity name |
This request returns one or more data quality issues from a Profisee entity given the entity name and, optionally, record code(s). |
| Get entity metadata by name |
This request returns metadata for a given entity name. |
| Get records by entity name |
This request returns one or more records from a Profisee entity given the entity name. |
| Update an existing theme |
This request updates an existing theme with the given theme name. |
| Update records by entity name |
This request updates one or more records for a Profisee entity given the entity name. |
Create a new attribute
This request creates a new attribute for the specified entity, attribute type, and other details.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
EntityName
|
Name | True | string |
Entity name |
|
AttributeName
|
Name | True | string |
Attribute name |
|
AttributeType
|
AttributeType | True | integer |
AttributeType |
|
DataType
|
DataType | True | integer |
Attribute data type |
|
DataTypeInformation
|
DataTypeInformation | integer |
Data type information |
|
|
IsUnique
|
IsUnique | boolean |
Is the attribute value unique |
|
|
IsRestricted
|
IsRestricted | boolean |
Is the attribute value restricted from online data entry? |
|
|
IsIndexed
|
IsIndexed | boolean |
Is the attribute valued indexed? |
|
|
DisplayWidth
|
DisplayWidth | True | integer |
Display width of attribute |
|
LongDescription
|
LongDescription | string |
Description of the attribute |
|
|
HasDefault
|
HasDefault | boolean |
Does the attribute have a default value? |
|
|
DefaultValue
|
DefaultValue | string |
Default value for the attribute if HasDefault is true |
|
|
IsCascadeDeleteEnabled
|
IsCascadeDeleteEnabled | boolean |
Is cascading delete enabled for the domain-based entity? |
|
|
DomainEntityName
|
Name | string |
Domain Entity Name |
Create a new entity
This request creates a new entity with the specified name, description, icon name, and file categories.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
id
|
id | string |
Entity ID |
|
|
name
|
name | True | string |
Entity name |
|
longDescription
|
longDescription | string |
Description of the entity |
|
|
iconName
|
iconName | string |
Name of the icon |
|
|
isCodeGenerationEnabled
|
isCodeGenerationEnabled | boolean |
Indicates if the code should be automatically generated. Default is false. |
|
|
codeGenerationSeed
|
codeGenerationSeed | integer |
codeGenerationSeed |
|
|
id
|
id | string |
id |
|
|
name
|
name | True | string |
File Category Name |
|
extensions
|
extensions | string |
fileCategories |
Create records by entity name
This request creates one or more records for a Profisee entity given the entity name and code values.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
The name of the entity.
|
entityName | True | string |
The name of the Profisee entity. |
|
Code
|
Code | True | string |
Record code, or unique value |
|
Name
|
Name | string |
Record name, or description |
|
|
Attribute 1
|
Attribute1 | string |
Attribute1 |
|
|
Attribute 2
|
Attribute2 | string |
Attribute2 |
Delete a record from an entity
This request deletes a record from a Profisee entity given the entity name and record code.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
The name of the entity.
|
entityName | True | string |
The name of the Profisee entity. |
|
Record code
|
recordCode | True | string |
Record code, or unique value |
Get attributes metadata by entity name
This request returns metadata for attributes given an entity name.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
The name of the entity.
|
entityName | True | string |
The name of the Profisee entity. |
Get data quality issues by entity name
This request returns one or more data quality issues from a Profisee entity given the entity name and, optionally, record code(s).
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
The name of the entity.
|
entityName | True | string |
The name of the Profisee entity. |
|
Page number defaults to 1.
|
PageNumber | integer |
Page number to return. Default is 1. |
|
|
Page size defaults to 50.
|
PageSize | integer |
Number of records to return with the page of data. Defaults to 50. |
|
|
Comma-separated list of record codes to be returned.
|
RecordCodes | string |
Comma-separated list of record codes controlling the records returned. |
Returns
- response
- object
Get entity metadata by name
This request returns metadata for a given entity name.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
The name of the entity.
|
entityName | True | string |
The name of the Profisee entity. |
Get records by entity name
This request returns one or more records from a Profisee entity given the entity name.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
The name of the entity.
|
entityName | True | string |
The name of the Profisee entity. |
|
Comma-separated list of attributes. Multi-level have forward slashes inbetween.
|
Attributes | string |
Comma-separated list of attribute names to be returned. Each attribute must be surrounded by brackets. Note: multi-level attributes (MLA) may be specified with a forward slash between each level. Example: [ProductSubCategory]/[ProductCategory]/[ProductGroup] |
|
|
If the response includes only counts. If not supplied, defaults to false.
|
CountsOnly | boolean |
Indicate whether response includes only counts. If not supplied, defaults to false. |
|
|
Record filter in OData format.
|
Filter | string |
Record filter in OData format. Example: [Color] ne 'Red' or [Color] eq null |
|
|
Comma-separated list of attributes and sort direction for returned records.
|
OrderBy | string |
Comma-separated list of attributes and directions to sort the returned records. Each attribute must be surrounded by brackets. Default sort order is ascending if not supplied. Format: [Attribute Name] [ { asc | desc } ] [, ... ]Example: [ProductSubCategory], [SellStartDate] desc, [Color] asc |
|
|
Page number to return. Default is 1.
|
PageNumber | integer |
Page number to return. Default is 1. |
|
|
Page size defaults to 50.
|
PageSize | integer |
Number of records to return with the page of data. Defaults to 50. |
|
|
Comma-separated list of record codes to be returned.
|
RecordCodes | string |
Comma-separated list of record codes controlling the records returned. |
Returns
- response
- object
Update an existing theme
This request updates an existing theme with the given theme name.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Name of theme.
|
name | True | string |
Name of the Profisee theme. |
|
bannerPrimary
|
bannerPrimary | string |
bannerPrimary |
|
|
bannerFi
|
bannerFi | string |
bannerFi |
|
|
bannerSecondary
|
bannerSecondary | string |
bannerSecondary |
|
|
contentPrimaryBg
|
contentPrimaryBg | string |
contentPrimaryBg |
|
|
contentPrimaryFi
|
contentPrimaryFi | string |
contentPrimaryFi |
|
|
contentSecondaryBg
|
contentSecondaryBg | string |
contentSecondaryBg |
|
|
contentSecondaryFi
|
contentSecondaryFi | string |
contentSecondaryFi |
|
|
accentBg
|
accentBg | string |
accentBg |
|
|
accentFi
|
accentFi | string |
accentFi |
|
|
selectedBg
|
selectedBg | string |
selectedBg |
|
|
hyperlink
|
hyperlink | string |
hyperlink |
Update records by entity name
This request updates one or more records for a Profisee entity given the entity name.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
The name of the entity.
|
entityName | True | string |
The name of the Profisee entity. |
|
Code
|
Code | string |
Record code, or unique value |
|
|
Name
|
Name | string |
Record name, or description |
|
|
Attribute 1
|
Attribute1 | string |
Attribute1 |
|
|
Attribute 2
|
Attribute2 | string |
Attribute2 |
Definitions
object
This is the type 'object'.