Data Upload API
Send data files to Visier.
Who can use this feature?
To use the APIs, you must have a Visier account with a profile that has the API capability. If you don't have an account, contact your administrator. They will create an account for you with permissions that allow you to view data.
In addition to an API profile, your API user must have a profile with the Data Upload capability.
Not sure if you have this feature or capability? Reach out to your administrator.
Overview
With the Data Upload API, send one data file per API call to Visier. To send multiple files in one API call, compress the files into a ZIP file.
To send data files using the API, the data files must be in a location that your API application can access. If using Postman, the data files you want to upload must be in Postman's files folder on your local device. For more information, see "Working directory" in Setting up Postman.
You can upload files in ZIP, CSV, XLS, and XLSX format, in plain text or PGP-encrypted, with a maximum file size of 500 MB. For more information about encrypting files, see Encrypt files.
Note:
- Use of this API requires client redirect. This API redirects requests directly to Visier's upload infrastructure to support long-running uploads. To ensure efficient uploading, we recommend that you use an HTTP client that supports the 100 Continue status code.
- If you want to send larger data files, we recommend SFTP. For more information, see File Upload Using SFTP.
- If you upload an XLS or XLSX file containing multiple sheets, each sheet creates a unique data transfer in Visier.
- Filenames can contain letters (A-Z, a-z), numbers (0-9), hyphens (-), periods (.), and underscores (_).
After you send the file to Visier, it goes through regular data processing during your next scheduled job. Alternatively, you can run a job manually after Visier receives the file. For more information, see File Upload Using the Solution.