Chatbot command for adding #coverage news items to airtables

[patcon]

Current Behavior

Someone (often @lourdesvera) must do the task of adding press releases to airtable. Due to the nature of the task, it is done by a single person for indefinite periods of time. It is invisible work. Others don't often think to help.

Desired Behavior

If new press entries could be added to the press coverage table via a public slack command, then it could be more of a public, shared task.

With just the link, we could add the title and publish date, and some other simple details. The remaining details could be filled in manually every so often, when someone visits the airtable on a less regular basis.

Proposal

Add a halpy chatbot command that works like this:

myname> halpy add press https://example.com/article.html
halpy> added the following article to the press database: "Some headline" (Mar 12, 2018) by Jane Doe
myname> halpy add press https://example.com/article.html
halpy> the link you submitted is already in the press database

---

It would be nice if anyone could add items to the press coverage table from the slack team, so it's not all on one person to maintain it. We can do this with a chatbot command.

• edgi namespace is prob nice, so our custom commands are a little more clear.
• coverage table on airtable [private]
• airtable api method for creating item [private]
• airtable.js node library

This is probably the command format we'd want

@halpy edgi coverage add 05/27/2017 http://example.com

This is an api call that check whether the link already exists in the table:

http GET "https://api.airtable.com/v0/apps6l3sgNsC4WzOq/Coverage?maxRecords=3&view=Main%20View" Authorization:"Bearer $AIRTABLE_API_KEY" filterByFormula=="SEARCH('https://thetech.com/2017/02/22/datarescue-students-collaborate-vital', {Link}) > 0" maxRecords==200

[dcwalk]

~Could to speak a little bit to how adding something to the airtable would add details about what is covered at that URL?~

~And does that mean that the airtable coverage would somehow be checking against all coverage? (Which is the difficulty that I think that repo is addressing: reconciling across updating sources)~

OMG "Coverage" collision, I was thinking coverage from Archivers, not News Coverage. Disregard above 😳

[patcon]

https://github.com/mozilla/readability https://github.com/ageitgey/node-unfluff

[stale[bot]]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed in seven days if no further activity occurs. If it should not be closed, please comment! Thank you for your contributions.