Changes

OData is described in the following article: [https://en.wikipedia.org/wiki/Open_Data_Protocol Wikipedia]article. OData provides clients with the ability to publish their data to their communities. It's as if each clients has their own API for their own communities. For example, a client can expose their annual grant/funding information so tax payers can retrieve in real time data for further analysis.

SmartSimple provides OData V2, V3 and V4 services.  These can be consumed by OData clients such as MS Excel, MS SQL server, SaleForce, or used though another API such as .NET.

# Easier to control security and data format like such as fields and fieldname, any end user can perform this task # Most clients wish to consume ready read only data anyway # Data relationships are handled in SSSmartSimple, the external client does not need to understand underlying data relationships #Easy to implement as there is no need to configure OData service and metadata enpointsendpoints (these are as required by the OData protocol), it is these are automatically handled by SS report engine automaticaly the SmartSimple Report Engine # More Greater flexible as SS the SmartSimple user are is able to create dummy tables (like similar to SQL views) by combining tables , applying formulas and aggregations # Filtering ans and ordering are pre-defined in SS reportSmartSimple Report, eliminate SQL injection vulnerability  ==OData Services Endpoints==  Depending on the version of the OData required the endpoint will vary.  Version 4: https://mysmartsimpleurl/OData/V4/424623/Service.svc/ Version 3: https://mysmartsimpleurl/OData/V3/424623/Service.svc/

https://mysmartsimpleurl/OData/V4/Services.svc/ ==How to setup in SS ? OData from within SmartSimple==