Smartstaff
1,385
edits
Changes
→Troubleshooting
For public access there is no requirement to create a user.
==Accessing a Report with OData ServiceReport with OData==SmartSimple OData services support requests for data via HTTP GET request.
Private and Public Endpoints exposes all collections (Reports enabled by OData Connector).
http://mysmartsimpleurl/OData/V3/pub/424623/Service.svc/my_Neo_Report_records
http://mysmartsimpleurl/OData/V4/pub/424623/Service.svc/my_Neo_Report_records</pre>
==OData Primitive Data Types==
Column headers from a report with the following data types will not be successfully transformed in the OData Service Report:
* Store Values
<pre> http://mysmartsimpleurl/OData/V4/pub/424623/Service.svc/report_Neo_records/$count</pre>
==Consuming SmartSimple OData Feed==
The following examples show how to consume OData.
* [[SmartSimple_OData_Feed_to_Excel|Pulling OData feed to Excel]]
* [[SmartSimple_OData_Feed_to_SQL_Server_Database|Import OData feed to SQL Server Database using SQL Server Integration Services]]
==Troubleshooting==
* Report name '''must not''' contain special characters such as question marks, underscore, number sign. Some characters, such as hyphens, are supported.
* Column Headings '''must not''' contain special characters such as question marks, number sign or brackets. Some characters, such as hyphens, are supported.
* Some applications, such as older versions of MS Excel / .NET , may not support the appropriate level of TLS Encryption (i.e. https) required.
=See Also=
* [[Reports: SmartSimple Reports]]
* [[OData Connector]]
* [http://www.odata.org More information on OData]
[[Category:Integration]][[Category:API]]
