{"uid":"cap_Q3d1It3pjoCog2NvEH3Qs","slug":"translation-delivery-duplicate-key-report-date-by-category-pivot-7546e70f","name":"Translation Delivery — Duplicate Key Report + Date by Category Pivot","description":"Translation delivery — Duplicate key report + Date by category pivot: Duplicate key report + 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-068?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_fQGP_8UjNuT2RcWO_3cyB","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":"Analyzes supplied translation delivery records to produce a duplicate key report and a date-by-category pivot table for translated_words or source_words, using local analytical engines with no external lookups.","exampleAgentPrompt":"Check my translation delivery records for duplicate row IDs and also give me a pivot of translated_words by date and document group — here are up to 200 rows with row_id, document_group, date, translated_words, and source_words.","exampleUseCases":[{"title":"Localization QA duplicate audit","prompt":"I have 150 translation delivery records with row IDs, document groups, dates, and word counts — can you run a duplicate key check on them and also pivot the translated_words by date and category so I can spot any data issues?"},{"title":"Translation volume pivot by date","prompt":"Can you take these translation job records and build a date-by-document-group pivot table for source_words? I want to see volume broken down by category across dates, and also flag any duplicate row IDs in the dataset."},{"title":"Monthly localization delivery review","prompt":"Here are our translation delivery records for last month — please detect any duplicate row entries and generate a pivot of translated_words grouped by document_group and date so we can review delivery patterns."}],"resultDescription":"Returns two independent analytical reports: (1) a duplicate key report identifying any repeated row_id values across the supplied records, and (2) a date-by-category pivot table aggregating the selected metric (translated_words or source_words) broken down by date and document_group. Results are computed locally from the supplied data, covering up to 200 rows.","failureModes":["More than 200 rows submitted — request rejected or truncated","Missing required fields (row_id, document_group, date, translated_words, source_words) — validation error","Invalid date format (not YYYY-MM-DD) — schema validation failure","Numeric values outside allowed range — schema rejection","Empty rows array — minimum items constraint violated","Invalid field enum value (not translated_words or source_words) — schema error"],"whenToPreferThis":"Choose this endpoint when you need both a duplicate key audit and a date-by-category pivot on translation delivery data (translated_words/source_words) in a single call for up to 200 rows, without requiring any external lookup or live data. It is ideal for localization QA workflows, delivery volume reviews, and data quality checks on translation job exports where the data is already available client-side.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-26T12:32:44.967Z","isFirstParty":false,"canonicalSlug":"translation-delivery-duplicate-key-report-date-by-category-pivot-7546e70f"}