Sendgrid - Get activity feed as dataframe

[jravenel]

Input :
Sendgrid API KEY

Output :

• STATUS
• MESSAGE
• TO
• LAST_EVENT
• OPEN
• CLICKS

[jravenel]

@FlorentLvr
@SanjuEpic as discussed last week. This is a good one for this week.

[SanjuEpic]

Great!

[SanjuEpic]

Just posting my findings related to information that we can extract with SendGrid:

1. Getting started with SendGrid API -> https://docs.sendgrid.com/api-reference/how-to-use-the-sendgrid-v3-api/
2. 100 emails/day forever with SendGrid API free account
3. Once an account is created, create your own API key for future access (https://app.sendgrid.com/settings/api_keys)
4. https://docs.sendgrid.com/api-reference/users-api/get-a-users-profile (for users profile info)
5. https://docs.sendgrid.com/api-reference/e-mail-activity/filter-all-messages (for this issue)
6. https://docs.sendgrid.com/api-reference/stats/retrieve-global-email-statistics (For global email statistics)

I am planning to currently work wrt SendGrid's rest API/ python package of sendgrid, below are the minimum requirements:
API url -> https://api.sendgrid.com/v3/messages
Header format for this issue-> "Authorization: Bearer <<YOUR_API_KEY_HERE>>"

Thanks and let me know if anything more is required!