{"uid":"cap_hZrWsHz0lZgQjKhLktB9c","slug":"shipment-costs-exact-row-deduplication-f9185237","name":"Shipment Costs Exact Row Deduplication","description":"Shipment costs - Exact row deduplication: Exact row deduplication for Shipment costs. Up to 200 supplied typed records. Local numeric and data-quality processing; no external enrichment or forecasting. One of 25 profiles or calculations across 20 shared operations in this sector. 0.01 USDC includes one bounded exact row deduplication deliverable.","url":"https://market.datapackvibe.com/x402/assistant-sector-analytics-shipment-costs-deduplicate?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","carrier","date","weight_kg","shipping_cost"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"carrier":{"type":"string","default":"","maxLength":80},"weight_kg":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"shipping_cost":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","carrier":"group-a","weight_kg":10,"shipping_cost":1},{"date":"2026-10-02","row_id":"row-2","carrier":"group-b","weight_kg":20,"shipping_cost":2},{"date":"2026-10-03","row_id":"row-3","carrier":"group-a","weight_kg":15,"shipping_cost":3},{"date":"2026-10-04","row_id":"row-4","carrier":"group-b","weight_kg":30,"shipping_cost":4}],"maxItems":200,"minItems":1}}},"responseSchema":null,"example":null,"exampleRequest":null,"tags":["x402"],"displayCostAmount":"0.01","displayCostAsset":"USDC","priceDynamic":false,"priceHint":null,"priceStatus":"priced","priceSource":"probe","requiresHandshake":false,"reviewCount":0,"rating":{"score":"0.00","successRate":"0.00","reviews":0,"stars":null,"state":"unrated"},"availabilityStatus":"unknown","priceObserved":null,"sessionDeposit":null,"pricing":{"kind":"static","summary":"$0.01/call","primary":{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.01","per":"call","confidence":"exact"},"accepted":[{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.01","per":"call","confidence":"exact"}]},"paymentMethods":[{"uid":"pm_dYhI42SYJvRrfYmcvOrff","protocol":"x402","methodType":"crypto","chain":"base","mode":"charge","costAmount":"0.01","costPer":"request","priority":0,"asset":"0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913","unit":"request","depositMicros":null,"planRef":null}],"brandName":null,"brandSlug":null,"brandBaseUrl":null,"brandDocsUrl":null,"whatItDoes":"Removes exact duplicate rows from a shipment costs dataset of up to 200 typed records using local numeric and data-quality processing.","exampleAgentPrompt":"Can you deduplicate these shipment cost records for me? I have up to 50 rows each with a row_id, carrier name, date, weight in kg, and shipping cost — please remove any exact duplicate rows and return the cleaned dataset.","exampleUseCases":[{"title":"Clean freight billing data before reporting","prompt":"I have a batch of shipment cost records exported from our TMS and I think there are duplicate entries — each row has a row_id, carrier, date, weight_kg, and shipping_cost. Can you run exact row deduplication on them so I get a clean list before I build the monthly freight spend report?"},{"title":"Deduplicate carrier invoices before payment","prompt":"Before we process carrier payments, I need to make sure we don't have any duplicate rows in our shipment cost file. Here are up to 150 records with row IDs, carrier names, dates, weights, and costs — please strip out any exact duplicates."},{"title":"Data quality check on imported logistics records","prompt":"We just imported shipment cost data from two different warehouse systems and there may be overlapping rows. Can you deduplicate the combined dataset — it has fields for row_id, carrier, date, weight_kg, and shipping_cost — and give me back only the unique records?"}],"resultDescription":"A cleaned collection of shipment cost rows with exact duplicate records removed, preserving one copy of each unique row. The response reflects local data-quality processing with no external enrichment, returning only the deduplicated subset of the submitted records.","failureModes":["Empty or missing rows array returns validation error","Rows array exceeds 200 items — request rejected","Invalid date format (not YYYY-MM-DD) causes schema validation failure","Missing required fields (row_id, carrier, date, weight_kg, shipping_cost) causes rejection","Payment failure results in no processing","Malformed numeric values outside allowed range rejected"],"whenToPreferThis":"Choose this endpoint when you have up to 200 shipment cost rows with structured fields (row_id, carrier, date, weight_kg, shipping_cost) and need fast, low-cost exact deduplication without any external API calls or enrichment. Ideal for data pipeline pre-processing steps before analytics or payment runs, where you need a simple deterministic duplicate removal on typed shipment records at minimal cost ($0.01 per call).","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-15T18:48:43.545Z","isFirstParty":false,"canonicalSlug":"shipment-costs-exact-row-deduplication-f9185237"}