{"uid":"cap_qtU4qJUUpravpaWaGTjZF","slug":"sampling-observations-string-normalisation-duplicate-key-report-e6cf5702","name":"Sampling Observations — String Normalisation + Duplicate Key Report","description":"Sampling observations — String normalisation + Duplicate key report: String normalisation + Duplicate key report for supplied sampling observations records (sample_value, sample_weight). 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-analytics-15-021?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","dataset_group","date","sample_value","sample_weight"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"sample_value":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"dataset_group":{"type":"string","default":"","maxLength":80},"sample_weight":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","sample_value":10,"dataset_group":"group-a","sample_weight":1},{"date":"2026-10-02","row_id":"row-2","sample_value":20,"dataset_group":"group-b","sample_weight":2},{"date":"2026-10-03","row_id":"row-3","sample_value":15,"dataset_group":"group-a","sample_weight":3},{"date":"2026-10-04","row_id":"row-4","sample_value":30,"dataset_group":"group-b","sample_weight":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_llSWNB4yHMp6ywj4UUWv1","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":"Runs two local analytical reports on sampling observation records: string normalisation of text fields and duplicate key detection, for up to 200 rows.","exampleAgentPrompt":"Can you check these 50 sampling observation rows for duplicate row IDs and normalise any inconsistent string values in the dataset_group field? Each row has a row_id, date, sample_value, and sample_weight.","exampleUseCases":[{"title":"Deduplicating survey sample records","prompt":"I have 120 rows of survey sampling data with row_id, date, sample_value, and sample_weight — can you check for any duplicate row IDs and flag them for me?"},{"title":"Normalising dataset group labels before aggregation","prompt":"Before I aggregate my sampling observations, can you normalise the dataset_group strings across these 80 rows so inconsistent capitalisation or spacing doesn't cause mismatches?"},{"title":"Pre-pipeline data quality check on sampling exports","prompt":"I'm about to load 150 sampling observation records into our pipeline — can you run a duplicate key report and string normalisation check on them first so I know the data is clean?"}],"resultDescription":"Two structured reports: (1) a string normalisation report identifying and correcting inconsistent text values in fields like dataset_group across submitted rows; (2) a duplicate key report listing any row_id values that appear more than once. Both reports cover up to 200 input rows and are generated using local analytical engines with no external lookups.","failureModes":["Input array is empty or exceeds 200 rows — request rejected","Rows missing required fields (row_id, date, sample_value, sample_weight) — validation error","Date field does not match YYYY-MM-DD pattern — schema rejection","sample_value or sample_weight outside allowed numeric range — rejection","Malformed JSON body — parse error","Payment not included or insufficient — 402 Payment Required"],"whenToPreferThis":"Choose this endpoint when you have up to 200 sampling observation records (with sample_value and sample_weight fields) and need both string normalisation and duplicate key detection in a single low-cost call ($0.01 USDC). It is ideal for pre-pipeline data quality checks on survey or measurement datasets where row uniqueness and consistent text labels matter. Prefer alternatives if you need outlier detection, statistical summaries, pivot tables, or more than 200 rows.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-24T00:54:35.913Z","isFirstParty":false,"canonicalSlug":"sampling-observations-string-normalisation-duplicate-key-report-e6cf5702"}