Optimizely 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.
Optimizely Tables
| Name | Description |
| Attributes | List Attributes under a Project. |
| Audiences | Get a list of all the Audiences for a Project. |
| CampaignResults | Get results for a single Campaign. |
| Campaigns | Get a list of all the Campaigns in a Project. |
| Events | Get all Events for a Project. |
| ExperimentResults | Get results for a single Experiment. |
| Experiments | Get a list of all the Experiments by Project or Campaign. |
| Extensions | List Extensions under a project. |
| Groups | List Exclusion Groups under a Project. |
| ListAttributes | Get all of the List Attributes that have been created in a given project. |
| Pages | List all Pages for a Project. |
| Projects | Get a list of all the Projects in your account. |