Integration TrailsINTEGRATION/TRAILS
FORGENewARTICLESMODULESCHALLENGESLEADERBOARDPRICINGABOUTDASHBOARD
INTEGRATION/TRAILS

Stop Reading Theory. Start Solving Problems.

// Built by practitioners
// PlatformModulesChallengesLeaderboardTrailsArticles
// ConnectNewsletterYouTubeTikTokAbout Us
// SupportHelp & SupportContact
© 2026 — Integration TrailsContent — CC BY-NC-SA | Code — MIT LicenseVER:2026-08-11-72a9b56
Challenges/ch-16-rest-pricing-dedup·DataWeave·INTERMEDIATE
DataWeaveINTERMEDIATE

Pricing Bulk Import with Deduplication

A retail pricing team submits bulk CSV files via a REST endpoint. The raw feed is noisy: it can contain duplicate SKU rows from the client's export tool, blank product names, and zero-price entries that must be rejected. You will transform the CSV client model into the JSON envelope the MuleSoft process layer expects — deduplicating entries by SKU, filtering out unapproved items, and reporting how many rows were skipped in the response envelope.

#deduplication#bulk-import#csv#rest-api
BY @patryk_bandurski
Community rating
—
Not rated yet
Sign in to rate
DWL
// READY TO BEGIN

Make it
count.

  • 3 attempts on every challenge
  • XP points & leaderboard scored
  • Public profile & shared trail
  • Newsletter weekly with API replay
Sign Up Free →Already a member → Sign in
// Built by practitioners

The fastest way
to learn integration.

Every challenge ships with a real-world payload, a graded test suite, and a walkthrough by a practitioner. No surface-level theory — just problems, solved.

…Challenges
…Modules
// You're reading in preview mode

You can read everything.
Coding requires an account.

🔒 IDE locked · sign in to enable
%dw 2.0
output application/json
---
payload
// Sign up to run, submit, and earn XP on this challenge
// Be first to rate this challenge!SCROLL TO READ ↓

The fastest way
to learn integration.

01.
Production payloads
Real CSV/JSON/XML you'll meet on day one — null fields, mixed casing, partial records.
02.
Design problems
What practitioners actually solve — null-safety, idempotency, retries, batch boundaries.
03.
Edge cases that break
Empty arrays, type coercion, deeply nested transforms, locale-specific dates.
…
CHALLENGES
…
MODULES
// Free forever · No credit card

Sign up.
Then code.

Free accounts get 3 attempts per challenge, full XP, and your trail progress synced across devices.

▶ Sign up free →Have an account? Sign in →
// WHAT YOU'LL BUILDHOW IT WORKS ↓
01.
Live DataWeave editor
Real DWL 2.0 IDE with helpers, modules, syntax highlighting.
02.
Test cases run on real runner
Same Go runner used in prod. Diffs show exactly which fields fail.
03.
3 graded attempts
Submit when you're ready. Score persists. Solution unlocks after pass or last attempt.
04.
Helpers & multi-module DWL
Bring in reusable %dw modules. Import, export, compose.
05.
XP & leaderboard
Points + XP awarded per challenge. Trail progress synced.
06.
Production-style payloads
Real CSV/JSON/XML — null fields, mixed casing, partial records.