Hi Ken!

Easiest way for me to generate reports in Okta is with APIs. Will suggest configuring a client like Postman which supports API calls. Once you have configured Postman use the "List Apps" API call and retrieve all your existing apps. Copy the JSON response and use a tool to convert it into a CSV. Excel filtering is great as you can generate from here reports with the apps that are running on SAML, SWA or WS-FED. Am attaching some links as well:

1. Postman setup https://developer.okta.com/code/rest/
2. List apps API https://developer.okta.com/docs/api/resources/apps#list-applications-with-defaults

Will recommend creating a case with support if further assistance is required. Our colleagues will guide you step by step if needed.

Hello Ken,

Thanks for posting your inquiry in Okta Community Portal.

If you receive a great answer to your question(s), please help readers find it by marking it the best answer. Hover over the answer and click "Best Answer." 

Thank you,

Mike Davie

Okta Help Center

Hello,

Thanks for your response. I downloaded the Postman plugin for Chrome.

From the documentation here: https://developer.okta.com/docs/api/resources/apps#list-applications-with-defaults

I used the following as a guideline for building a request in Postman. I had to figure out Postman a little.

curl -v -X GET \

-H "Accept: application/json" \

-H "Content-Type: application/json" \

-H "Authorization: SSWS ${api_token}" \

"https://{yourOktaDomain}/api/v1/apps"

Then I got a large response in JSON. That's what I've gotten so far. I'll work on converting it to CSV and opening in Excel. It's a lot of work for a report for someone that isn't familiar with these tools. But I'm getting there, thanks.

Hello,

When I look at the results, I'm only receiving 20 rows (applications). We have several hundred applications in Okta.

Is there something that limits the size of the output? I'm not using any filter in the GET, its just "https://mycompany.okta.com/api/v1/apps"

Thanks,

Ken

Hi Ken!

By design Okta will return only 20 results but you can specify this limit in the URI:

{{url}}/api/v1/apps?limit=100

When using our APIs, Okta will return the first 100 results and will require to use pagination. For the next 100 entries will require to get the link from the header after a successful call.

Take a look at the example presented here: https://developer.okta.com/docs/api/getting_started/design_principles#link-header

Hello,

Thanks so much. Now I have a better understanding, but I've spent about 45 minutes here trying several things to get the next page and I cannot. I've found that I can set the limit to 200 and get the first 200 rows. Since we've got over 330 apps, I'm trying to figure out how to use the "after" and "next" parameters to get the following pages, but I can't figure out a combination of inputs to get it to work.

When I use Postman in Chrome, under the "Body" section I see the response. I can use an online converter to get it to 200 rows in a CSV. I can use the "Headers" section to see something like:

From what I understand, I'd need to send another GET that makes it relative to the ID of the first one. I'm just not able to figure it out. This is my first experience with any of this and it's foreign.

Can you help further? Or do I need to open a service request.

My goal here is to simply get a report of all my apps and what each one uses for "signOnMode".

Nevermind, I got it. I was making it more complicated than I needed to.

When I get the results from the first GET, and I look at the headers, I can see two links. One with "self" which was the first page and one with "next". All I had to do was copy and past the link with "next" into a new GET and I received the second page. I appreciate you sticking with me.

Hello Ken!

Thanks for posting your inquiry in Okta Community Portal.

If you really liked your answer, please help readers find it by marking it the best answer. Hover over the answer and click "Best Answer." 

Thank you,

Mike Davie

Okta Help Center