{"uid":"cap_JLGWw9cwa-Q4GBTqThdtV","slug":"data-catalog-coverage-string-normalisation-date-by-category-pivot-f68f7f17","name":"Data Catalog Coverage — String Normalisation + Date by Category Pivot","description":"Data catalog coverage — String normalisation + Date by category pivot: String normalisation + Date by category pivot for supplied data catalog coverage records (documented_fields, total_fields). 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-21-035?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","dataset_group","date","documented_fields","total_fields"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"total_fields":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"dataset_group":{"type":"string","default":"","maxLength":80},"documented_fields":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","total_fields":1,"dataset_group":"group-a","documented_fields":10},{"date":"2026-10-02","row_id":"row-2","total_fields":2,"dataset_group":"group-b","documented_fields":20},{"date":"2026-10-03","row_id":"row-3","total_fields":3,"dataset_group":"group-a","documented_fields":15},{"date":"2026-10-04","row_id":"row-4","total_fields":4,"dataset_group":"group-b","documented_fields":30}],"maxItems":200,"minItems":1},"field":{"enum":["documented_fields","total_fields"],"type":"string","default":"documented_fields"}}},"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_YZh3_uoBnjRoiUsiAFQ_O","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 analytical reports on data catalog coverage records: string normalisation of field values and a date-by-category pivot, for up to 200 rows.","exampleAgentPrompt":"Can you run string normalisation and a date-by-category pivot on my data catalog coverage records? I have rows with dataset_group, date, documented_fields, and total_fields — up to about 50 rows — and I want the analysis focused on the documented_fields column.","exampleUseCases":[{"title":"Coverage reporting across dataset groups","prompt":"I've got 80 catalog coverage records with row_id, dataset_group, date, documented_fields, and total_fields. Can you normalise the string values and pivot them by date and category so I can see how documentation coverage varies across groups over time? Use documented_fields as the focus field."},{"title":"Data quality audit for a governance team","prompt":"Our data governance team needs to audit field documentation rates. I'll give you 150 catalog records — each has a dataset_group, a date, and counts of documented_fields and total_fields. Please run string normalisation and a date-by-category pivot on total_fields so we can spot underdocumented datasets."},{"title":"Monthly catalog coverage summary","prompt":"Can you analyse this month's catalog coverage snapshot? I have around 40 rows with dataset_group, date, documented_fields, and total_fields. Run the string normalisation and date pivot reports on documented_fields so I can share a clean summary with the data team."}],"resultDescription":"Returns two independent analytical reports: (1) a string normalisation report that cleans and standardises text values in the specified field across the supplied catalog coverage rows, and (2) a date-by-category pivot report that aggregates the chosen numeric measure (documented_fields or total_fields) across dataset_group categories and dates. Both reports are computed locally against the supplied data with no external lookups.","failureModes":["Fewer than 1 row or more than 200 rows supplied — request rejected","Missing required fields (row_id, dataset_group, date, documented_fields, total_fields) in any row — validation error","Invalid date format (must match YYYY-MM-DD) — schema validation failure","Numeric values outside allowed range (±1,000,000,000,000) — rejection","Invalid field enum value (must be 'documented_fields' or 'total_fields') — schema error","Payment of 0.01 USDC not completed — request blocked"],"whenToPreferThis":"Choose this endpoint when you need two bundled analytical operations — string normalisation and a date-by-category pivot — applied to data catalog coverage records (documented_fields, total_fields) in a single low-cost call. It is ideal for data governance or catalog quality workflows where you supply your own rows and need fast, local computation without external data lookups, predictions, or professional assessments. Prefer it over general analytics APIs when your domain is specifically data catalog coverage metrics grouped by dataset_group and date.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-23T18:52:18.830Z","isFirstParty":false,"canonicalSlug":"data-catalog-coverage-string-normalisation-date-by-category-pivot-f68f7f17"}