Allow AqUA to return JSON response

vkannan Tutor

Tutor

Allow AqUA to return JSON response

Status: Unlikely
by Tutor vkannan on ‎08-11-2017 02:32 PM

Hi,

Today when we execute AqUA, the only option is to get back a file with the data.

Can we look at returning JSON for the same response.

We can look at creating page sizes to restrict the size.

Thanks,

Vimal

Status: Unlikely

@vkannan, why do you prefer JSON over CSV, for extracts that are meant to be quite large?

Comments
lukasz Z-Product Team

Z-Product Team

by Z-Product Team
on ‎08-24-2017 12:29 PM
Status changed to: Unlikely

@vkannan, why do you prefer JSON over CSV, for extracts that are meant to be quite large?

vkannan Tutor

Tutor

by Tutor vkannan
on ‎12-07-2017 04:28 PM

Lucas,

We have a middle tier that is processing the file stream and is waiting for the files to be proceesed through a loader program.File Streams are inherently error prone especially if the size exceeds 2 MB.

This capability will make it easier for the middleware to transform the payload back from Zuora into our internal systems.

Thanks,

Vimal

lukasz Z-Product Team

Z-Product Team

by Z-Product Team
on ‎12-20-2017 10:32 AM

@vkannan, did you mean 2GB? Please note this article in our KC, which addresses what to do if the response files are bigger than that.

vkannan Tutor

Tutor

by Tutor vkannan
on ‎12-20-2017 10:46 AM

@lukasz it's not about the 2GB limit, many of our daily stateless requests result in files having less than 5 rows, we now have to store the file in a file location and then write a CSV parser to get the data parsed and inserted into our DB. If the response was a JSON, our middleware can parse it and call a DB adapter to put the data directly in our database.

It's a much simpler interface. From your end, is there a CSV to JSON conversion that can be provided?

 

lukasz Z-Product Team

Z-Product Team

by Z-Product Team
on ‎12-20-2017 10:56 AM

Ah, I see what you mean now. So, no, today, we don't have another format for the results from AQuA to be provided other than either CSV or Zip CSV. I believe we chose this format because it was ultimately meant for large extracts, and the idea that all responses would be consistent. Obviously, we have provisions for supporting other formats. I'll let the community here upvote the request. Thank you for getting back to me with the details of the issue.