/members request

[starting from version: 2.8]

A request for all members of the field.

Request

{
    "type": "members",   
    "index": string,
    "field": FieldObject, 
    "filter": FilterObject | FilterGroupObject, 
    "page": number
}

The request has the following parameters:

• type — String. The type of the request. In this case, it is "members".
• index – String. The dataset identifier.
• field – FieldObject. The field whose members should be sent in the response.
• filter – FilterObject | FilterGroupObject. Filters that should be applied to members. filter is present in the request when multilevel hierarchies are configured in Flexmonster Pivot.
  The filter can be:
  • The FilterObject – when the version sent in the /handshake response is earlier than 2.8.22 or /handshake is not implemented. Only include and exclude filtering parameters of the FilterObject are used.
  • The FilterGroupObject – when the version sent in the /handshake response is 2.8.22 or later.
• page – Number. The page number. It can be used to load members by parts. If the response contains pageTotal parameter, additional requests will be performed to load the remaining pages. Starts from 0.

Response

{
    "members"[]: {
        "value": string | number,
        "id": string
    },
    "sorted": boolean,
    "page": number,
    "pageTotal": number
}

The response has the following parameters:

• members – Array of objects. It contains all the members. Each member has the following properties:
  • value – String|Number. The member’s value. In the case of a number field, it should be of type number. In the case of a date field, the members should be passed to Flexmonster in the Unix timestamp format, then dates are recognized correctly. For example, the date "2016-02-07" will be 1454803200 in the form of a Unix timestamp.
  • id (optional) – String. The member’s id. Supported only for string fields. If defined, it is used in queries and in responses to identify the member.
• sorted (optional) – Boolean. If true, the members’ order from the response will be used as AZ order on the UI.
• page (optional) – Number. The current page number. Starts from 0.
• pageTotal (optional) – Number. The total number of pages. It can be used to load members by parts.

Examples

1. Example with a string field
   Request:

   {
       "index": "data-set-123",
       "type": "members",
       "field": {
           "uniqueName": "city"
       },
       "page": 0
   }
   

   Response:

   {
       "members": [
           { "value": "Toronto" }, 
           { "value": "Montreal" }, 
           { "value": "New York" }
       ]
   }
   

2. Example with a number field
   Request:

   {
       "index": "data-set-123",
       "type": "members",
       "field": {
           "uniqueName": "price"
       },
       "page": 0
   }
   

   Response:

   {
       "members": [
           { "value": 10 }, 
           { "value": 28 }, 
           { "value": 30 }
       ]
   }
   

3. Example with a date field
   Request:

   {
       "index": "data-set-123",
       "type": "members",
       "field": {
           "uniqueName": "order_date"
       },
       "page": 0
   }
   

   Response:

   {
       "members": [
           { "value": 1562889600000 }, 
           { "value": 1564617600000 }, 
           { "value": 1564963200000 }
       ]
   }
   

See also

/handshake request
/fields request
/select request for pivot table
/select request for flat table
/select request for drill-through view