AutoPilot 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.
AutoPilot Tables
| Name | Description |
| Account | It retrieves the account information of the primary account holder of the Autopilot instance associated with the provided API key |
| Contacts | Get a list of all of the contacts for your account |
| CustomFields | Get a list of all custom fields. |
| Lists | Get a list of lists |
| Segments | Get a list of segments |
| Triggers | Get list of journeys containing API triggers |