GetParentListInfo Function

Description

The GetParentListInfo function allows users to return list information, similar to the GetListInfo function, one level above the current result. For example, this function can be used to show parent subsidiaries using the subsidiary name as an input.

Function Arguments

Argument Name	Input Information
List Name	The exact name of a list from the Data Retrieval > From List selection
Name/Number/Identifier	The exact name, number or identifier (Id) from the list selected will allow this function to hone in on the row to look at
Property Name	The exact name of a column header from the list selected that will be used to return the value for that property based on the row identified from the name/number/identifier
Prefix	Optional Parameter to add a string value to the start of the returned list information
Suffix	Optional input to add a string value to the end of the returned list information

Remarks

• To ensure proper names are being used for each argument, utilize the dropdown options when possible. Additionally, pull in any list to review what information you're trying to return.
• This function utilizes the Level column on lists to determine which parent values should be returned.

Example

Let's say a user wants to return the Parent Subsidiary Name for each subsidiary in order to better understand their NetSuite set up. They can use the GetParentListInfo function to do this.

1. Select Finsyte Functions > GetParentListInfo
2. Fill in the arguments. List Name is "Subsidiaries", Name should link to the Subsidiary Values and Property Name should reference "Name" as seen in the Subsidiaries list as we are using the subsidiary name to return the name at the higher level.

Note: In the example above, all the subsidiaries roll up to the Headquarter Subisidairy.