{"uid":"cap_tDA7oQDox5L4LtnMvQ6KO","slug":"brainiac-inventory-intelligence-data-normalize-b26fcdca","name":"BRAINIAC Inventory Intelligence Data Normalize","description":"Pay-per-call APIs for AI agents: OFAC sanctions screening, compliance checks, token security, and Base chain data via x402. No account. Fixed USDC price. MCP-ready.","url":"https://www.brainiac.software/api/v1/inventory-intelligence/data-normalize?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"csv":{"type":"string","maxLength":200000},"asOf":{"type":"string","maxLength":40},"file":{"type":"object","required":["mediaType","fileBase64"],"properties":{"filename":{"type":"string","maxLength":180,"minLength":1},"mediaType":{"enum":["text/plain","text/csv","application/json"],"type":"string"},"fileBase64":{"type":"string","maxLength":12000000,"minLength":1}},"additionalProperties":false},"json":{"type":"string","maxLength":200000},"text":{"type":"string","maxLength":200000},"sales":{"type":"array","items":{"type":"object","properties":{"sku":{"type":"string","maxLength":80},"date":{"type":"string","maxLength":40},"units":{"type":"number","maximum":1000000000,"minimum":0}},"additionalProperties":false},"maxItems":2000},"products":{"type":"array","items":{"type":"object","properties":{"sku":{"type":"string","maxLength":80},"name":{"type":"string","maxLength":160},"onHand":{"type":"number","maximum":1000000000,"minimum":0},"onOrder":{"type":"number","maximum":1000000000,"minimum":0},"unitCost":{"type":"number","maximum":1000000000,"minimum":0}},"additionalProperties":false},"maxItems":200},"slowDays":{"type":"number","maximum":3650,"minimum":1},"purchases":{"type":"array","items":{"type":"object","properties":{"sku":{"type":"string","maxLength":80},"date":{"type":"string","maxLength":40},"units":{"type":"number","maximum":1000000000,"minimum":0},"unitPrice":{"type":"number","maximum":1000000000,"minimum":0}},"additionalProperties":false},"maxItems":500},"slowUnits":{"type":"number","maximum":1000000000,"minimum":0},"suppliers":{"type":"array","items":{"type":"object","properties":{"moq":{"type":"number","maximum":1000000000,"minimum":0},"sku":{"type":"string","maxLength":80},"supplierId":{"type":"string","maxLength":80},"leadTimeDays":{"type":"number","maximum":3650,"minimum":0}},"additionalProperties":false},"maxItems":200},"reviewDays":{"type":"number","maximum":365,"minimum":0},"historyDays":{"type":"integer","maximum":3650,"minimum":1},"forecastDays":{"type":"integer","maximum":365,"minimum":1},"serviceLevelZ":{"type":"number","maximum":5,"minimum":0},"excessDaysCover":{"type":"number","maximum":3650,"minimum":1}}},"responseSchema":{"type":"json","example":{"sales":[{"sku":"SKU-1","date":"2026-11-01","units":8,"unitsSupplied":true}],"status":"normalized","findings":[{"code":"unlabeled_line","kind":"ignored","detail":"Lines without a recognized label were not read and their text was not copied.","subject":""}],"products":[{"sku":"SKU-1","name":"Widget","onHand":40,"onOrder":10,"unitCost":2.5,"saleCount":1,"purchaseCount":1,"onHandSupplied":true,"onOrderSupplied":true,"unitCostSupplied":true,"leadTimeDaysSupplied":true}],"checkedAt":"2026-11-04T19:00:00.000Z","purchases":[{"sku":"SKU-1","date":"2026-10-20","units":50,"unitPrice":2.1,"unitsSupplied":true,"unitPriceSupplied":true}],"suppliers":[{"moq":20,"sku":"SKU-1","supplierId":"SUP-1","moqSupplied":true,"leadTimeDays":7,"leadTimeDaysSupplied":true}],"assumptions":["serviceLevelZ=1.65 (explicit normal z factor for safety stock)","reviewDays=0","historyDays=90","forecastDays=30","excessDaysCover=90","slowUnits=5 over slowDays=90","Daily demand average fills missing days in the history window with zero when a history end date exists.","Seasonality is not added. Only variation already present in the supplied history affects the standard deviation."],"limitations":["Products, sales, supplier lead times, and purchases are copied only from labeled fields supplied by the caller.","Reorder point = average daily demand × (lead time days + review days) + safety stock.","Safety stock = service-level z × daily demand standard deviation × square root of lead time days.","Demand forecasts use a simple average of available history only. Seasonality is not modeled unless present in that history.","Lead times, demand, and purchase prices are never invented. No purchase order is created and no inventory system is accessed."],"priceInvented":false,"demandInvented":false,"leadTimeInvented":false,"purchaseOrderCreated":false,"inventorySystemAccessed":false}},"example":null,"exampleRequest":null,"tags":["x402"],"displayCostAmount":"0.04","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.04/call","primary":{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.04","per":"call","confidence":"exact"},"accepted":[{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.04","per":"call","confidence":"exact"}]},"paymentMethods":[{"uid":"pm_rX58e9yaoTmuwYlo8izKz","protocol":"x402","methodType":"crypto","chain":"base","mode":"charge","costAmount":"0.04","costPer":"request","priority":0,"asset":"0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913","unit":"request","depositMicros":null,"planRef":null}],"brandName":null,"brandSlug":null,"brandBaseUrl":null,"brandDocsUrl":null,"whatItDoes":"Normalizes messy inventory, sales, purchase, and supplier data into a clean, structured format ready for inventory intelligence computations","exampleAgentPrompt":"Normalize my inventory data — I have product records for SKU-1 (Widget, 40 on hand, 10 on order, $2.50 unit cost), one sales record (SKU-1, 2026-11-01, 8 units), one purchase (SKU-1, 2026-10-20, 50 units at $2.10), and one supplier (SUP-1 for SKU-1 with a 7-day lead time and MOQ of 20). Use a 90-day history window and 30-day forecast horizon.","exampleUseCases":[{"title":"Clean mixed-format CSV before reorder planning","prompt":"I have a messy CSV export from our warehouse system with product names, SKUs, on-hand counts, and 90 days of sales history all mixed together — can you normalize it into clean structured inventory data with a 30-day forecast horizon and flag anything that looks wrong?"},{"title":"Standardize supplier data for safety stock calc","prompt":"I've got supplier records for 15 SKUs with lead times and MOQs, plus matching sales history for the last 180 days — normalize all of it and use a service level z of 1.65 so I can run safety stock calculations afterward."},{"title":"Reconcile product and sales records from JSON","prompt":"Here's a JSON blob with our product catalog and 60 days of sales transactions — please normalize and validate the data, using a 60-day history window, and tell me which fields were actually supplied vs assumed."}],"resultDescription":"Returns a normalized JSON object containing cleaned arrays of products, sales, purchases, and suppliers with per-record flags indicating which fields were supplied vs inferred. Also includes a list of findings (warnings, ignored lines), assumptions made during normalization (history window, forecast horizon, z-score, etc.), and explicit limitations. Boolean flags confirm that no prices, demand figures, or lead times were invented and that no purchase orders were created or external inventory systems accessed.","failureModes":["Malformed or unrecognized CSV/JSON structure may result in findings entries with 'ignored' kind rather than parsed data","SKUs present in sales but absent from products array will be flagged but not auto-created","Exceeding maxItems limits (200 products, 500 purchases, 2000 sales) will cause validation rejection","Missing required file fields (mediaType or fileBase64) when using file upload will cause schema validation error","Very sparse sales history (few data points) will produce low-confidence demand standard deviation, noted in assumptions"],"whenToPreferThis":"Use this endpoint as the first step in any inventory intelligence pipeline when your raw data is messy, mixed-format, or unvalidated. It is specifically designed to accept CSV, JSON, plain text, or structured arrays and return a clean normalized payload with explicit provenance flags — ideal before calling reorder-point or safety-stock computation endpoints. Prefer this over generic data cleaning tools when you need inventory-domain-aware normalization that understands SKUs, lead times, MOQs, and sales history semantics.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-11-12T18:39:50.337Z","isFirstParty":false,"canonicalSlug":"brainiac-inventory-intelligence-data-normalize-b26fcdca"}