SOsocotra

POST /business-stats/delta-files/list

Request

Request body

tenantLocatorstring 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

versioninteger

Target a specific schema version; defaults to latest if omitted

startTimeinteger

Files in returned index will all have a generationTime later than startTime. Format is UNIX timestamp in UTC milliseconds (e.g. 1741713134934)

lastFilestring

Only files after this file in the index will be returned. Must provide full fileName

dataProcessedThroughTimeinteger

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

OK

versioninteger required

Target a specific schema version; defaults to latest if omitted

createTableFilestring required

Path & name of file with necessary sql statement to create the table in the destination schema

dropTableFilestring required

Path & name of file with necessary sql statement to drop the existing version of the table in the destination schema

s3Bucketstring required

The source S3 bucket required for the <ApiLink name='DeltaFileDownloadRequest' />

dataProcessedThroughTimeinteger 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)

Changes

No recorded changes to this operation across all 2 revisions of this API.