This April brings a series of updates to SpreadsheetWeb Hub, enhancing its capabilities and ensuring it remains a competitive tool for users requiring sophisticated application development solutions. These updates offer significant improvements to the API toolkit and performance enhancements. As SpreadsheetWeb continues to adapt and improve, these enhancements are designed to support more efficient and effective user interactions and data processing tasks.
Enhanced API Toolkit
The API toolkit in SpreadsheetWeb has undergone a substantial upgrade, resulting in enhanced functionality across various features. The toolkit now features a redesigned interface that facilitates saving and loading records, making it easier for users to enable database options.
A new functionality has been introduced to assign tags during record-saving, improving data categorization and retrieval. Users can also select transactions by specific dates, enhancing the application's ability to handle data queries precisely. Furthermore, the toolkit includes improved response time metrics, providing users with more precise insights into the performance of their requests. Support for directly editing table values has also been added. Lastly, an export option to a Postman collection is now available, aiding developers in the testing and integration process by allowing them to create and share API collections easily.
Transaction Date Support for Single Calculation Requests
Another significant enhancement is introducing transaction date support for single calculation requests. Users can now perform API calculations based on transactions effective on specific dates without knowing the corresponding transaction ID. This feature allows you to make an API call to historical versions of the Excel model by merely specifying the date and time. The system will locate the active Excel file on that date and process the API request accordingly.
Ability to Store JSON files for API Requests
Another API feature introduced allows for the storage of complete JSON files for each API request linked to a single calculation method. This functionality enables users to audit API requests directly through SpreadsheetWeb's user interface, removing the necessity of storing them on the client side. It is important to note that this feature is only available in the private cloud and server packages.
This update includes feature enhancements and improvements to increase the platform's performance. Implementing memory caching for the API Toolkit's calculation request JSON schema significantly improves the system's speed and responsiveness.
These updates to SpreadsheetWeb in April 2024 underscore the platform's commitment to delivering robust solutions that meet businesses' evolving needs. By focusing on functionality and user experience, SpreadsheetWeb ensures its tools are powerful but also accessible and efficient.
