When no data/columns is provided, hide 'Fields' modal

Hello, Patrick,
 
Thank you for reaching out to us.
 
The described behavior can be achieved using two approaches.
 
The Field List will not be opened in case the dataSource object is missed or does not contain data or filename property. In such a situation, an empty grid will be shown.
 
However, as we can see from your question, the JSON response is not always empty, and the filename property is required. In this case, our team suggests embedding of following code snippet to the page:

pivot.on('reportcomplete', function() {
    pivot.off("reportcomplete");
    if (pivot.getAllHierarchies().length == 0)
        pivot.setReport(pivot.getReport().dataSource = {});
});

The block of code provided above is executed when the reportcomplete event is triggered. It scans all hierarchies presented in the data set and modifies the dataSource object in case the data set does not contain any hierarchies, thereby the Field List is not opened, and the empty spreadsheet is displayed.
 
Please refer to an example we have prepared for you.
 
More information about API calls and object used in the example:

• reportcomplete event
• getAllHierarchies method
• setReport & getReport API calls

 
We hope it works for you.
 
Please contact us in case any additional questions occur.
 
Best regards,
Illia

Hello, Patric,
 
Thank you for your feedback.
We are happy to hear you have managed to achieve the desired result.
 
Do not hesitate to contact us in case other questions arise.
 
Kind regards,
Illia