Lyftrondata Sql based web API provide REST end points that can be used to consume JSON based data by third party applications . These end points can be called over HTTP protocol to get different types of data from Lyftrondata app.
Implementation Requirements
- As Lyftrondata use Sql Server as a simulation layer so any new unique request been sent from Rest Request will create one session in the Sql Server database pool.
- Always try to reuse connection strings as much as possible, as well as close each rest request by calling the closure api right after the response is received. By applying this practice, you will help connection pooler to handle your database connection needs faster and more efficiently, by reusing connections from the pool.
Benefits
- Automatically convert any Lyftrondata objects like table, views, pipeline into an API
- Automatically convert the tables and views of third-party platforms like Snowflake, Google Bigquery, Redshift, Sql Server, Postgres, Oracle, Sap Hana etc to API endpoints
- Automatically convert the pipeline logic to load the data from sources to targets platforms into API endpoints
GetOAuthToken
This API is used to authenticate a user on the Lyftrondata app to get the access token that is further used in subsequent requests to access the resources of the system like connections, databases, tables, pipelines etc.
Click here for more details
GetTableData
This API is used to get table data from a database registered inside the Lyftrondata app. The API will return data in batches in JSON form.
Click here for more details
GetPipelineData
This API is used to get pipeline data from a warehouse registered inside the Lyftrondata app. The API will return data in batches in JSON form.
Click here for more details
Close User Session
This curl command will be used after each request and successful response to close the user session
Click here for more details