SFMC Data Loader — VS Code Extension

A lightweight VS Code extension that surfaces the sfmc-dataloader CLI (mcdata) as Command Palette commands.

Requirements

An mcdev project initialised with mcdev (.mcdevrc.json + .mcdev-auth.json in the workspace root)
sfmc-dataloader installed globally or available as a local binary:

npm install -g sfmc-dataloader
# or inside the project
npm install sfmc-dataloader

Commands

Command Palette

Command	Description
`SFMC Data: Export DE Data`	Export one or more Data Extension rows to CSV/TSV/JSON
`SFMC Data: Export DE Data (Multi-BU)`	Export from several BUs in one command
`SFMC Data: Import DE Data`	Import rows from a file or by DE key
`SFMC Data: Import DE Data (Cross-BU)`	Import rows from one BU into multiple target BUs via the SFMC API

Both commands open a guided QuickPick workflow:

Select credential (skipped when only one exists)
Select Business Unit (skipped when only one exists)
Enter DE key(s) or select file(s)

Right-click any of the following files in the VS Code Explorer to access the SFMC Data Loader submenu:

*.dataExtension-meta.json or *.dataExtension-doc.md under retrieve/<cred>/<bu>/dataExtension/
*+MCDATA+* export files under data/<cred>/<bu>/

You can multi-select files within the same BU and all commands will operate on them together.

Context menu item	retrieve/ files	data/ files
Export Data	`mcdata export <cred/bu> --de <key>...`	same
Export from BUs...	Multi-select source BUs (pre-selects current BU), runs `mcdata export --from ...`	same
Import Data	`mcdata import <cred/bu> --de <key>...` (resolves latest export file)	`mcdata import <cred/bu> --file <path>...`
Import to BU...	Multi-select target BUs, runs `mcdata import --from <src> --to <tgt>... --de <key>...`	Multi-select target BUs, runs `mcdata import --to <tgt>... --file <path>...`

The assembled mcdata command runs in a dedicated integrated terminal so you can see live output.

Settings

Setting	Default	Description
`sfmcData.mcdataPath`	`""`	Custom path to the `mcdata` binary. Leave blank to use `mcdata` from `PATH`.
`sfmcData.importApi`	`async`	REST API family used for imports (`async` \| `sync`).
`sfmcData.defaultMode`	`upsert`	Default row write mode (`upsert` \| `insert` \| `update`). `insert` and `update` require `--api sync`.
`sfmcData.defaultFormat`	`csv`	Default file format for exports and imports (`csv` \| `tsv` \| `json`).

How it works

The extension reads .mcdevrc.json to populate credential and BU quick-picks. It then constructs a mcdata export or mcdata import command and runs it in VS Code's integrated terminal with the mcdev project root as the working directory.

No SFMC API calls are made by the extension itself — all network activity goes through the mcdata CLI.

Release Notes

See CHANGELOG.md.

SFMC Data Loader

Jörn Berkefeld