{"uid":"cap_BHocknkKMhxlVbgQqeLvM","slug":"product-photography-tracker-exact-row-deduplication-daily-sum-series-359eee8e","name":"Product Photography Tracker — Exact Row Deduplication + Daily Sum Series","description":"Product photography — Exact row deduplication + Daily sum series: Exact row deduplication + Daily sum series for supplied product photography records (required_images, completed_images). 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-retail-09-044?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","store_group","date","required_images","completed_images"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"store_group":{"type":"string","default":"","maxLength":80},"required_images":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"completed_images":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","store_group":"group-a","required_images":10,"completed_images":1},{"date":"2026-10-02","row_id":"row-2","store_group":"group-b","required_images":20,"completed_images":2},{"date":"2026-10-03","row_id":"row-3","store_group":"group-a","required_images":15,"completed_images":3},{"date":"2026-10-04","row_id":"row-4","store_group":"group-b","required_images":30,"completed_images":4}],"maxItems":200,"minItems":1},"field":{"enum":["required_images","completed_images"],"type":"string","default":"required_images"}}},"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_t7K0PiU6KpBQMep4ZhIMF","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 exact duplicate rows and generates a daily sum time series for product photography completion data (required_images, completed_images) across up to 200 records.","exampleAgentPrompt":"Can you deduplicate my product photography records and give me a daily sum series for required_images? I have about 150 rows with store group, date, required_images, and completed_images columns — just pass them all through.","exampleUseCases":[{"title":"Clean duplicate photography records before reporting","prompt":"I pulled our store photography tracker and I think there are duplicate rows in it — can you run an exact row deduplication on these records and also give me the daily totals for completed_images? I have around 120 rows with row_id, store_group, date, required_images, and completed_images."},{"title":"Daily image completion trend for retail audit","prompt":"I need a daily sum series for required_images across all our store groups — here are the 200 rows of photography data with dates, store groups, and image counts. Can you also deduplicate them first in case any exact rows got duplicated during the export?"},{"title":"Validate photography pipeline data quality","prompt":"Before I send this photography progress report to management, can you check for exact duplicate rows and generate a day-by-day total of required_images? I've got about 80 rows covering multiple store groups and dates from October."}],"resultDescription":"Returns two reports: (1) the input rows with exact duplicate rows removed, and (2) a daily sum time series for the selected field (required_images or completed_images), aggregated across all records by date. Both reports are computed locally from the supplied data with no external lookups.","failureModes":["Exceeding 200-row limit returns an error or truncated result","Missing required fields (row_id, date, required_images, completed_images) cause validation failure","Malformed date strings not matching YYYY-MM-DD pattern rejected","Null values in numeric fields may affect sum accuracy","Empty rows array rejected (minItems: 1)"],"whenToPreferThis":"Choose this endpoint when you need both exact duplicate row removal and a daily aggregated sum time series from product photography tracking data in a single low-cost call. Ideal for retail analytics pipelines where image completion records may contain exact duplicate rows from data exports, and you need clean daily totals for reporting — all without any external data lookup or prediction.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-30T19:11:29.042Z","isFirstParty":false,"canonicalSlug":"product-photography-tracker-exact-row-deduplication-daily-sum-series-359eee8e"}