{"uid":"cap_dlpA-KWTPZZeaXSGju-e7","slug":"uv-layouts-exact-row-deduplication-duplicate-key-report-874907e1","name":"UV Layouts — Exact Row Deduplication + Duplicate Key Report","description":"UV layouts — Exact row deduplication + Duplicate key report: Exact row deduplication + Duplicate key report for supplied uv layouts records (island_count, occupied_percent). 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-06-038?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","asset_group","date","island_count","occupied_percent"],"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},"island_count":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"occupied_percent":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","asset_group":"group-a","island_count":10,"occupied_percent":1},{"date":"2026-10-02","row_id":"row-2","asset_group":"group-b","island_count":20,"occupied_percent":2},{"date":"2026-10-03","row_id":"row-3","asset_group":"group-a","island_count":15,"occupied_percent":3},{"date":"2026-10-04","row_id":"row-4","asset_group":"group-b","island_count":30,"occupied_percent":4}],"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_CxAS3pWkIiqvSdfkQaGbv","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 up to 200 UV layout records by exact row match and generates a duplicate key report for island_count and occupied_percent fields.","exampleAgentPrompt":"I have a batch of UV layout records with asset groups, dates, island counts, and occupied percentages — can you run exact row deduplication on them and also give me a duplicate key report for the island_count and occupied_percent fields? Here are up to 200 rows across groups like 'group-a' and 'group-b' dated from 2026-10-01 onward.","exampleUseCases":[{"title":"Cleaning repeated UV layout exports","prompt":"I've been exporting UV layout snapshots daily and I think some rows got duplicated — can you deduplicate these records exactly and show me which island_count and occupied_percent values appear more than once? I have about 150 rows with dates, asset groups, and row IDs."},{"title":"Auditing island occupancy data quality","prompt":"Before I pass this UV layout dataset to our pipeline, I need to confirm there are no exact duplicate rows and get a report of any keys that appear multiple times in the island_count and occupied_percent columns — can you run both checks on my 80 records?"},{"title":"Identifying repeated asset group entries","prompt":"Our UV layout tool keeps re-submitting the same asset group rows — please find all exact row duplicates across these 200 records and generate a duplicate key report for the island_count and occupied_percent fields so I can see where the overlap is."}],"resultDescription":"Returns two independent reports: (1) an exact row deduplication result identifying which of the up to 200 submitted UV layout rows are duplicates and providing a deduplicated set, and (2) a duplicate key report flagging repeated values in the island_count and occupied_percent columns across all submitted records.","failureModes":["Exceeding 200 rows results in rejection or truncation","Missing required fields (row_id, date, asset_group, island_count, occupied_percent) causes validation error","Malformed date format (not YYYY-MM-DD) triggers pattern mismatch error","Numeric values outside allowed range (-1e12 to 1e12) cause schema validation failure","Empty rows array returns an error due to minItems:1 constraint"],"whenToPreferThis":"Choose this endpoint when you have UV layout records with island_count and occupied_percent metrics and need both exact row deduplication and a duplicate key report in a single call without any external lookups, predictions, or live data. It is ideal for data cleaning pipelines processing up to 200 UV layout rows at once using purely local analytical computation.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-26T18:52:24.658Z","isFirstParty":false,"canonicalSlug":"uv-layouts-exact-row-deduplication-duplicate-key-report-874907e1"}