Sigma Conso CR (Preview)
Sigma Conso Consolidation & Reporting Connector provides a set of APIs to interact with your Consolidation & Reporting instances. Easily transfer data, trigger actions and automate workflows in Sigma Conso. Go beyond the limits of traditional CPM solutions.
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 | Sigma Conso |
| URL | https://www.sigmaconso.com/ |
| support@sigmaconso.com |
| Connector Metadata | |
|---|---|
| Publisher | Sigma Conso |
| Website | https://www.sigmaconso.com/ |
| Privacy policy | https://www.sigmaconso.com/en/security-and-privacy-policy/ |
| Categories | Finance |
The Sigma Conso connector allows you to import data and run a consolidation, processes and scheduled jobs.
Prerequisites
The user of the connector should have an access to a Sigma Conso Consolidation & Reporting application. https://www.sigmaconso.com/en/contact-us/
How to get credentials
To make a connection a user needs to create an api-key linked to his user. In Sigma Conso Consolidation and Reporting an API-key can be created in the Users/Customers screen.
Known issues and limitations
Files have to be sent in Base64-format. This can be handled by converting them using the base64() expression.
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 |
|---|---|---|---|
| API Key | securestring | The API Key for this api | True |
Throttling Limits
| Name | Calls | Renewal Period |
|---|---|---|
| API calls per connection | 100 | 60 seconds |
Actions
| Consolidation |
Run a consolidation job |
| Import file |
Import a csv or xlsx file |
| Run a process |
Run a process |
| Scheduled job |
Run a scheduled job |
Consolidation
Run a consolidation job
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Enter the application url.
|
ApplicationURL | True | string |
Enter the application url. |
|
ConsoCode
|
ConsoCode | True | string |
Consocode |
|
CustomerCode
|
CustomerCode | True | string |
Customer code |
|
WaitForResult
|
WaitForResult | boolean |
Wait for the result. |
Returns
| Name | Path | Type | Description |
|---|---|---|---|
|
Message
|
Message | string |
Message |
Import file
Import a csv or xlsx file
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Enter the application url.
|
ApplicationURL | True | string |
Enter the application url. |
|
ImportStructureCode
|
ImportStructureCode | True | string |
Importstructure code |
|
CustomerCode
|
CustomerCode | True | string |
Customer code |
|
Base64File
|
Base64File | True | string |
The file in base64 format. |
|
WaitForResult
|
WaitForResult | boolean |
Wait for the result. |
Returns
| Name | Path | Type | Description |
|---|---|---|---|
|
Message
|
Message | string |
Message |
Run a process
Run a process
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Enter the application url.
|
ApplicationURL | True | string |
Enter the application url. |
|
Process
|
Process | True | string |
Process |
|
Action
|
Action | True | string |
Action |
|
CustomerCode
|
CustomerCode | True | string |
Customer code |
|
WaitForResult
|
WaitForResult | boolean |
Wait for the result. |
Returns
| Name | Path | Type | Description |
|---|---|---|---|
|
Message
|
Message | string |
Message |
Scheduled job
Run a scheduled job
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Enter the application url.
|
ApplicationURL | True | string |
Enter the application url. |
|
JobScheduleName
|
JobScheduleName | True | string |
JobSchedule name |
|
CustomerCode
|
CustomerCode | True | string |
Customer code |
|
WaitForResult
|
WaitForResult | boolean |
Wait for the result. |
Returns
| Name | Path | Type | Description |
|---|---|---|---|
|
Message
|
Message | string |
Message |