REST API Reference > Platform REST API version 2 resources > Activity logs
  

Activity logs

You can use the REST API to request log information for completed and running jobs.

Logs for completed jobs

Use this resource to request log information for completed jobs from the Monitor service. You can also request error logs and session logs. To request log information for jobs that are running, use the activityMonitor resource.

GET Request

You can request all of the log information or filter the log response. To request information from the log, use the following URI:
/api/v2/activity/activityLog
To request information for a specific log ID, use the following URI:
/api/v2/activity/activityLog/<id>
To request information for a specific run ID, include the run ID and task ID in the following URI:
/api/v2/activity/activityLog?runId=<runId>&taskId=<taskId>
Note: The task ID is required whenever the run ID is included in a request.
To request information for a specific task, include the task ID in the following URI:
/api/v2/activity/activityLog?taskId=<taskId>
To specify the number of rows to skip, use the following URI:
/api/v2/activity/activityLog?offset=<offset>
To specify a row limit, use the following URI:
/api/v2/activity/activityLog?rowLimit=<rowLimit>
You can use any combination of these options. For example, you can use the following URI:
/api/v2/activity/activityLog?offset=<offset>&rowLimit=<rowLimit>&taskId=<taskId>&runId=<runId>
You can also use the activityLog resource to get a session log. To get a session log, use the following URI:
/api/v2/activity/activityLog/<id>/sessionLog
You can use the following optional attributes in the activityLog GET URI:
Field
Description
id
Log entry ID.
Include this attribute if you want to receive information for a specific ID.
runId
Job ID associated with the log entry ID. Whenever runId is included in a request, taskId is required.
taskId
Task ID associated with the log entry ID. If taskId is not specified, all activityLog entries for all tasks are returned.
offset
The number of rows to skip. For example, you might want to skip the first three rows.
rowLimit
The maximum number of rows to return. The maximum number you can specify is 1000.
If you omit this attribute, the activityLog returns all available rows, up to a maximum of 200 rows.

GET Response

Returns an activityLogEntry object for each row in the log or returns an activityLogEntry object for the specified ID. Returns the error object if errors occur.
When you request information for each row in the log, the activityLogEntry object includes the following attributes:
Field
Type
Description
id
String
Log entry ID.
type
String
The type of task. For Data Integration, returns one of the following codes:
  • - DMASK. Masking task.
  • - DRS. Replication task.
  • - DSS. Synchronization task.
  • - MTT. Mapping task.
  • - PCS. PowerCenter task.
  • - WORKFLOW. Linear taskflow.
objectId
String
Task ID.
objectName
String
Name of the task.
runId
Long
ID for the task run.
agentId
String
Agent that runs the task.
runtimeEnvironmentId
String
Runtime environment that runs the task.
startTime
Date/time
Start time for the task or linear taskflow. Uses Eastern Time Zone (ET).
endTime
Date/time
End time for the task or linear taskflow. Uses Eastern Time Zone (ET).
startTimeUtc
Date/time
Start time for the task or linear taskflow. Uses Coordinated Universal Time (UTC).
endTimeUtc
Date/time
End time for the task or linear taskflow. Uses Coordinated Universal Time (UTC).
state
Short
Indicates whether the task completed successfully. Returns one of the following codes:
  • - 1. The task completed successfully.
  • - 2. The task completed with errors.
  • - 3. The task failed to complete.
failedSourceRows
Long
Number of rows that the task failed to read from the source.
successSourceRows
Long
Number of rows that the task successfully read from the source.
failedTargetRows
Long
Number of rows that the task failed to write to the target.
successTargetRows
Long
Number of rows that the task successfully wrote to the target.
scheduleName
String
Schedule name, if task was initiated by a schedule.
entries
Indicates the start of information for a child object.
The entries object includes activityLogEntry child objects. The child objects include the following attributes:
Field
Type
Description
id
String
Activity log entry item ID.
Note: You can't use the ID from an activityLogEntry child object to request information for a specific log.
type
String
The type of task. For Data Integration, returns one of the following codes:
  • - DMASK. Masking task.
  • - DRS. Replication task.
  • - DSS. Synchronization task.
  • - MTT. Mapping task.
  • - PCS. PowerCenter task.
  • - WORKFLOW. Linear taskflow.
