The Salesforce Marketing Cloud is a leading provider of Digital Marketing automation and analytics. It is used to create and manage marketing campaigns. Users can use the platform and the marketing APIs to create mailing lists, send emails, etc. It is a different system than the core Salesforce product (it was formerly ExactTarget), with a different set of APIs. https://developer.salesforce.com/docs/atlas.en-us.noversion.mc-apis.meta/mc-apis/supported_operations_for_objects_and_methods.htm contains a list of the different types of objects that can be managed.This plugin would allow users to retrieve data from their Salesforce Marketing Cloud instance on objects such as accounts, activities, campaigns etc. This plugin would support two modes of data retrieval:
- Multi-object data extraction - In this mode, the user will be allowed to select multiple objects
- Single-object data extraction - This mode would user to select a single
Use Cases
User would like to specify
Salesforce Objects
...
Plugin Type
- Batch Source
- Batch Sink
- Real-time Source
- Real-time Sink
- Action
- Post-Run Action
- Aggregate
- Join
- Spark Model
- Spark Compute
User Configurations
| Section | User Configuration Label | Description | Default | User Widget | Notes |
|---|---|---|---|---|---|
| Authentication | Client ID | OAuth client ID for authentication | Text Box | ||
| Client Secret | OAuth client ID for authentication | Password | |||
| Basic | Data retrieval mode |
| Select Multi-object to retrieve data on multiple objects; Select Single-object for extracting and transforming data for a specific object | Drop-down | ||
| Object | Salesforce Marketing Cloud object name - ex: |
| CampaignAccount, List, Subscriber. |
| Drop-down | |||||
| Objects list | |||||
| Advanced | Maximum bytes per batch | If size of batch data is larger than given number of bytes, split the batch. | Text Box | ||
| Maximum records per batch | If there are more than given number of records, split the batch. | Text Box | |||
| Error handling | Possible values: "Skip on error" - ignores any reports about records not inserted. Simply prints an error log. | Skip on error | Select |
Design / Implementation Tips
- REST API documentation can be found hereSalesforce Marketing Cloud objects can be found at https://developer.salesforce.com/docs/atlas.en-us.noversion.mc-apis.meta/mc-apis/account.htm
- Data retrieve since last batch option: https://developer.salesforce.com/docs/atlas.en-us.noversion.mc-apis.meta/mc-apis/routesretrieving_all_records_since_last_batch.htm
- API Integration: https://developer.salesforce.com/docs/atlas.en-us.mc-app-development.meta/mc-app-development/api-integration.htm
...