{"uid":"cap_MOgirqq3PPcm3LMJ3akfg","slug":"onboarding-progress-string-normalisation-exact-row-deduplication-2614ff24","name":"Onboarding Progress — String Normalisation + Exact Row Deduplication","description":"Onboarding progress — String normalisation + Exact row deduplication: String normalisation + Exact row deduplication for supplied onboarding progress records (completed_steps, required_steps). 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-operations-08-020?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","team_group","date","completed_steps","required_steps"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"team_group":{"type":"string","default":"","maxLength":80},"required_steps":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"completed_steps":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","team_group":"group-a","required_steps":1,"completed_steps":10},{"date":"2026-10-02","row_id":"row-2","team_group":"group-b","required_steps":2,"completed_steps":20},{"date":"2026-10-03","row_id":"row-3","team_group":"group-a","required_steps":3,"completed_steps":15},{"date":"2026-10-04","row_id":"row-4","team_group":"group-b","required_steps":4,"completed_steps":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_xB-WySmfGXbnNzD8ZwUH6","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 string fields and deduplicates exact rows in onboarding progress records (completed_steps, required_steps) for up to 200 rows, returning 2 analytical reports.","exampleAgentPrompt":"Can you clean up my onboarding progress records by normalising the string fields and removing any exact duplicate rows? I have data for 4 rows: row-1 group-a 2026-10-01 completed=10 required=1, row-2 group-b 2026-10-02 completed=20 required=2, row-3 group-a 2026-10-03 completed=15 required=3, row-4 group-b 2026-10-04 completed=30 required=4.","exampleUseCases":[{"title":"Deduplicating HR onboarding batch export","prompt":"I exported our onboarding progress records and suspect there are duplicate rows — can you run string normalisation and exact deduplication on these 50 entries so I get a clean dataset? Here are the rows with row_id, team_group, date, completed_steps, and required_steps fields."},{"title":"Standardising team group names before reporting","prompt":"Our onboarding data has inconsistent capitalisation and spacing in the team_group field across 120 rows — can you normalise the strings and flag any exact duplicates so I have clean data ready for our weekly report?"},{"title":"Auditing onboarding completion data quality","prompt":"Before I load this batch of 200 onboarding progress records into our dashboard, can you run string normalisation and exact row deduplication and give me two reports so I know what was cleaned up?"}],"resultDescription":"Two analytical reports: (1) a string normalisation report detailing transformations applied to string fields (e.g. team_group), and (2) an exact row deduplication report identifying and removing fully duplicate records from the submitted onboarding progress rows. Reports are generated locally with no external lookups.","failureModes":["More than 200 rows submitted — request rejected due to maxItems constraint","Missing required fields (row_id, team_group, date, completed_steps, required_steps) — validation error","Invalid date format (not YYYY-MM-DD) — schema validation failure","row_id empty or exceeds 80 characters — validation error","Payment of 0.01 USDC not completed — 402 Payment Required response"],"whenToPreferThis":"Choose this endpoint when you need lightweight, local string cleaning and exact duplicate detection specifically on onboarding progress records with completed_steps and required_steps fields. Ideal for pre-processing small batches (up to 200 rows) before loading into dashboards or reports. Prefer this over heavier ETL pipelines when you need two focused quality reports quickly and cheaply without any external data lookups or predictions.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-29T12:53:47.302Z","isFirstParty":false,"canonicalSlug":"onboarding-progress-string-normalisation-exact-row-deduplication-2614ff24"}