Smartstaff
1,385
edits
Changes
→Troubleshooting
==How to setup an authenticated user to consume a private OData Service==
For [[JSON API (SmartConnect) Prerequisite|'''authenticated access''']], you will need to create a new user with the Web Service Client Access attribute.
# Create the new user and set access to Web Service Client Access.
# Set a password for this user.
For public access there is no requirement to create a user.<br/>
Private and Public Endpoints exposes all collections (Reports enabled by OData Connector).
http://mysmartsimpleurl/OData/V4/pub/424623/Service.svc/my_Neo_Report_records</pre>
==Syntax of OData Queries==
<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]]* [httpshttp://wikiwww.smartsimpleodata.com/wiki/OData_Connector org More information on OData Connector] [[Category:Integration]][[Category:API]]
