dlt-source-app-store-connect 0.2.0

A dlt source for Apple App Store Connect API

dlt-source-app-store-connect

A dlt source for Apple App Store Connect API.

Features

• 15 resources covering apps, builds, TestFlight, subscriptions, and reports
• Incremental loading for sales, finance, and analytics reports
• Automatic JWT token refresh
• Rate limit handling with exponential backoff
• Works with any dlt destination (BigQuery, Snowflake, DuckDB, etc.)

Installation

pip install dlt-source-app-store-connect

Or with uv:

uv add dlt-source-app-store-connect

Quick start

import dlt
from dlt_source_app_store_connect import app_store_connect_source

pipeline = dlt.pipeline(
    pipeline_name="app_store_connect",
    destination="bigquery",  # or any dlt destination
    dataset_name="source_app_store_connect",
)

source = app_store_connect_source(
    key_id="YOUR_KEY_ID",
    issuer_id="YOUR_ISSUER_ID",
    private_key=open("AuthKey_XXXXX.p8").read(),
    vendor_number="YOUR_VENDOR_NUMBER",  # required for sales/finance reports
)

load_info = pipeline.run(source)
print(load_info)

Load specific resources

source = app_store_connect_source(
    key_id="YOUR_KEY_ID",
    issuer_id="YOUR_ISSUER_ID",
    private_key=open("AuthKey_XXXXX.p8").read(),
    resources=["apps", "builds", "sales_reports"],
)

Resources

Resource	Write Disposition	Incremental	Description
apps	merge	-	App metadata
app_store_versions	merge	-	App Store version history
builds	merge	-	Build information
beta_testers	merge	-	TestFlight testers
beta_groups	merge	-	TestFlight groups
bundle_ids	merge	-	Bundle identifiers
certificates	merge	-	Signing certificates
devices	merge	-	Registered devices
in_app_purchases	merge	-	In-app purchase products
subscriptions	merge	-	Subscription products
subscription_groups	merge	-	Subscription groups
users	merge	-	Team members
sales_reports	append	daily	Sales and trends reports
finance_reports	append	monthly	Financial reports
analytics_reports	append	by processing date	Analytics reports

sales_reports and finance_reports require vendor_number.

Authentication

You need an API key from App Store Connect.

Required credentials:

Parameter	Description
key_id	The identifier for your API key
issuer_id	Your team's issuer ID
private_key	Contents of the .p8 file downloaded when creating the key
vendor_number	Your vendor number (required for sales/finance reports)

Development

git clone https://github.com/ota2000/dlt-source-app-store-connect.git
cd dlt-source-app-store-connect
uv sync --group dev
uv run pytest -v
uv run ruff check .

Contributing

See CONTRIBUTING.md.

License

MIT