This sample shows to get the data for PivotEngine from an external API.

https://stackblitz.com/edit/query-pivot-panel-chart-56dssl