Sync NGP Data

API Sync

Date range must fall within the last 90 days (NGP API limit). The export returns contributions changed in the window; the store is filtered to contributions received in the window.

CSV Backfill

Upload an NGP contribution export (.zip or .csv). The zip format is recommended for large files. Use this for periods older than 90 days. All rows are stored as source=csv and can be re-processed locally without hitting the API.

Source Codes

Upload an NGP source-code export. Either the raw CSV or the .zip it ships in works. Overwrites any matching code_ids in the local store.
API sync (may not match contribution source codes)
Pulls from the NGP /codes endpoint. The codes returned here may be unrelated to the source codes that appear on contribution records — pending confirmation from NGP.

646 source codes cached.

Local Store

282,173 contributions (Jan 05, 2025 – Apr 30, 2026)

Process stored contributions →

Sync History

Type Date Range / File Started Status Records Notes
csv_backfill ContributionReport-14775862799.csv 2026-05-15 01:21 ✓ complete 13,558
api_contributions Apr 01 – Apr 30, 2026 2026-05-15 01:15 ✓ complete 10,988 export job 5402280113
csv_source_codes SourceCodesReport-2823504317.csv 2026-05-15 01:14 ✓ complete 646
api_contributions Apr 01 – Apr 30, 2026 2026-05-15 01:08 ✓ complete 0 export job 5402242620
csv_source_codes SourceCodesReport-2823504317.csv 2026-05-15 01:08 ✓ complete 646
api_contributions Apr 01 – Apr 30, 2026 2026-05-15 01:03 ✗ error — Failed to fetch source codes: HTTP 403.
csv_source_codes SourceCodesReport-2823504317.csv 2026-05-15 01:03 ✓ complete 646
csv_source_codes SourceCodesReport-2823504317.csv 2026-05-15 00:59 ✗ error — invalid byte sequence for encoding "UTF8": 0x00
csv_source_codes SourceCodesReport-2823504317.csv 2026-05-15 00:59 ✗ error — invalid byte sequence for encoding "UTF8": 0x00
csv_backfill SourceCodesReport-2823504317.csv 2026-05-15 00:55 ✗ error — Missing columns: Contribution ID, VANID, Contact Name, Date Received, Amount, Source Code, Designation, Payment Method, Remaining Amount, Financial Batch, Period, Cycle, Contribution Type, Source Code ID, Source Code Path, Direct Marketing Code. Expected NGP contribution report format.
api_contributions Apr 01 – Apr 30, 2026 2026-05-14 17:34 ✗ error — Failed to fetch source codes: HTTP 403.
api_contributions Apr 01 – Apr 30, 2026 2026-05-14 17:07 ✗ error — Failed to fetch source codes: HTTP 403.
api_contributions Apr 01 – Apr 30, 2026 2026-05-14 17:07 ✗ error — Failed to fetch source codes: HTTP 403.
csv_backfill ContributionReport-3118171282.csv 2026-04-18 01:15 ✓ complete 268,616
csv_backfill ContributionReport-3118171282.csv 2026-04-18 00:45 ⚠ cancelled — Cancelled: browser disconnected or server restarted
csv_backfill ContributionReport-3118171282.csv 2026-04-17 21:39 ✗ error — unsupported Unicode escape sequence DETAIL: \u0000 cannot be converted to text.
csv_backfill ContributionReport-3118171282.csv 2026-04-17 21:06 ⚠ cancelled — Cancelled: browser disconnected or server restarted
csv_backfill ContributionReport-3118171282.csv 2026-04-17 20:56 ⚠ cancelled — Cancelled: browser disconnected or server restarted
source_codes — 2026-04-17 01:48 ✓ complete 0
api_contributions Mar 01 – Mar 31, 2026 2026-04-17 01:47 ✓ complete 0 export job 5339759667