mailarchive
mailarchive copied to clipboard
ietf-tools
Create data export API
owner:[email protected] type_enhancement | by [email protected]
Need a data export API for providing an external reporting tools, dashboard, with mailing list data. See IMR Reports "lists" and "subcounts" reports for example.
Issue migrated from trac:2488 at 2022-03-03 10:01:19 +0000
@[email protected] commented
The datatracker imports data from mailman, so some of this is available through the datatracker API; see for instance https://datatracker.ietf.org/api/v1/mailinglists/list/ .
@[email protected] commented
Datatracker uses the export feature to get message info for use in the Review process. See here: /ietf/review/mailarch.py. It would be better to use an API that returns JSON.
@[email protected] commented
From #1333
The output should be just a table, showing the date range in the title, with the following columns:
List Name Total number of messages posted Total number of unique subjects Total number of unique senders
Other interesting data Number of messages posted on each list month. Number of overall messages in each list's archive. How many different people posted messages in the last month. Who are the most active (nonspam) posters.
API Data (suggested by Robert 10-2021)
At some point, we should talk about either extending the api endpoint you've already started, or adding another one, that will answer questions like this one easily. Other variants would be "What lists and how many messages did
Messages from the ietf list for the week ending Sun Oct 10 06:00:20 2021
Count | Bytes | Who ------------+----------------+------- 76 ( 100%) | 623655 ( 100%) | Total 10 (13.2%) | 85410 (13.7%) | Salz, Rich [email protected] 6 ( 7.9%) | 39144 ( 6.3%) | Keith Moore [email protected] 5 ( 6.6%) | 37813 ( 6.1%) | Lloyd W [email protected] 5 ( 6.6%) | 27052 ( 4.3%) | Toerless Eckert [email protected] 4 ( 5.3%) | 59871 ( 9.6%) | Ron Bonica [email protected] ...
