...
Requirements and Limitations
For mobile_number, Oracle Netsuite Bronto automatically removes the `+` in a phone number. For example, `+085` becomes`085` on the server-side.
...
You need to define the column mapping in the query. The columns in the query represent add, update or delete Contact a Contact object in Bronto data.
Depend on your data object, you will need different column mapping:
...
the selected Action, certain columns are required
Add/Update Contacts or Replace Contacts from List
Column name | Type | RequỉedRequired | Description of Expected Value |
---|---|---|---|
String | Required email or phone_numberyes | E.g. test.me@abc.com | |
phone_number | String | Required email or phone_numberoptional | E.g. +593979652820 |
status | String | optional | transactional, onboarding, unconfirmed, unsub, bounce, active (default: onboarding) |
source | String | optional | manual, api, import, webform, sforcereport |
custom_source | String | optional | A source you define that states where the contact came from. |
fields | Array JSON | optional | JSON or JSON array format with the following required fields: fieldId and content |
list_idsArray | StringComma-separated string | optional | E.g. "list1,list2,list3" |
msg_pref | String | optional | The message preference for the contact. A contact can have a message preference of text or html. Only applies to adds. The message preference is ignored in the case of an update |
sms_keyword_ids | Array String |
...
Comma-separated string | optional | An array of the SMS keyword ids you want to subscribe the contact to. |
Remove Contacts from List
email
Column name | Type | RequỉedRequired | Description of Expected Value | |||||
---|---|---|---|---|---|---|---|---|
id | String | Required id, email or phone_number | email | String | Required id, email or phone_number | phone_number | String | Required id, email or phone_number |
status | String | optional | transactional, onboarding, unconfirmed, unsub, bounce, active | |||||
source | String | optional | manual, api, import, webform, sforcereport | custom_source | String | optional | ||
fields | Array JSON | optional | JSON or JSON array format with the following required fields:
| list_ids | Array String | optional | msg_pref | String | optional | sms_keyword_ids | Array String |
For Delete Contact
Yes (unless the email is used) | The unique id assigned to the contact | ||
email | String | Yes (unless name the contact id is used) | The email address assigned to the contact |
Numbered Headings | ||||||||
---|---|---|---|---|---|---|---|---|
|
...
Integration Parameters for Bronto
Parameter | Values | Description |
---|---|---|
Action |
add
update
delete
|
| |
List Name | String | List Name is required for Replace Contacts from List or Remove Contacts from List action. Add all users to this Mail List if the selected action is Add/Update Contacts |
Skip Invalid Data |
|
|
Example Query
Code Block | ||||
---|---|---|---|---|
| ||||
SELECT id, email, phone_number FROM table my_table |
...
Code Block |
---|
_export:
td:
database: td.database
+bronto_export_task:
td>: export_bronto.sql
database: bronto_db
result_connection: bronto
result_settings:
type: bronto
access_token: accesss_token
action: add_or_update
list_name: my list
skip_invalid_data: false |