Replace all attributes of this Data Unification Enhancement

Replace all attributes of this Data Unification Enhancement

enhancements_put_data_unification(
  id,
  name,
  field_mapping1,
  field_mapping2,
  schedule = NULL,
  parent_id = NULL,
  notifications = NULL,
  table1 = NULL,
  table2 = NULL,
  output_table = NULL,
  max_matches = NULL,
  threshold = NULL
)

Arguments

id	integer required. The ID for the enhancement.
name	string required. The name of the enhancement job.
field_mapping1	list required. The column mapping for Table 1. See /enhancements/field_mapping for list of valid fields.
field_mapping2	list required. The column mapping for Table 2. See /enhancements/field_mapping for list of valid fields.
schedule	list optional. A list containing the following elements: scheduled boolean, If the item is scheduled. scheduledDays array, Day based on numeric value starting at 0 for Sunday. scheduledHours array, Hours of the day it is scheduled on. scheduledMinutes array, Minutes of the day it is scheduled on. scheduledRunsPerHour integer, Alternative to scheduled minutes, number of times to run per hour.
parent_id	integer optional. Parent ID that triggers this enhancement.
notifications	list optional. A list containing the following elements: urls array, URLs to receive a POST request at job completion successEmailSubject string, Custom subject line for success e-mail. successEmailBody string, Custom body text for success e-mail, written in Markdown. successEmailAddresses array, Addresses to notify by e-mail when the job completes successfully. successEmailFromName string, Name from which success emails are sent; defaults to "Civis." successEmailReplyTo string, Address for replies to success emails; defaults to the author of the job. failureEmailAddresses array, Addresses to notify by e-mail when the job fails. stallWarningMinutes integer, Stall warning emails will be sent after this amount of minutes. successOn boolean, If success email notifications are on. failureOn boolean, If failure email notifications are on.
table1	list optional. A list containing the following elements: databaseName string, The Redshift database name for the table. schema string, The schema name for the table. table string, The table name.
table2	list optional. A list containing the following elements: databaseName string, The Redshift database name for the table. schema string, The schema name for the table. table string, The table name.
output_table	list optional. A list containing the following elements: databaseName string, The Redshift database name for the table. schema string, The schema name for the table. table string, The table name.
max_matches	integer optional. The maximum number of matches per record in Table 1 to return. Must be between 0 and 10. 0 returns all matches.
threshold	number optional. The score threshold (between 0 and 1). Matches below this threshold will not be returned.

Value

A list containing the following elements:

id

integer, The ID for the enhancement.

name

string, The name of the enhancement job.

type

string, The type of the enhancement (e.g CASS-NCOA)

createdAt

string, The time this enhancement was created.

updatedAt

string, The time the enhancement was last updated.

author

list, A list containing the following elements:

• id integer, The ID of this user.

• name string, This user's name.

• username string, This user's username.

• initials string, This user's initials.

• online boolean, Whether this user is online.

state

string, The status of the enhancement's last run

schedule

list, A list containing the following elements:

• scheduled boolean, If the item is scheduled.

• scheduledDays array, Day based on numeric value starting at 0 for Sunday.

• scheduledHours array, Hours of the day it is scheduled on.

• scheduledMinutes array, Minutes of the day it is scheduled on.

• scheduledRunsPerHour integer, Alternative to scheduled minutes, number of times to run per hour.

parentId

integer, Parent ID that triggers this enhancement.

notifications

list, A list containing the following elements:

• urls array, URLs to receive a POST request at job completion

• successEmailSubject string, Custom subject line for success e-mail.

• successEmailBody string, Custom body text for success e-mail, written in Markdown.

• successEmailAddresses array, Addresses to notify by e-mail when the job completes successfully.

• successEmailFromName string, Name from which success emails are sent; defaults to "Civis."

• successEmailReplyTo string, Address for replies to success emails; defaults to the author of the job.

• failureEmailAddresses array, Addresses to notify by e-mail when the job fails.

• stallWarningMinutes integer, Stall warning emails will be sent after this amount of minutes.

• successOn boolean, If success email notifications are on.

• failureOn boolean, If failure email notifications are on.

runningAs

list, A list containing the following elements:

• id integer, The ID of this user.

• name string, This user's name.

• username string, This user's username.

• initials string, This user's initials.

• online boolean, Whether this user is online.

fieldMapping1

list, The column mapping for Table 1. See /enhancements/field_mapping for list of valid fields.

table1

list, A list containing the following elements:

• databaseName string, The Redshift database name for the table.

• schema string, The schema name for the table.

• table string, The table name.

fieldMapping2

list, The column mapping for Table 2. See /enhancements/field_mapping for list of valid fields.

table2

list, A list containing the following elements:

• databaseName string, The Redshift database name for the table.

• schema string, The schema name for the table.

• table string, The table name.

outputTable

list, A list containing the following elements:

• databaseName string, The Redshift database name for the table.

• schema string, The schema name for the table.

• table string, The table name.

maxMatches

integer, The maximum number of matches per record in Table 1 to return. Must be between 0 and 10. 0 returns all matches.

threshold

number, The score threshold (between 0 and 1). Matches below this threshold will not be returned.