objectName
String
Name of the task.
runId
String
ID for the task run.
agentId
String
Agent that runs the task.
runtimeEnvironmentId
String
Runtime environment that runs the task.
startTime
Date/time
Start time for the task or linear taskflow. Uses Eastern Time Zone (ET).
endTime
Date/time
End time for the task or linear taskflow. Uses Eastern Time Zone (ET).
startTimeUtc
Date/time
Start time for the task or linear taskflow. Uses Coordinated Universal Time (UTC).
endTimeUtc
Date/time
End time for the task or linear taskflow. Uses Coordinated Universal Time (UTC).
state
Short
Indicates whether the task completed successfully. Returns one of the following codes:
  • - 1. The task completed successfully.
  • - 2. The task completed with errors.
  • - 3. The task failed to complete.
  • - 4. The task has not started.
UIState
Short
Used for internal purposes only.
failedSourceRows
Long
Number of rows that the task failed to read from the source.
successSourceRows
Long
Number of rows that the task successfully read from the source.
failedTargetRows
Long
Number of rows that the task failed to write to the target.
successTargetRows
Long
Number of rows that the task successfully wrote to the target.
errorMsg
String
Error message associated with the job.
startedBy
String
User who started the task.
runContextType
String
Method through which the task was initiated. Returns one of the following options:
  • - ICS_UI. Task was initiated through the user interface.
  • - SCHEDULER. Task was initiated through the task scheduler.
  • - REST-API. Task was initiated through the REST API.
  • - OUTBOUND MESSAGE. Task was initiated through an outbound message.
entries
Indicates the start of information for a child object.
subTaskEntries
Indicates the start of information for subtask child objects.
logEntryItemAttrs
Indicates the start of metadata about the task, including the task's location and the number compute units the job consumed.
sessionVariables
Indicates the start of advanced session properties provided in the task.
totalSuccessRows
Long
Total number of rows that were successfully read from the source and written to the target.
totalFailedRows
Long
Total number of rows that were not read from the source and written to the target.
stopOnError
Boolean
Determines the runtime environment action to take when a nonfatal error occurs. Includes the following values:
  • - True. The linear taskflow stops when an error occurs.
  • - False. The linear taskflow continues to process when an error occurs.
hasStopOnErrorRecord
Boolean
Indicates whether the task encountered an error and stopped.
contextExternalId
String
Task ID of the parent object.
isStopped
Boolean
Indicates whether the task was stopped by the user. A value of true is possible if the task completed with errors or failed to complete.
transformationEntries
Includes information in an entry object for each transformation.
When you request log information for a specific ID, the activityLogEntry object includes the following attributes:
Field
Type
Description
id
String
Log entry ID.
type
String
The type of task. For Data Integration, returns one of the following codes:
  • - DMASK. Masking task.
  • - DRS. Replication task.
  • - DSS. Synchronization task.
  • - MTT. Mapping task.
  • - PCS. PowerCenter task.
  • - WORKFLOW. Linear taskflow.
objectId
String
Task ID.
objectName
String
Name of the task.
runId
String
ID for the task run.
agentId
String
Agent that runs the task.
runtimeEnvironmentId
String
Runtime environment where the task runs.
startTime
Date/time
Start time for the task or linear taskflow. Uses Eastern Time Zone (ET).
endTime
Date/time
End time for the task or linear taskflow. Uses Eastern Time Zone (ET).
startTimeUtc
Date/time
Start time for the task or linear taskflow. Uses Coordinated Universal Time (UTC).
endTimeUtc
Date/time
End time for the task or linear taskflow. Uses Coordinated Universal Time (UTC).
state
Short
Indicates whether the task completed successfully. Returns one of the following codes:
  • - 1. The task completed successfully.
  • - 2. The task completed with errors.
  • - 3. The task failed to complete.
  • - 4. The task has not started.
