Happy Business Starts Here

How to retrieve the file size of an AQuA or Export file without downloading it

Zuora Support Moderator

How to retrieve the file size of an AQuA or Export file without downloading it

Problem: Customer requested if there was a way to estimate AQuA file size output on a per-file basis for storage planning.



If you found my answer helpful, please give me a kudo ↑
Help others find answers faster by accepting my post as a solution √


1 REPLY
Zuora Support Moderator

Re: How to retrieve the file size of an AQuA or Export file without downloading it

Solution:

 

Most of Zuora's customer facing output shows row output from the UI.  If the approximate byte output per row is known, a user may be able to estimate output, however here is a more precise method using WGET on the individual fileid (on a per-file basis):

$ wget --spider --header="Authorization: ZSession <TOKEN REDACTED>" https://www.zuora.com/apps/api/file/2c92a1ae77e698382160fa1249ca8487
Spider mode enabled. Check if remote file exists.
--2018-01-15 09:00:48-- https://www.zuora.com/apps/api/file/2c92a1ae77e698382160fa1249ca8487
Resolving www.zuora.com (www.zuora.com)... 23.5.245.171
Connecting to www.zuora.com (www.zuora.com)|23.5.245.171|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 22281818032 (21G) [text/csv]
Remote file exists.

 

 

Searching through Google suggests CURL can also be used similar to the above.



If you found my answer helpful, please give me a kudo ↑
Help others find answers faster by accepting my post as a solution √