Solved

XFget to retrieve name from description

Forum|Forum|1 year ago
September 10, 2024
2 replies
4 views

Is there a function to lookup the name of a member from description. I've been looking at the functions for a couple hours and cant find anything

Excel Add In

Best answer by rhankey

There is no api function that directly returns a member name from a description. However you can use api.Members.GetMembersUsingFilter() with a filter of something like "A#Root.DescendantsInclusive.Where(Description = Equity)", which will return a list of Members matching that filter. You would need to figure out what to do if you got zero or more than one matches, as Descriptions are not required to be unique.

"

S

SimonHesford

I would venture no as Member Descriptions do not need to be unique so they couldn't be guaranteed to return a specific member.

J

JonKunertAuthor

Thats what i figured, but was hoping I was wrong

S

SimonHesford

Yeah, the hours of searching was probably your biggest clue 😉

R

rhankeyAnswer

There is no api function that directly returns a member name from a description. However you can use api.Members.GetMembersUsingFilter() with a filter of something like "A#Root.DescendantsInclusive.Where(Description = Equity)", which will return a list of Members matching that filter. You would need to figure out what to do if you got zero or more than one matches, as Descriptions are not required to be unique.

"

J

JonKunertAuthor

That will work. We dont use the description in multiple places. Thank you for this

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded