Share via


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

  1. Request details for one or more records from your Profisee instance given the entity name.
  2. Create master data records within a Profisee entity.
  3. Update master data records within a Profisee entity.
  4. Delete records within a Profisee entity.
  5. Create an entity.
  6. Create an attribute within a Profisee entity.
  7. Update the Profisee theme (color scheme).
  8. Request data quality issues for a Profisee entity.
  9. 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

  1. 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.
  2. On the left pane, select All services. In the Filter box, enter Microsoft Entra ID, and then select Microsoft Entra ID.
  3. On the left pane of the Microsoft Entra ID blade, expand Manage and select App registrations.
  4. Select new registration.
  5. Give it a name and select the supported account type single tenant / multitenant based on your needs.
  6. Copy the Application ID, because you need it later.
  7. On the left pane of the App registrations blade, expand Manage and select API permissions.
  8. Select add permission.
  9. Under Delegated permissions, select Access Azure Resource Manager as organization users > Select -> Add permission.
  10. Go to Certificates & secrets -> add new client secret -> provide description and expiration date and click add.
  11. 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.

  1. On the Security page, select authentication type as OAuth 2.0.
  2. Identity provider -> Microsoft Active Directory.
  3. 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.

  1. 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'.