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

Operation ID:

Consolidationjob

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

Operation ID:

ImportFile

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

Operation ID:

Processjob

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

Operation ID:

Scheduledjob

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