You can create a dynamic mapping task with the REST API to batch jobs together that are based on the same mapping. You can also run the task and get details about the job.
Use the following resources for dynamic mapping tasks:
•Login. Use to log in to Informatica Intelligent Cloud Services and get the session ID to use in dynamic task REST API calls.
•dynamictask. Use to create, view, update, or delete a dynamic mapping task.
•job. Use to start, stop, or get details about a dynamic mapping task run instance.
When you use these resources, note the following rules:
The server URL includes the name and region of the POD that your organization uses and the Informatica Intelligent Cloud Services domain, informaticacloud.com. If you do not know the name and region of your organization's POD, you can find it by logging in to Informatica Intelligent Cloud Services through the user interface. The POD information is located in the browser's address bar.
In the following example, https://usw3.dm-us.informaticacloud.com is the server URL:
Use the server URL as the base URL in the header of REST API calls.
Note: If you use a tool such as Postman that automatically includes the HTTP version, do not enter the HTTP version in the URL. If the HTTP version appears twice in the URL, the request fails.
Logging in
Use this resource to log into Informatica Intelligent Cloud Services when you use resources that require the IDS-SESSION-ID in the call header. The IDS-SESSION-ID is included in a successful login response.
POST request
Use the following URL:
<login URL>/identity-service/api/v1/Login
The login URL includes the region where your organization is located and the Informatica Intelligent Cloud Services domain, informaticacloud.com. You can find your organization's login region by opening the Informatica Intelligent Cloud Services log in page. The regional login URL is located in the browser's address bar before you log in to Informatica Intelligent Cloud Services.
In the following example, https://dm-us.informaticacloud.com, is the region URL:
The following table describes the fields to include in the request:
Field
Type
Required
Description
username
String
Yes
Informatica Intelligent Cloud Services user name.
Maximum length is 255 characters.
password
String
Yes
Informatica Intelligent Cloud Services password.
Maximum length is 255 characters.
POST response
Returns the user object if the request is successful. Returns the error object if errors occur.
Use the session ID returned in the response for subsequent requests.
The user object includes the following attributes:
Field
Type
Description
sessionId
String
REST API session ID for the current session. Use in most REST API request headers.
sessionExpireTime
String
Time the session expires.
id
String
User ID.
name
String
Informatica Intelligent Cloud Services user name.
currentOrgId
String
Current organization ID.
currentOrgName
String
Name of the current organization.
parentOrgId
String
ID of the parent organization.
orgId
String
ID of the organization the user belongs to.
orgName
String
Name of the organization the user belongs to.
groups
String
User group.
effectiveRoles
String
Roles assigned to the user.
effectivePrivileges
String
Privileges assigned to the user.
status
String
Status of the user.
timeZoneId
String
Time zone of the user. Time zone honors Daylight Saving Time. For more information, see Time zone codes.
authenticator
String
User authentication method.
Getting dynamic mapping task details
Use this resource to request the details of a dynamic mapping task. You can also create, update, or delete a dynamic mapping task.
To request details or to update a dynamic task that already exists, you need the task ID. You can get the task ID using the V3 lookup resource. To lookup object details with the V3 lookup resource, use the following URI:
/saas/public/core/v3/lookup
Include BATCH_MAPPING as the object type as shown in the following example:
To request the details of a dynamic mapping task, use the task ID.
Use the following URI to request the details of a dynamic mapping task:
/batch-mapping/api/v1/dynamictask/<id>
GET response
Returns the dynamictask object for the requested task ID.
Returns the error object if errors occurred.
The following table describes the attributes in a dynamictask object:
Field
Type
Description
name
String
Name of the dynamic mapping task.
mappingId
String
ID of the mapping used in the task.
mappingDocType
String
Type of mapping used in the task.
runtimeEnvironmentId
String
Runtime environment used for the task.
groups
Groups in the dynamic mapping task.
groupName
String
Included in the group object.
Name of the group.
enabled
Boolean
Included in the group object.
Whether the group is enabled or not.
Returns true when the group is enabled.
parameters
Parameters in the dynamic mapping task.
name
String
Included in the parameter object.
Name of the parameter.
type
String
Included in the parameter object.
Type of parameter.
txName
String
Included in the parameter object.
Name of the transformation that uses the parameter.
uniqueName
String
Included in the parameter object.
Transformation name and parameter name. If no transformation name is present, then parameter name.
scope
String
Included in the parameter object.
Scope of the parameter, either DEFAULT or LOCAL.
label
String
Included in the parameter object.
Parameter label.
description
String
Included in the parameter object.
Parameter description.
retentionPolicy
String
Included in the parameter object.
Applicable to in-out parameters. Determines when the task retains the current parameter value.
aggregationType
String
Included in the parameter object.
Applicable to in-out parameters. Type of calculation the parameter performs.
job
Jobs in the dynamic mapping task.
jobName
String
Included in the job object.
Name of the job.
jobType
String
Included in the job object.
Type of job, either USER or DEFAULT.
enabled
Boolean
Included in the job object.
Determines if the job is enabled.
Default is false.
stopOnError
Boolean
Included in the job object.
Stops the job when it encounters an error.
Default is false.
stopOnWarning
Boolean
Included in the job object.
Stops the job when it encounters a warning.
Default is false.
preProcessingCmds
Sting
Included in the job object.
List of commands to run before the task.
postProcessingCmds
String
Included in the job object.
List of commands to run after the task.
advSessionProperties
Map
Included in the job object.
Map of the advanced session properties that are set for the job.
group
String
Included in the job object.
Name of the group that the job belongs to.
paramValueBindings
Included in the job object.
Parameter attributes in the job.
paramDefnRef
Sting
Included in the paramValueBindings object.
Unique name of the parameter.
type
String
Included in the paramValueBindings object.
Type of parameter. Value can be one of the following types:
- Connection
- String
- Source
- Target
- INOUT
- Sequence
connection
Attributes for connection type parameters.
connectionId
String
Included in the paramValueBindings object.
Connection ID.
connectionType
String
Included in the paramValueBindings object.
Type of connection.
runtimeAttrs
Map
Included in the paramValueBindings object.
Runtime attributes for the connection.
oprRuntimeAttrs
Map
Included in the paramValueBindings object.
Read/write runtime attributes.
source
Attributes for source type parameters.
sourceObject
Object
Included in the paramValueBindings object.
Source object.
advancedFilterExpression
String
Included in the paramValueBindings object.
Advanced filter condition.
filterFields
List of objects
Included in the paramValueBindings object.
List of filter fields.
sortFields
List of objects
Included in the paramValueBindings object.
List of sort fields.
srcFFAttrs
Object
Included in the paramValueBindings object.
Flat file attributes.
ccmDataFormat
Object
Included in the paramValueBindings object.
Data format
customQuery
String
Included in the paramValueBindings object.
Custom query
handleSpecialChars
Boolean
Included in the paramValueBindings object.
Determines if the task can use special characters.
runtimeAttrs
Map
Included in the paramValueBindings object.
Runtime Attributes
oprRuntimeAttrs
Map
Included in the paramValueBindings object.
Read/write runtime attributes.
string
Attributes for string type parameters.
text
String
Included in the paramValueBindings object.
Text value for the parameter.
target
Attributes for target type parameters.
objectName
String
Included in the paramValueBindings object.
Name of the existing target object.
objectLabel
String
Included in the paramValueBindings object.
Label of the existing target object.
newObjectName
String
Included in the paramValueBindings object.
Name of the new target file.
truncateTarget
Boolean
Included in the paramValueBindings object.
Determines if Data Integration truncates the target.
bulkApiDBTarget
Boolean
Included in the paramValueBindings object.
Determines if bulk API is used.
operationType
String
Included in the paramValueBindings object.
Task operation.
tgtFFAttrs
String
Included in the paramValueBindings object.
Flat file attributes.
tgtObjectAttributes
Map
Included in the paramValueBindings object.
Target object attributes.
runtimeAttrs
Map
Included in the paramValueBindings object.
Run time attributes
oprRuntimeAttrs
Map
Included in the paramValueBindings object.
Read/write runtime attributes.
ccmDataFormat
Object
Included in the paramValueBindings object.
Data format for CCI targets.
dynamicFileName
Boolean
Included in the paramValueBindings object.
Determines if the target file name is dynamic.
handleSpecialChars
Boolean
Included in the paramValueBindings object.
Determines if the target object handles special characters.
INOUT
Attributes for INOUT type parameters.
initialValue
String
Included in the paramValueBindings object.
Initial value of the in-out parameter.
datatype
String
Included in the paramValueBindings object.
Data type of the parameter.
precision
String
Included in the paramValueBindings object.
Precision of the parameter.
scale
String
Included in the paramValueBindings object.
Scale of the parameter.
retentionPolicy
String
Included in the paramValueBindings object.
Determines when the task retains the current parameter value.
aggregationType
String
Included in the paramValueBindings object.
Type of calculation the parameter performs.
currentValue
String
Included in the paramValueBindings object.
Current value of the in-out parameter.
sequence
Attributes for sequence type parameters.
txName
String
Included in the paramValueBindings object.
Name of the Sequence transformation.
initialValue
String
Included in the paramValueBindings object.
Initial value of the Sequence transformation.
value
String
Included in the paramValueBindings object.
Current value of the Sequence transformation.
POST request
To create a dynamic mapping task, use the following URI:
/batch-mapping/api/v1/dynamictask
If you want to specify a location for the task, include the container ID as a query parameter in the request. If the container ID isn't included in the request, the task is created in the Default folder. You can find the container ID for a project or folder in the Data Integration user interface. On the Explore page, select the folder. In the URL, the last string of characters in the container ID.
For example, in the following URL, the container ID is dH2DuGJYda7ijgW4Sm32sR:
When you use the REST API to run a dynamic mapping task, use the REST API version 1 job resource to start or stop the job. You can also get details about the job.
Do not use the platform REST API version 2 job resource to get the status of a dynamic mapping task.
If your organization uses projects and folders, use the REST API version 3 lookup resource to retrieve the task ID. This ID is the federated task ID, which you must include in the POST request.
GET request
To get details of a dynamic mapping task run, use the following URI: