cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mzhydenko Frequent Visitor
Frequent Visitor

loop through the column

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) 

Capture1.JPG

 

(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

1 ACCEPTED SOLUTION

Accepted Solutions
mzhydenko Frequent Visitor
Frequent Visitor

Re: loop through the column

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 Smiley Happy

7 REPLIES 7
Community Support Team
Community Support Team

Re: loop through the column

Hi @mzhydenko,

 

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

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
mzhydenko Frequent Visitor
Frequent Visitor

Re: loop through the column

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 Established Member
Established Member

Re: loop through the column

Hi @mzhydenko

 

Is it possible to share the pbix file?

 

Please see this post to get your question answered quick.

 

 

Regards

Affan

mzhydenko Frequent Visitor
Frequent Visitor

Re: loop through the column

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 Established Member
Established Member

Re: loop through the column

@mzhydenko

 

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.

 

Highlighted
mzhydenko Frequent Visitor
Frequent Visitor

Re: loop through the column

@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 Smiley Happy

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

 

And thank you for your time!

 

Best,

 

Mariia

mzhydenko Frequent Visitor
Frequent Visitor

Re: loop through the column

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 Smiley Happy