Summary: We've introduced the ability to filter by first time login on the RC service app and part of the requirement is to download the results.

Based on the amount of data, it would be problematic to do this in the front end. We should look to create a reporting function on the organisations endpoint to support a seperate section in the RC Service app specific for reporting.

Details specific to this requirement:

Provide a ‘Download CSV’ option on the RC Service App for 'Users' only
Extract to include the following fields
Name,
Email Address,
Job Title,
Active,
Mfa Status,
Tracking Consent,
Org Name,
Primary Org ID,
Date Created,
First Login Date ,
User Roles

Specification

• Project: Internal user service
• New endpoint GET /users/download that uses the same query object as the GET /users endpoint with the exception of page size/page number parameters
• Store the generated file in S3. New bucket to be created for this purpose with a lifecycle policy that deletes these files after 24 hours. Generate a random filename for the extract (guid is fine or similar). Use a redirect to send the user off to download the file
• Use same repository methods as the main endpoint to fetch the database from the data (this means that the same set of frontend filters can be used to serve as a report generator)
• Find a suitable package for generating an excel sheet. CSV is a bit old hat and we should consider moving away from it as people are likely going to want to do things with the data that a CSV won't support (potential option but check licensing)
• Once this is built and available log front end ticket with appropriate details