Share via


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