ODBC CSV / REST API Driver

⚡ Key Benefits

• SQL-Based CSV & API Access — Query local files and REST APIs using SELECT, WHERE, GROUP BY syntax
• Broad Authentication — OAuth 2.0, JWT, Basic Auth, NTLM, and Dynamic Token for secured endpoints
• Multi-File & Wildcard Support — Read single or multiple CSV/TSV files using wildcard patterns
• Built-In API Pagination — Page, offset, cursor, and token-based handlers for multi-page responses
• Centralized Access — Share driver via Data Gateway without local installs on client machines

📸 Visual Overview & Setup

1. Configure CSV / REST API Connection 🔍 View Full Size	2. Test Connection 🔍 View Full Size	3. Preview Data Results 🔍 View Full Size
4. Write SQL Query 🔍 View Full Size	5. Use in Power BI, Excel & More 🔍 View Full Size	6. Share via Data Gateway Data Gateway overview

🔗 Seamless SQL Query Integration

-- OAuth 2.0 Authentication (3-Legged) - Query REST API as CSV
SELECT *
FROM $
WITH (
    SRC = 'http://yourhost/api/some-service',
    DataConnectionType = 'OAuth',
    UseCustomApp = 'True',
    OAuthVersion = 'OAuth2',
    AuthUrl = 'https://yourhost/api/authorize',
    TokenUrl = 'https://yourhost/api/token',
    ClientId = 'xxxxxxxxxxx',
    ClientSecret = 'xxxxxxxxxxxxx',
    AccessToken = 'xxxxxxxxxxx',
    RefreshToken = 'xxxxxxxxxxx'
)

🔧 Key Features

Read & Query CSV / REST

• SELECT with WHERE, ORDER BY, GROUP BY, LIMIT on CSV files and web API responses
• Custom math, string, and datetime functions in SQL queries
• Wildcard patterns for multiple files (e.g., Year??_data*.csv)
• Embedded CSV data directly in queries using the DATA parameter

API Calls & POST

• HTTP POST with custom headers, body, and URL parameters
• MultiPart file upload support for sending files to API endpoints
• Dynamic Token authentication for two-step login flows
• Cookie forwarding and proxy server support

API Pagination

• URL parameter-based and URL path-based pagination
• Cursor-based and token-based pagination for modern APIs
• Status check loop — wait for a value before continuing
• Auto-detect end of pages by response status code or record count

URL JOIN (Parent-Child Data)

• Pass parent columns to child URL queries using [$alias.column$] placeholders
• Up to 7 levels of hierarchical joins across multiple API endpoints
• Download binary files to local disk via JOIN

Security & Platform

• OAuth 2.0, JWT, Basic Auth, NTLM, X509 certificate authentication
• HTTPS / SSL / TLS 1.2 for encrypted communication
• Standard ODBC for Power BI, Tableau, Qlik, Excel, SSRS, SQL Server, SSIS, and custom apps
• Server-side access via Data Gateway — no local driver install required

💡 Common Use Cases

Typical scenarios for the ODBC CSV / REST API Driver in reporting, ETL, and app development:

• Import REST API data into Power BI or Excel: Query a web API returning CSV and load into BI reports.
  Example: SELECT * FROM $ WITH (SRC='https://zappysys.com/downloads/files/test/invoices.csv')
• ETL from CSV files to SQL Server: Read local or remote CSV files using wildcard patterns and load into database tables.
  Example: SELECT * FROM $ WITH (SRC='C:\Data\cust*-?.csv')
• Paginate through multi-page APIs: Configure URL parameter or cursor-based pagination to retrieve all pages automatically.
  Example: SELECT * FROM $ WITH (SRC='https://api.example.com/records?page=1', PagingMode='ByUrlParameter', PagingByUrlAttributeName='page')
• POST data or upload files to REST endpoints: Send CSV payloads or upload files using MultiPart POST.
  Example: SELECT * FROM $ WITH (METHOD='POST', SRC='http://httpbin.org/post', BODY='@c:\files\dump.csv', IsMultiPart='True')
• Join parent-child API responses: Use URL JOIN to pass parent row values into child API URLs across multiple levels.
  Example: fetch customers, then orders per customer using [$c.custid$] in the child URL.
• Server-side access without local ODBC: Route queries through Data Gateway from SQL Server Linked Server or JDBC clients.
  Example: Java or Linux services query CSV/REST data via the gateway JDBC connection.

🎯 Summary

Access CSV files and REST APIs from the ODBC ecosystem your team already uses.
Query with SQL, authenticate with OAuth or JWT, paginate multi-page responses, join parent-child API data, and connect from Power BI, SQL Server, Excel, or code — without maintaining one-off REST integrations.

Trusted by Developers & IT Teams Worldwide Built for ODBC Workloads: One driver model across BI, ETL, databases, and custom code. Expert Technical Support: Engineers help with connection strings, SQL queries, and pagination tuning. Proven Enterprise Scale: Thousands of teams worldwide rely on ZappySys for API and cloud connectivity.

ODBC PowerPack Includes ODBC CSV / REST API Driver Read reviews on Capterra →