POST api/Data

Queries the database based on a QueryCriteria object (Columns, Predicates, SortKeys, GroupKeys, RowFilters, Options, StartAt, Take, ProductId, EntityName). Returns a list of records based on the Columns provided

Request Information

URI Parameters

None.

Body Parameters

QueryCriteria object

SI.Model.Simfund.Generic.QueryCriteria

Name	Type	Additional information
Filters	Collection of SI.Model.Simfund.Generic.SearchPredicate	None.
RowFilters	Collection of SI.Model.Simfund.Generic.SearchPredicate	None.
WorkbookFilters	Collection of SI.Model.Simfund.Generic.SearchPredicate	None.
Columns	Collection of SI.Configuration.Simfund.DataItem	None.
SortKeys	Collection of SI.Model.Simfund.Generic.SortKey	None.
GroupKeys	Collection of SI.Model.Simfund.Generic.SortKey	None.
StartAt	integer	None.
Take	integer	None.
ProductId	integer	None.
EntityName	string	None.
Options	Collection of SI.Model.Simfund.Generic.CustomOption	None.

Request Formats

application/json, text/json

Sample:

{
  "<Filters>k__BackingField": [
    {
      "Id": "40b13d7d-22f2-4ece-8cf7-e65c63faeffb",
      "ItemKey": "sample string 2",
      "ObservationKey": "sample string 3",
      "ObservationName": "sample string 4",
      "Value": {},
      "IsOr": true,
      "Operator": 0,
      "IsLogicalContainer": true,
      "IgnoreSearchField": true,
      "Negate": true,
      "Predicates": [],
      "ClassName": "sample string 10",
      "IsDefaultLogicalOr": true,
      "Level": 12,
      "ProductId": 13,
      "ItemName": "sample string 14",
      "Column": null,
      "UniverseId": 1,
      "SortOrder": 1
    },
    {
      "Id": "40b13d7d-22f2-4ece-8cf7-e65c63faeffb",
      "ItemKey": "sample string 2",
      "ObservationKey": "sample string 3",
      "ObservationName": "sample string 4",
      "Value": {},
      "IsOr": true,
      "Operator": 0,
      "IsLogicalContainer": true,
      "IgnoreSearchField": true,
      "Negate": true,
      "Predicates": [],
      "ClassName": "sample string 10",
      "IsDefaultLogicalOr": true,
      "Level": 12,
      "ProductId": 13,
      "ItemName": "sample string 14",
      "Column": null,
      "UniverseId": 1,
      "SortOrder": 1
    }
  ],
  "<RowFilters>k__BackingField": [
    {
      "Id": "40b13d7d-22f2-4ece-8cf7-e65c63faeffb",
      "ItemKey": "sample string 2",
      "ObservationKey": "sample string 3",
      "ObservationName": "sample string 4",
      "Value": {},
      "IsOr": true,
      "Operator": 0,
      "IsLogicalContainer": true,
      "IgnoreSearchField": true,
      "Negate": true,
      "Predicates": [],
      "ClassName": "sample string 10",
      "IsDefaultLogicalOr": true,
      "Level": 12,
      "ProductId": 13,
      "ItemName": "sample string 14",
      "Column": null,
      "UniverseId": 1,
      "SortOrder": 1
    },
    {
      "Id": "40b13d7d-22f2-4ece-8cf7-e65c63faeffb",
      "ItemKey": "sample string 2",
      "ObservationKey": "sample string 3",
      "ObservationName": "sample string 4",
      "Value": {},
      "IsOr": true,
      "Operator": 0,
      "IsLogicalContainer": true,
      "IgnoreSearchField": true,
      "Negate": true,
      "Predicates": [],
      "ClassName": "sample string 10",
      "IsDefaultLogicalOr": true,
      "Level": 12,
      "ProductId": 13,
      "ItemName": "sample string 14",
      "Column": null,
      "UniverseId": 1,
      "SortOrder": 1
    }
  ],
  "<WorkbookFilters>k__BackingField": [
    {
      "Id": "40b13d7d-22f2-4ece-8cf7-e65c63faeffb",
      "ItemKey": "sample string 2",
      "ObservationKey": "sample string 3",
      "ObservationName": "sample string 4",
      "Value": {},
      "IsOr": true,
      "Operator": 0,
      "IsLogicalContainer": true,
      "IgnoreSearchField": true,
      "Negate": true,
      "Predicates": [],
      "ClassName": "sample string 10",
      "IsDefaultLogicalOr": true,
      "Level": 12,
      "ProductId": 13,
      "ItemName": "sample string 14",
      "Column": null,
      "UniverseId": 1,
      "SortOrder": 1
    },
    {
      "Id": "40b13d7d-22f2-4ece-8cf7-e65c63faeffb",
      "ItemKey": "sample string 2",
      "ObservationKey": "sample string 3",
      "ObservationName": "sample string 4",
      "Value": {},
      "IsOr": true,
      "Operator": 0,
      "IsLogicalContainer": true,
      "IgnoreSearchField": true,
      "Negate": true,
      "Predicates": [],
      "ClassName": "sample string 10",
      "IsDefaultLogicalOr": true,
      "Level": 12,
      "ProductId": 13,
      "ItemName": "sample string 14",
      "Column": null,
      "UniverseId": 1,
      "SortOrder": 1
    }
  ],
  "<Columns>k__BackingField": null,
  "<SortKeys>k__BackingField": [
    {
      "ItemKey": "sample string 1",
      "ObservationKey": "sample string 2",
      "Direction": 0,
      "Alias": "sample string 3",
      "HeaderText": "sample string 4"
    },
    {
      "ItemKey": "sample string 1",
      "ObservationKey": "sample string 2",
      "Direction": 0,
      "Alias": "sample string 3",
      "HeaderText": "sample string 4"
    }
  ],
  "<GroupKeys>k__BackingField": [
    {
      "ItemKey": "sample string 1",
      "ObservationKey": "sample string 2",
      "Direction": 0,
      "Alias": "sample string 3",
      "HeaderText": "sample string 4"
    },
    {
      "ItemKey": "sample string 1",
      "ObservationKey": "sample string 2",
      "Direction": 0,
      "Alias": "sample string 3",
      "HeaderText": "sample string 4"
    }
  ],
  "<StartAt>k__BackingField": 1,
  "<Take>k__BackingField": 2,
  "<ProductId>k__BackingField": 3,
  "<EntityName>k__BackingField": "sample string 4",
  "<Options>k__BackingField": [
    {
      "Name": "sample string 1",
      "Value": "sample string 2"
    },
    {
      "Name": "sample string 1",
      "Value": "sample string 2"
    }
  ]
}

application/x-www-form-urlencoded

Sample:

Failed to generate the sample for media type 'application/x-www-form-urlencoded'. Cannot use formatter 'System.Web.Http.ModelBinding.JQueryMvcFormUrlEncodedFormatter' to write type 'SI.Model.Simfund.Generic.QueryCriteria'.

Response Information

Resource Description

List of requested column values

System.Web.Http.IHttpActionResult

None.

Response Formats

application/json, text/json

Sample:

Sample not available.