Skip to main content

OData Service With Read Only Support


You want to create an OData Service with read support (GET) only.


Drag and drop an Http in node to receive with GET method and connect it to an Odata-in node. Use a Function node before the Odata-in node OR an EDM node inside the Odata-in node to define your database schema. Connect the Odata-in node to a Sequelize node and configure your database settings. Draw a wire from the Sequelize node to an Odata-out node to formulate an OData compliant response. Use an Http response node to send the http response back to the client.



[{"id":"142e39e1.410ee6","type":"sequelize","z":"29efa5eb.87dd3a","name":"Configure database","usepayload":false,"query":"","database":"","output":true,"outputs":1,"x":310,"y":280,"wires":[["9af76df7.0ace"]]},{"id":"1de72c64.80d9c4","type":"http in","z":"29efa5eb.87dd3a","name":"","url":"/root/*","method":"get","upload":false,"swaggerDoc":"","x":120,"y":180,"wires":[["d3f120a.dec7be"]]},{"id":"d3f120a.dec7be","type":"function","z":"29efa5eb.87dd3a","name":"users EDM","func":"msg.model = {\n    namespace: \"ignite\",\n    entityTypes: {\n        \"users\": {\n            \"id\": {\"type\": \"Edm.Int32\", \"key\": true},\n            \"name\": {\"type\": \"Edm.String\"},            \n            \"username\": {\"type\": \"Edm.String\"}            \n        }\n    },   \n    entitySets: {\n        \"users\": {\n            entityType: \"ignite.users\"\n        }\n    }\n}\nreturn msg;","outputs":1,"noerr":0,"x":310,"y":180,"wires":[["1ae9a04f.eb2fe"]]},{"id":"1cc5b619.1e3a7a","type":"http response","z":"29efa5eb.87dd3a","name":"","statusCode":"","headers":{},"x":750,"y":280,"wires":[]},{"id":"9af76df7.0ace","type":"odata out","z":"29efa5eb.87dd3a","name":"","x":540,"y":280,"wires":[["1cc5b619.1e3a7a"]]},{"id":"1ae9a04f.eb2fe","type":"odata in","z":"29efa5eb.87dd3a","name":"","x":500,"y":180,"wires":[["142e39e1.410ee6"]]}]


The above OData service can be used to create OData compliant REST APIs with read support only.

In the example flow, we have defined a sample EDM "users" using both, a Function node and the EDM node.

Using this flow, you can send data from your Database to another OData Consumer.