topic Re: Is it possible to export reports and custom data to excel? in Open Q&A

Is it possible to export reports and custom data to excel?

Zimmer — Thu, 06 Oct 2022 07:37:12 GMT

Hello,
I'm wondering if it's possible to export business cases or user stats based on the login into the separate excel file to create a report and send it to the management?

For instance, get the custom value from users which failed registration with a specific error like 503, onboarding reporting, or users who couldn't perform a password reset by percentage and export it into excel.

Re: Is it possible to export reports and custom data to excel?

AntonioSousa — Wed, 05 Oct 2022 10:19:23 GMT

@Zimmer,

If you can produce data data in Data Explorer, you can then output it as CSV.

Or you can also use the API to grab the data and produce whatever reports you need.

Re: Is it possible to export reports and custom data to excel?

bradley_danyo — Thu, 06 Oct 2022 21:02:59 GMT

Yes what I typically do for an excel report is build out an API call using our swagger page. You can use Excel to import data from web and use the request url that is given in the swagger page. When pasting the URL in excel, make sure you add &api-token=<YOUR_API_TOKEN>

https://support.microsoft.com/en-us/office/import-data-from-the-web-b13eed81-33fe-410d-9247-1747269c28e4#:~:text=Select%20Data%20%3E%20Get%20%26%20Transform%20%3E,View%20pane%20on%20the%20right.

Re: Is it possible to export reports and custom data to excel?

Zimmer — Fri, 07 Oct 2022 05:27:48 GMT

Yeah, with API you can do magic but I thought it will be somewhere out of the box in settings or somewhere.. seems the only right way is to use API.

Re: Is it possible to export reports and custom data to excel?

Zimmer — Fri, 07 Oct 2022 05:29:16 GMT

Yeah, that's the only way to use it per your needs with API you can do whatever you want but I thought it was already build-in functionality, seems not.
Thank you for the answer.