Purpose:

This article explains the steps to download data extracts using the Basware Data Access API through Postman.

 

Step 1: Retrieve Extract List

1. Open Postman.
2. Select the GET method.
3. Use the following endpoint URL to pull available extracts:

https://api.us.basware.com/v1/dataExtracts

 

Step 2: Review the Extract Response

Once executed, you will receive a response in JSON format similar to the example below:

{

    "id": "71aaadaf829048cfbdef88cba186dc63",

    "type": "Delta",

    "startDate": "03/11/2025, 13:45:52",

    "endDate": "04/11/2025, 13:41:22",

    "fileCount": 20,

    "processingStatus": "WaitingForExport",

    "extractDate": "04/11/2025, 13:53:49",

    "extractName": "Standard_data_extract"

}

Step 3: Retrieve File Details for the Extract

Take the id value from the response and append it to the base URL to get detailed file information:

 

Step 4: Review the File Information

The output will list all extract files with their respective metadata — including extract ID, table name, file name, start/end dates, and download URL.

Example Response:

{

    "extractId": "71aaadaf829048cfbdef88cba186dc63",

    "tableName": "ADM_ORGANIZATION_ELEMENT",

    "fileName": "ADM_ORGANIZATION_ELEMENT_0001.csv.gz",

    "startDate": "03/11/2025, 13:45:52",

    "endDate": "04/11/2025, 13:41:22",

    "downloadUrl": "https://api.us.basware.com/v1/dataExtracts/71aaadaf829048cfbdef88cba186dc63/getFile?file=ADM_ORGANIZATION_ELEMENT_0001.csv.gz"

  },

 

 

Step 5: Download the Extract File

1. Copy the downloadUrl value.
2. In Postman, use the GET method with the copied download URL.
3. Click “Send and Download” (not just Send) to download the file.

 

 

Step 6: Decompress and Access the File

• The downloaded file will be in a compressed (.gz) format.
• Decompress the file using any standard decompression tool (e.g., 7-Zip, WinRAR).
• Once extracted, the file will be ready for use.

 

Additional Notes:

• Ensure you are using valid API authentication headers before making any request.
• Depending on your configuration, data extract availability may vary.
• If no data is returned, verify your user permissions and extract configuration in Basware.