GitLab

Extend DescriptorController API v0 with a method that returns filtered results in Excel format using the format of the existing sheet for descriptors of the standard Catalog Excel template.

@PostMapping(value = "/export", produces = { "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet" } )
public void exportDescriptors(
		@RequestParam(name = "f", required = false) String filterCode,
		@RequestBody(required = false) DescriptorFilter filter, HttpServletResponse response) throws IOException {

	if (filterCode != null) {
		filter = shortFilterService.filterByCode(filterCode, DescriptorFilter.class);
	} else {
		filterCode = shortFilterService.getCode(filter);
	}

	response.setContentType("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");
	response.addHeader("Content-Disposition", String.format("attachment; filename=\"genesys-descriptors-" + filterCode + ".xlsx\""));
	response.flushBuffer();

	// Write XLSX to the stream.
	final OutputStream outputStream = response.getOutputStream();

	try {
		descriptorService.exportDescriptors(filter, outputStream);
		response.flushBuffer();
	} catch (EOFException e) {
		LOG.warn("Download was aborted", e);
	}
}

The export should include the UUID and version as the first two columns of the updated Excel sheet.