bim360appstore-model.derivative-nodejs-xls.exporter icon indicating copy to clipboard operation
bim360appstore-model.derivative-nodejs-xls.exporter copied to clipboard

Downloading large files

Open ko-ogundowole opened this issue 2 years ago • 2 comments

Does anyone have a suggestion regarding export of significantly large files?

The service works wonderfully, but when a file approaches 250Mb is size, the download is stuck on 'Preparing {filename}.xlsx' and 'Reading project information...'.

Is there, perhaps, a way to divide large files into categories of objects, and download several smaller sized .xlsx files?

ko-ogundowole avatar Jun 24 '22 11:06 ko-ogundowole

Hey, i had the same issue about it. i talked to Augusto and he told there is a restriction in the file size. am trying to develop a similar app through ACC to extract all the data without restrictions.

K3ph4s avatar Jun 28 '23 14:06 K3ph4s

first, this sample uses the endpoint /properties which has default limit with volume of model metadata (20MB). When the properties of this model exceeds the default 20MB, it will throw 413. You could add the query param forceget=true when fetching the properties. e.g. https://aps.autodesk.com/en/docs/model-derivative/v2/reference/http/metadata/urn-metadata-guid-properties-GET/#query-string-parameters in the sample source code, this line can be: https://github.com/autodesk-platform-services/aps-extract-spreadsheet/blob/master/public/js/ExportXLS.js#L60

IF you know the filter which objects 's properties to be download, you could migrate the code with other endpoint: https://aps.autodesk.com/blog/advanced-query-model-derivative-api which supports downloading in pagination.

xiaodongliang avatar Jul 14 '23 15:07 xiaodongliang