{"uid":"cap_48W0AdtVAopSomt56C0VU","slug":"soil-moisture-observations-string-normalisation-exact-row-deduplication-ab841899","name":"Soil Moisture Observations — String Normalisation & Exact Row Deduplication","description":"Soil moisture observations — String normalisation + Exact row deduplication: String normalisation + Exact row deduplication for supplied soil moisture observations records (moisture_percent, depth_cm). Up to 200 rows; 2 independent reports using shared local analytical engines. No live lookup, prediction, professional assessment or external action. 0.01 USDC includes 2 supplied-data reports for up to 200 rows.","url":"https://market.datapackvibe.com/x402/assistant-ib26-weather-08-020?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","station_group","date","moisture_percent","depth_cm"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"depth_cm":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"station_group":{"type":"string","default":"","maxLength":80},"moisture_percent":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","depth_cm":1,"station_group":"group-a","moisture_percent":10},{"date":"2026-10-02","row_id":"row-2","depth_cm":2,"station_group":"group-b","moisture_percent":20},{"date":"2026-10-03","row_id":"row-3","depth_cm":3,"station_group":"group-a","moisture_percent":15},{"date":"2026-10-04","row_id":"row-4","depth_cm":4,"station_group":"group-b","moisture_percent":30}],"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_4zEkxJbPVPBfKw2zR3PNb","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":"Normalises strings and deduplicates exact rows in supplied soil moisture observation records (moisture_percent, depth_cm) for up to 200 rows, returning 2 analytical reports.","exampleAgentPrompt":"Clean up my soil moisture observation records — normalise the strings and remove any exact duplicate rows. I have about 50 records with fields like row_id, station_group, date, moisture_percent, and depth_cm. Can you run string normalisation and deduplication on them and give me back the 2 analytical reports?","exampleUseCases":[{"title":"Agricultural sensor data cleanup","prompt":"I've got 120 soil moisture readings from our field stations — some station names have inconsistent capitalisation and I suspect there are duplicate entries. Can you normalise the strings and deduplicate exact rows across moisture_percent and depth_cm fields and give me the analysis reports?"},{"title":"Pre-processing before irrigation modelling","prompt":"Before I feed this soil moisture dataset into our irrigation model, I need to clean it up — please normalise all the string fields and strip out any exact duplicate rows. The dataset has around 80 records with station_group, date, moisture_percent, and depth_cm columns."},{"title":"Multi-station data reconciliation","prompt":"We merged soil moisture data from two monitoring networks and now have duplicate rows and messy station group names. Can you run string normalisation and exact row deduplication on these 150 records so I get two clean analytical reports back?"}],"resultDescription":"Two independent analytical reports covering: (1) string-normalised versions of the supplied soil moisture records and (2) exact duplicate row identification and removal results, both derived locally from the submitted rows without any external data lookup or prediction.","failureModes":["Exceeding 200 rows returns a validation error","Missing required fields (row_id, station_group, date, moisture_percent, depth_cm) causes rejection","Invalid date format (non-YYYY-MM-DD) fails pattern validation","Empty rows array (minItems:1 violated) returns error","Null numeric values for moisture_percent or depth_cm may affect deduplication logic"],"whenToPreferThis":"Choose this endpoint when you need lightweight, low-cost ($0.01 USDC) offline string normalisation and exact row deduplication specifically for soil moisture observation records (moisture_percent, depth_cm) without requiring any live data lookup, prediction, or external action. Ideal for data pipeline pre-processing steps where you want two structured analytical reports on batches of up to 200 rows.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-24T12:53:33.600Z","isFirstParty":false,"canonicalSlug":"soil-moisture-observations-string-normalisation-exact-row-deduplication-ab841899"}