CargoWise Data Extraction & Accounting via eAdapter
Bulk queries, job costing, invoices, and the CW1 SQL nobody documents. For everyone pulling data OUT of CargoWise — reporting, Power BI, reconciliation, and margin analysis.
For devs and BI consultants building reporting on top of CargoWise.
Get early accessLaunch discount for the wait list. One email when it ships, no spam.
Stop googling these
The Problems This Guide Solves
“CargoWise query multiple shipments by date range XML”
Native CriteriaGroup bulk queries with the full operator table that is documented nowhere public — including the default-to-Equal trap.
“CargoWise job costing charge lines via API”
Extracting buy, sell, and margin per shipment from JobCosting ChargeLines, parsed into a model you can actually report on.
“How to tell if a CargoWise billing line was autorated”
The flags everyone checks are unreliable — they mark charge-code eligibility, not this line. The ground truth is RatingSetPK.
“CargoWise Receipt template missing invoice line detail”
The DocBuilder AR Transaction context shift silently drops line items. Three workarounds, including the supported one.
“CargoWise org search returns empty for a valid company name”
Company names with & produce malformed XML that CW silently rejects, and the wildcard is % (SQL LIKE), not *.
What's inside
7 Chapters, Zero Filler
The complete bulk-query reference, margin extraction, and the undocumented SQL layer — the material consultants bill day-rates to rediscover.
Chapter 1 · Free preview
The Extraction Landscape
Three ways data leaves CW: Native XML queries, XSR retrieval, direct CW1 SQL. When to use which, and the ~50MB silent truncation reality.
Chapter 2
Native CriteriaGroup Bulk Queries
CriteriaGroup anatomy, the complete operator reference, the date-field catalogue for shipments and invoices, and three complete worked queries.
Chapter 3
Job Costing & Margin Extraction
ChargeLine buy/sell/margin per shipment, multi-currency margin math, and reconciling API totals against CW screen totals.
Chapter 4
The CW1 SQL Layer Nobody Documents
OsJobs, OsJobRate, OsJobEvent — the tables behind the UI. The RatingSetPK autorating recipe and safe read-only patterns against a live instance.
Chapter 5
DocBuilder & Document Data
The context hierarchy, why AR Invoice → AR Transaction drops line-item data, and three receipt workarounds.
Chapter 6
Organisation Search & XML Safety
Name/code/type-filtered org search templates, the & escaping trap, % wildcard semantics, double-encoding, and reading multi-company errors.
Chapter 7
Building the Reporting Pipeline
Scheduling extractions without hammering CW, incremental sync by date watermark, star-schema-lite shaping for Power BI, and freshness monitoring.
Get first access
The guide is being written now. Join the list for early access and a launch discount.
Already own Vol. 1? You get first access automatically.