curl -X GET https://api.tableflow.com/v2/extractions/uT2bJNWN75YPU95r/tables/line_items/download \
  -H "Authorization: Bearer YOUR_API_KEY" \
  --output line_items.csv

curl -X GET https://api.tableflow.com/v2/extractions/uT2bJNWN75YPU95r/tables/line_items/download?filter=valid \
  -H "Authorization: Bearer YOUR_API_KEY" \
  --output valid_line_items.csv

const axios = require("axios");
const fs = require("fs");

async function downloadTableData(extractionId, tableKey, filter = "all", outputPath) {
  try {
    const response = await axios.get(
      `https://api.tableflow.com/v2/extractions/${extractionId}/tables/${tableKey}/download`,
      {
        params: { filter },
        headers: {
          Authorization: "Bearer YOUR_API_KEY",
        },
        responseType: "stream",
      }
    );

    // Save the CSV directly to the specified path
    const writer = fs.createWriteStream(outputPath);
    response.data.pipe(writer);

    return new Promise((resolve, reject) => {
      writer.on("finish", () => resolve(outputPath));
      writer.on("error", reject);
    });
  } catch (error) {
    console.error("Error downloading CSV:", error.message);
    throw error;
  }
}

// Example usage
downloadTableData("uT2bJNWN75YPU95r", "line_items", "all", "downloads/line_items.csv")
  .then(filePath => {
    console.log(`CSV file downloaded successfully to: ${filePath}`);
  })
  .catch(error => {
    console.error(`Failed to download CSV file: ${error.message}`);
  });

import requests

def download_table_data(extraction_id, table_key, output_path, filter_type="all"):
    url = f"https://api.tableflow.com/v2/extractions/{extraction_id}/tables/{table_key}/download"
    headers = {
        "Authorization": "Bearer YOUR_API_KEY"
    }
    params = {"filter": filter_type}
    
    # Download the CSV
    response = requests.get(url, headers=headers, params=params)
    response.raise_for_status()
    
    # Save to the specified path
    with open(output_path, 'wb') as f:
        f.write(response.content)
    
    return output_path

# Example usage
try:
    file_path = download_table_data(
        "uT2bJNWN75YPU95r",
        "line_items",
        "downloads/line_items.csv"
    )
    print(f"CSV downloaded to: {file_path}")
except requests.exceptions.HTTPError as e:
    print(f"Error downloading table data: {e}")

{
  "error": "Cannot download extraction while in status processing"
}

{
  "error": "Tables over 500000 rows are too large to download directly, please use the /rows pagination endpoint to access the data"
}