Home > Articles > Accessing your Vtiger CRM data via OData feed

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

Bindu Rekha Babu

21 Sep, 2020 - Updated 1 year ago

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 module
instance_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