UIState
Short
Used for internal purposes only.
isStopped
Boolean
Indicates whether the task was stopped by the user. A value of true is possible if the task completed with errors or failed to complete.
failedSourceRows
Long
Number of rows that the task failed to read from the source.
successSourceRows
Long
Number of rows that the task successfully read from the source.
failedTargetRows
Long
Number of rows that the task failed to write to the target.
successTargetRows
Long
Number of rows that the task successfully wrote to the target.
errorMsg
String
Error message associated with the job.
startedBy
String
User who started the task.
runContextType
String
Method through which the task was initiated. Returns one of the following options:
  • - UI. Task was initiated through the user interface.
  • - SCHEDULER. Task was initiated through the task scheduler.
  • - REST-API. Task was initiated through the REST API.
  • - OUTBOUND MESSAGE. Task was initiated through an outbound message.
scheduleName
String
Schedule name, if task was initiated by a schedule.
orgId
String
Organization ID.
totalSuccessRows
Long
Total number of rows that were successfully read from the source and written to the target.
totalFailedRows
Long
Total number of rows that were not read from the source and written to the target.
logFilename
String
The name of the generated log file.
errorFilename
String
The name of the generated error file.
errorFileDir
String
The location of the error file on the Secure Agent machine.
connType
String
Connection type.
stopOnError
Boolean
Determines the runtime environment action to take when a nonfatal error occurs. Includes the following values:
  • - True. The linear taskflow stops when an error occurs.
  • - False. The linear taskflow continues to process when an error occurs.
items
Includes an activityLogEntryItem object for each task.
type
String
Included in the activityLogEntryItem object.
The type of task. For Data Integration, returns one of the following codes:
  • - DMASK. Masking task.
  • - DRS. Replication task.
  • - DSS. Synchronization task.
  • - MTT. Mapping task.
  • - PCS. PowerCenter task.
  • - WORKFLOW. Linear taskflow.
objectId
String
Included in the activityLogEntryItem object.
Task ID.
objectName
String
Included in the activityLogEntryItem object.
Name of the task.
runId
String
Included in the activityLogEntryItem object.
ID for the task run.
agentId
String
Included in the activityLogEntryItem object.
Agent that ran the task.
runtimeEnvironmentId
String
Included in the activityLogEntryItem object.
Runtime environment where the task ran.
startTime
Date/time
Included in the activityLogEntryItem object.
Start time for the task or linear taskflow. Uses Eastern Time Zone (ET).
endTime
Date/time
Included in the activityLogEntryItem object.
End time for the task or linear taskflow. Uses Eastern Time Zone (ET).
state
String
Included in the activityLogEntryItem object.
Indicates whether the task completed successfully. Returns one of the following codes:
  • - 1. The task completed successfully.
  • - 2. The task completed with errors.
  • - 3. The task failed to complete.
isStopped
Boolean
Included in the activityLogEntryItem object.
Indicates whether the task was stopped by the user. A value of true is possible if the task completed with errors or failed to complete.
errorMsg
String
Included in the activityLogEntryItem object.
Error message associated with the job.
connType
String
Included in the activityLogEntryItem object.
Connection type.
children
String
Included in the activityLogEntryItem object.
Returns an activityLogEntryItem object for each table in the linear taskflow.
startedBy
String
User who started the task.
runContextType
String
Method through which the task was initiated. Returns one of the following options:
  • - UI. Task was initiated through the user interface.
  • - SCHEDULER. Task was initiated through the task scheduler.
  • - REST-API. Task was initiated through the REST API.
  • - OUTBOUND MESSAGE. Task was initiated through an outbound message.
