convert_excel_to_sandbox_payload
Converts GSTR-1 Excel data into the JSON payload format required by Sandbox.co save_gstr1_data API for GST return submission.
Instructions
Convert a GSTR-1 Excel file (output of the unified-gstr1 skill) into the JSON payload format required by the Sandbox.co save_gstr1_data() API.
Reads the b2b, b2cl, b2cs, and hsn sheets from the Excel file and maps each row to the corresponding Sandbox.co API structure.
Args: excel_path: Absolute path to the GSTR-1 Excel file
Returns: Dict with the formatted payload ready to pass to save_gstr1_data(), or an error dict.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| excel_path | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |