AgileCRM Tables
The provider models the data in API as a list of tables in a relational database that can be queried using standard SQL statements.
AgileCRM Tables
| Name | Description |
| Campaigns | Returns a list of campaigns |
| ContactDeals | Fetches list of deals related to specified contact using the contact id. |
| ContactNotes | Returns list of notes related to the contact. |
| Contacts | Returns list of contacts in domain which are ordered by creation time. |
| ContactTasks | Retrieves the tasks related to contact, sorted by the date (latest first.) |
| DealBased | Fetches list of deals from the particular track. Number of milestones depends upon the milestones added by user to that track. The track id has to be sent as a query parameter. |
| DealNotes | Returns list of notes related to the contact. |
| Deals | Returns a list of all Deals/Opportunities. |
| Documents | Returns list of documents related to the contact. |
| Events | Fetches the list of events happened in particular time. |
| MyDeals | Get deals of current user |
| Tasks | Get list of tasks. |
| TicketFilters | Returns list of ticket filters. |
| TicketNotes | Returns the list of notes/messages for a specific ticket. |
| Tickets | Returns list of tickets. |
| Tracks | Gets all the tracks. Each track will be having a set of milestones. |