scheduleName
String
Schedule name, if task was initiated by a schedule.
transformationEntries
Includes information in a transformationLogEntry object for each transformation.
id
String
Included in the transformationLogEntry object.
Transformation ID.
txName
String
Included in the transformationLogEntry object.
Transformation name.
For target transformations, returns the target object name.
txType
String
Included in the transformationLogEntry object.
Transformation type.
successRows
Long
Included in the transformationLogEntry object.
Number of successful rows for the transformation.
affectedRows
Long
Included in the transformationLogEntry object.
Number of rows affected by the defined task operation.
Applies to target transformations in data transfer tasks and mapping tasks based on mappings that are not configured for full SQL ELT optimization. Doesn't apply to mappings in SQL ELT mode or advanced mappings.
failedRows
Long
Included in the transformationLogEntry object.
Number of failed rows for the transformation.
sequenceValues
Returns information generated from a task that includes the sequence generator transformation. Includes a sequenceValueLogEntry object for each transformation.
txName
String
Included in the sequenceValueLogEntry object.
Transformation name.
For target transformations, returns the target object name.
nextValue
String
Included in the sequenceValueLogEntry object.
The last value generated by the task.
inOutParameterValues
The in-out parameter values used in the task. Includes an inOutParameterValueLogEntry for each parameter.
name
String
Included in the inOutParameterValueLogEntry object.
Parameter name.
value
String
Included in the inOutParameterValueLogEntry object.
Parameter value.

GET Example

To request 20 rows of information returned from the log in JSON format, you might use the following request:
GET <serverUrl>/api/v2/activity/activityLog?rowLimit=20 HTTP/1.0
Accept:application/json
icSessionId: <icSessionId>
A successful request returns a list: an activityLogEntry object for each entry returned from the log.
The following text is a sample return in JSON:
[
{
"@type": "activityLogEntry",
"id": "000001C100000000000C",
"type": "DRS",
"objectName": "drstask1",
"runId": 1,
"runtimeEnvironmentId": "00000C25000000000002",
"startTime": "2012-07-30T13:30:30.000Z",
"endTime": "2012-07-30T13:32:30.000Z",
"state": 1,
"failedSourceRows": 0,
"successSourceRows": 39,
"failedTargetRows": 0,
"successTargetRows": 39,
"errorMsg": null,
"entries": [
{
"@type": "activityLogEntry",
"id": "128964732",
"type": "DRS",
"objectName": "Contact",
"runId": 0,
"runtimeEnvironmentId": "00000C25000000000002",
"agentId: "01000008000000000006",
"startTime": "2012-07-30T13:32:31.000Z",
"endTime": "2012-07-30T13:35:31.000Z",
"state": 1,
"isStopped": FALSE,
"failedSourceRows": 0,
"successSourceRows": 39,
"failedTargetRows": 0,
"successTargetRows": 39,
"errorMsg": "No errors encountered.",
"entries": []
},
]
},
{
"@type": "activityLogEntry",
"id": "010000C1000000000PGP",
"type": "MTT_TEST",
"objectId": "0100000Z00000000001N",
"objectName": "Mapping-MultiSource",
"runId": 12,
"startTime": "2020-03-27T08:05:56.000Z",
"endTime": "2020-03-27T08:06:07.000Z",
"startTimeUtc": "2020-03-27T12:05:56.000Z",
"endTimeUtc": "2020-03-27T12:06:07.000Z",
"state": 2,
"failedSourceRows": 0,
"successSourceRows": 800,
"failedTargetRows": 200,
"successTargetRows": 600,
"startedBy": "di@infa.com",
"runContextType": "ICS_UI",
"entries": [
{
"@type": "activityLogEntry",
"id": "118964723",
"type": "MTT_TEST",
"objectName": "",
"runId": 12,
"agentId": "01000008000000000004",
"runtimeEnvironmentId": "01000025000000000004",
"startTime": "2020-03-27T08:05:56.000Z",
"endTime": "2020-03-27T08:06:07.000Z",
"startTimeUtc": "2020-03-27T12:05:56.000Z",
"endTimeUtc": "2020-03-27T12:06:07.000Z",
"state": 2,
"failedSourceRows": 0,
"successSourceRows": 800,
"failedTargetRows": 200,
"successTargetRows": 600,
"errorMsg": null,
"startedBy": "di@infa.com",
"runContextType": "ICS_UI",
"entries": [],
"subTaskEntries": [],
"logEntryItemAttrs": {
"CONSUMED_COMPUTE_UNITS": "0.0",
"ERROR_CODE": "0",
"IS_SERVER_LESS": "false",
"REQUESTED_COMPUTE_UNITS": "0.0",
"Session Log File Name": "s_mtt_0Sr7LdcbAG2ldG33Lp8koQ_2.log"
},
"totalSuccessRows": 0,
"totalFailedRows": 0,
"stopOnError": false,
"hasStopOnErrorRecord": false,
"contextExternalId": "0100000Z00000000001N",
"transformationEntries": [
{
"@type": "transformationLogEntry",
"id": "141332309",
"txName": "FFSource2",
"txType": "SOURCE",
"successRows": 600,
"failedRows": 0
},
{
"@type": "transformationLogEntry",
"id": "141332310",
"txName": "FFSource1",
"txType": "SOURCE",
"successRows": 200,
"failedRows": 0
},
{
"@type": "transformationLogEntry",
"id": "141332311",
"txName": "FFTarget.csv",
"txType": "TARGET",
"successRows": 600,
"affectedRows": 600,
"failedRows": 0
},
{
"@type": "transformationLogEntry",
"id": "141332312",
"txName": "MYSQLTarget",
"txType": "TARGET",
"successRows": 0,
"affectedRows": 0,
"failedRows": 200
}
]
}
]
}
]

