Unique data in Select one choice

Content

Hi Experts,

I have a REST API that gives a list of account details (as below) with duplicate account names. I wanted to create a Select one choice and show only a unique account name in the drop-down. My Select one choice should have only ABC, XYZ, WWW. Can this be achieved? Also how to show one account name as the default option. Please suggest.

 

[
{
"account":"ABC",
"id":"123"
},
{
"account":"ABC",
"id":"123"
},
{
"account":"XYZ",
"id":"321"
},
{
"account":"XYZ",
"id":"321"
},
{
"account":"WWW",
"id":"333"
}
]