{ "swagger": "2.0", "info": { "title": "dataintegrationapi", "description": "Easily and directly query database backup files, convert into other file formats.", "version": "v1" }, "paths": { "/dataintegration/backup/convert/mssql/bak/get/tables": { "post": { "tags": [ "BackupConvert" ], "summary": "Lists all tables stored in a SQL Server Backup (.BAK) file", "consumes": [ "multipart/form-data" ], "produces": [ "text/plain", "application/json", "text/json" ], "parameters": [ { "in": "formData", "name": "inputFile", "description": "Input file to perform the operation on", "type": "file", "format": "binary" } ], "responses": { "200": { "description": "Success", "schema": { "$ref": "#/definitions/MssqlBakEnumerateTablesResult" } } } } }, "/dataintegration/backup/convert/mssql/bak/to/csv": { "post": { "tags": [ "BackupConvert" ], "summary": "Converts a SQL Server Backup (.BAK) file into CSV for a specified table", "description": "Input the target table to extract the data as a CSV format file. Supports a wide array of SQL Server .BAK files and SQL Server backup file versions. Consumes 1 API call per MB of input data.", "consumes": [ "multipart/form-data" ], "produces": [ "text/csv" ], "parameters": [ { "in": "header", "name": "tableName", "description": "Name of the table to return", "type": "string" }, { "in": "formData", "name": "inputFile", "description": "Input file to perform the operation on", "type": "file", "format": "binary" } ], "responses": { "200": { "schema": { "format": "binary", "type": "string" } } } } } }, "definitions": { "MssqlTable": { "description": "Details about a SQL Server Table", "type": "object", "properties": { "schemaName": { "description": "Name of the schema containing the table", "type": "string" }, "tableName": { "description": "Name of the table", "type": "string" } } }, "MssqlBakEnumerateTablesResult": { "description": "Result of enumeerating Tables in a SQL Server Backup (.BAK) file", "type": "object", "properties": { "successful": { "description": "True if successful, False otherwise", "type": "boolean" }, "tables": { "description": "SQL Server Tables in the backup file", "type": "array", "items": { "$ref": "#/definitions/MssqlTable" } } } } }, "securityDefinitions": { "Apikey": { "type": "apiKey", "name": "Apikey", "in": "header", "description": "Apikey" } }, "security": [ { "Apikey": [ ] } ] }