API Endpoints are URLs where a web service or API receives requests. DataSelf employs endpoints for the SQL Extractor API and Tableau Extractor API.
Features of API Endpoints
-
Bypass the computer code often required to use APIs. API endpoints embed the API call in a URL that can be called from a web browser or Excel workbook. Just call the endpoint, and you get your data instantly.
-
Works Over the internet.
-
Security. API endpoints can be protected by security measures like authentication and encryption.
-
Microsoft Excel. Excel fully supports API endpoints.
Open Excel, Data tab > Get Data > From Other Sources > From Web.
API (Application Programming Interface)
An API (Application Programming Interface) is a set of rules and protocols that allows different software applications to communicate with each other. APIs act as a bridge between systems, enabling them to exchange data and functionality without needing to understand internal workings.
Endpoints (Background)
Endpoints are used in a wide variety of situations and contexts.
Endpoints are specific points of interaction between systems, computers and devices.
They are points of communication or connection in a network where data is transmitted or received. Endpoints facilitate data exchange.
Examples of Endpoints
-
Bluetooth connection point
-
Wi-Fi interface
-
Network ports such as web server port (TCP/80)
-
API endpoints (see section above)
-
SSH connection port (TCP/22)
-
Database connection interface
NOTES
-
Endpoints and devices represent two distinct concepts in computing, though they're often related.