{"uid":"cap_nHGf6jQvu8CgbZ69Mdur_","slug":"export-validation-analytics-string-normalisation-grouped-numeric-29a9ee87","name":"Export Validation Analytics — String Normalisation + Grouped Numeric Summary","description":"Export validation — String normalisation + Grouped numeric summary: String normalisation + Grouped numeric summary for supplied export validation records (valid_rows, exported_rows). 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-14-023?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","dataset_group","date","valid_rows","exported_rows"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"valid_rows":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"dataset_group":{"type":"string","default":"","maxLength":80},"exported_rows":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","valid_rows":10,"dataset_group":"group-a","exported_rows":1},{"date":"2026-10-02","row_id":"row-2","valid_rows":20,"dataset_group":"group-b","exported_rows":2},{"date":"2026-10-03","row_id":"row-3","valid_rows":15,"dataset_group":"group-a","exported_rows":3},{"date":"2026-10-04","row_id":"row-4","valid_rows":30,"dataset_group":"group-b","exported_rows":4}],"maxItems":200,"minItems":1},"field":{"enum":["valid_rows","exported_rows"],"type":"string","default":"valid_rows"}}},"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_87mmXIrqX4YCbmvNipwqw","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 produces a grouped numeric summary for export validation records containing valid_rows and exported_rows metrics, processing up to 200 rows in two independent analytical reports.","exampleAgentPrompt":"Can you normalise the string fields and give me a grouped numeric summary for my export validation records? I have 4 rows with dataset groups 'group-a' and 'group-b', dates from 2026-10-01 to 2026-10-04, and I want the summary focused on the valid_rows field.","exampleUseCases":[{"title":"Export pipeline completeness audit","prompt":"I have a batch of export validation records across two dataset groups — can you normalise the group names and summarise the valid_rows counts by dataset_group so I can see which groups are underperforming?"},{"title":"ETL row count discrepancy check","prompt":"Can you run a grouped numeric summary on my exported_rows data? I've got 150 rows with dataset groups like 'finance' and 'marketing' across dates in October 2026 and I want to spot where export counts look off."},{"title":"Data quality report for export audit","prompt":"I need to clean up the string fields and produce a grouped summary of valid_rows for my export validation dataset — there are about 80 rows across several dataset groups from the past month, can you handle that?"}],"resultDescription":"Returns two independent analytical reports: (1) a string normalisation report cleaning dataset_group and related string fields, and (2) a grouped numeric summary aggregating the selected field (valid_rows or exported_rows) by dataset_group, covering up to 200 input rows. No external lookups or predictions are included.","failureModes":["Exceeding 200 rows causes a rejection or truncation error","Missing required fields (row_id, dataset_group, date, valid_rows, exported_rows) causes validation failure","Invalid date format (not YYYY-MM-DD) triggers a pattern validation error","Null numeric values in the selected field may affect summary completeness","Supplying fewer than 1 row returns an error due to minItems constraint"],"whenToPreferThis":"Choose this endpoint when you have export validation data with valid_rows and exported_rows fields and need both string normalisation and a grouped numeric summary in one call. It is particularly well-suited for ETL pipeline monitoring, export completeness auditing, and data quality checks where dataset groups need to be compared statistically. It does not perform live lookups, predictions, or external enrichment, so prefer it for purely analytical, offline batch summaries of up to 200 rows.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-28T19:42:10.328Z","isFirstParty":false,"canonicalSlug":"export-validation-analytics-string-normalisation-grouped-numeric-29a9ee87"}