Downloading data export files

The Toast platform stores data export files in Amazon® Simple Storage Service® (Amazon S3) for seven days, after which they are deleted. When you enable data exports for your restaurant group, Toast support will provide the following information that you can use to retrieve data export files:

  • User name

  • S3 access key ID

  • S3 secret access key

  • Export IDs

Export IDs can also be obtained from the Toast admininstration back-end. Navigate to Reports > Settings > Data Exports and click the link in the banner at the top of the screen, view restaurant # mapping to export a file that includes an Export ID column which includes the ID for each restaurant.

Prior to downloading data export files, ensure that you have added an SSH key to the Toast administration back-end. There are several ways that you can retrieve files from Amazon S3. The following examples are for use with the macOS™ terminal and Windows™ command prompt. For information about how to export files using a third party FTP solution see this Toast Central article.

Accessing your sFTP directory using macOS terminal

  1. Connect to your sFTP directory

    To access your restaurant's sFTP directory using terminal use the following command:

    sftp \ 
          -i ~/{SSH key filepath} \
          -r {username}@s-9b0f88558b264dfda.server.transfer.us-east-1.amazonaws.com:{export id}/{YYYYMMDD}/*

    Replace the {username} and {export id} placeholders with the details you received from Toast support. Change {YYYYMMDD} to the business date of the desired export within the last seven days and the {SSH key filepath} to the location of your SSH key on your machine.

    Note

    The {filepath} used will be the export directory for your restaurant files.

  2. Exporting files using terminal

    Once you are connected to the sFTP directory use the ls command and press Return to display all files.

    Export all files using the get * command or use get {fileName} to export a specific file.

Accessing your sFTP directory using Windows command prompt

  1. Connect to your sFTP directory

    To access your restaurant's sFTP directory using command prompt use the following command:

    sftp \
      -i {SSH key filepath}\
      -r {username}@s-9b0f88558b264dfda.server.transfer.us-east-1.amazonaws.com:{export id}/{YYMMDD}/*

    Replace the {username} and {export id} placeholders with the details you received from Toast support. Change {YYYYMMDD} to the business date of the desired export within the last seven days and the {SSH key filepath} to the location of your SSH key on your machine.

    Note

    The {filepath} used will be the export directory for your restaurant files.

  2. Exporting files using command prompt

    Once you are connected to the sFTP directory use the ls command and press Enter to display all files.

    Export all files using the get * command or use get {fileName} to export a specific file.