---
title: "POST /business-stats/delta-files/list"
method: POST
path: "/business-stats/delta-files/list"
---

# POST /business-stats/delta-files/list

`POST /business-stats/delta-files/list`

## Request

- Base URL: `https://docs.socotra.com`
- URL: `https://docs.socotra.com/business-stats/delta-files/list`
- Auth: none declared
- TypeScript: <https://skmtc.dev/socotra/apis/socotra-insurance-suite-openapi/docs/business-stats/delta-files/list/post.ts> (a function with typed inputs; its response is checked against the schema)

## Request body

- DeltaFilesGetRequest
  - `tenantLocator` string, uuid, required: Locator of the tenant corresponding to the data
  - `transformationTable` 'DataLakeAccountDataExtensions' | 'DataLakeAccounts' | 'DataLakeAffectedTransactions' | 'DataLakeAuxData' | 'DataLakeBillingHolds' | 'DataLakeClaimDataExtensions' | 'DataLakeClaims' | 'DataLakeCreditDistributions' | 'DataLakeCreditItems' | 'DataLakeDelinquencies' | 'DataLakeDelinquencyReferences' | 'DataLakeDiaries' | 'DataLakeDisbursementDataExtensions' | 'DataLakeDisbursements' | 'DataLakeFaTransactionAccountLines' | 'DataLakeFaTransactions' | 'DataLakeFnolDataExtensions' | 'DataLakeFnols' | 'DataLakeInstallmentItems' | 'DataLakeInstallments' | 'DataLakeInstallmentSettings' | 'DataLakeInvoiceItems' | 'DataLakeInvoices' | 'DataLakeLedgerAccountLineItems' | 'DataLakeLedgerAccounts' | 'DataLakeMoratoriumElections' | 'DataLakeMoratoriums' | 'DataLakeMoratoriumStatuses' | 'DataLakePaymentDataExtensions' | 'DataLakePayments' | 'DataLakePolicies' | 'DataLakePolicyAutoRenewals' | 'DataLakePolicyCoverageTerms' | 'DataLakePolicyDataExtensions' | 'DataLakePolicyElementCharges' | 'DataLakePolicyElements' | 'DataLakePolicyElementTree' | 'DataLakePolicyElementUnderwritingFlags' | 'DataLakePolicyPreferences' | 'DataLakePolicySegments' | 'DataLakePolicyStatuses' | 'DataLakePolicyTerms' | 'DataLakePolicyTransactionChangeInstructions' | 'DataLakePolicyTransactions' | 'DataLakeProducerCodeDataExtensions' | 'DataLakeProducerCodes' | 'DataLakeProducerDataExtensions' | 'DataLakeProducerHierarchy' | 'DataLakeProducers' | 'DataLakeQuoteCoverageTerms' | 'DataLakeQuoteDataExtensions' | 'DataLakeQuoteElementCharges' | 'DataLakeQuoteElements' | 'DataLakeQuoteElementTree' | 'DataLakeQuoteElementUnderwritingFlags' | 'DataLakeQuotes' | 'DataLakeTaskReferences' | 'DataLakeTasks' | 'DataLakeUserAssociations' | 'DataLakeUserQualifications' | 'DataLakeWriteOffs', required: Name of the desired Data Lake table
  - `deltaFileType` 'sql' | 'csv': The format of the delta files to be returned. Defaults to `sql` if omitted
  - `version` integer: Target a specific schema version; defaults to latest if omitted
  - `startTime` integer: Files in returned index will all have a `generationTime` later than `startTime`. Format is UNIX timestamp in UTC milliseconds (e.g. 1741713134934)
  - `lastFile` string: Only files after this file in the index will be returned. Must provide full `fileName`
  - `dataProcessedThroughTime` integer: Only files with a `dataProcessedThroughTime` prior to or equal to this time will be returned. Format is UNIX timestamp in UTC seconds (e.g. 1451606100)

## Response `200`

OK

- DeltaFilesGetResponse
  - `version` integer, required: Target a specific schema version; defaults to latest if omitted
  - `createTableFile` string, required: Path & name of file with necessary sql statement to create the table in the destination schema
  - `dropTableFile` string, required: Path & name of file with necessary sql statement to drop the existing version of the table in the destination schema
  - `s3Bucket` string, required: The source S3 bucket required for the <ApiLink name='DeltaFileDownloadRequest' />
  - `dataProcessedThroughTime` integer, required: The time of the latest operational change that will be reflected in the data. Format is UNIX timestamp in UTC seconds (e.g. 1451606100)
  - `deltaFiles` DeltaFile[], required: The index of individual delta files
    - `deltaFileType` 'sql' | 'csv', required: The format of the delta file
    - `fileName` string, required: The name of the delta file
    - `jobStartTime` integer, required: The that the job to generate the file began. Format is UNIX timestamp in UTC seconds (e.g. 1451606100)
    - `jobEndTime` integer, required: The that the job to generate the file ended. Format is UNIX timestamp in UTC seconds (e.g. 1451606100)
    - `generationTime` integer, required: The time that the file was generated. Format is UNIX timestamp in UTC milliseconds (e.g. 1741713134934)
    - `recordCount` integer: For files with `deltaFileType` = `csv`, the number of rows in the file, excluding headers
    - `md5HashSum` string: For files with `deltaFileType` = `csv`, the MD5 format hashsum for the file contents, including headers

---

[API](https://skmtc.dev/socotra/apis/socotra-insurance-suite-openapi.md) - [All operations](https://skmtc.dev/socotra/apis/socotra-insurance-suite-openapi/llms.txt) - [OpenAPI document](https://skmtc.dev/socotra/apis/socotra-insurance-suite-openapi/revisions/6537d24b3693?raw)