{"uid":"cap_PhbWpUGY0bkqFyRCbx-bC","slug":"lighting-setups-record-quality-audit-string-normalisation-date-by-cdc988cd","name":"Lighting Setups — Record Quality Audit + String Normalisation + Date by Category Pivot","description":"Lighting setups — Record quality audit + String normalisation + Date by category pivot: Record quality audit + String normalisation + Date by category pivot for supplied lighting setups records (light_count, render_seconds). Up to 200 rows; 3 independent reports using shared local analytical engines. No live lookup, prediction, professional assessment or external action. 0.01 USDC includes 3 supplied-data reports for up to 200 rows.","url":"https://market.datapackvibe.com/x402/assistant-ib26-creative-11-206?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","asset_group","date","light_count","render_seconds"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"asset_group":{"type":"string","default":"","maxLength":80},"light_count":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"render_seconds":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","asset_group":"group-a","light_count":10,"render_seconds":1},{"date":"2026-10-02","row_id":"row-2","asset_group":"group-b","light_count":20,"render_seconds":2},{"date":"2026-10-03","row_id":"row-3","asset_group":"group-a","light_count":15,"render_seconds":3},{"date":"2026-10-04","row_id":"row-4","asset_group":"group-b","light_count":30,"render_seconds":4}],"maxItems":200,"minItems":1},"field":{"enum":["light_count","render_seconds"],"type":"string","default":"light_count"}}},"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_JN3kgZdqri_hQzvIh1HwN","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 three local analytical reports on lighting setup records: a record quality audit, string normalisation, and a date-by-category pivot, for up to 200 rows of light_count and render_seconds data.","exampleAgentPrompt":"Can you run a record quality audit, string normalisation, and date-by-category pivot on my lighting setup data? I have up to 50 rows with fields row_id, asset_group, date, light_count, and render_seconds — use light_count as the field for analysis.","exampleUseCases":[{"title":"Quality check on lighting batch","prompt":"I've got about 80 rows of lighting setup records with asset_group, date, light_count, and render_seconds — can you audit the record quality, normalise the string fields, and pivot them by date and category so I can spot issues?"},{"title":"Pivot render seconds by asset group","prompt":"Run a date-by-category pivot on my lighting data using render_seconds as the field — I have 120 rows across a few asset groups and want to see how render times break down over the dates."},{"title":"Pre-delivery data validation for lighting assets","prompt":"Before I hand off these lighting setup records to the team, can you do a full quality audit and string normalisation on the 60 rows I have? The fields are row_id, asset_group, date, light_count, and render_seconds."}],"resultDescription":"Returns three independent analytical reports: (1) a record quality audit flagging completeness and validity issues per row, (2) a string normalisation report cleaning and standardising text fields like asset_group, and (3) a date-by-category pivot summarising the selected numeric field (light_count or render_seconds) broken down by date and asset group — all computed locally from the supplied data, no external lookups.","failureModes":["More than 200 rows submitted — exceeds maxItems limit","Missing required fields (row_id, asset_group, date, light_count, or render_seconds) causes validation error","Malformed date string not matching YYYY-MM-DD pattern rejected","Invalid field enum value (must be light_count or render_seconds)","Empty rows array (minItems: 1) returns error","Numeric values outside allowed range cause schema rejection"],"whenToPreferThis":"Choose this endpoint when you need three bundled analytical operations — quality audit, string normalisation, and date pivot — on lighting setup records in a single cost-efficient call ($0.01 USDC for all three reports). Ideal for pre-processing or QA steps in 3D rendering pipelines where you want to validate, clean, and summarise up to 200 rows of lighting data without any external lookups or live data dependencies.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-22T00:49:29.454Z","isFirstParty":false,"canonicalSlug":"lighting-setups-record-quality-audit-string-normalisation-date-by-cdc988cd"}