loop through the column

[Anonymous]

Hi!

I have just one table with a column of names. 

name

aee1

aee2

aee3

aee4

aee5

aee6

aee7

aee8

aee9

aee10

I`m trying to get the data through rest api so I`m using the query link :    /rest/usermanagement/1/user?username="" . Instead of "" in the username attribute I have to add each username from the column with names (unfortunately, there`s no wildcard for this attribute that I could use to avoid looping through column).

What I have now: 

I enter manually the username to the query link and get the detailed info about user. Query returns xml formatted data (there`s no problem with expanding it in the Power BI) 

(just one row with data about one user only).

And what I need is:

a lot of rows with the info about each user in one table. Maybe I need to write a function and pass the name column as a parameter to it, but I`m not sure how to do that.

Any help would be really appreciated.

Cheers

[v-piga-msft]

Hi @Anonymous,

If it is convenient, could you share some data sample and your desired output so that we could help further on it.

Best Regards,

Cherry

[Anonymous]

Hi @v-piga-msft, Sorry for that, I edited the post and I hope it`s more understandable now. I`d be really grateful if you could help. Thank you!

[affan]

Hi @Anonymous

Is it possible to share the pbix file?

Please see this post to get your question answered quick.

Regards

Affan

[Anonymous]

Hi @affan Thank you for your reply and for the link provided! I`m sorry if my post is still unclear. Unfortunately I cant` provide a pbix file because of the security reasons. But I can provide some more info about that if needed. Please, let me know if you have some questions about my post I`d be happy to talk! Best, Mariia

[affan]

@Anonymous

1. Is your issue relevant to a single table or multiple?

2. If this is a single table, can you please share a sample of this table (by copy pasting the table in excel) atleast 10 records * you can change the actual records to be sample values.

3. If you are having this question to be resolved over multiple tables please share all the table's sample

4. If multiple tables are invlolved in the issue please also share the screenshot of the relationships.

[Anonymous]

@affan

1. I have just one table with one column 'name'.

2. Sure, here it is 

name

aee1

aee2

aee3

aee4

aee5

aee6

aee7

aee8

aee9

aee10

3. just one table with one column in it.

I also edited the post again and I hope it`s better for understanding now 🙂

Please, let me know if some more details are needed.

And thank you for your time!

Best,

Mariia

[Anonymous · Accepted solution]

Actually the initial problem was getting the list of all users with detailed info using crowd api. I found the solution using query parameter:

crowd/rest/usermanagement/1/search?entity-type=user&start-index=1000&max-results=1000&expand=user

In case anybody will ever need this 🙂