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.
The user of the connector should have an access to a Sigma Conso Consolidation & Reporting application. https://www.sigmaconso.com/en/contact-us/
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.
Files have to be sent in Base64-format. This can be handled by converting them using the base64() expression.
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 |
---|---|---|---|
API Key | securestring | The API Key for this api | True |
Name | Calls | Renewal Period |
---|---|---|
API calls per connection | 100 | 60 seconds |
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 |
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 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
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 |
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 |