Changes

Odata Overview

17 bytes added, 17:56, 7 May 2018
no edit summary
Version 3: https: //mysmartsimpleurl/OData/'''V3'''/'''pri'''/424623/Service.svc/<br />
Version 2: https: //mysmartsimpleurl/OData/'''V2'''/'''pri'''/424623/Service.svc/
 
 
===Public Access Endpoint===
Version 2: https: //mysmartsimpleurl/OData/'''V2'''/'''Pub'''/424623/Service.svc/
==How to setup an authenticated user to consume private OData Service Service==
For '''authenticated access''', you will need to create a new user with the Web Service Client Access attribute.
1. Search syntax i.e. criteria on report using “???”: the URL below returns OData records with firstname equal ‘steve’ only
<pre>http://localhostmysmartsimpleurl/OData/V4/pub/113/Service.svc/report_Neo_records?$search=steve</pre>
2. Filter for dynamical search: the URL below returns OData records with firstname equal ‘steve’ only (eq stands for equal in OData protocol)
<pre>http://localhostmysmartsimpleurl/OData/V4/pub/113/Service.svc/report_Neo_records?$filter=first_name +eq+steve </pre>
3. Ordering: the URL below orders by first name
<pre>http://localhost/OData/V4/pub/113/Service.svc/report_Neo_records?$orderby=first_name+asc
or
http://localhostmysmartsimpleurl/OData/V4/pub/113/Service.svc/report_Neo_records?$orderby=first_name
</pre>
Smartstaff
1,385
edits