Service OData v4 requests from an SQL data store.
The OData V4 SQL Connector provides functionality to convert the various types of OData segments into SQL query statements, that you can execute over an SQL database.
- Create high speed, standard compliant data sharing APIs
import { createFilter } from '@steedos/odata-v4-sql'
//example request: GET /api/Users?$filter=Id eq 42
app.get("/api/Users", (req: Request, res: Response) => {
const filter = createFilter(req.query.$filter);
// request instance from mssql module
request.query(`SELECT * FROM Users WHERE ${filter.where}`, function(err, data){
res.json({
'@odata.context': req.protocol + '://' + req.get('host') + '/api/$metadata#Users',
value: data
});
});
});
Advanced TypeScript example available here.
var createFilter = require('@steedos/odata-v4-sql').createFilter;
app.get("/api/Users", function(req, res) {
var filter = createFilter(req.query.$filter);
// request instance from mssql module
request.query(filter.from("Users"), function(err, data){
res.json({
'@odata.context': req.protocol + '://' + req.get('host') + '/api/$metadata#Users',
value: data
});
});
})
- $filter
- $select
- $skip
- $top
- $orderby
- $expand