Connecting to Coda

The Coda API uses API key authentication.

Using API Key Authentication

Your Coda API token (Bearer token) is required to create a connection to Coda. API token can be obtained from your Coda account settings under the API Settings section. Once you have obtained the API token, set it in the ProfileSettings connection property.

Example Connection string

Profile=C:\profiles\Coda.apip;ProfileSettings='APIKey=your_api_token;'AuthScheme=APIKey;

Usage Examples

AclMetadata:

SELECT * FROM AclMetadata WHERE DocId='doc123'

AclPermissions:

SELECT * FROM AclPermissions WHERE DocId='doc123'

AclSettings:

SELECT * FROM AclSettings WHERE DocId='doc123'

AnalyticsDocs:

SELECT * FROM AnalyticsDocs

AnalyticsDocsSummary:

SELECT * FROM AnalyticsDocsSummary

AnalyticsPackFormulas:

SELECT * FROM AnalyticsPackFormulas WHERE PackId=123

AnalyticsPacks:

SELECT * FROM AnalyticsPacks

AnalyticsPacksSummary:

SELECT * FROM AnalyticsPacksSummary

AnalyticsPages:

SELECT * FROM AnalyticsPages WHERE DocId='doc123'

Categories:

SELECT * FROM Categories

Columns:

SELECT * FROM Columns WHERE DocId='doc123' AND TableId='grid-xyz'

Controls:

SELECT * FROM Controls WHERE DocId='doc123'

Docs:

SELECT * FROM Docs

Formulas:

SELECT * FROM Formulas WHERE DocId='doc123'

PackListings:

SELECT * FROM PackListings

PackPermissions:

SELECT * FROM PackPermissions WHERE PackId=123

PackReleases:

SELECT * FROM PackReleases WHERE PackId=123

Packs:

SELECT * FROM Packs

PackVersions:

SELECT * FROM PackVersions WHERE PackId=123

Pages:

SELECT * FROM Pages WHERE DocId='doc123'

Rows:

SELECT * FROM Rows WHERE DocId='doc123' AND TableId='grid-xyz'

Tables:

SELECT * FROM Tables WHERE DocId='doc123'

WhoAmI:

SELECT * FROM WhoAmI

Connection Properties

The connection string properties are the various options that can be used to establish a connection. This section provides a complete list of the options you can configure in the connection string for this provider.

---

Property	Description
APIKey	The API key used for authentication with the Coda API.
AuthScheme	The scheme used for authentication. Accepted entries are APIKey or None. Allowed values are: BASIC, NONE, NTLM, OAUTH, APIKEY, OAUTH_CLIENT