Community Hub

Vtiger CRM Community

A community for everyone exploring the Vtiger ecosystem. Learn, share knowledge, exchange experiences, ask questions, and help each other better understand Vtiger.

Join to post → Browse discussions ↓

🔌 API

30 discussions with real solutions from the Vtiger CRM community

🔍
All (280) 💬 General (235) 🔌 API (30) 📱 Mobile (15) 📱 Mobile App (0)
🔌
✓ VQL (Vtiger CRM Query Language) — complete reference with examples for Vtiger 7 and 8
I am building an integration with the Vtiger CRM API and need to query records using VQL. The official documentation at wiki.vtige
API 👤 koicodedev
✓ Answered
🔌
✓ How to create a custom workflow function (Invoke Custom Function) in Vtiger
I want to add a custom action to Vtiger workflows — specifically, I want a workflow to call my PHP function when a Lead is saved.
API 👤 balduin_dev
✓ Answered
🔌
✓ Vtiger CRM REST Webservices API — complete beginner guide with working PHP code
I am trying to integrate an external application with Vtiger 7 using the REST Webservices API. My attempts return 'INVALID_SESSION
API 👤 alexchen
✓ Answered
🔌
✓ MANDATORY_FIELDS_MISS creating Invoice via Vtiger CRM webservices — LineItems capitalisation bug
I am trying to create an Invoice via the Vtiger CRM Webservices API. I keep getting `MANDATORY_FIELDS_MISS` even though I am sendi
API 👤 koicodedev
✓ Answered
🔌
✓ vtws_revise returns DATABASE_QUERY_ERROR from inside a Vtiger CRM workflow function
I have a custom workflow function that calls `vtws_revise` to update a related record. When I run the same code from a PHP CLI scr
API 👤 alexchen
✓ Answered
🔌
✓ How to create a Lead via Vtiger CRM REST API POST request — working curl and PHP examples
I need to insert new leads into Vtiger CRM from an external website (a contact form). I found the webservice.php endpoint but I ca
API 👤 alexchen
✓ Answered
🔌
✓ Vtiger CRM webforms not creating records — silent failure after spam filter change
We have webforms on our website that send leads directly into Vtiger CRM 7.5. They worked for a year without issues. Three weeks a
API 👤 alexchen
✓ Answered
🔌
✓ Vtiger CRM API getRelatedRecords returns empty array even when related records exist
I am calling `getRelatedRecords` on the Vtiger CRM REST API to fetch the Contacts related to an Account. The account has 3 contact
API 👤 koicodedev
✓ Answered
🔌
DATABASE_QUERY_ERROR - Create leads operation
I am trying to create new lead via webservice but receiving error json response. "error": { "code": "DATABASE_QUERY_ER
API 👤 khangthai
✓ Answered
🔌
DATABASE_QUERY_ERROR
Hi, I am trying to import sales order referring http://blog.crm-now.de/2018/02/26/new-api-description-and-new-example-code-for-cr
API 👤 nafisa
✓ Answered

Vtiger CRM Knowledge Base

13 detailed articles across 6 categories — with real SQL, PHP, and config fixes

🔄
Workflows
Cron scheduler locked at RUNNING — every timed workflow stops silently
After a PHP timeout or server restart, the scheduler lock flag is never cleared. All timed workflows stop without a single error in the log.
Read solution
🔄
Workflows
Workflow "Send Email" silently skipped when recipient is a field variable
Setting the To address to a field variable like {contacts.email} causes the entire action to skip — no error, no log entry, no email delivered.
Read solution
🔄
Workflows
"Expression Invalid" with preg_replace_str_only in workflow conditions
Using preg_replace_str_only() inside a workflow condition formula throws "Expression Invalid" even when the regex is correct, halting the entire workflow.
Read solution
🔄
Workflows
Workflow Actions tab renders completely blank after upgrading to Vtiger 8.1
After upgrading to 8.1 or 8.2, existing workflows show an empty Actions tab — tasks are still in the database but nothing renders because a column is too short.
Read solution
📧
Email
Email merge fields arrive as raw placeholders in Outlook and Gmail
Emails sent from Vtiger arrive with {contacts.firstname} instead of the actual name. The preview inside Vtiger looks correct — only sent emails are broken.
Read solution
📧
Email
Mail Manager inbox blank or spinning forever after connecting Office 365
After saving Office 365 IMAP credentials, the inbox shows zero messages or loads indefinitely — even though the same credentials work fine in Outlook and Thunderbird.
Read solution
🗄️
Database
DATABASE_QUERY_ERROR when creating records — editing existing ones works fine
Creating Leads, Events, or custom-module records returns {"code":"DATABASE_QUERY_ERROR"}. The error is generic, but almost always one of three root causes.
Read solution
🗄️
Database
MySQL 5.7 / 8.0 strict mode breaks Vtiger inserts — the correct sql_mode to set
After a MySQL upgrade, various Vtiger write operations fail silently. The culprit is the strict sql_mode enabled by default since MySQL 5.7.
Read solution
🔌
API
INVALID_AUTH_TOKEN on Vtiger login — the exact cause and how to fix it
The /webservice.php?operation=login call returns INVALID_AUTH_TOKEN even with correct credentials. Almost always a subtle MD5 construction mistake.
Read solution
🔌
API
Vtiger API session expires silently after 15–30 minutes of inactivity
Your integration works perfectly at first, then starts returning auth errors with no warning after a period of inactivity. Sessions are not automatically renewed.
Read solution
📦
Inventory
Product stock quantity not decremented when a Sales Order is created
Creating a Sales Order with line items does not reduce the available stock. This is by design in the community edition — but here are the workarounds.
Read solution
⚙️
Setup
HTTP 500 after switching to French or another non-English language pack
Selecting a non-English language from Settings → CRM Settings crashes everything with a 500 error. The only recovery is reverting the language directly in MySQL.
Read solution
⚙️
Setup
Installed modules missing from the main navigation menu after install
After installing an extension, one or more modules are absent from the top navigation even though they are visible and active in Module Manager.
Read solution

Community Posts

10 posts from our members

Join to post →
Sep 25, 2026
Vtiger offline sync deep dive — conflict resolution explained
Explaining the delta sync algorithm we use when a contact is modified both on device and on server simultaneously. The key challenge is detecting true conflicts
Sep 25, 2026
Connecting Odoo 17 JSON-RPC from a React Native app
Step-by-step guide to authenticating with Odoo 17 using JSON-RPC, querying the CRM pipeline, and writing records back from a mobile app...
Sep 25, 2026
Custom module fields in Vtiger Webservices — the complete guide
Accessing custom fields via the Webservices API requires you to first query the metadata endpoint. Here is how to discover and interact with custom Vtiger modul
Sep 25, 2026
VQL query optimization tips — speed up your Vtiger API calls
After working with the Vtiger API for 3 years, here are the VQL patterns that actually make a difference to performance in production...
Sep 25, 2026
Building push notifications for Vtiger deal stage changes
We built a custom webhook listener on our server that fires FCM/APNs notifications when a deal moves to Closing stage...
Sep 25, 2026
SuiteCRM V8 API OAuth2 flow — working code samples
The V8 API is a big improvement over SOAP but the OAuth2 setup still trips people up. Here is a full working example...
Sep 25, 2026
Built a WhatsApp → Vtiger lead capture integration
Sharing our setup: incoming WhatsApp messages via 360dialog API automatically create Leads in Vtiger via Webservices. Here is the full architecture...
Sep 25, 2026
Multi-company Odoo setup with opencrmapps
If you have multiple Odoo databases (one per subsidiary), here is how to configure the app to switch contexts seamlessly...
Oct 4, 2026
need help
need help
Sep 25, 2026
maange contact
how manage contacts in crm