dvload
v0.2.0
Published
Load Excel/Power Query tables into Microsoft Dataverse from the command line. Schedules via Windows Task Scheduler.
Maintainers
Readme
dvload
Load Excel tables (typically Power Query output) into Microsoft Dataverse
from the command line. Pairs with Windows Task Scheduler for daily
unattended imports. The mapping (.dvmap.json) is built visually in the
companion Excel add-in
and run here.
Install
npm i -g dvloadRequires Node 20+. Windows 10/11 for scheduling and Power Query refresh.
Quick start
# one-time sign-in (opens your browser; no Entra setup, no admin consent)
dvload login --env https://yourorg.crm.dynamics.com
# sanity-check a mapping against live Dataverse metadata
dvload validate ./contacts.dvmap.json
# dry run, then the real thing
dvload run ./contacts.dvmap.json -w ./customers.xlsx --dry-run
dvload run ./contacts.dvmap.json -w ./customers.xlsx --refresh
# nightly at 03:30 (see docs for unattended app-only auth)
dvload schedule ./contacts.dvmap.json -w ./customers.xlsx --time 03:30Documentation
- Full README — auth model, all commands, mapping format, .pqt bridge
- Unattended scheduled runs — app-only auth setup for schedules
License
MIT
