openapi: 3.0.0 info: title: CSV Processor API description: A powerful CSV processing API that converts, validates, transforms, and aggregates CSV data. version: 1.0.0 contact: name: API Support license: name: MIT url: https://opensource.org/licenses/MIT servers: - url: https://csv.apibolt.io description: Production server - url: http://localhost:3015 description: Local development server tags: - name: General description: General endpoints - name: CSV Processing description: CSV processing and conversion endpoints - name: CSV Analysis description: CSV validation, filtering, and aggregation endpoints paths: /: get: tags: - General summary: API Information operationId: getApiInfo description: Returns API information and available endpoints responses: '200': description: Successful response content: application/json: schema: type: object properties: name: type: string version: type: string endpoints: type: array items: type: string example: name: CSV Processor API version: 1.0.0 endpoints: - /api/csv/parse - /api/csv/to-json - /api/csv/to-xml /health: get: tags: - General summary: Health Check operationId: healthCheck description: Returns API health status and timestamp responses: '200': description: Server is healthy content: application/json: schema: type: object properties: status: type: string timestamp: type: string example: status: ok timestamp: '2024-01-15T10:30:00Z' /api/csv/parse: post: tags: - CSV Processing summary: Parse CSV to JSON operationId: parseCsv description: Parses CSV string and returns structured JSON data with metadata security: [] requestBody: required: true content: application/json: schema: type: object properties: csv: type: string description: CSV string data example: "name,age,city\nJohn,30,NYC\nJane,25,LA" options: type: object description: PapaParse options required: - csv example: csv: "name,age,city\nJohn,30,NYC\nJane,25,LA" responses: '200': description: CSV parsed successfully content: application/json: schema: type: object properties: success: type: boolean data: type: array meta: type: object example: success: true data: - name: John age: '30' city: NYC - name: Jane age: '25' city: LA meta: rowCount: 2 columnCount: 3 delimiter: ',' '400': description: Invalid CSV or missing data '401': description: Missing API key /api/csv/to-json: post: tags: - CSV Processing summary: Convert CSV to JSON operationId: csvToJson description: Converts CSV string to JSON array format security: [] requestBody: required: true content: application/json: schema: type: object properties: csv: type: string description: CSV string data example: "name,age,city\nJohn,30,NYC\nJane,25,LA" required: - csv example: csv: "name,age,city\nJohn,30,NYC\nJane,25,LA" responses: '200': description: Conversion successful content: application/json: schema: type: object properties: success: type: boolean data: type: array example: success: true data: - name: John age: '30' city: NYC - name: Jane age: '25' city: LA '400': description: Invalid CSV '401': description: Missing API key /api/csv/to-xml: post: tags: - CSV Processing summary: Convert CSV to XML operationId: csvToXml description: Converts CSV data to XML format with proper escaping security: [] requestBody: required: true content: application/json: schema: type: object properties: csv: type: string description: CSV string data example: "name,age,city\nJohn,30,NYC" required: - csv example: csv: "name,age,city\nJohn,30,NYC" responses: '200': description: Conversion successful content: application/json: schema: type: object properties: success: type: boolean data: type: string example: success: true data: 'John30NYC' '400': description: Invalid CSV '401': description: Missing API key /api/csv/to-html: post: tags: - CSV Processing summary: Convert CSV to HTML operationId: csvToHtml description: Converts CSV data to HTML table format security: [] requestBody: required: true content: application/json: schema: type: object properties: csv: type: string required: - csv example: csv: "name,age,city\nJohn,30,NYC" responses: '200': description: Conversion successful content: application/json: schema: type: object properties: success: type: boolean data: type: string example: success: true data: '

name	age	city
John	30	NYC

