FAQs in this section
What are Settings?
How do I create an Internal Ticket?
Can I host cloud version on my servers?
What is Vtiger CRM?
Can IP restriction be added on my Vtiger?
What is the password that is needed to authenticate my Vtiger account in Power BI?
How to get training on using Vtiger?
Does Leads module have Profile Score?
Can admin disable the profile scoring feature?
How do I setup Profile Scoring?
Need help in configuring Vtiger Open Source version?
Can I integrate Vtiger with Power Bi?
What is OData? Does Vtiger allow data to be fetched in Power Bi via OData?
What is the limit on the number of records being fetched via OData feed?
Where do I find my Access Key in Vtiger?
How do I sort the order of the values shown in a picklist field?
How can I rename a picklist value?
What is the SPF string that needs to added to restrict emails sent from Vtiger landing in customer's Spam folder?
What is the difference between Cloud and Open Source version of Vtiger?
Where can I look for the recorded Webinars of Vtiger?
Where can I check the list of the recent updates done my Vtiger account?
Can I approve/reject a record if I login as another user?
How do I group 2 companies/Organisations?
Does Vtiger integrate with a chat system?
Can I react to comments posted by others?
What is Permalink in a comment?
Can I delete a comment in the CRM?

How can I fetch filtered data via OData feed?

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

 
Home Privacy Policy Terms of Service Security Center Policy & Legal Center
© Copyright 2021 Vtiger. All rights reserved.
Powered by Vtiger
Facebook Twitter Linkedin Youtube