Data Aggregator OpenAPI Odata queries in browser create CSV file without extension
search cancel

Data Aggregator OpenAPI Odata queries in browser create CSV file without extension

book

Article ID: 193539

calendar_today

Updated On:

Products

CA Infrastructure Management CA Performance Management - Usage and Administration DX NetOps

Issue/Introduction

I have a customer that uses the querybuilder to run queries.

When they export the results, it downloads with no extension.

This makes it difficult to use scripts to process the data.

Is there a way to force PM to append the extension .csv on these exports.

There is a documented method for the Bulk Data Export tool has such a setting but I can't find one for the QueryBuilder.

Environment

All supported Performance Management releases

Cause

Functioning as Designed

Resolution

To have the CSV files saved with the .csv, or any other Excel based extension, would be an Enhancement Request.

The CSV file extension is a mime type. We're dependent on how the browser handles it. Most browser show HTML, JSON, XML, and ATOM outputs inside the browser tab rather than saving the output to a file by default.

The issue is that a CSV is not a file type the browser will show by default.

As a result the output returned is saved to the file without an extension.

To do that would require new code and this is an Enhancement Request.

Additional Information

Enhancement Requests can be submitted via the Broadcom Community Ideation site found here.