{"uid":"cap_nuKIuLMjIedbrI_VCaqSk","slug":"file-ingestion-date-by-category-pivot-a1131319","name":"File Ingestion Date-by-Category Pivot","description":"File ingestion - Date by category pivot: Date by category pivot for File ingestion. Up to 200 supplied typed records. Local descriptive analytics; no enrichment or forecast. One of 25 new profiles across 20 shared operations in this industry. 0.01 USDC includes one bounded date by category pivot report.","url":"https://market.datapackvibe.com/x402/assistant-ar-analytics-file-ingestion-pivot?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","source","date","loaded_bytes","parse_errors"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"source":{"type":"string","default":"","maxLength":80},"loaded_bytes":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"parse_errors":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","source":"group-a","loaded_bytes":10,"parse_errors":1},{"date":"2026-10-02","row_id":"row-2","source":"group-b","loaded_bytes":20,"parse_errors":2},{"date":"2026-10-03","row_id":"row-3","source":"group-a","loaded_bytes":15,"parse_errors":3},{"date":"2026-10-04","row_id":"row-4","source":"group-b","loaded_bytes":30,"parse_errors":4}],"maxItems":200,"minItems":1},"field":{"enum":["loaded_bytes","parse_errors"],"type":"string","default":"loaded_bytes"}}},"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_lJY1DXmyJLzfjQsON1A90","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":"Generates a date-by-category pivot report for file ingestion records, summarizing a chosen numeric metric (loaded bytes or parse errors) broken down by source category across dates.","exampleAgentPrompt":"Take these file ingestion records and pivot the loaded_bytes metric by date and source category — I've got 4 rows: row-1 (2026-10-01, group-a, 10 bytes, 1 error), row-2 (2026-10-02, group-b, 20 bytes, 2 errors), row-3 (2026-10-03, group-a, 15 bytes, 3 errors), row-4 (2026-10-04, group-b, 30 bytes, 4 errors).","exampleUseCases":[{"title":"Daily ingestion load by source","prompt":"I have a week's worth of file ingestion logs with sources like 'group-a' and 'group-b' — can you pivot the loaded_bytes field by date and source so I can see which group is moving the most data each day?"},{"title":"Parse error trend by category","prompt":"Here are 50 ingestion records from last month across three source categories. Pivot the parse_errors metric by date and source so I can spot which category has the worst error days."},{"title":"Multi-source ingestion health check","prompt":"I'm running a daily ingestion pipeline with multiple sources. Can you take these 120 records and generate a date-by-category breakdown of loaded_bytes so I can compare throughput across sources over the past two weeks?"}],"resultDescription":"A date-by-category pivot report showing the selected numeric metric (loaded_bytes or parse_errors) aggregated by source category for each date present in the input records — a cross-tabulation suitable for local descriptive analytics with no forecasting or external enrichment.","failureModes":["Input array is empty or missing (minItems:1 violated)","More than 200 rows supplied (maxItems:200 exceeded)","Date strings not matching YYYY-MM-DD pattern","row_id missing or exceeds 80 characters","field enum value not one of loaded_bytes or parse_errors","Numeric fields out of allowed range (-1e12 to 1e12)","Payment not attached or insufficient USDC balance"],"whenToPreferThis":"Choose this endpoint when you have up to 200 typed file ingestion records and need a quick local pivot of loaded_bytes or parse_errors broken down by source category and date, with no requirement for external data enrichment or forecasting. It is best for lightweight, on-demand descriptive analytics on ETL or ingestion pipeline data at minimal cost ($0.01 USDC).","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-19T19:17:54.000Z","isFirstParty":false,"canonicalSlug":"file-ingestion-date-by-category-pivot-a1131319"}