' '400': description: Invalid CSV '401': description: Missing API key /api/csv/to-sql: post: tags: - CSV Processing summary: Convert CSV to SQL operationId: csvToSql description: Converts CSV data to SQL INSERT statements security: [] requestBody: required: true content: application/json: schema: type: object properties: csv: type: string tableName: type: string default: csv_data required: - csv example: csv: "name,age,city\nJohn,30,NYC" tableName: csv_data responses: '200': description: Conversion successful content: application/json: schema: type: object properties: success: type: boolean data: type: string example: success: true data: 'INSERT INTO csv_data (name, age, city) VALUES (''John'', ''30'', ''NYC'');' '400': description: Invalid CSV '401': description: Missing API key /api/csv/validate: post: tags: - CSV Analysis summary: Validate CSV Structure operationId: validateCsv description: Validates CSV structure and checks for inconsistencies security: [] requestBody: required: true content: application/json: schema: type: object properties: csv: type: string required: - csv example: csv: "name,age,city\nJohn,30,NYC" responses: '200': description: Validation complete content: application/json: schema: type: object properties: success: type: boolean valid: type: boolean errors: type: array items: type: string example: success: true valid: true errors: [] '400': description: Invalid CSV '401': description: Missing API key /api/csv/transform: post: tags: - CSV Analysis summary: Transform CSV Data operationId: transformCsv description: Apply transformations like rename, filter, sort to CSV data security: [] requestBody: required: true content: application/json: schema: type: object properties: csv: type: string transformations: type: array items: type: object properties: type: type: string enum: [rename, filter, sort] oldName: type: string newName: type: string column: type: string value: type: string order: type: string enum: [asc, desc] required: - csv example: csv: "name,age,city\nJohn,30,NYC" transformations: [] responses: '200': description: Transformation successful content: application/json: schema: type: object properties: success: type: boolean data: type: array example: success: true data: - name: John age: '30' city: NYC '400': description: Invalid request '401': description: Missing API key /api/csv/aggregate: post: tags: - CSV Analysis summary: Aggregate CSV Data operationId: aggregateCsv description: Group and aggregate CSV data with operations like sum, avg, count, min, max security: [] requestBody: required: true content: application/json: schema: type: object properties: csv: type: string groupBy: type: array items: type: string aggregations: type: array items: type: object properties: column: type: string operation: type: string enum: [sum, avg, count, min, max] alias: type: string required: - csv - groupBy - aggregations example: csv: "city,age\nNYC,30\nLA,25" groupBy: - city aggregations: - column: age operation: avg alias: avg_age responses: '200': description: Aggregation successful content: application/json: schema: type: object properties: success: type: boolean data: type: array example: success: true data: - city: NYC total_age: 55 avg_age: 27.5 '400': description: Invalid request '401': description: Missing API key /api/csv/filter: post: tags: - CSV Analysis summary: Filter CSV Rows operationId: filterCsv description: Filter CSV rows based on conditions with various operators security: [] requestBody: required: true content: application/json: schema: type: object properties: csv: type: string conditions: type: array items: type: object properties: column: type: string operator: type: string enum: [eq, neq, gt, lt, gte, lte, contains] value: type: string required: - csv example: csv: "name,age,city\nJohn,30,NYC\nJane,25,LA" conditions: - column: age operator: gt value: "25" responses: '200': description: Filter applied content: application/json: schema: type: object properties: success: type: boolean data: type: array count: type: integer example: success: true data: - name: John age: '30' city: NYC count: 1 '400': description: Invalid request '401': description: Missing API key /api/csv/from-json: post: tags: - CSV Processing summary: Convert JSON to CSV description: Converts a JSON array of objects to CSV format operationId: jsonToCsv security: [] requestBody: required: true content: application/json: schema: type: object properties: json: type: string description: JSON array of objects as a string example: '[{"name":"John","age":30,"city":"NYC"}]' required: - json example: json: '[{"name":"John","age":30,"city":"NYC"}]' responses: '200': description: Conversion successful content: application/json: schema: type: object properties: success: type: boolean data: type: string example: success: true data: 'name,age,city\nJohn,30,NYC' '400': description: Invalid JSON or missing data '401': description: Missing API key /api/csv/validate/advanced: post: tags: - CSV Analysis summary: Advanced CSV validation description: Perform advanced validation including data type checks, duplicate detection, and configurable rules operationId: advancedValidateCsv security: [] requestBody: required: true content: application/json: schema: type: object properties: csv: type: string options: type: object properties: checkColumnCount: type: boolean description: Check for consistent column counts default: true checkMissingValues: type: boolean description: Check for missing values default: true allowEmptyStrings: type: boolean description: Treat empty strings as valid default: false checkDataTypes: type: boolean description: Validate data types default: false numericColumns: type: array items: type: string description: Columns that should contain numeric values dateColumns: type: array items: type: string description: Columns that should contain valid dates checkDuplicates: type: boolean description: Check for duplicate rows default: false uniqueColumns: type: array items: type: string description: Columns to check for uniqueness required: - csv example: csv: "name,age,city\nJohn,30,NYC\nJane,25,LA" responses: '200': description: Advanced validation complete content: application/json: schema: type: object properties: success: type: boolean valid: type: boolean errors: type: array items: type: string warnings: type: array items: type: string example: success: true valid: true errors: [] warnings: [] '400': description: Invalid CSV '401': description: Missing API key /api/csv/pivot: post: tags: - CSV Analysis summary: Create pivot table description: Create a pivot table from CSV data with configurable aggregation operationId: pivotCsv security: [] requestBody: required: true content: application/json: schema: type: object properties: csv: type: string rowKeys: type: array items: type: string description: Columns to use as row identifiers colKey: type: string description: Column to use as column headers valueKey: type: string description: Column containing values to aggregate aggregation: type: string description: Aggregation function enum: [sum, avg, count, min, max] default: sum required: - csv - rowKeys - colKey - valueKey example: csv: "city,age\nNYC,30\nNYC,25\nLA,25" rowKeys: - city colKey: age valueKey: age aggregation: avg responses: '200': description: Pivot table created content: application/json: schema: type: object properties: success: type: boolean data: type: object properties: rows: type: array items: type: string columns: type: array items: type: string data: type: object example: success: true data: rows: - NYC - LA columns: - age data: NYC: 30 LA: 25 '400': description: Invalid request '401': description: Missing API key /api/csv/detect: post: tags: - CSV Analysis summary: Detect CSV structure description: Automatically detect the delimiter and structure of CSV data operationId: detectCsvStructure security: [] requestBody: required: true content: application/json: schema: type: object properties: csv: type: string description: Raw CSV string to analyze example: "name,age,city\nJohn,30,NYC" required: - csv example: csv: "name,age,city\nJohn,30,NYC" responses: '200': description: Detection result content: application/json: schema: type: object properties: success: type: boolean data: type: object properties: delimiter: type: string description: Detected delimiter character confidence: type: number description: Confidence score of detection counts: type: object description: Count of each potential delimiter example: success: true data: delimiter: ',' confidence: 0.95 counts: ',': 3 ';': 0 '\t': 0 '400': description: Invalid CSV '401': description: Missing API key /api/csv/query: post: tags: - CSV Processing summary: SQL-like query on CSV description: Execute SQL-like queries (SELECT, WHERE, ORDER BY, LIMIT) on CSV data operationId: queryCsv security: [] requestBody: required: true content: application/json: schema: type: object properties: csv: type: string description: CSV data to query example: "name,age,city\nJohn,30,NYC\nJane,25,LA" query: type: string description: SQL-like query string (e.g., "SELECT name, age FROM data WHERE age > 30 ORDER BY name LIMIT 10") example: "SELECT name, age FROM data WHERE age > 25" required: - csv - query example: csv: "name,age,city\nJohn,30,NYC\nJane,25,LA" query: "SELECT name, age FROM data WHERE age > 25" responses: '200': description: Query result content: application/json: schema: type: object properties: success: type: boolean data: type: array rowCount: type: integer description: Number of rows returned example: success: true data: - name: John age: '30' city: NYC rowCount: 1 '400': description: Invalid request '401': description: Missing API key /api/csv/merge: post: tags: - CSV Processing summary: Merge Multiple CSVs operationId: mergeCsv description: Merge multiple CSV datasets with join operations security: [] requestBody: required: true content: application/json: schema: type: object properties: csvs: type: array items: type: string options: type: object properties: key: type: string joinType: type: string enum: [inner, outer] required: - csvs example: csvs: - "name,age,city\nJohn,30,NYC" - "name,score\nJohn,95" options: key: name joinType: inner responses: '200': description: Merge successful content: application/json: schema: type: object properties: success: type: boolean data: type: array example: success: true data: - name: John age: '30' city: NYC '400': description: Invalid request '401': description: Missing API key components: # securitySchemes removed - RapidAPI handles authentication