Plugins

turbot/mailchimp

GitHub
Overview
12Tables
Versions
GitHub
steampipe plugin install mailchimpsteampipe plugin install mailchimp
On This Page
Documentation
Quick start
Get involved
Get Involved
Edit on GitHub
Discuss on Slack
Source Code
turbot/steampipe-plugin-mailchimp
License
Apache License 2.0
Version
v0.0.3
Published
10 Jul 2023

Mailchimp + Steampipe

Mailchimp is a marketing automation and email marketing platform.

Steampipe is an open source CLI to instantly query cloud APIs using SQL.

List details of your Mailchimp campaign:

select
  id,
  title,
  content_type,
  create_time,
  emails_sent,
  send_time,
  status,
  type
from
  mailchimp_campaign;
+------------+------------------------------------+--------------+---------------------------+-------------+-----------+--------+------------------+
| id         | title                              | content_type | create_time               | emails_sent | send_time | status | type             |
+------------+------------------------------------+--------------+---------------------------+-------------+-----------+--------+------------------+
| f739729f66 | We're here to help you get started | template     | 2023-06-16T17:51:52+05:30 | <null>      | <null>    | save   | automation-email |
+------------+------------------------------------+--------------+---------------------------+-------------+-----------+--------+------------------+

Documentation

Quick start

Install

Download and install the latest Mailchimp plugin:

steampipe plugin install mailchimp

Credentials

ItemDescription
CredentialsMailchimp requires an API key for all requests.
PermissionsAPI keys have the same permissions as the user who creates them, and if the user permissions change, the API key permissions also change.
RadiusEach connection represents a single Mailchimp Installation.
Resolution1. Credentials explicitly set in a steampipe config file (~/.steampipe/config/mailchimp.spc)
2. Credentials specified in environment variables, e.g., MAILCHIMP_API_KEY.

Configuration

Installing the latest mailchimp plugin will create a config file (~/.steampipe/config/mailchimp.spc) with a single connection named mailchimp:

connection "mailchimp" {
  plugin = "mailchimp"


  # Mailchimp API key for requests. Required.
  # Generate your API Key as per: https://mailchimp.com/developer/marketing/guides/quick-start/#generate-your-api-key/
  # This can also be set via the `MAILCHIMP_API_KEY` environment variable.
  # api_key = "08355689e3e6f9fd0f5630362b16b1b5-us21"
}

Alternatively, you can also use the standard Mailchimp environment variables to obtain credentials only if other argument (api_key) is not specified in the connection:

export MAILCHIMP_API_KEY=q8355689e3e6f9fd0f5630362b16b1b5-us21

Get involved