Get Request Line Member Properties

This action allows to fetch member property details for the given request line.

Endpoint Details

URL Structure

http(s)://<EPMWARE_URL>/service/api/request/get_line_member_props

Method

GET

Parameters

Parameter	Type	Required	Default	Description
`requestId`	Query	Yes		Filter by request ID
`lineNumber`	Query	Yes		Filter by line number
`startIndex`	Query	No	0	Paging offset
`pageSize`	Query	No		Page size
`sortBy`	Query	No		Sort field (`propName`)
`sortType`	Query	No		Sort direction (`asc` or `desc`)

Request Examples

Using curl

curl GET 'https://demo.epmwarecloud.com/service/api/request/get_line_member_props?requestId=1368&lineNumber=1' \
  -H 'Authorization: Token 15388ad5-c9af-4cf3-af47-8021c1ab3fb7'

Response Format

Successful Response

{
    "startIndex": 0,
    "pageSize": 200,
    "totalCount": 2,
    "resultSize": 2,
    "vEWVRequestLineMemberPropsAll": [
        {
            "requestLineId": 336004,
            "appDimensionId": 2396,
            "hierarchyId": 4110136,
            "propName": "Alias",
            "requestId": 1368,
            "lineNumber": 1,
            "appId": 501,
            "appName": "FIN_APP",
            "dimName": "Account",
            "memberId": 1346586,
            "memberName": "ALLACCOUNTS",
            "arrayMemberName": "English",
            "parentMemberId": 1300000,
            "parentMemberName": "ACCOUNTS",
            "propId": 8801,
            "propLabel": "Alias",
            "propValue": "TEST A",
            "hierarchyType": "P",
            "arrayType": "Y",
            "clobFlag": "N",
            "clobPropValue": null
        }
    ]
}

Response Fields

Field	Type	Description
`requestLineId`	Long	Request line ID
`appDimensionId`	Long	Application dimension ID
`hierarchyId`	Long	Hierarchy ID
`propName`	String	Property name
`requestId`	Long	Request ID
`lineNumber`	Long	Request line number
`appId`	Long	Application ID
`appName`	String	Application name
`dimName`	String	Dimension name
`memberId`	Long	Member ID
`memberName`	String	Member name
`parentMemberId`	Long	Parent member ID
`parentMemberName`	String	Parent member name
`propId`	Long	Property ID
`propLabel`	String	Property label
`propValue`	String	Property value (up to 4000 characters)
`hierarchyType`	String	Hierarchy type flag
`arrayMemberName`	String	Array Member name
`arrayType`	String	`Y` if the property is an array (multi-value) type
`clobFlag`	String	`Y` if the value is stored as a CLOB
`clobPropValue`	String	CLOB property value, populated when `clobFlag` is `Y`

Common Response Envelope

Field	Type	Description
`startIndex`	Integer	Offset of the first returned row
`pageSize`	Integer	Requested page size
`totalCount`	Long	Total matching rows
`resultSize`	Integer	Number of rows in this response
`sortBy`	String	Applied sort field
`sortType`	String	Applied sort direction

← Get Request Lines | Back to Request