Silverline API empowers seamless integration with a diverse range of data sources, making API creation more flexible and efficient. Below are the supported data sources:
- APIs – Connect to external services effortlessly
- Azure SQL – Leverage Microsoft’s powerful cloud database
- CSV File Upload – Import structured data with ease
- CSV File via FTP – Automate CSV ingestion through FTP
- Excel File Upload – Integrate spreadsheets seamlessly
- Excel File via FTP – Process Excel files via FTP connection
- Microsoft SQL Server – Utilize enterprise-grade SQL databases
- MySQL – Connect to one of the world’s most popular databases
- PostgreSQL – A powerful, open-source database option
- Supabase – Scalable, PostgreSQL-based backend solutions
We are continuously expanding our integrations and supported data sources. If there’s a data source you don’t see here and would like to connect, please reach out to us—we’ll work on accommodating your request as soon as possible.
Please see below for additional details and features when connecting to certain data sources.
Connect CSV File Via FTP
1️. Select Data Source Type – Choose “CSV File via FTP” from the drop-down menu.
2️. Provide FTP Server Details – Enter host, port (default 21), username, and password.
3️. Specify File Path – Provide the exact file path or directory on the FTP server.
4️. Test Connection – Click “Test Connection” to verify access to the FTP server.
5️. Select CSV File & Define Structure – Choose the required CSV file.
6️. Provide File Description – This step is optional. However, adding details about column header names will enhance AI-driven query generation.
7️. Save & Use Data – Click “Save” to store the connection and start using the CSV data.
(Refresh Schedules – With refresh schedules, you can define how often the system automatically connects to the FTP file to retrieve the latest version.)
Note: Checking the box in the file name field and clicking the pop-out button allows you to programmatically generate a file name. This is especially useful when file names change frequently, such as when a new file is generated daily with a date appended to it.
Uploading CSV or Excel File
1️. Select Data Source Type – Choose “CSV File Upload” or “Excel File Upload” from the drop-down menu.
2️. Upload File – Click “Upload” and select the CSV or Excel file from your system.
3️. Provide File Description – Add relevant details for better AI-generated queries.
4️. Save & Use Data – Click “Save” to store the uploaded file and start querying the data.
Connecting to API as a Data Source
1️. Select Data Source Type – Choose “API” from the drop-down menu.
2. Provide API Endpoint – Enter the API URL to fetch data.
3. Set Authentication – Configure Bearer Token, API Key, or Basic Auth if required.
4. Define Request Method – Select GET, POST, PUT, or DELETE based on API functionality.
5️. Test Connection – Click “Test Connection” to verify the API response.
6️. Save & Use Data – Click “Save” to store the connection and start using API data.
