{"uid":"cap_eHCuUNZrX9hxalBNpfH0b","slug":"lighting-setups-exact-row-deduplication-base-100-series-8a26ca29","name":"Lighting Setups — Exact Row Deduplication + Base-100 Series","description":"Lighting setups — Exact row deduplication + Base-100 series: Exact row deduplication + Base-100 series for supplied lighting setups records (light_count, render_seconds). 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-creative-11-047?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"},"base_index":{"type":"integer","default":0,"maximum":199,"minimum":0}}},"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_o-XtGUajsshafbGt96J9S","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":"Deduplicates lighting setup records and produces a Base-100 indexed series for light_count or render_seconds across up to 200 rows.","exampleAgentPrompt":"I have a set of lighting setup records with light_count and render_seconds — can you deduplicate exact duplicate rows and then build a Base-100 index series on light_count starting from row 0? Here are up to 200 rows across asset groups like group-a and group-b.","exampleUseCases":[{"title":"Deduplicating studio lighting logs","prompt":"I've got a CSV of lighting setup records for our studio shoots — dates, asset groups, light counts, and render times — and I know there are some exact duplicate rows in there. Can you deduplicate them and give me a base-100 index series on light_count starting from the first row?"},{"title":"Benchmarking render time across asset groups","prompt":"I want to index our render_seconds data to 100 starting from row 2 so I can compare how different asset groups' lighting setups scale relative to that baseline — can you deduplicate the records first and then build that series?"},{"title":"Cleaning lighting data before pipeline handoff","prompt":"Before we hand off our lighting setup data to the render pipeline, I need to strip out any exact duplicate rows and get a normalized base-100 series on light_count — here are 150 rows with row_ids, dates, asset groups, and the numeric fields."}],"resultDescription":"Returns two analytical reports: (1) an exact-row deduplication report showing which rows were duplicates and the cleaned dataset, and (2) a Base-100 indexed series for the chosen numeric field (light_count or render_seconds) anchored at the specified base_index row, covering up to 200 input rows.","failureModes":["More than 200 rows submitted — request rejected or truncated","Invalid date format (not YYYY-MM-DD) causes row rejection","Missing required fields (row_id, light_count, render_seconds) causes validation error","base_index out of range (0–199) relative to actual row count","All rows are duplicates leaving zero unique records for indexing","Null values in the selected numeric field may produce gaps in the Base-100 series"],"whenToPreferThis":"Choose this endpoint when you have lighting setup records (with light_count and render_seconds) and need both exact deduplication and a Base-100 normalized time series in a single call. It is ideal for 3D/creative production workflows where you want to clean a dataset and benchmark numeric trends relative to a specific row, without any external lookup or live data dependency. Prefer it over generic analytics tools when your dataset fits within 200 rows and you need two bundled reports at minimal cost.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-22T00:49:01.866Z","isFirstParty":false,"canonicalSlug":"lighting-setups-exact-row-deduplication-base-100-series-8a26ca29"}