Sheet JSON Converter APIs

Financial information required for tax compliance is typically stored in Excel files or formats. However, while Sandbox APIs process this data in a Sheet-JSON structure, developers often face the challenge of manually mapping values and performing conversions, which can significantly extend development timelines.

The introduction of the Sheet-JSON APIs resolves this issue by providing an efficient way to handle conversions between Excel (XLSX) and Sheet-JSON formats. This automation eliminates the need for manual mapping, significantly speeding up the development process. The APIs include:

• XLSX to Sheet JSON: Converts XLSX files into Sheet-JSON format.
• Sheet JSON to XLSX: Converts Sheet-JSON data back into XLSX files.

The Sheet-JSON APIs also offer flexibility, enabling developers to create custom JSON structures, as long as the XLSX and JSON follow the Sheet-JSON format. This allows for efficient and tailored data conversions beyond the specific JSON requirements of the Sandbox APIs.