{"uid":"cap_VuLcFGCaaCL42uJOUQpqi","slug":"brainiac-cloud-finops-billing-csv-parser-0816ef8a","name":"BRAINIAC Cloud FinOps Billing CSV Parser","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/cloud-finops/billing-csv-parse?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"csv":{"type":"string","maxLength":200000,"minLength":1},"file":{"type":"object","required":["mediaType","fileBase64"],"properties":{"filename":{"type":"string","maxLength":180,"minLength":1},"mediaType":{"enum":["text/csv","text/plain"],"type":"string"},"fileBase64":{"type":"string","maxLength":12000000,"minLength":1}},"additionalProperties":false},"rows":{"type":"array","items":{"type":"object","required":["date","service","cost","currency"],"properties":{"cost":{"type":"number","maximum":1000000000000,"minimum":-1000000000000},"date":{"type":"string","format":"date","pattern":"^(?:(?:\\d\\d[2468][048]|\\d\\d[13579][26]|\\d\\d0[48]|[02468][048]00|[13579][26]00)-02-29|\\d{4}-(?:(?:0[13578]|1[02])-(?:0[1-9]|[12]\\d|3[01])|(?:0[469]|11)-(?:0[1-9]|[12]\\d|30)|(?:02)-(?:0[1-9]|1\\d|2[0-8])))$"},"tags":{"type":"array","items":{"type":"object","required":["key","value"],"properties":{"key":{"type":"string","maxLength":80,"minLength":1},"value":{"type":"string","maxLength":200,"minLength":1}},"additionalProperties":false},"maxItems":20},"region":{"type":"string","maxLength":80,"minLength":1},"account":{"type":"string","maxLength":80,"minLength":1},"service":{"type":"string","maxLength":120,"minLength":1},"currency":{"type":"string","pattern":"^[A-Za-z]{3}$"},"usageUnit":{"type":"string","maxLength":40,"minLength":1},"resourceId":{"type":"string","maxLength":200,"minLength":1},"resourceType":{"type":"string","maxLength":80,"minLength":1},"usageQuantity":{"type":"number","maximum":1000000000000,"minimum":0}},"additionalProperties":false},"maxItems":5000}}},"responseSchema":{"type":"json","example":{"rows":[{"cost":10,"date":"2026-01-01","tags":"team=platform","region":"","account":"","service":"compute","currency":"USD","usageUnit":"","resourceId":"","resourceType":"","usageQuantity":null},{"cost":5,"date":"2026-01-02","tags":"","region":"","account":"","service":"storage","currency":"USD","usageUnit":"","resourceId":"","resourceType":"","usageQuantity":null}],"format":"brainiac-billing-v1","status":"parsed","findings":[],"rowCount":2,"checkedAt":"2026-11-02T19:00:00.000Z","currencies":["USD"],"limitations":["No cloud account was connected and no infrastructure was changed.","Costs and forecasts use only figures supplied in the request.","Provider list prices are not added, and no saving is claimed without a supplied cost.","The billing format is brainiac-billing-v1. Native provider exports are not accepted."],"accountConnected":false,"infrastructureChanged":false}},"example":null,"exampleRequest":null,"tags":["x402"],"displayCostAmount":"0.03","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.03/call","primary":{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.03","per":"call","confidence":"exact"},"accepted":[{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.03","per":"call","confidence":"exact"}]},"paymentMethods":[{"uid":"pm_CfTN9n4icqrqwA4FrD1Fm","protocol":"x402","methodType":"crypto","chain":"base","mode":"charge","costAmount":"0.03","costPer":"request","priority":0,"asset":"0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913","unit":"request","depositMicros":null,"planRef":null}],"brandName":null,"brandSlug":null,"brandBaseUrl":null,"brandDocsUrl":null,"whatItDoes":"Parses cloud billing CSV data into a normalized, structured format with FinOps findings and metadata","exampleAgentPrompt":"Parse this cloud billing CSV for me — here's the raw CSV text from our AWS cost and usage report, and I need the rows normalized into structured JSON with service, date, cost, currency, region, and any tags.","exampleUseCases":[{"title":"Normalize AWS cost export for FinOps dashboard","prompt":"I have a raw AWS Cost and Usage Report CSV — can you parse it into structured billing rows with service, date, cost, currency, region, and resource tags so I can feed it into our FinOps dashboard?"},{"title":"Ingest GCP billing CSV into cost pipeline","prompt":"Here's our GCP billing export as a base64-encoded CSV file with mediaType text/csv — please parse it and return normalized billing rows grouped by service and region."},{"title":"Validate and extract line items from billing file","prompt":"Can you process this cloud billing CSV text and extract all the line items into structured JSON? I need the date, service name, cost, currency, usage quantity, and any resource tags for each row."}],"resultDescription":"Returns a JSON object containing an array of normalized billing rows (each with date, service, cost, currency, region, account, resourceId, resourceType, usageUnit, usageQuantity, and tags), a billing format identifier ('brainiac-billing-v1'), a parse status, total row count, list of currencies found, a checkedAt timestamp, any findings or anomalies, and a limitations list clarifying that no cloud account was connected and no live provider data was fetched.","failureModes":["CSV text exceeds 200,000 character limit — returns validation error","Base64 file content exceeds 12,000,000 character limit — returns validation error","Malformed or unparseable CSV content — returns error or empty rows","Missing required row fields (date, service, cost, currency) — row rejected or error returned","Invalid date format in rows — schema validation failure","More than 5,000 rows submitted — validation error","Unsupported mediaType for file upload — schema validation failure","Payment not completed via x402/USDC — 402 Payment Required response"],"whenToPreferThis":"Choose this endpoint when you need a no-account, pay-per-call solution to parse and normalize cloud billing CSV data into structured JSON for FinOps pipelines, dashboards, or cost analysis workflows. It supports raw CSV text, base64-encoded file uploads, or pre-structured row arrays. Prefer this over building custom CSV parsing logic when you need consistent normalization of billing fields including service, region, account, tags, and usage metrics in a single API call.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-11-17T00:37:09.112Z","isFirstParty":false,"canonicalSlug":"brainiac-cloud-finops-billing-csv-parser-0816ef8a"}