XaitCPQ API

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

Get paginated list of data for a section with all the fields as a single flattened data object

Request Information

URI

https://ofd-api.blueprintcpq.net/data/list-simple/{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]}&groups[0]={groups[0]}&groups[1]={groups[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
groups

Collection of integer

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.

RowDataContainerSimple
NameDescriptionTypeAdditional information
Data

Collection of Dictionary of string [key] and Object [value]

None.
TotalRecords

integer

None.
PageNumber

integer

None.
PageSize

integer

None.
SortBy

string

None.
SortDirection

string

None.

Response Formats

application/json, text/json

Sample: 
{
  "Data": [
    {
      "sample string 1": {},
      "sample string 3": {}
    },
    {
      "sample string 1": {},
      "sample string 3": {}
    }
  ],
  "TotalRecords": 1,
  "PageNumber": 2,
  "PageSize": 3,
  "SortBy": "sample string 4",
  "SortDirection": "sample string 5"
}

text/html

Sample: 
{"Data":[{"sample string 1":{},"sample string 3":{}},{"sample string 1":{},"sample string 3":{}}],"TotalRecords":1,"PageNumber":2,"PageSize":3,"SortBy":"sample string 4","SortDirection":"sample string 5"}

application/xml, text/xml

Sample: 
<RowDataContainerSimple xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/Shared.Models.DataModels">
  <PageNumber>2</PageNumber>
  <PageSize>3</PageSize>
  <SortBy>sample string 4</SortBy>
  <SortDirection>sample string 5</SortDirection>
  <TotalRecords>1</TotalRecords>
  <Data xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:ArrayOfKeyValueOfstringanyType>
      <d2p1:KeyValueOfstringanyType>
        <d2p1:Key>sample string 1</d2p1:Key>
        <d2p1:Value />
      </d2p1:KeyValueOfstringanyType>
      <d2p1:KeyValueOfstringanyType>
        <d2p1:Key>sample string 3</d2p1:Key>
        <d2p1:Value />
      </d2p1:KeyValueOfstringanyType>
    </d2p1:ArrayOfKeyValueOfstringanyType>
    <d2p1:ArrayOfKeyValueOfstringanyType>
      <d2p1:KeyValueOfstringanyType>
        <d2p1:Key>sample string 1</d2p1:Key>
        <d2p1:Value />
      </d2p1:KeyValueOfstringanyType>
      <d2p1:KeyValueOfstringanyType>
        <d2p1:Key>sample string 3</d2p1:Key>
        <d2p1:Value />
      </d2p1:KeyValueOfstringanyType>
    </d2p1:ArrayOfKeyValueOfstringanyType>
  </Data>
</RowDataContainerSimple>