{"uid":"cap_JA2eNh1v-t9clM6sFRZ8x","slug":"render-jobs-string-normalisation-and-exact-row-deduplication-dcf6250a","name":"Render Jobs String Normalisation and Exact Row Deduplication","description":"Render jobs — String normalisation + Exact row deduplication: String normalisation + Exact row deduplication for supplied render jobs records (render_seconds, sample_count). 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-02-020?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","asset_group","date","render_seconds","sample_count"],"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},"sample_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","sample_count":1,"render_seconds":10},{"date":"2026-10-02","row_id":"row-2","asset_group":"group-b","sample_count":2,"render_seconds":20},{"date":"2026-10-03","row_id":"row-3","asset_group":"group-a","sample_count":3,"render_seconds":15},{"date":"2026-10-04","row_id":"row-4","asset_group":"group-b","sample_count":4,"render_seconds":30}],"maxItems":200,"minItems":1}}},"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_cd5j2haWkLq0lsG32Ms2F","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":"Normalises strings and deduplicates exact rows in render job records (render_seconds, sample_count), producing 2 analytical reports for up to 200 rows.","exampleAgentPrompt":"Can you clean up these render job records — I need string normalisation and exact row deduplication on my asset_group and render_seconds data? I have about 50 rows across groups like 'group-a' and 'group-b' with dates from 2026-10-01, and I want 2 reports back.","exampleUseCases":[{"title":"Deduplicating studio render logs","prompt":"I've got 120 rows of render job logs from our studio pipeline with render_seconds and sample_count fields — can you deduplicate the exact repeated rows and normalise any inconsistent string casing in the asset_group column? I need both the dedup report and the normalisation report."},{"title":"Cleaning render data before reporting","prompt":"Before I generate our weekly render performance report, can you run string normalisation and exact row deduplication on these 80 render job records? They have dates between 2026-09-01 and 2026-09-30, asset groups like 'Interior_A' and 'exterior_a', and render_seconds values."},{"title":"Auditing duplicate frames in batch render","prompt":"We ran a batch render job and suspect some frames were submitted twice — can you check these 200 render job rows for exact duplicate entries and also normalise the asset_group strings? Give me both analysis reports."}],"resultDescription":"Two analytical reports: (1) a string normalisation report showing standardised versions of string fields across the submitted render job rows, and (2) an exact row deduplication report identifying and removing fully duplicate records from the dataset. No live lookups or external data are used.","failureModes":["More than 200 rows submitted — request will be rejected or truncated","Missing required fields (row_id, date, render_seconds, sample_count) — validation error","Malformed date format (not YYYY-MM-DD) — schema validation failure","Numeric values outside allowed range (-1e12 to 1e12) — validation error","Empty rows array — minimum 1 item required"],"whenToPreferThis":"Choose this endpoint when you have render job records (with render_seconds and sample_count metrics) that need both string normalisation and exact duplicate row removal in a single call returning 2 reports. Ideal for pre-processing creative production pipeline data before aggregation or reporting, when datasets are 200 rows or fewer and no live data lookup or prediction is needed.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-22T00:49:24.447Z","isFirstParty":false,"canonicalSlug":"render-jobs-string-normalisation-and-exact-row-deduplication-dcf6250a"}