Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Add Web API to dump badge data #255

Open
rockfordlhotka opened this issue Apr 10, 2017 · 1 comment
Open

Add Web API to dump badge data #255

rockfordlhotka opened this issue Apr 10, 2017 · 1 comment

Comments

@rockfordlhotka
Copy link
Contributor

rockfordlhotka commented Apr 10, 2017

We need a web API that dumps the badge data - counts of each badge per person - so ad-hoc reporting is possible via Excel or other analytics tool (Power BI?).

The output from this service will be loaded into Excel, so the output should be a CSV or tab-delimited text file that can be downloaded. It is less of a "service" than downloading a generated file.

Each row in the file should contain:

  • Username (e.g. "rockyl")
  • User first name
  • User last name
  • Badge id
  • Badge name
  • Badge graphic URL
  • Date awarded
  • Amount awarded for badge
  • Was the amount paid out for this badge

The output should include all badges for all people - just a big table of data that can be analyzed in Excel.

@Bowman74
Copy link
Contributor

For a short term fix we can at least have a call people can make to return all the people who have received a particular badge. Query should look something like:

select ba.badgeawardid, ba.awardAmount, ba.paidout, B.BadgeName, E.FirstName, E.LastName, BA.awardDate from badgeaward BA inner join employee E on BA.employeeid = E.employeeid inner join badge B on BA.badgeid = B.badgeid where B.BadgeName = 'Secure Developer Level 1'

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants