Mtttask

Use this resource to request the details of a mapping task. You can also create, update, or delete a mapping task.

Note...
You cannot use the REST API to create a mapping task based on a mapping that includes a mapplet.

GET Request

To request the details of a mapping task, you can use the task ID or task name. Use one of the following URIs:

/api/v2/mttask/<id>
/api/v2/mttask/name/<name>

If you use the task name in the URI and the task name includes a space, replace the space with %20. For example:

/api/v2/mttask/name/task%20name

GET Response

Returns the mtTask object for the requested task ID or task name.
Returns the error object if errors occurred.
The following table describes attributes in an mtTask object:

idStringTask ID.
orgIdStringOrganization ID.
nameStringTask name.
descriptionStringDescription
createTimeDate/timeTime the task was created.
updateTimeDate/timeLast time the task was updated.
createdByStringUser who created the task.
updatedByStringUser who last updated the task.
errorTaskEmailObject that includes the taskEmail object for error notifications
idStringIncluded in taskEmail object for errorTaskEmail.
ID.
emailsStringIncluded in taskEmail object for errorTaskEmail.
Email address that receives email notification when a task fails to complete.
successTaskEmailObject that includes the taskEmail object for success notifications.
idStringIncluded in taskEmail object for successTaskEmail.
ID.
emailsStringIncluded in taskEmail object for successTaskEmail.
Email address that receives email notification when a task completes successfull
warningTaskEmailObject that includes the taskEmail object for warning notifications.
idStringIncluded in taskEmail object for warningTaskEmail.
ID.
emailsStringIncluded in taskEmail object for warningTaskEmail.
Email address that receives email notification when a task completes with errors
parametersParameters associated with the task. Includes attributes in the mtTaskParameter object for each parameter.
idIncluded in the mtTaskParameter object.
Parameter ID.
nameStringIncluded in the mtTaskParameter object.
Parameter name.
typeStringIncluded in the mtTaskParameter object.
Parameter type
textStringIncluded in the mtTaskParameter object.
Parameter value
labelStringIncluded in the mtTaskParameter object.
Parameter label.
descriptionStringIncluded in the mtTaskParameter object.
Parameter description.
sourceConnectionIdStringIncluded in the mtTaskParameter object.
Source connection ID
targetConnectionIdStringIncluded in the mtTaskParameter object.
Target connection ID
lookupConnectionIdStringIncluded in the mtTaskParameter object.
Lookup connection ID
transfConnectionIdStringIncluded in the mtTaskParameter object.
Connection ID of mapplet. Reserved for future use.
midstreamConnectionIdStringIncluded in the mtTaskParameter object.
Connection ID of midstream transformation.
sourceObjectStringIncluded in the mtTaskParameter object.
Source object name.
sourceObjectLabelStringIncluded in the mtTaskParameter object.
Source object label
targetObjectStringIncluded in the mtTaskParameter object.
Target object name.
targetObjectLabelStringIncluded in the mtTaskParameter object.
Target object label.
lookupObjectStringIncluded in the mtTaskParameter object.
Lookup object name.
lookupObjectLabelStringIncluded in the mtTaskParameter object.
Lookup object label.
midstreamObjectStringIncluded in the mtTaskParameter object.
Midstream object name
midstreamObjectLabelStringIncluded in the mtTaskParameter object.
Midstream object label.
newObjectBooleanIncluded in the mtTaskParameter object.
Whether the application creates a new flat file target. Returns True when it creates a target.
newObjectNameStringIncluded in the mtTaskParameter object.
Name of the flat file target.
operationTypeStringIncluded in the mtTaskParameter object.
The task operation for the target.
truncateTargetBooleanIncluded in the mtTaskParameter object.
Whether the application truncates a database target before writing to it. Returns True when it truncates the target
srcFFAttrsIncluded in the mtTaskParameter object.
Object that contains the source file attributes in the flatFileAttrs object.
tgtFFAttrsIncluded in the mtTaskParameter object.
Object that contains the target file attributes in the flatFileAttrs object.
lkpFFAttrsIncluded in the mtTaskParameter object.
Object that contains the lookup file attributes in the flatFileAttrs object.
flatFileAttrsObject that includes attributes for the source, target, and lookup files.
idLongIncluded in the flatFileAttrs object.
Field ID.
delimiterStringIncluded in the flatFileAttrs object.
Character used to separate fields
textQualifierStringIncluded in the flatFileAttrs object.
Quote character that defines the boundaries of text strings
escapeCharStringIncluded in the flatFileAttrs object.
Character immediately preceding a field delimiter character embedded in an unquoted string, or immediately preceding the quote character in a quoted string
headerLineNoIntIncluded in the flatFileAttrs object.
Number of header lines
firstDataRowIntIncluded in the flatFileAttrs object.
The row number where the data begins in the file.
customFuncCfgIncluded in the mtTaskParameter object.
Object that defines configuration for mapplets used in the task. Includes attributes in the customFuncConfig object for each mapplet.
idLongIncluded in the customFuncConfig object.
Mapplet ID.
connectionsIncluded in the customFuncConfig object.
Object to define connections used in a mapplet. Includes information in the pcsConnection object for each connection
idLongIncluded in the pcsConnection object.
nameStringIncluded in the pcsConnection object.
Connection name.
typeStringIncluded in the pcsConnection object.
Connection type
subtypeStringIncluded in the pcsConnection object.
Connection subtype.
descriptionStringIncluded in the pcsConnection object.
Description of the connection.
connectionIdStringIncluded in the pcsConnection object.
Connection ID.
showBusinessNamesStringIncluded in the mtTaskParameter object.
Whether the task displays business names. Returns True when it shows business names.
naturalOrderBooleanIncluded in the mtTaskParameter object.
The order that the task uses to display fields. Returns True for the order returned by the connection. Returns False for alphabetic order.
isRESTModernSourceBooleanIncluded in the mtTaskParameter object.
Always set to True to enable extended objects
customQueryStringIncluded in the mtTaskParameter object.
The custom query specified in Mapping Designer or mapping task query options
overriddenFieldsIncluded in the mtTaskParameter object.
Changes to field metadata in the mapping task. Includes information in the mtTaskOverriddenField object for each overridden field
nameStringIncluded in the mtTaskOverriddenField object.
Field name.
typeStringIncluded in the mtTaskOverriddenField object.Field type.
precisionIntIncluded in the mtTaskOverriddenField object.Length of the field in bytes.
scaleIntIncluded in the mtTaskOverriddenField object.Number of digits after the decimal point for numeric values.
tgtFieldRefsStringIncluded in the mtTaskParameter object.
Salesforce field reference IDs.
extendedObjectIncluded in the mtTaskParameter object.
The source or target with more than one object joined
targetUpdateColumnsStringIncluded in the mtTaskParameter object.
List of column names used to update records in the target object.
runtimeAttrsStringIncluded in the mtTaskParameter object.
Advanced connection properties for connections used in a task.
Use a runtimeAttrs object to define key-value pairs of advanced connection properties. Use an entry object for each key-value pair.
For the attribute name, use the advanced connection property name as displayed in the Data Integration user interface.
For more information about advanced connection properties, see the Data Integration Help
dataFormatIncluded in the mtTaskParameter object.
Data format provided by the connector.
Includes attributes in the dataFormat object for each connector.
The dataFormat object is not applicable to all connectors. To see if dataFormat is applicable to the connectors you are using, see the relevant connector guides
formatIdIncluded in the dataFormat object.
Data format type provided by the connector, such as FLAT, AVRO, PARQUET, JSON, or XM
dataFormatAttributesIncluded in the dataFormat object.
Format attributes for the data format type. For example, for a flat file, the dataFormatAttributes object includes values such as escapeChar, delimiter, and qualifier
sequencesDefines values for the Sequence Generator transformation. Includes the sequenceDefinition object for each sequence transformation.
txNameStringIncluded in the sequenceDefinition object.
Name of the Sequence Generator transformation
initialValueStringIncluded in the sequenceDefinition object.
The initial value of the sequence.
currentValueStringIncluded in the sequenceDefinition object.
The value used for the last row added to the transformation.
inOutParametersIn-out parameter used in the task. Includes a mtTaskInOutParameter object for each in-out parameter.
idStringIncluded in the mtTaskInOutParameter object.
Parameter ID.
nameStringIncluded in the mtTaskInOutParameter object.
Parameter name.
descriptionStringIncluded in the mtTaskInOutParameter object.
Description of the paramete
initialValueStringIncluded in the mtTaskInOutParameter object.
Initial value for the parameter.
datatypeStringIncluded in the mtTaskInOutParameter object.
Data type of the parameter
precisionStringIncluded in the mtTaskInOutParameter object.
Precision of the parameter.
scaleStringIncluded in the mtTaskInOutParameter object.
Scale of the parameter.
retentionPolicyStringIncluded in the mtTaskInOutParameter object.
Determines when the task retains the current value.
aggregationTypeStringIncluded in the mtTaskInOutParameter object.
Determines the final current value of the parameter when the task runs.
currentValueStringIncluded in the mtTaskInOutParameter object.
Current value for the paramete
agentIdStringAgent that runs the task.
lastRunTimeDate/timeTime the task last run.
masterTemplateIdStringVisio template ID. Returned when a Visio template is the basis of the task
mappingIdStringMapping ID. Returned when a mapping is the basis for the task
scheduleIdStringSchedule associated with the task, if any.
shortDescriptionStringThe first 50 characters of the description.
sessionPropertiesStringAdvanced session properties associated with the task.
Includes advanced session properties in a sessionProperties object.
outboundMessageUrlTokenStringOutbound message URL token for the task, if it exists.
outboundMessageUrlQueueTimeLongOutbound message URL queue time for the task, if it exists.
runtimeEnvironmentIdStringRuntime environment used for the task.
preProcessingCmdStringCommand to run before the task.
postProcessingCmdStringCommand to run after the task completes.
parameterFileNameStringThe name of the parameter file used in the task.
maxLogsLongNumber of session log files and import log files Data Integration retains.
verboseBooleanWhether Data Integration generates additional data in the logs to use for troubleshooting purposes. Returns True or False.

POST Request

To update a mapping task, use a mapping task ID in the following URI. To create a mapping task, omit the optional task ID.

/api/v2/mttask/<id>

You can submit a partial update using partial mode. If you want to update a field that is within a collection using partial mode, you must include the key field for the collection. The following table lists the collections in the mttask resource and the corresponding key fields:

CollectionKey Field
mtTaskInOutParametername
sequenceDefinitiontxtName
mtTaskOverriddenFieldname
mtTaskParametername
type

To submit a request using partial mode, use a JSON request and include the following line in the header:

Update-Mode=PARTIAL

The following table describes the attributes you can include in an mtTask object:

POST Response

If successful, returns the mtTask object that you created or updated. Returns the error object if errors occur.

DELETE Request

To delete a mapping task, use the task ID in the following URI:

/api/v2/mttask/<id>

DELETE Response

Returns the 200 response code if the request is successful.
Returns the error object if errors occur.

POST Example

To create a new mapping task with XML, you might use the following request:

POST <serverUrl>/api/v2/mttask
Content-Type: application/xml
Accept: application/xml
icSessionId: <icSessionId>

<mtTask>
  <errorTaskEmail>
    <taskEmail>
      <emails>[email protected], [email protected]</emails>
    </taskEmail>
  </errorTaskEmail>
  <successTaskEmail>
    <taskEmail>
      <emails>[email protected]</emails>
    </taskEmail>
  </successTaskEmail>
  <warningTaskEmail>
    <taskEmail>
      <emails>[email protected], [email protected]</emails>
    </taskEmail>
  </warningTaskEmail>
  <parameters>
    <mtTaskParameter>
      <name>sort convert plugin</name>
      <type>MAPPLET</type>
    </mtTaskParameter>
  </parameters>
  <parameters>
    <mtTaskParameter>
      <name>DB lookup</name>
      <type>LOOKUP</type>
    </mtTaskParameter>
  </parameters>
  <sessionProperties>
      <entry>
         <key>Java Classpath</key>
         <value>C:/test/classpathnew</value>
      </entry>
      <entry>
         <key>Pushdown Optimization</key>
         <value>To Source</value>
      </entry>
      <entry>
         <key>Write Backward Compatible Session Log File</key>
         <value>no</value>
      </entry>
   </sessionProperties>
  <runtimeEnvironmentId>00000398D00000004</runtimeEnvironmentId>
  <sequences>
    <sequenceDefinition>
      <txName>SeqGen1</txName>
      <initialValue>1</initialValue>
      <currentValue>62</currentValue>
    </sequenceDefinition>
  </sequences>
  <preProcessingCmd>echo CurrentDate is 'date'</preProcessingCmd>
  <postProcessingCmd>echo PR-PostProcess</postProcessingCmd>
  <masterTemplateId>00034234M00000R</masterTemplateId>
