Data Exports

Data Exports gives every ShipHero customer weekly full exports and delta exports every six hours at no additional cost. Use the data_exports Public API query to find completed runs and download account-scoped Parquet files.

For more frequent exports, contact your Customer Success Manager.

Export schedule and file format

• Full exports run weekly. For an explicit timestamp range, the API returns the first completed full export from each UTC week touched by that range. The selected run may be earlier than timestamp_from because it represents that week’s full export.
• Delta exports use six-hour UTC slots starting at 00:00, 06:00, 12:00, and 18:00. Each export can include changes from up to eight hours before the run. The API returns the first completed delta export in each matching slot.
• Files use Parquet format with Snappy compression.
• In some cases, a table can contain more than one file. Download every entry in files to read the complete table for that run.
• Signed URLs expire after 24 hours. Run the query again when a URL expires.

Request arguments

The data_exports query accepts these arguments:

• export_types is required. Pass FULL, DELTA, or both.
• timestamp_from is an optional inclusive ISO 8601 timestamp.
• timestamp_to is an optional exclusive ISO 8601 timestamp. It requires timestamp_from. If omitted when timestamp_from is present, it defaults to the current time.
• modules optionally limits the response to specific export modules. When provided, it must contain at least one module.

Omit both timestamps to request the latest eligible export for each requested type. Send both timestamps in UTC.

For an explicit range, timestamp_from must be before the current time. When you provide timestamp_to, it must be later than timestamp_from.

Supported module filters

Public API example

The following query requests full and delta exports in a UTC range and limits the results to the Orders and Shipments modules.

query DataExports(
  $exportTypes: [DataExportType!]!
  $timestampFrom: ISODateTime
  $timestampTo: ISODateTime
  $modules: [DataExportModuleName!]
) {
  data_exports(
    export_types: $exportTypes
    timestamp_from: $timestampFrom
    timestamp_to: $timestampTo
    modules: $modules
  ) {
    request_id
    data {
      full {
        run_id
        modules {
          name
          tables {
            name
            files {
              signed_url
              size
              created_at
            }
          }
        }
      }
      delta {
        run_id
        modules {
          name
          tables {
            name
            files {
              signed_url
              size
              created_at
            }
          }
        }
      }
    }
  }
}

Use these variables with the query:

{
  "exportTypes": ["FULL", "DELTA"],
  "timestampFrom": "2026-08-10T00:00:00Z",
  "timestampTo": "2026-08-11T00:00:00Z",
  "modules": ["ORDERS", "SHIPMENTS"]
}

To request the latest full export without a timestamp range, send only the required export type:

{
  "exportTypes": ["FULL"]
}

Reading the response

• full contains the selected weekly full runs.
• delta contains the selected runs generated every six hours.
• run_id identifies the export run.
• modules[].name is the lower-case module name, such as orders.
• tables[].name identifies a table in the module.
• files[] contains every Parquet file part for the table.
• signed_url is the temporary file URL.
• size is the file size in bytes.
• created_at is the file creation time in UTC.

If no data matches the requested range or module filters, the corresponding full or delta list is empty. If ShipHero cannot find a complete export for a selected period, the query fails instead of returning partial data.

Available data tables

Data Exports can include the following tables. The API returns the tables present in the selected run after applying any module filters.

Orders

• orders, main order records with customer information, totals, and status
• line_items, SKUs and quantities for each order
• order_tags, tags applied to orders
• _order_history, order updates and status changes

Shipments

• shipments, shipment records with tracking and carrier data
• shipped_line_items, line items included in each shipment
• shipping_labels, metadata for generated shipping labels
• shipment_attributes, shipment-level key and value attributes
• shipped_line_item_lots, links between shipped items and inventory lots
• shipped_items, physical items included in shipments

Returns

• returns, return authorization records
• rma_labels, shipping labels associated with returns
• return_items, items included in each return

Products

• products, product records and attributes
• product_tags, tags applied to products
• product_images2, product image URLs and display order
• lots, lot tracking information
• warehouse_products, warehouse-specific product data
• kitting_map, kit and bundle components
• assembly_map, assembled products and their component quantities
• product_cases, case pack configurations

Inventory

• bins, warehouse storage bins
• item_bins, product quantities by bin
• location_change_log, inventory movements between bins
• location_types, location classifications
• cycle_count_v2_batches, cycle count batches
• cycle_count_v2_batch_items, items in cycle count batches
• cycle_count_v2_batch_discrepancies, discrepancies found during cycle counts

Purchase orders

• purchase_orders, purchase order records
• purchase_order_line_items, items in each purchase order
• vendors, supplier records
• products_vendors, product and vendor relationships

3PL metadata

• warehouse_to_customers, relationships between 3PL warehouses and customers

Users

• users, user accounts, roles, and permissions

Labor

• activities, labor activities performed by WorkforceHero workers
• alerts, alerts generated during worker activities
• jobs, warehouse job definitions
• shifts_management, warehouse shift definitions
• special_projects, non-standard warehouse projects
• warehouses, warehouses enabled for the Labor module
• workers, WorkforceHero worker records

Additional tables may be added over time.

Authentication and access

The query requires the view:data_exports scope. Authenticate with a Developer User created through the third-party developer flow or a regular user account with Data Exports enabled.