{"uid":"cap_MI_Gl0jC_GIOlSKPCrXSe","slug":"translation-delivery-record-quality-audit-date-by-category-pivot-519bf032","name":"Translation Delivery — Record Quality Audit + Date by Category Pivot","description":"Translation delivery — Record quality audit + Date by category pivot: Record quality audit + Date by category pivot for supplied translation delivery records (translated_words, source_words). 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-writing-04-017?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","document_group","date","translated_words","source_words"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"source_words":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"document_group":{"type":"string","default":"","maxLength":80},"translated_words":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","source_words":1,"document_group":"group-a","translated_words":10},{"date":"2026-10-02","row_id":"row-2","source_words":2,"document_group":"group-b","translated_words":20},{"date":"2026-10-03","row_id":"row-3","source_words":3,"document_group":"group-a","translated_words":15},{"date":"2026-10-04","row_id":"row-4","source_words":4,"document_group":"group-b","translated_words":30}],"maxItems":200,"minItems":1},"field":{"enum":["translated_words","source_words"],"type":"string","default":"translated_words"}}},"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_-HCE6FUqZuui6-icnuk1f","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 local analytical reports on translation delivery records: a record quality audit and a date-by-category pivot, for up to 200 rows.","exampleAgentPrompt":"Can you run a record quality audit and a date-by-category pivot on these translation delivery records — I have up to 50 rows with row_id, document_group, date, translated_words, and source_words — and use translated_words as the main field?","exampleUseCases":[{"title":"Monthly translation throughput pivot","prompt":"I have 120 rows of translation delivery data with document groups and dates from last quarter — can you pivot the translated_words counts by date and document group so I can see throughput trends across categories?"},{"title":"Data quality check before invoicing","prompt":"Before I send invoices, I need a quality audit on my translation delivery records — here are 80 rows with row_id, document_group, date, translated_words, and source_words. Flag any missing or bad values."},{"title":"Source word volume by category and date","prompt":"Can you generate both a quality audit and a date-by-category pivot for these 35 translation delivery records, but use source_words as the field to analyze instead of translated words?"}],"resultDescription":"Returns two reports: (1) a record quality audit identifying missing values, nulls, and data completeness issues per row; and (2) a date-by-category pivot table aggregating the selected word count field (translated_words or source_words) grouped by date and document_group. All processing is local with no external lookups.","failureModes":["More than 200 rows submitted — endpoint only supports up to 200 rows per call","Missing required fields (row_id, document_group, date, translated_words, or source_words) cause validation errors","Date field not matching YYYY-MM-DD pattern causes schema rejection","Empty rows array rejected (minItems: 1)","Invalid field enum value (must be 'translated_words' or 'source_words')"],"whenToPreferThis":"Choose this endpoint when you need two bundled analytical reports — a data quality audit and a date-by-category pivot — on translation delivery data in a single low-cost call ($0.01 USDC). Ideal for localization teams or project managers who want to validate record completeness and summarize word volume trends by document group and date without any external API calls or live data lookups. Best for datasets up to 200 rows.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-30T12:39:05.021Z","isFirstParty":false,"canonicalSlug":"translation-delivery-record-quality-audit-date-by-category-pivot-519bf032"}