{"uid":"cap_KPuLs0NMJzoz12V7C4CvX","slug":"public-procurement-string-normalisation-and-exact-row-deduplication-d936c0c3","name":"Public Procurement String Normalisation and Exact Row Deduplication","description":"Public procurement — String normalisation + Exact row deduplication: String normalisation + Exact row deduplication for supplied public procurement records (contract_amount, bid_count). 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-17-020?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","region","date","contract_amount","bid_count"],"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},"bid_count":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"contract_amount":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","region":"group-a","row_id":"row-1","bid_count":1,"contract_amount":10},{"date":"2026-10-02","region":"group-b","row_id":"row-2","bid_count":2,"contract_amount":20},{"date":"2026-10-03","region":"group-a","row_id":"row-3","bid_count":3,"contract_amount":15},{"date":"2026-10-04","region":"group-b","row_id":"row-4","bid_count":4,"contract_amount":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_vAvZ-XwbiE2vphbPS0s1T","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 removes exact duplicate rows from up to 200 public procurement records containing contract amount and bid count fields, returning 2 analytical reports.","exampleAgentPrompt":"Can you clean up these 50 procurement records — normalise the region and date strings and flag any exact duplicate rows? The records include row IDs, dates like 2026-10-01, regions like 'North-West', contract amounts, and bid counts.","exampleUseCases":[{"title":"Pre-analysis procurement data cleaning","prompt":"I have 120 procurement rows from Q3 with region names, contract amounts, and bid counts — can you normalise all the strings and remove any exact duplicates before I run my analysis?"},{"title":"Auditing government contract records","prompt":"We exported 80 government contract records with fields for row ID, date, region, contract amount, and bid count. Can you run string normalisation and exact deduplication on them and give me two reports?"},{"title":"Spotting duplicate bids in tender dataset","prompt":"Here are 200 procurement tender rows — each has a row ID, date, region, contract amount, and bid count. Please normalise the text fields and identify any rows that are exact duplicates so we can clean the dataset."}],"resultDescription":"Two analytical reports: one covering string normalisation outcomes (standardised field values for region, date, and other text fields) and one covering exact row deduplication results (identified duplicate row IDs and deduplicated dataset summary), applied to the submitted procurement records.","failureModes":["More than 200 rows submitted — request rejected due to row limit","Missing required fields (row_id, region, date, contract_amount, bid_count) cause validation errors","Date field not matching YYYY-MM-DD pattern causes schema rejection","contract_amount or bid_count outside allowed numeric range causes rejection","Empty rows array rejected due to minItems:1 constraint"],"whenToPreferThis":"Choose this endpoint when you have up to 200 public procurement records with contract_amount and bid_count fields and need both string normalisation and exact duplicate row detection in a single low-cost call. It is purpose-built for procurement data quality workflows and returns two independent reports from shared local analytical engines without any live lookups or external calls, making it suitable for deterministic, repeatable data cleaning pipelines.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-22T12:44:58.889Z","isFirstParty":false,"canonicalSlug":"public-procurement-string-normalisation-and-exact-row-deduplication-d936c0c3"}