GET data/list/{name}/{section}/{pageNumber}/{pageSize}

Get paginated list of data for a section.

Request Information

URI

https://ofd-api.blueprintcpq.net/data/list/{name}/{section}/{pageNumber}/{pageSize}?filters[0]={filters[0]}&filters[1]={filters[1]}&operators[0]={operators[0]}&operators[1]={operators[1]}&values[0]={values[0]}&values[1]={values[1]}&sortField={sortField}&sortDirection={sortDirection}&baseRecord={baseRecord}&share={share}

URI Parameters

NameDescriptionTypeAdditional information
name

Page name.

string

Required

section

Section Name or Id.

string

Required

filters

The filters.

Collection of string

Required

operators

Filter operators.

Collection of Operator

Required

values

Filter values.

Collection of string

Required

pageNumber

Page number.

integer

Default value is 1

pageSize

Maximum number of rows to return.

integer

Default value is 20

sortField

Field to sort by.

string

None.

sortDirection

Direction to sort (asc or desc)

SortDirection

None.

baseRecord

Base record Id

string

None.

share

Optional share identifier.

globally unique identifier

None.

Body Parameters

None.

Response Information

Resource Description

List of Data.

RowDataContainer
NameDescriptionTypeAdditional information
TotalRecords

integer

None.

PageNumber

integer

None.

PageSize

integer

None.

SortBy

string

None.

SortDirection

string

None.

IdField

globally unique identifier

None.

LinkTableName

string

None.

Data

Collection of RowData

None.

Response Formats

application/json, text/json

Sample:
{
  "TotalRecords": 1,
  "PageNumber": 2,
  "PageSize": 3,
  "SortBy": "sample string 4",
  "SortDirection": "sample string 5",
  "IdField": "42badf77-5b1a-4bd2-a490-926245d25188",
  "LinkTableName": "sample string 7",
  "Data": null
}

text/html

Sample:
{"TotalRecords":1,"PageNumber":2,"PageSize":3,"SortBy":"sample string 4","SortDirection":"sample string 5","IdField":"42badf77-5b1a-4bd2-a490-926245d25188","LinkTableName":"sample string 7","Data":null}

application/xml, text/xml

Sample:
<RowDataContainer xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/Shared.Models.DataModels">
  <Data i:nil="true" />
  <IdField>42badf77-5b1a-4bd2-a490-926245d25188</IdField>
  <LinkTableName>sample string 7</LinkTableName>
  <PageNumber>2</PageNumber>
  <PageSize>3</PageSize>
  <SortBy>sample string 4</SortBy>
  <SortDirection>sample string 5</SortDirection>
  <TotalRecords>1</TotalRecords>
</RowDataContainer>