ZendeskSell Tables
The provider models the data in API into a list of tables that can be queried using standard SQL statements.
Generally, querying API tables is the same as querying a table in a relational database. Sometimes there are special cases, for example, including a certain column in the WHERE clause might be required to get data for certain columns in the table. This is typically needed for situations where a separate request must be made for each row to get certain columns. These types of situations are clearly documented at the top of the table page linked below.
ZendeskSell Tables
| Name | Description |
| Account | Returns detailed information about your account. |
| AssociatedContacts | Returns all deal associated contacts. |
| CallOutcomes | Returns all call outcomes available to the user, according to the parameters provided. Call outcomes are always sorted by id in ascending order. |
| Calls | Returns all calls available to the user, according to the parameters provided. Calls are always sorted by made_at in descending order. |
| Collaborations | Returns all collaborations available to the user. |
| Contacts | Returns all contacts available to the user. |
| CustomFields | Returns all custom fields associated with the specified resource type. |
| Deals | Returns all deals available to the user. |
| DealSources | Returns all deal sources available to the user. |
| DealUnqualifiedReasons | Returns all deal unqualified reasons available to the user. |
| Documents | Returns all docuements attached to the specific resource. |
| Leads | Returns all leads available to the user. |
| LeadSources | Returns all lead sources available to the user. |
| LeadUnqualifiedReasons | Returns all lead unqualified reasons available to the user. |
| LineItems | Returns all orders available to the user. |
| LossReasons | Returns all deal loss reasons available to the user. |
| Notes | Returns all deals available to the user. |
| Orders | Returns all orders available to the user. |
| Pipelines | Returns all pipelines available to the user. |
| Products | Returns all products available to the user. |
| Stages | Returns all stages available to the user. |
| Tags | Returns all tags available to the user. |
| Tasks | Returns all tasks available to the user. |
| Users | Returns all users. |
| VisitOutcomes | Returns all visit outcomes available to the user. |
| Visits | Returns all visits available to the user. |