Note: If you request log information for a job that includes both Data Integration Server and advanced cluster subtasks, the response contains a transformation log entry for a temporary target.

Error Log Requests

You can request an error log from the server.
To request an error log from the server for a specific log ID, use the following URI:
/api/v2/activity/errorLog/id
To retrieve an error log from the server, you might use the following request:
GET <server URL>/api/v2/activity/errorLog/000002C10000000002BG HTTP/1.0
Accept:application/json
icSessionId: <icSessionId>
The server returns the error log as a string, as shown in the following example:
"Col1","Col2","Error"

"05/11/2015 00:00:00.000000000","05/11/2015 00:00:00.000000000","ERROR: Target table [test] has no keys specified."

"05/11/2015 00:00:00.000000000","05/11/2015 00:00:00.000000000","ERROR: Target table [test] has no keys specified."

"05/11/2015 00:00:00.000000000","05/11/2015 00:00:00.000000000","ERROR: Target table [test] has no keys specified."

"05/11/2015 00:00:00.000000000","05/11/2015 00:00:00.000000000","ERROR: Target table [test] has no keys specified."

"05/11/2015 00:00:00.000000000","05/11/2015 00:00:00.000000000","ERROR: Target table [test] has no keys specified."

Session Log Requests

You can download session logs for all task types using the sessionLog API. For tasks that have subtasks such as replication tasks and linear taskflows, you can download a ZIP file that contains all of the session logs in the hierarchy. For replication tasks, which have two levels of tasks, you can specify an itemId to return a session log for a subtask if you do not want all of the session logs. For linear taskflows, which have three levels of tasks, you can specify an itemId or childItemId to return a session log for a particular subtask.
Use the following URI to download session logs:
/saas/api/v2/activity/activityLog/<Top_Level_Log_Entry_Id>/sessionLog?itemId=<child-log-entry-item-id>&childItemId=<child-log-entry-item-id>
The following example requests include a request for a specific session log and requests for session logs for subtasks:

Logs for running jobs

Use this resource to request log information for running jobs from the Monitor service. To request log information for completed jobs, use the activityLog resource.

GET Request

To request log information about running jobs, use the following URI:
/api/v2/activity/activityMonitor?details=<true|false>
You can use the following attribute in the activityMonitor GET URI:
details
Optional.
Log detail to be returned from Informatica Intelligent Cloud Services. Use one of the following options:
Default is false. If you omit this optional attribute, Monitor does not return additional details.

GET Response

Returns an activityMonitorEntry object for each row in the log. Returns the error object if errors occur.
The activityMonitorEntry object includes the following GET response attributes:
Field
Type
Description
id
String
Log entry ID.
type
String
The type of task. Returns one of the following codes:
  • - DMASK. Masking task.
  • - DRS. Replication task.
  • - DSS. Synchronization task.
  • - MAPPING. Job type of the sub job when you run a dynamic mapping task.
  • - MTT. Mapping task.
  • - MTT_DP. Job type when you run data preview for a mapping.
  • - MTT_DP_CDIE. Job type when you run data preview for a mapping in advanced mode.
  • - MTT_TEST. Job type when you use the Run button in the Mapping Designer.
  • - PCS. PowerCenter task.
  • - WORKFLOW. Linear taskflow.
taskId
String
Task ID.
taskName
String
Task name.
objectName
String
Source object used in the task, or the replication object being processed.
runId
Long
ID for the task run.
startTime
Date/time
Start time for the task or linear taskflow. Uses Eastern Time Zone (ET).
endTime
Date/time
End time for the task or linear taskflow. Uses Eastern Time Zone (ET).
executionState
String
State of the task. Returns one of the following codes:
  • - QUEUED
  • - INITIALIZED
  • - RUNNING
  • - STOPPING
  • - FAILED
FAILED can be returned for linear taskflow subtasks only.
failedSourceRows
Long
Number of rows that were not read from the source.
successSourceRows
Long
Number of rows that were successfully read from the source.
failedTargetRows
Long
Number of rows that were not written to the target.
successTargetRows
Long
Number of rows that were successfully written to the target.
errorMsg
String
Error message associated with the job.
entries
Indicates the start of information for a child object. A child object might be a task within a linear taskflow, or an object in a replication task.
agentId
String
Agent used for the activity.
runtimeEnvironmentId
String
Runtime environment used for the activity.
startedBy
String
User who started the task.
runContextType
String
Method through which the task was initiated. Includes the following values:
  • - UI. Task was initiated through the Data Integration user interface.
  • - SCHEDULER. Task was initiated through the task scheduler.
  • - REST-API. Task was initiated through the REST API.
  • - OUTBOUND MESSAGE. Task was initiated through an outbound message.
scheduleName
String
Schedule name, if task was initiated by a schedule.
callbackURL
String
Status of the job.

GET Example

To return log information including details about child objects in XML, you might use the following request:
GET <serverUrl>/api/v2/activity/activityMonitor?details=true
Content-Type: application/xml
Accept: application/xml
icSessionId: <icSessionId>
A successful request returns an activityMonitorEntry object for each item returned from Monitor.
The following text is a sample return in XML:
<root>
<activityMonitorEntry>
<id>000001C100000000000D</id>
<type>DSS</type>
<objectName>dss-f2f</objectName>
<runId>0</runId>
<startTime>2012-07-30T13:30:00.000Z</startTime>
<endTime></endTime>
<executionState>RUNNING</executionState>
<failedSourceRows>0</failedSourceRows>
<successSourcerows>938</successSourceRows>
<failedTargetRows>0</failedTargetRows>
<successTargetRows>596</successTargetRows>
<errorMsg> </errorMsg>
<entries> </entries>
<agentId>00000C08000000000003</agentId>
<runtimeEnvironmentId>00000C25000000000002</runtimeEnvironmentId>
</activityMonitorEntry>
<activityMonitorEntry>
<id>000001C500000000000L</id>
<type>PCS</type>
<objectName>pcs-lookup</objectName>
<runId>2</runId>
<startTime>2012-07-30T13:30:03.001Z</startTime>
<endTime>2012-07-30T13:30:03.010Z</endTime>
<executionState>COMPLETE</executionState>
<failedSourceRows>0</failedSourceRows>
<successSourcerows>688</successSourceRows>
<failedTargetRows>0</failedTargetRows>
<successTargetRows>688</successTargetRows>
<errorMsg> </errorMsg>
<entries> </entries>
<agentId>00000C08000000000003</agentId>
<runtimeEnvironmentId>00000C25000000000002</runtimeEnvironmentId>
</activityMonitorEntry>
</root>