Data Integration API API Reference

Version: v1

Authentication

Apikey

type

apiKey

name

Apikey

header

Paths

BackupConvert

Lists all tables stored in a SQL Server Backup (.BAK) file

POST /dataintegration/backup/convert/mssql/bak/get/tables

inputFile: file (binary)

in formData

Input file to perform the operation on

Code Example:

200 OK

MssqlBakEnumerateTablesResult

Success

Response Content-Types: text/plain, application/json, text/json

Response Example (200 OK)

{
  "successful": "boolean",
  "tables": [
    {
      "schemaName": "string",
      "tableName": "string"
    }
  ]
}

BackupConvert

Converts a SQL Server Backup (.BAK) file into CSV for a specified table

POST /dataintegration/backup/convert/mssql/bak/to/csv

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.

tableName: string

in header

Name of the table to return

inputFile: file (binary)

in formData

Input file to perform the operation on

Code Example:

200 OK

undefined

type

string (binary)

Response Content-Types: text/csv

Response Example (200 OK)

"string (binary)"

Schema Definitions

MssqlTable: object

Details about a SQL Server Table

schemaName: string: Name of the schema containing the table
tableName: string: Name of the table

Example

{
  "schemaName": "string",
  "tableName": "string"
}

MssqlBakEnumerateTablesResult: object

Result of enumeerating Tables in a SQL Server Backup (.BAK) file

successful: boolean: True if successful, False otherwise
tables: MssqlTable: SQL Server Tables in the backup file
MssqlTable

Example

{
  "successful": "boolean",
  "tables": [
    {
      "schemaName": "string",
      "tableName": "string"
    }
  ]
}