Operations (sample payloads)

1
{
2
    "file": {
3
        "name": "sales_report.xlsx",
4
        "url": "https://example.com/files/sales_report.xlsx",
5
        "mime_type": "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"
6
    },
7
    "worksheet_names": [
8
        "Q1 Sales",
9
        "Q2 Sales"
10
    ],
11
    "delimiter": "comma",
12
    "end_line": "Unix/LF",
13
    "enclose_quotes": true,
14
    "include_blank_rows": false
15
}

1
{
2
    "results": [
3
        {
4
            "name": "Q1_Sales.csv",
5
            "url": "https://example.com/files/Q1_Sales.csv",
6
            "mime_type": "text/csv",
7
            "expires": 1623456789
8
        },
9
        {
10
            "name": "Q2_Sales.csv",
11
            "url": "https://example.com/files/Q2_Sales.csv",
12
            "mime_type": "text/csv",
13
            "expires": 1623456789
14
        }
15
    ],
16
    "warnings": [
17
        {
18
            "sheet": "Q2 Sales",
19
            "message": "Some cells contain formulas that were converted to their calculated values."
20
        }
21
    ]
22
}

1
{
2
    "file": {
3
        "name": "sales_data.xlsx",
4
        "url": "https://example.com/files/sales_data.xlsx",
5
        "mime_type": "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"
6
    },
7
    "worksheet_names": [
8
        "Q1 Sales",
9
        "Q2 Sales"
10
    ],
11
    "column": 3,
12
    "blank_cell_value": "N/A"
13
}

1
{
2
    "results": [
3
        {
4
            "name": "extracted_column_data.csv",
5
            "url": "https://example.com/files/extracted_column_data.csv",
6
            "mime_type": "text/csv",
7
            "expires": 1623456789
8
        }
9
    ],
10
    "warnings": [
11
        {
12
            "sheet": "Q2 Sales",
13
            "message": "Some cells in the specified column were blank and replaced with 'N/A'"
14
        }
15
    ]
16
}