Changes

Jump to: navigation, search

Odata Overview

410 bytes added, 19:53, 17 October 2022
→‎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/V4/pub/424623/Service.svc/my_Neo_Report_records</pre>
Output ==OData Primitive Data Types==Primitive type representations in XML request is based on the [[Custom Field Type IDs|Data Type]] of the [[Standard Field|Standard Fields]] / [[Custom Fields – General Information|Custom Fields]]<br />Column headers from a report with the following data types will display maximum of 1024 rows only..not be successfully transformed in the OData Service Report:
==OData Primitive Data Types==Primitive type representations in the XML request is based on the [[Custom Field Type IDs|Data Type]] of the [[Standard Field|Standard Fields]] / [[Custom Fields – General Information|Custom Fields]]<br />Column headers from the report with the following data types will not be successfuly transformed in the Odata Service Report:<br/><ol><li>* Display Only</li><li>* Link</li><li>* Read Only</li><li>* Store Values</li>
==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]]
Lalaine Songalia
Smartstaff
1,385
edits
Retrieved from ‘https://wiki.smartsimple.com/wiki/Special:MobileDiff/31923...40185’

Navigation menu