{"uid":"cap__2XCw9sr3Jq-x0KuQwW-r","slug":"brainiac-appointment-intelligence-data-normalize-04fca729","name":"BRAINIAC Appointment 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/appointment-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},"slots":{"type":"array","items":{"type":"object","properties":{"id":{"type":"string","maxLength":80},"end":{"type":"string","maxLength":40},"start":{"type":"string","maxLength":40},"capacity":{"type":"number","maximum":10000,"minimum":0},"providerId":{"type":"string","maxLength":80}},"additionalProperties":false},"maxItems":200},"minSample":{"type":"integer","maximum":100000,"minimum":1},"providers":{"type":"array","items":{"type":"object","properties":{"id":{"type":"string","maxLength":80},"name":{"type":"string","maxLength":160},"capacityMinutes":{"type":"number","maximum":100000,"minimum":0}},"additionalProperties":false},"maxItems":40},"gapMinutes":{"type":"integer","maximum":1440,"minimum":1},"appointments":{"type":"array","items":{"type":"object","properties":{"id":{"type":"string","maxLength":80},"end":{"type":"string","maxLength":40},"start":{"type":"string","maxLength":40},"status":{"type":"string","maxLength":80},"channel":{"type":"string","maxLength":80},"service":{"type":"string","maxLength":160},"bookedAt":{"type":"string","maxLength":40},"clientId":{"type":"string","maxLength":80},"providerId":{"type":"string","maxLength":80},"reminderAt":{"type":"string","maxLength":40},"cancelledAt":{"type":"string","maxLength":40}},"additionalProperties":false},"maxItems":500}}},"responseSchema":{"type":"json","example":{"slots":[],"status":"normalized","findings":[{"code":"unlabeled_line","kind":"ignored","detail":"Lines without a recognized label were not read and their text was not copied.","subject":""}],"checkedAt":"2026-11-04T18:00:00.000Z","providers":[{"id":"P-1","name":"Dr Lee","capacityMinutes":480,"capacityMinutesSupplied":true}],"limitations":["Appointments, slots, and providers are copied only from labeled fields supplied by the caller.","Attendance, cancellation, and utilization metrics use only those records. Missing times are not invented.","Pattern notes and recommendations describe observed counts. They are not a guarantee of future attendance.","Protected characteristics and sensitive personal attributes are not accepted or used.","No reminder is sent and no booking is modified. Small samples are disclosed."],"appointments":[{"id":"A-1","end":"2026-11-03T10:30:00.000Z","hour":10,"start":"2026-11-03T10:00:00.000Z","status":"attended","channel":"phone","service":"consult","weekday":"tue","bookedAt":"2026-11-01T09:00:00.000Z","clientId":"C-1","providerId":"P-1","reminderAt":"2026-11-02T10:00:00.000Z","statusKind":"attended","cancelledAt":"","hourSupplied":true,"durationMinutes":30,"durationMinutesSupplied":true}],"reminderSent":false,"bookingModified":false,"attendancePredicted":false,"protectedAttributesUsed":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_z7fwqKpebpHfDgfzg3L-p","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 raw appointment, slot, and provider data from CSV, JSON, or text into a clean structured format with attendance status, duration, weekday, and hour fields, plus findings and limitations notes.","exampleAgentPrompt":"Normalize this appointment CSV for me — it has columns for appointment ID, start and end times, provider ID, client ID, status, channel, and service. Use November 4 2026 as the reference date and flag any gaps of 15 minutes or more.","exampleUseCases":[{"title":"Clinic appointment history cleanup","prompt":"I have a CSV export of 300 patient appointments from our clinic — fields include appointment ID, start, end, provider, status, and service. Can you normalize it as of today and flag any findings like unlabeled lines or missing times?"},{"title":"Scheduling analytics data prep","prompt":"Take this JSON blob of booking records and normalize it into clean appointment objects with weekday, hour, and duration filled in. Use May 1 2025 as the as-of date and set a minimum sample of 50 so I know if the dataset is too small."},{"title":"Provider slot normalization before capacity review","prompt":"I need to normalize this list of providers and their available slots — I have it as plain text with labeled fields. Set gap detection to 30 minutes and use today's date as the reference so I can review utilization across the team."}],"resultDescription":"Returns a JSON object with status 'normalized', an array of cleaned appointment objects (each with computed fields: weekday, hour, durationMinutes, statusKind, and boolean flags for which fields were supplied), normalized slots and providers arrays, a checkedAt timestamp, a list of findings describing any parsing issues (e.g. unlabeled lines, missing fields), and a limitations array explaining what the normalization did and did not do. Also includes top-level flags: reminderSent (always false), bookingModified (always false), attendancePredicted (always false), and protectedAttributesUsed (always false).","failureModes":["Payload too large — CSV, JSON, or text inputs exceeding 200,000 characters or file base64 exceeding 12MB will be rejected","Unrecognized date formats — start/end/bookedAt strings that cannot be parsed will result in those fields being omitted or flagged in findings","Unlabeled lines — rows or keys that do not match expected labels are ignored and reported as 'unlabeled_line' findings","Too few records — if the sample falls below minSample, a small-sample limitation is disclosed","Invalid mediaType — file uploads with an unsupported MIME type will be rejected","Missing required file fields — a file object without mediaType or fileBase64 will fail schema validation"],"whenToPreferThis":"Use this endpoint when you have raw appointment, slot, or provider data in CSV, JSON, or plain text format that needs to be standardized into a consistent schema before further analysis or reporting. It is especially useful when data comes from heterogeneous sources with inconsistent date formats, missing duration fields, or unlabeled rows. Prefer this over building your own parser when you need computed fields like weekday, hour, durationMinutes, and statusKind derived automatically, or when you need explicit findings about parsing anomalies and transparent limitations disclosures.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-11-12T12:36:22.237Z","isFirstParty":false,"canonicalSlug":"brainiac-appointment-intelligence-data-normalize-04fca729"}