Salesforce
Prerequisites
- Salesforce Account with Enterprise access or API quota purchased
- Dedicated Salesforce user (optional)
Tables in the Salesforce connector
| No | Table Name | Columns | Primary Keys | Read Mode | Inc. Sync Keys | API Info |
|---|---|---|---|---|---|---|
| 1 | Describe | 43 |
Table: Describe
| No | Column Name | Type | Notes |
|---|---|---|---|
| 1 | mruEnabled | BOOLEAN | |
| 2 | updateable | BOOLEAN | |
| 3 | activateable | BOOLEAN | |
| 4 | childRelationships | VARCHAR | |
| 5 | recordTypeInfos | VARCHAR | |
| 6 | deprecatedAndHidden | BOOLEAN | |
| 7 | supportedScopes | VARCHAR | |
| 8 | searchLayoutable | BOOLEAN | |
| 9 | deletable | BOOLEAN | |
| 10 | dataTranslationEnabled | BOOLEAN | |
| 11 | replicateable | BOOLEAN | |
| 12 | actionOverrides | VARCHAR | |
| 13 | urlEdit | VARCHAR | |
| 14 | mergeable | BOOLEAN | |
| 15 | compactLayoutable | BOOLEAN | |
| 16 | feedEnabled | BOOLEAN | |
| 17 | extendsInterfaces | VARCHAR | |
| 18 | networkScopeFieldName | VARCHAR | |
| 19 | customSetting | BOOLEAN | |
| 20 | urlDetail | VARCHAR | |
| 21 | isInterface | BOOLEAN | |
| 22 | implementedBy | VARCHAR | |
| 23 | implementsInterfaces | VARCHAR | |
| 24 | extendedBy | VARCHAR | |
| 25 | defaultImplementation | VARCHAR | |
| 26 | deepCloneable | BOOLEAN | |
| 27 | layoutable | BOOLEAN | |
| 28 | custom | BOOLEAN | |
| 29 | associateParentEntity | VARCHAR | |
| 30 | undeletable | BOOLEAN | |
| 31 | label | VARCHAR | |
| 32 | keyPrefix | VARCHAR | |
| 33 | namedLayoutInfos | VARCHAR | |
| 34 | searchable | BOOLEAN | |
| 35 | urlNew | VARCHAR | |
| 36 | queryable | BOOLEAN | |
| 37 | createable | BOOLEAN | |
| 38 | retrieveable | BOOLEAN | |
| 39 | associateEntityType | VARCHAR | |
| 40 | name | VARCHAR | |
| 41 | fields | VARCHAR | |
| 42 | labelPlural | VARCHAR | |
| 43 | triggerable | BOOLEAN |
External Resources
- Salesforce Account
- User
- Oauth
- Log Into Salesforce
- Sandbox Account
- Walkthrough
- Created A Read-only User
- Daily Rate Limits
- Here
- Bulk Api
Zipstack Cloud features a powerful SQL querying engine on top of many types of connectors, including those from Trino, some custom connectors and connectors from the open source Airbyte project. Some Zipstack cloud connectors are designed to utilize and expand upon Airbyte's connector protocol, but they do not use Airbyte's EL core. Additionally, some parts of the documentation for these connectors have been adapted from the connector documentation found in Airbyte's open source project.