Use this resource to request the details for a mapping, the details of all mappings in the organization, or an image of a mapping. You can also send a request to get transformation details such as advanced properties and sequence generator details for all of the transformations in a mapping or for a particular transformation type.
Getting mapping details
You can get the details for all the mappings in an organization or details for a particular mapping.
Get request
Use one of the following URIs to get mapping details.
Details for all mappings in the organization
To request the details for all mappings in the organization, use the following URI:
/api/v2/mapping
Details for a particular mapping
To request the details for a particular mapping, include the mapping ID or mapping name in the URI. Use one of the following URIs:
/api/v2/mapping/<id>
/api/v2/mapping/name/<name>
If you use the mapping name in the URI and the mapping name value includes a space, replace the space with %20. For example:
/api/v2/mapping/name/my%20mapping
You can also request a specific mapping by name with the following URI:
/api/v2/mapping/search?name=<name>
GET response
If successful, returns the mapping object for the requested mapping.
If you request the details for all mappings, returns the mapping object for every mapping in the organization without parameter details.
Returns the error object if errors occur.
The mapping object includes the following attributes:
Field
Type
Description
id
String
Mapping ID.
orgId
String
Organization ID.
name
String
Mapping name.
description
String
Description of the mapping.
createTime
Date/time
Time the mapping was created.
updateTime
Date/time
Last time the mapping was updated.
createdBy
String
User who created the mapping.
updatedBy
String
User who last updated the mapping.
bundleObjectId
String
ID of the bundle that includes the mapping, if applicable.
bundleVersion
String
Version of the bundle that includes the mapping, if applicable.
templateId
String
ID of the template created internally to represent the mapping.
deployTime
Date/time
Time the mapping was deployed.
hasParameters
Boolean
Indicates if the mapping includes parameters. Returns true or false.
valid
Boolean
Indicates if the mapping is valid. Returns true or false.
fixedConnection
Boolean
Indicates if the mapping has fixed connections. Returns true or false.
hasParametersDeployed
Boolean
Indicates if the mapping has parameters deployed. Returns true or false.
fixedConnectionDeployed
Boolean
Indicates if the mapping has fixed connections deployed. Returns true or false.
deployedTemplateId
String
ID of the template created internally to represent the deployed mapping.
tasks
Int
Number of tasks that use the mapping.
parameters
Parameters used in the mapping. Includes an mtTaskParameter object for each parameter.
id
Long
Included in the mtTaskParameter object.
Parameter ID.
name
String
Included in the mtTaskParameter object.
Parameter name.
type
String
Included in the mtTaskParameter object.
Parameter type.
description
String
Included in the mtTaskParameter object.
Parameter description.
customFuncId
String
Mapplet ID for mapplet type parameters.
uiProperties
String
Included in the mtParameter object.
Display property for the parameter. Includes the following information:
- cnxtype. Connection type for the parameter.
- logcnx. Logical connection.
- order. Display order.
- wizstep. Wizard step to display the parameter.
- default. Default value.
- visible. Whether the parameter is visible.
- editable. Whether the parameter is editable.
- required. Whether the parameter is required.
- paramtype. UI control type for string parameters. Returns one of the following responses:
- Condition. Filter condition input control.
- Expression. Expression editor input control.
- Field. Field selection input control.
- Fieldmap. Field mapping input control. Includes the following attributes:
- lefttitle. Left title for the field mapping display.
- righttitle. Right title for the field mapping display.
- leftfs. Set of fields to display in the left table of the field mapping display.
- rightfs. Set of fields to display in the right table of the field mapping display.
- leftfilter. Regular expression to limit the fields that display in the left table of the field mapping display.
- rightfilter. Regular expression to limit the fields that display in the right table of the field mapping display.
- staticlist. List of fields to display on the right side of the field mapping display.
inOutParameters
In-out parameter used in the mapping. Includes a mtTaskInOutParameter object for each in-out parameter.
id
Long
Included in the mtTaskInOutParameter object.
Parameter ID.
name
String
Included in the mtTaskInOutParameter object.
Parameter name.
description
String
Included in the mtTaskInOutParameter object.
Description of the parameter.
initialValue
String
Included in the mtTaskInOutParameter object.
Initial value for the parameter.
datatype
String
Included in the mtTaskInOutParameter object.
Data type of the parameter.
precision
String
Included in the mtTaskInOutParameter object.
Precision of the parameter.
scale
String
Included in the mtTaskInOutParameter object.
Scale of the parameter.
retentionPolicy
String
Included in the mtTaskInOutParameter object.
Determines when the task retains the current value.
aggregationType
String
Included in the mtTaskInOutParameter object.
Determines the final current value of the parameter when the task runs.
currentValue
String
Included in the mtTaskInOutParameter object.
Current value for the parameter.
mappingPreviewFileRecordId
String
ID of the image file that is used when previewing a mapping.
deployedMappingPreviewFileRecordId
String
ID of the image file that is used when previewing a deployed mapping.
references
Reference information. Returns the reference object, which includes the following attributes:
refObjectId
String
Included in the reference object.
refType
String
Included in the reference object.
Getting transformation details
You can get the details for all the transformations in a mapping or details for the transformations of a particular type in a mapping.
Get request
Use one of the following URIs to get transformation details.
Details for all the transformations in a mapping
To include transformation details for all of the transformations in the mapping, use one of the following URIs:
If successful, returns transformation details for the mapping. Details can include transformation advanced properties such as tracing level and sequence information if a Sequence transformation is included in the mapping.
Note: If any advanced properties are specified for a transformation, the response includes all of the advanced property values for the transformation. If no advanced properties are specified for a transformation, the response doesn't include values for the advanced properties even though default values are used.
Returns the error object if errors occur.
The response includes the following attributes:
Field
Type
Description
id
String
Mapping ID.
orgId
String
Organization ID.
name
String
Mapping name.
description
String
Description of the mapping.
createTime
Date/time
Time the mapping was created.
updateTime
Date/time
Last time the mapping was updated.
createdBy
String
User who created the mapping.
updatedBy
String
User who last updated the mapping.
templateId
String
ID of the template created internally to represent the mapping.
valid
Boolean
Indicates if the mapping is valid. Returns true or false.
additionalAttributes
Additional mapping attributes.
specialCharacterSupport
Boolean
Returned in the additionalAttributes object.
Whether the mapping supports special characters in field names or replaces special characters with an underscore (_).
allowMaxFieldLength
Boolean
Returned in the additionalAttributes object.
Whether the mapping allows field names up to 255 characters. Names exceeding 255 characters are truncated. Default is false.
transformations
Object
Advanced transformation properties and sequence details.
transformationProperties
Object
Properties for each transformation in the mapping, or for a specific transformation type, if requested.
name
String
Transformation name.
txType
String
Transformation type.
advancedProperties
Object
Returned in the transformationProperties object.
Advanced properties for the transformation. The properties included in the response vary based on the transformation type and connection type.
sequences
Object
Sequence information for the mapping, if the mapping includes a Sequence transformation.
sequenceStateDefinition
Object
Properties for each Sequence transformation in the mapping.
name
String
Name of the Sequence transformation
txType
String
Transformation type.
cycle
Boolean
Whether the mapping task cycles through the sequence range.
endValue
String
Maximum value that the mapping task generates.
incrementBy
String
The difference between two consecutive values in a generated sequence.
numberOfCachedValues
String
Number of sequential values the mapping task caches for each run.
reset
Boolean
Whether reset is enabled.
sharedSequenceId
String
ID of the shared sequence, if enabled.
initialValue
String
Initial value of the sequence.
cycleStartValue
String
Start value of the generated sequence that you want the mapping task to use.
useSharedSequence
Boolean
Whether the Sequence transformation uses a shared sequence.
GET Example
To request details for all transformations in a particular mapping, you might use the following request:
GET <serverUrl>/api/v2/mapping/additionalTransformationInfoByName/m_Mapping26 Content-type: application/xml Accept: application/xml icSessionId: ABCdOrJmd6YUtmK123
If successful, you might receive a response similar the to following example: