Planful (Preview)
Planful is the pioneer of financial performance management cloud software. The Planful platform is used by the Office of the CFO around the globe to streamline business-wide planning, budgeting, consolidations, reporting, and visual analytics.
This connector is available in the following products and regions:
Service | Class | Regions |
---|---|---|
Logic Apps | Standard | All Logic Apps regions except the following: - Azure Government regions - Azure China regions - 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) |
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) |
Contact | |
---|---|
Name | Planful |
URL | https://www.planful.com |
support@planful.com |
Connector Metadata | |
---|---|
Publisher | Planful |
Website | https://www.planful.com/ |
Privacy policy | https://planful.com/privacy-policy |
Categories | Finance |
Planful Connector
Planful is the pioneer of financial performance management cloud software. The Planful platform is used by the Office of the CFO around the globe to streamline business-wide planning, budgeting, consolidations, reporting, and visual analytics. Planful transforms the way you plan, close, and report so you can drive more impactful decisions across your business.
An active acount with Planful
Access to 'Data Load Rules' within Planful
User to have 'Web services Access' enabled. Account admin can enable this in the "User & Role Management" section for any user
Step1: Sign in to your Planful account
Step2: Click on your profile icon at the top right and navigate to "Access Keys"
Step3: Give a name for the access key to create a new access key
Step4: Copy the Access ID and Access Key to use them during authenticating the connector in Power Automate
Choose the connector in a flow either to load data or extract gl data from Planful.
There is a sample template available to load a data file from Gdrive to Planful
Fetch credentials as shown above.
Log into Planful to use any of the existing DLRs (data load rules), or create new. These are used for data validation.
Unauthorized: Check if your credentials are valid. Delete and generate new access id and secret if required.
Data load rule not found: For loading data to Planful, it is important that you provide a valid and existing Data Load Rule name
Fiscal year and Scenario are mandatory: To extract GL data out of Planful, make sure that the Scenario and Fiscalyear you provided in the operation exists within your Planful application.
- Supports only csv file types for data load.
- This connector supports only 'Structured Planning' operations.
- N/A
The connector supports the following authentication types:
Default | Parameters for creating connection. | All regions | Not shareable |
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 |
---|---|---|---|
Planful URL | string | Root site url (Example: https://na04.planful.com). If not specified, site url will be defaulted to https://na04.planful.com. | |
Access ID | securestring | The Access ID for this api | True |
Access Key | securestring | The Access Key for this api | True |
Name | Calls | Renewal Period |
---|---|---|
API calls per connection | 100 | 60 seconds |
File load |
File load |
Get GL data |
Get GL data |
Get Rules |
Get Rules |
File load
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
Data load rule name
|
DataLoadRuleName | string |
Data load rule name |
|
Column Delimiter
|
ColumnDelimiter | True | string |
Column delimiter |
The file
|
file | file |
The file to upload. |
Returns
Name | Path | Type | Description |
---|---|---|---|
DataLoadRuleId
|
DataLoadRuleId | integer |
Rule id |
ExcecutionId
|
ExcecutionId | string |
Execution id |
RunAsynchronously
|
RunAsynchronously | boolean |
Does this task run asynchronously |
Attempts
|
Attempts | integer |
How many attempts did this take to load this file |
Success
|
TransferResponse.Success | boolean |
Is the file load successful |
Message
|
TransferResponse.Message | string |
Response message |
Get GL data
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
Scenario
|
Scenario | True | string |
Enter name of the scenario |
FiscalYear
|
FiscalYear | True | integer |
Enter FiscalYear |
$filter
|
$filter | string |
odata query |
Returns
Name | Path | Type | Description |
---|---|---|---|
|
array of object | ||
Scenario
|
Scenario | string |
Name of the scenario |
FiscalYear
|
FiscalYear | integer |
Fiscal year |
Get Rules
Returns
Name | Path | Type | Description |
---|---|---|---|
|
array of object | ||
DataLoadRuleId
|
DataLoadRuleId | integer |
Data rule id |
Name
|
Name | string |
Name of the data load rule |
LoadItem
|
LoadItem | string |
Load item |