Communities
A collaborative platform to connect and grow with like-minded Informaticans across the globe
Product Communities
Connect and collaborate with Informatica experts and champions
Discussions
Have a question? Start a Discussion and get immediate answers you are looking for
User Groups
Customer-organized groups that meet online and in-person. Join today to network, share ideas, and get tips on how to get the most out of Informatica
Get Started
Community Guidelines
Knowledge Center
Troubleshooting documents, product guides, how to videos, best practices, and more
Knowledge Base
One-stop self-service portal for solutions, FAQs, Whitepapers, How Tos, Videos, and more
Support TV
Video channel for step-by-step instructions to use our products, best practices, troubleshooting tips, and much more
Documentation
Information library of the latest product documents
Velocity (Best Practices)
Best practices and use cases from the Implementation team
Learn
Rich resources to help you leverage full capabilities of our products
Trainings
Role-based training programs for the best ROI
Certifications
Get certified on Informatica products. Free, Foundation, or Professional
Product Learning Paths
Free and unlimited modules based on your expertise level and journey
Resources
Library of content to help you leverage the best of Informatica products
Tech Tuesdays Webinars
Most popular webinars on product architecture, best practices, and more
Product Availability Matrix
Product Availability Matrix statements of Informatica products
SupportFlash
Monthly support newsletter
Support Documents
Informatica Support Guide and Statements, Quick Start Guides, and Cloud Product Description Schedule
Product Lifecycle
End of Life statements of Informatica products
Ideas
Events
Change Request Tracking
Marketplace
English
  • Administrator
  • All Products

Table of Contents

Search

  1. Preface
  2. Informatica Intelligent Cloud Services REST API
  3. Platform REST API version 2 resources
  4. Platform REST API version 3 resources
  5. Data Integration REST API
  6. File Ingestion and Replication REST API
  7. Streaming Ingestion and Replication REST API
  8. Model Serve REST API
  9. RunAJob utility
  10. ParamSetCli utility
  11. REST API codes
  12. REST API resource quick references

REST API Reference

REST API Reference

Back Next

Logs for completed 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>
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.
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
                    }
                ]
            }
        ]
    }
]
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:
  • To request a session log, which may return a ZIP file if the task is a
    replication
     task or linear taskflow, you might use the following request: 
    /saas/api/v2/activity/activityLog/000001C1000000000591/sessionLog
  • To request a session log for a particular subtask for a
    replication
     task or linear taskflow, you might use the following request: 
    /saas/api/v2/activity/activityLog/000001C1000000000591/sessionLog?itemId=233
  • To request a session log for a sub-subtask in a linear taskflow, you might use the following request: 
    /saas/api/v2/activity/activityLog/000001C1000000000591/sessionLog?itemId=233&childItemId=234
0 COMMENTS
We’d like to hear from you!