Home  >   FAQs   >  How can I fetch filtered data via OData feed?

How can I fetch filtered data via OData feed?

Table of Contents
You can filter records fetched via OData through Power Bi conditionally.

1.Fetch selected fields 
https://instance_url/restapi/V1/OData/Pull/odata.svc/Contacts?$select=firstname,lastname

2.Fetch with conditions 
https://instance_url/restapi/V1/OData/Pull/odata.svc/Contacts?$filter=firstname eq 'Mark'

3.Fetch with limit 
https://instance_url/restapi/V1/OData/Pull/odata.svc/Contacts?$top=10

4.Skip few records from the result (we can use this for paging) 
https://instance_url/restapi/V1/OData/Pull/odata.svc/Contacts?$skip=10&$top=10

5.Count the total number of records 
https://instance_url/restapi/V1/OData/Pull/odata.svc/Contacts/$count

Refer : OData Feed

 
Was this FAQ helpful?
0  out of  0  found this helpful.
Comments 0
Be the first to comment
© Copyright 2022 Vtiger. All rights reserved.