Hello Helical Insight Team,
We are currently using Helical Insight 6.2 and are trying to use an API as a metadata source for report creation.
Our API typically returns approximately 20,000 to 50,000 records, and sometimes even more. The API request itself takes only around 400 ms, but the report takes approximately 8 to 15 seconds to load.
I noticed that the Helical Insight website mentions a Streaming Response Enhancement feature that can be used to improve performance:
https://www.helicalinsight.com/helical-insight-6-2-streaming-response-enhancement/
However, when I changed the following configuration:
false
to:
true
an error occurred while creating the report:
Error: NullPointerException: Cannot invoke “java.sql.ResultSetMetaData.getColumnCount()” because “” is null
I also tried changing only the other streaming-related configurations, but there was no noticeable improvement in the request or report-generation time.
The API response format is shown in the attached screenshot.
Could you please advise how we can optimize report creation performance when using an API data source with this volume of data? We would also like to know whether the Streaming Response Enhancement feature supports API-based data sources, and whether any additional configuration or limitations apply.
Thank you.
