{"uid":"cap_OPSVkgBXx_oSDVZPeSlbv","slug":"price-basket-observations-string-normalisation-duplicate-key-report-3bf6c38f","name":"Price Basket Observations — String Normalisation + Duplicate Key Report","description":"Price basket observations — String normalisation + Duplicate key report: String normalisation + Duplicate key report for supplied price basket observations records (item_price, quantity_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-economics-07-021?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","region","date","item_price","quantity_weight"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"region":{"type":"string","default":"","maxLength":80},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"item_price":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"quantity_weight":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","region":"group-a","row_id":"row-1","item_price":10,"quantity_weight":1},{"date":"2026-10-02","region":"group-b","row_id":"row-2","item_price":20,"quantity_weight":2},{"date":"2026-10-03","region":"group-a","row_id":"row-3","item_price":15,"quantity_weight":3},{"date":"2026-10-04","region":"group-b","row_id":"row-4","item_price":30,"quantity_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_wAAEe_r35lC2JCJ9L4tBM","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 string normalisation and duplicate key detection reports on up to 200 price basket observation records containing item_price and quantity_weight fields.","exampleAgentPrompt":"Can you check my price basket observations for string normalisation issues and duplicate keys? I have 4 rows: row-1 in group-a on 2026-10-01 with item_price 10 and quantity_weight 1, row-2 in group-b on 2026-10-02 with item_price 20 and quantity_weight 2, row-3 in group-a on 2026-10-03 with item_price 15 and quantity_weight 3, and row-4 in group-b on 2026-10-04 with item_price 30 and quantity_weight 4.","exampleUseCases":[{"title":"Retail price survey data cleanup","prompt":"I've collected weekly price basket surveys from 3 regions — can you run a string normalisation and duplicate key check on these 50 rows of item_price and quantity_weight records before I import them into my database?"},{"title":"Economics research deduplication","prompt":"Before I analyse this dataset of 120 price basket observations across multiple dates and regions, can you flag any duplicate row IDs and highlight any string fields that need normalisation?"},{"title":"Automated pipeline data validation","prompt":"As part of my data pipeline, I need to validate incoming price basket records — please run the string normalisation and duplicate key reports on these 80 rows with their item_price and quantity_weight values and tell me what issues you find."}],"resultDescription":"Two independent reports: (1) a string normalisation report identifying string formatting inconsistencies across the supplied fields, and (2) a duplicate key report flagging rows with repeated or conflicting key combinations — both applied to the submitted price basket observation records (up to 200 rows).","failureModes":["Exceeding 200 rows returns a validation error","Missing required fields (row_id, region, date, item_price, quantity_weight) cause rejection","Invalid date format (non YYYY-MM-DD) fails schema validation","item_price or quantity_weight values outside ±1,000,000,000,000 are rejected","Empty rows array (minItems:1 not met) returns an error"],"whenToPreferThis":"Choose this endpoint when you need to simultaneously audit string normalisation quality and detect duplicate keys in price basket observation data (item_price, quantity_weight) in a single low-cost call. Ideal for pre-import validation, pipeline data quality gates, or economics research data preparation when working with up to 200 rows. Not suitable for live price lookups, forecasting, or datasets larger than 200 rows.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-26T12:31:49.432Z","isFirstParty":false,"canonicalSlug":"price-basket-observations-string-normalisation-duplicate-key-report-3bf6c38f"}