Updating Excel sheets

Basic idea

4Straction provides a way to map Excel sheets to system indicators and allow updating them via interface. This provides a seamless way to integrate manually updated backoffice excel data to web publishing process.

You can also import Excel sheets via API from your backoffice.

Importing Excel sheets

You have to pass Base64 encoded string value for the Excel binary and integer configuration value for Excel configuration in the system. Currently you can get the integer value by studying the network traffic in the browser.

/v1/SheetExcelConfiguration&importAndProcessExcelFile
FileUploadHelperEntity {
String Base64String
}
int sheetExcelConfigurationID

Feedback

After successfull upload, you will get an entity representing PerformanceIndicatorTimePeriodSummary which you can iterate to find out that you really have that data understood and processed by the system that you want.