Pivot Data Reporting Server
Budget: $15 – $25 USD
We have all data stored in mysql database and a backend api server.
Currently frontend will make request to backend api for data. However, the current backend is not capable of doing pivot table reporting.
Hence we plan to run a reporting server which is independent from existing system.
The new flow as follows :
- The backend api will trigger a request to the reporting server.
- The backed api will send the data, required pivot options, & a transaction id over to via POST
- The reporting server will take the data & the required pivot options and process the data into a pivoted data and export to a public folder on the reporting server as an excel file. .
- The export file name will be the transaction id from the backend api.
Currently frontend will make request to backend api for data. However, the current backend is not capable of doing pivot table reporting.
Hence we plan to run a reporting server which is independent from existing system.
The new flow as follows :
- The backend api will trigger a request to the reporting server.
- The backed api will send the data, required pivot options, & a transaction id over to via POST
- The reporting server will take the data & the required pivot options and process the data into a pivoted data and export to a public folder on the reporting server as an excel file. .
- The export file name will be the transaction id from the backend api.