# Data Lake Delta Files API



<EndpointIndex
  names={['getMetadata', 'download']}
  titles={{
  	getMetadata: 'Fetch List of Delta Files',
  	download: 'Fetch Specific Delta File',
  }}
/>

Delta File Endpoints [#delta-file-endpoints]

Fetch List of Delta Files [#fetch-list-of-delta-files]

<ApiEndpoint name="getMetadata" title="Fetch List of Delta Files" />

Fetch Specific Delta File [#fetch-specific-delta-file]

<ApiEndpoint name="download" title="Fetch Specific Delta File" />

Delta File Request and Response Objects [#delta-file-request-and-response-objects]

<ApiSchema name="DeltaFilesGetRequest" />

<ApiSchema name="DeltaFilesGetResponse" />

<ApiSchema name="DeltaFile" />

<ApiSchema name="DeltaFileDownloadRequest" />

See Also [#see-also]

* [Data Lake Delta File Feature Guide](/features/reporting/delta-files)


## API Reference

POST /business-stats/delta-files/list — getMetadata
Tags: delta-files-controller
Permissions: read
Request body (DeltaFilesGetRequest):
Responses:
  200 DeltaFilesGetResponse — OK

POST /business-stats/delta-files/download — download
Tags: delta-files-controller
Permissions: read
Request body (DeltaFileDownloadRequest):
Responses:
  200 — OK

DeltaFilesGetRequest
Properties:
  tenantLocator (uuid, required)
  transformationTable (Enum 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)
  deltaFileType (Enum sql | csv)
  version (integer)
  startTime (integer)
  lastFile (string)
  dataProcessedThroughTime (integer)

DeltaFilesGetResponse
Properties:
  version (integer, required)
  createTableFile (string, required)
  dropTableFile (string, required)
  s3Bucket (string, required)
  dataProcessedThroughTime (integer, required)
  deltaFiles (DeltaFile[], required)

DeltaFile
Properties:
  deltaFileType (Enum sql | csv, required)
  fileName (string, required)
  jobStartTime (integer, required)
  jobEndTime (integer, required)
  generationTime (integer, required)
  recordCount (integer)
  md5HashSum (string)

DeltaFileDownloadRequest
Properties:
  tenantLocator (uuid, required)
  s3Bucket (string, required)
  fileName (string, required)