Loading

DFS MIS API (latest)

Download OpenAPI specification:Download

REST Services for managing MIS data.

For endpoints that support localization the language can be passed either as a query string parameter (using the name 'language') or in the 'accept-language' header.
If no language is passed to such endpoints then the default configured language will be used.

AgGrid

Retrieve filters

Retrieve filter information available for the passed data source.

Authorizations:
header Parameters
Accept-Language
string

The ISO 639-1 language to use for localizable data.

Request Body schema:

The request DTO

fieldKey
string Nullable
dataSourceName
string Nullable
dataSourceId
integer <int32> Nullable

Responses

200

OK

400

Bad Request

401

Unauthorized

403

Forbidden

404

Not Found

422

UnprocessableEntity

500

Internal Server Error

post/v1.0/ag-grid/filter
https://example-host/v1.0/ag-grid/filter

Request samples

Content type
Copy
Expand all Collapse all
{
  • "fieldKey": "string",
  • "dataSourceName": "string",
  • "dataSourceId": 0
}

Response samples

Content type
application/json
Copy
Expand all Collapse all
{
  • "results":
    [
    ]
}

Retrieve data

Retrieve data for the passed data source.

Authorizations:
header Parameters
Accept-Language
string

The ISO 639-1 language to use for localizable data.

Request Body schema:

The request DTO

startRow
integer <int32>
endRow
integer <int32>
rowGroupCols
Array of objects (ColumnVO) Nullable
valueCols
Array of objects (ColumnVO) Nullable
pivotCols
Array of objects (ColumnVO) Nullable
pivotMode
boolean
groupKeys
Array of strings Nullable
filterModel
object Nullable
sortModel
Array of objects (SortModel) Nullable
dataSourceName
string Nullable
dataSourceId
integer <int32> Nullable
allRows
boolean

Responses

200

OK

400

Bad Request

401

Unauthorized

403

Forbidden

404

Not Found

422

UnprocessableEntity

500

Internal Server Error

post/v1.0/ag-grid/rows
https://example-host/v1.0/ag-grid/rows

Request samples

Content type
Copy
Expand all Collapse all
{
  • "startRow": 0,
  • "endRow": 0,
  • "rowGroupCols":
    [
    ],
  • "valueCols":
    [
    ],
  • "pivotCols":
    [
    ],
  • "pivotMode": true,
  • "groupKeys":
    [
    ],
  • "filterModel":
    {
    },
  • "sortModel":
    [
    ],
  • "dataSourceName": "string",
  • "dataSourceId": 0,
  • "allRows": true
}

Response samples

Content type
application/json
Copy
Expand all Collapse all
{
  • "data":
    [
    ],
  • "lastRow": 0,
  • "secondaryColumnFields":
    [
    ]
}

DataSource

Delete data source scenario

Delete, for the passed data source, a specific scenario.

Authorizations:
path Parameters
dataSourceId
required
integer <int32>

The data source Id

scenarioId
required
integer <int32>

The scenario Id

header Parameters
Accept-Language
string

The ISO 639-1 language to use for localizable data.

Responses

200

OK

400

Bad Request

401

Unauthorized

403

Forbidden

404

Not Found

422

UnprocessableEntity

500

Internal Server Error

delete/v1.0/data-sources/{dataSourceId}/scenarios/{scenarioId}
https://example-host/v1.0/data-sources/{dataSourceId}/scenarios/{scenarioId}

Response samples

Content type
application/json
Copy
Expand all Collapse all
{
  • "success": true
}

Retrieve data source scenario

Retrieve information for the passed scenario and data source combination.

Authorizations:
path Parameters
dataSourceId
required
integer <int32>

The data source Id

scenarioId
required
integer <int32>

The scenario Id

header Parameters
Accept-Language
string

The ISO 639-1 language to use for localizable data.

Responses

200

OK

400

Bad Request

401

Unauthorized

403

Forbidden

404

Not Found

422

UnprocessableEntity