</mtTask>

A successful request returns the mtTask object.

Mask Rule Parameter Attributes for Masking Techniques

Define the parameter attribute values of a mask rule parameter when you run the mapping task. The attributes that you define depend on the masking technique that you apply.

For example, to mask a billing city field with the Substitution City masking technique, define the following attributes:

[
  {
    "referenceField": "BillingCity",
    "pcType": "string",
    "precision": 40,
    "paramMap": {
      "isSeeded": "TRUE",
      "seedValue": "190",
      "dicName": "informatica_mask_us_towns.dic",
      "outputPort": "TOWNNAMES",
    },
    "maskingType": "Substitution City"
  }
]

The following table lists the attributes that you define for each masking technique:

Masking TechniqueAttributes
Credit CardisSeeded
seedValue
keepCardIssuer
targetIssuer
Custom SubstitutionDicConn
DicName
outputPort
isSeeded
seedValue
Email addresssSeeded
seedValue
IP addressisSeeded
seedValue
Key DateisSeeded
seedValue
Key Numericoverride
isSeeded
seedValue
Key StringisSeeded
seedValue
useMaskFormat
maskFormat
useSrcFilter
srcFilterOption
srcFilterStr
useTargetFilter
targetFilterOption
targetFilterStr
PhoneisSeeded
seedValue
Random DateuseRange
minWidth
maxWidth
useBlurring
blurringUnit
blurLow
blurHigh
Random NumericuseRange
minWidth
maxWidth
useBlurring
blurringOption
blurLow
blurHigh
Random StringuseRange
minWidth
maxWidth
useMaskFormat
useSrcFilter
srcFilterStr
useTargetFilter
targetFilterOption
targetFilterStr
SINisSeeded
seedValue
startDigit
startDigitValue
SSNisSeeded
seedValue
Substitution CityisSeeded
seedValue
DicName
outputPort
Substitution CountryisSeeded
seedValue
DicName
outputPort
Substitution Female NameisSeeded
seedValue
DicName
outputPort
Substitution Last NameisSeeded
seedValue
DicName
outputPort
Substitution Male NameisSeeded
seedValue
DicName
outputPort
Substitution NameisSeeded
seedValue
DicName
outputPort
Substitution PositionisSeeded
seedValue
DicName
outputPort
Substitution StateisSeeded
seedValue
DicName
outputPort
Substitution StreetisSeeded
seedValue
DicName
outputPort
Substitution U.S. ZIP codeisSeeded
seedValue
DicName
outputPort
URLisSeeded
seedValue

