Table: mailchimp_authorized_app - Query Mailchimp Authorized Apps using SQL

Mailchimp Authorized Apps are applications that have been granted permission to access a Mailchimp account. This access is granted by the account owner, and can be revoked at any time. Authorized Apps can perform various actions on the account, limited by the permissions set by the account owner.

Table Usage Guide

The mailchimp_authorized_app table provides insights into the apps authorized to access a Mailchimp account. As an account owner or administrator, you can use this table to manage and monitor app access to your Mailchimp account. It can be used to review app details, including permissions, access levels, and associated metadata.

Examples

Basic info

Explore which authorized applications are connected to your Mailchimp account, gaining insights into their names and descriptions for better management and oversight.

select
  id,
  name,
  description
from
  mailchimp_authorized_app;

select
  id,
  name,
  description
from
  mailchimp_authorized_app;

List users who have linked the app

Explore which users have connected their accounts with the application, useful for understanding user engagement and app utilization.

select
  id,
  name,
  description,
  u as user
from
  mailchimp_authorized_app,
  jsonb_array_elements_text(users) u;

select
  id,
  name,
  description,
  u.value as user
from
  mailchimp_authorized_app,
  json_each(mailchimp_authorized_app.users) as u;

Schema for mailchimp_authorized_app

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
account_id	text	=, !=, ~~, ~~, !~~, !~~	The Mailchimp account ID.
description	text		A short description of the application.
id	bigint	=	The ID for the application.
name	text		The name of the application.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
title	text		The title of the resource.
users	jsonb		An array of usernames for users who have linked the app.

Export

This table is available as a standalone Exporter CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.

You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_export_installer.sh script:

/bin/sh -c "$(curl -fsSL https://steampipe.io/install/export.sh)" -- mailchimp

You can pass the configuration to the command with the --config argument:

steampipe_export_mailchimp --config '<your_config>' mailchimp_authorized_app