Purpose:
This article explains the steps to download data extracts using the Basware Data Access API through Postman.
Step 1: Retrieve Extract List
- Open Postman.
- Select the GET method.
- 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
- Copy the downloadUrl value.
- In Postman, use the GET method with the copied download URL.
- 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.