Mask Rule Parameter Attribute Values

Define the required parameter attribute values when you run the mapping task.

The following table describes the attributes and values that you define for the mask rule parameter:

AttributeDescription
blurHighRequired. The higher bound for blurring. You can specify the value in digits.
Default is 0.
blurLowRequired. The lower bound for blurring. You can specify the value in digits.
Default is 0
blurringOptionRequired. The unit of blurring for a numeric port. You can specify the following values:
Percent. Blurs the data based on a percent value.
Fixed. Blurs the data based on a fixed value.
blurringUnitRequired. The unit of blurring for a date port. You can specify the following values:
Year. Blurs the year value.
Month. Blurs the month value.
Day. Blurs the day value.
Hour. Blurs the hour value.
Minute. Blurs the minute value.
Second. Blurs the second value.
Default is Year
delimiterDelimiter to separate the first name and last name in a masked email address. You can specify the value as:
.
-
_
DicConnThe connection that contains the dictionary files. Create a flat file connection that points to the directory with the dictionary files. Specify the flat file connection name.
dicNameThe name of the flat file dictionary file. The dictionary file must be present in the rdtmDir directory of the Secure Agent.
domainConstantValueDomain name to use in masked email addresses.
Default is company.com.
expTextAn attribute to configure an expression.
firstNameColumnThe first name column to use in masked email addresses. Specify the name of the port.
firstNameLengthThe length of the first name in a masked email address. You can specify the value in digits.
Default is 5
isSeededAn attribute to configure repeatable output. You can specify the following values:
TRUE. Masks the data with repeatable output. When true, specify a seed value.
FALSE. Masks the data with random output.
Default is TRUE.
keepCardIssuerMasks a credit card field with a credit card number from the same issuer. You can specify the following values:
TRUE. Retains the same card issuer in the masked data.
FALSE. Uses a specified card issuer in the masked data.
When false, define the targetIssuer attribute.
Default is TRUE.
lastNameColumnThe last name column to use in masked email addresses. Specify the name of the port.
lastNameLengthThe maximum length of the last name in masked email addresses. You can enter the value in digits.
Default is 5
maskFormatDefines the type of character to substitute for each character in the input data. You can limit each character to an alphabetic, numeric, or alphanumeric character type.
Use the following characters to define a mask format:
A. Alphabetic
D. Digits 0-9
N. Alphanumeric
X. Any character
R. Rest of the characters.
Specify the value as ADNX+R. R must appear as the last character. For example, to ensure the masked output begins with an alphabet, enter the value as A+R.
Default is R.
maxWidthRequired. The minimum value for the range. Enter the value in digits.
Default is 0
maxWidthRequired. The maximum value for the range. Enter the datetime value.
Default is 01/19/2038 03:13:59.
minWidthRequired. The minimum value for the range. Enter the datetime value.
Default is 01/01/1970 00:00:00.
minWdthRequired. The minimum value for the range. Enter the value in digits.
Default is 0.
outputPortThe output port column from the dictionary.
seedValueThe seed value. Specify a value between 1 and 999.
Default is 190.
srcFilterOptionRequired. The type of filter to apply to source filter characters. You can specify the following values:
Mask Only. Masks only the specified characters in the source.
Mask all except. Masks all characters in the source except the characters specified.
srcFilterStrRequired. Defines the characters in the source string that you want to mask
startDigitRequired. Defines the first digit of the masked SIN. You can specify the following values:
TRUE. Uses the digit that you specify as the first digit of the masked SIN.
FALSE. Uses a random digit as the first digit of the masked SIN.
Default is FALSE. When true, define the startDigitValue attribute.
startDigitValueRequired. Defines the first digit of the masked SIN. Specify a value between 0 and 9.
Default is 0.
targetFilterOptionRequired. The type of filter to apply on target filter characters. You can specify the following values:
Use Only. Uses only the target characters that you specify.
Use All Except. Uses all characters in the target except what you specify.
targetFilterStrRequired. Substitutes the characters in a target string with the characters that you define in target filter characters. For example, enter the following characters to configure the masked output to contain all uppercase alphabetic characters: ABCDEFGHIJKLMNOPQRSTUVWXYZ.
targetIssuerRequired. Masked values contain credit card numbers from the issuer that you select. You can specify the following values:
ANY
JCB
VISA
AMEX
DISCOVER
MASTERCARD
useBlurringRequired. Masks dates based on a variance that you apply to a unit of the date. The masked date is within the variance. You can specify the following values:
TRUE. Applies a variance that you specify on a unit of the date.
FALSE. Does not apply a variance.
Default is FALSE.
useMaskFormatSpecifies a mask format. You can specify the following values:
TRUE. Masks the data based on a format that you specify.
FALSE. Masks the data in a random format.
Default is TRUE. If true, define the maskFormat attribute.
useRangeRequired. Specifies a return value between the minimum and maximum values of the range based on field precision. You can specify the following values:
TRUE. Masks the data within a range that you specify.
FALSE. Does not use a specified range to mask the data.
To define the range, configure the minimum and maximum ranges or configure a blurring range based on a variance from the original source value.
Default is FALSE.
useSrcFilterSpecifies the characters in the source string that you want to mask. You can specify the following values:
TRUE. Masks the characters in the source string that you specify.
FALSE. Masks random characters in the source string.
Default is FALSE.
useTargetFilterSpecifies the characters to use in the masked string. You can specify the following values:
TRUE. Uses characters that you specify in the masked string.
FALSE. Uses random characters in the masked string.
Default is FALSE