Articles in this section
Access CRM data offline via Vtiger 360
Access CRM data offline via Vtiger 360
Kanban View of Deals
Kanban View of Deals
Calendar View
Calendar View
Capturing Emotional Journeys
Capturing Emotional Journeys
Closed States
Closed States
Customer Touchpoints
Customer Touchpoints
Customizer
Customizer
Desktop Notification overview
Desktop Notification overview
Exporting Data from Vtiger CRM
Exporting Data from Vtiger CRM
Feature Limits
Feature Limits
Glossary
Glossary
How do I scan a Business Card in Vtiger 360 mobile App
How do I scan a Business Card in Vtiger 360 mobile App
IP Based Restriction
IP Based Restriction
Introduction to Kanban View
Introduction to Kanban View
Make the leap from Spreadsheets
Make the leap from Spreadsheets
Merging Duplicates in Summary View
Merging Duplicates in Summary View
Migration Timeframe and Process
Migration Timeframe and Process
One View: Introduction
One View: Introduction
Overview of Permission Usecases
Overview of Permission Usecases
Performing Global Search
Performing Global Search
Rest API Manual
Rest API Manual
Top Salespersons
Top Salespersons
Understand the Billing Process in Vtiger
Understand the Billing Process in Vtiger
Using Comments and @mentions
Using Comments and @mentions
Vtiger 360 for Field Sales
Vtiger 360 for Field Sales
Vtiger 360 Mobile App
Vtiger 360 Mobile App
What are Contact Roles
What are Contact Roles
What are Record-Level Analytics
What are Record-Level Analytics
What are Sticky Notes
What are Sticky Notes
What is the List View
What is the List View
Whitelisting Vtiger on Google to use Gmail Sync
Whitelisting Vtiger on Google to use Gmail Sync
What is Quick Create
What is Quick Create
Built-in Phone Dialer in the CRM with Plivo and Twilio
Built-in Phone Dialer in the CRM with Plivo and Twilio
Using Grid Edit in Vtiger CRM
Using Grid Edit in Vtiger CRM
Auto Forward Emails from Individual & Group Mail Boxes
Auto Forward Emails from Individual & Group Mail Boxes
Vtiger SAML application in Azure AD
Vtiger SAML application in Azure AD
Understanding Email Bounces and Error Codes
Understanding Email Bounces and Error Codes
Accessing your Vtiger CRM data via OData feed
B
Bindu Rekha Babu
21 Sep, 2020 - Updated
1 year ago
Table of Contents
Introduction
OData (Open Data Protocol) allows applications such as Microsoft Power BI, MS Sharepoint, and other Apps to readily consume queryable information in a simple and standard way.
OData is a REST-based protocol for querying and updating data and is built on standardized technologies such as HTTP, Atom/XML, and JSON. It is different from other REST-based web services in that it provides a uniform way to describe both the data and the data model.
OData and Vtiger CRM
Vtiger provides an entry point to access data in OData format. User can hit the OData URL and provide credentials to fetch information from any module
For example, To fetch data from Contacts moduleinstance_url/restapi/V1/OData/Pull/odata.svc/Contacts
Parameters
It even allows fetching filtered data
- Fetch selected fields
instance_url/restapi/V1/OData/Pull/odata.svc/Contacts?$select=firstname,lastname
- Fetch with conditions
instance_url/restapi/V1/OData/Pull/odata.svc/Contacts?$filter=firstname eq 'Mark'
- Fetch with limit
instance_url/restapi/V1/OData/Pull/odata.svc/Contacts?$top=10
- Skip few records from the result (we can use this for paging)
instance_url/restapi/V1/OData/Pull/odata.svc/Contacts?$skip=10&$top=10
- Count the total number of records
instance_url/restapi/V1/OData/Pull/odata.svc/Contacts/$count
Limitations:
- To ensure optimal performance, results are limited to 5000 records per request. To get the next set of records, you can use the Skip command.
Was this article helpful?
0
out of
1
found this helpful.
Comments 0
Be the first to comment