500

Internal Server Error

get/v1.0/data-sources/{dataSourceId}/scenarios/{scenarioId}
https://example-host/v1.0/data-sources/{dataSourceId}/scenarios/{scenarioId}

Response samples

Content type
application/json
Copy
Expand all Collapse all
{
  • "id": 0,
  • "name": "string",
  • "columnState": "string",
  • "groupState": "string",
  • "filterModel": "string",
  • "pivotMode": true,
  • "createDate": "2025-05-09T12:06:29Z"
}

Retrieve data sources

Retrieve the available data sources.

Authorizations:
header Parameters
Accept-Language
string

The ISO 639-1 language to use for localizable data.

Responses

200

OK

400

Bad Request

401

Unauthorized

403

Forbidden

500

Internal Server Error

get/v1.0/data-sources
https://example-host/v1.0/data-sources

Response samples

Content type
application/json
Copy
Expand all Collapse all
{
  • "results":
    [
    ]
}

Retrieve data source

Retrieve information about the data source passed.

Authorizations:
path Parameters
dataSourceId
required
integer <int32>

The data source Id

header Parameters
Accept-Language
string

The ISO 639-1 language to use for localizable data.

Responses

200

OK

400

Bad Request

401

Unauthorized

403

Forbidden

404

Not Found

422

UnprocessableEntity

500

Internal Server Error

get/v1.0/data-sources/{dataSourceId}
https://example-host/v1.0/data-sources/{dataSourceId}

Response samples

Content type
application/json
Copy
Expand all Collapse all
{
  • "id": 0,
  • "name": "string",
  • "tableName": "string"
}

Retrieve data source settings

Retrieve the settings of the data source passed.

Authorizations:
path Parameters
dataSourceId
required
integer <int32>

The data source Id

header Parameters
Accept-Language
string

The ISO 639-1 language to use for localizable data.

Responses

200

OK

400

Bad Request

401

Unauthorized

403

Forbidden

404

Not Found

422

UnprocessableEntity

500

Internal Server Error

get/v1.0/data-sources/{dataSourceId}/settings
https://example-host/v1.0/data-sources/{dataSourceId}/settings

Response samples

Content type
application/json
Copy
Expand all Collapse all
{
  • "data": "string"
}

Retrieve data source scenarios

Retrieve the scenarios present for the data source passed.

Authorizations:
path Parameters
dataSourceId
required
integer <int32>

The data source Id

header Parameters
Accept-Language
string

The ISO 639-1 language to use for localizable data.

Responses

200

OK

400

Bad Request

401

Unauthorized

403

Forbidden

404

Not Found

422

UnprocessableEntity

500

Internal Server Error

get/v1.0/data-sources/{dataSourceId}/scenarios
https://example-host/v1.0/data-sources/{dataSourceId}/scenarios

Response samples

Content type
application/json
Copy
Expand all Collapse all
{
  • "results":
    [
    ]
}

Create data source scenario

Create, for the data source passed, a new scenario (based on the conditions passed).

Authorizations:
path Parameters
dataSourceId
required
integer <int32>

The data source Id

header Parameters
Accept-Language
string

The ISO 639-1 language to use for localizable data.

Request Body schema:

The scenario DTO

name
string Nullable
columnState
string Nullable
groupState
string Nullable
filterModel
string Nullable
pivotMode
boolean Nullable

Responses

200

OK

400

Bad Request

401

Unauthorized

403

Forbidden

404

Not Found

422

UnprocessableEntity

500

Internal Server Error

post/v1.0/data-sources/{dataSourceId}/scenarios
https://example-host/v1.0/data-sources/{dataSourceId}/scenarios

Request samples

Content type
Copy
Expand all Collapse all
{
  • "name": "string",
  • "columnState": "string",
  • "groupState": "string",
  • "filterModel": "string",
  • "pivotMode": true
}

Response samples

Content type
application/json
Copy
Expand all Collapse all
{
  • "id": 0
}