Happy Business Starts Here

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 1
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 √