Skip to main content

Server Operations Web Services - Export and Import

Universal Controller supports the following RESTful-based web services for Export and Import Server Operations, which are listed alphabetically on this page.

Formatting specifications for each web service, including details about parameter requirements, are provided.

Bulk Export​

Description

URI

http://host_name/uc/resources/serveroperation/bulkexport

HTTP Method

POST

Description

Performs a Bulk Export server operation.

Example URI

http://localhost:8080/uc/resources/serveroperation/bulkexport

Authentication

HTTP Basic

Consumes Content-Type

n/a

Produces Content-Type

application/xml, application/json

Example Response

See Bulk Export Example Response.

Response Properties

See Bulk Export: Response Properties.

Bulk Export: Example Response​

JSON Response
JSON Response
{
  "operation": "Bulk Export",
  "success": true,
  "output": "Bulk export completed successfully.\nBulk exporting table: ops_abort_action\nNo records exported for table ops_abort_action.
...
\nBulk exporting table: ops_backup\nBulk exporting 3 record(s) to file \"D:\\tomcat\\uc_export\\Tue_Jun_19_14_27_17_EDT_2018-BULK_EXPORT\\ops_backup.xml\".
\nBulk exporting table: ops_bundle\nNo records exported for table ops_bundle.
...
\nBulk exporting table: ops_calendar\nBulk exporting 1 record(s) to file \"D:\\tomcat\\uc_export\\Tue_Jun_19_14_27_17_EDT_2018-BULK_EXPORT\\ops_calendar.xml\".
\nBulk exporting table: ops_config\nBulk exporting 134 record(s) to file \"D:\\tomcat\\uc_export\\Tue_Jun_19_14_27_17_EDT_2018-BULK_EXPORT\\ops_config.xml\".
\nBulk exporting table: ops_credentials\nNo records exported for table ops_credentials.
...
\nBulk exporting table: ops_task_manual\nBulk exporting 1 record(s) to file \"D:\\tomcat\\uc_export\\Tue_Jun_19_14_27_17_EDT_2018-BULK_EXPORT\\ops_task_manual.xml\".
\nBulk exporting table: ops_task_monitor\nNo records exported for table ops_task_monitor.
...
\nBulk exporting table: ops_task_sleep\nBulk exporting 3 record(s) to file \"D:\\tomcat\\uc_export\\Tue_Jun_19_14_27_17_EDT_2018-BULK_EXPORT\\ops_task_sleep.xml\".
\nBulk exporting table: ops_task_sql\nNo records exported for table ops_task_sql.
...
\nBulk exporting table: ops_trigger_manual\nBulk exporting 1 record(s) to file \"D:\\tomcat\\uc_export\\Tue_Jun_19_14_27_17_EDT_2018-BULK_EXPORT\\ops_trigger_manual.xml\".
\nBulk exporting table: ops_trigger_temp\nNo records exported for table ops_trigger_temp.
...
\nBulk exporting table: ops_unix_agent_cluster\nBulk exporting 1 record(s) to file \"D:\\tomcat\\uc_export\\Tue_Jun_19_14_27_17_EDT_2018-BULK_EXPORT\\ops_unix_agent_cluster.xml\".
\nBulk exporting table: ops_unix_agent_cluster_join\nNo records exported for table ops_unix_agent_cluster_join.
...
\nBulk exporting table: ops_windows_agent_cluster\nBulk exporting 1 record(s) to file \"D:\\tomcat\\uc_export\\Tue_Jun_19_14_27_17_EDT_2018-BULK_EXPORT\\ops_windows_agent_cluster.xml\".
\nBulk exporting table: ops_win_agent_cluster_join\nNo records exported for table ops_win_agent_cluster_join.
...
\nBulk exporting table: ops_group_has_role\nBulk exporting 6 record(s) to file \"D:\\tomcat\\uc_export\\Tue_Jun_19_14_27_17_EDT_2018-BULK_EXPORT\\ops_group_has_role.xml\".
\nBulk exporting table: ops_user\nBulk exporting 1 record(s) to file \"D:\\tomcat\\uc_export\\Tue_Jun_19_14_27_17_EDT_2018-BULK_EXPORT\\ops_user.xml\".
\nBulk exporting table: ops_user_grmember\nBulk exporting 1 record(s) to file \"D:\\tomcat\\uc_export\\Tue_Jun_19_14_27_17_EDT_2018-BULK_EXPORT\\ops_user_grmember.xml\".
\nBulk exporting table: ops_user_group\nBulk exporting 2 record(s) to file \"D:\\tomcat\\uc_export\\Tue_Jun_19_14_27_17_EDT_2018-BULK_EXPORT\\ops_user_group.xml\".
\nBulk exporting table: ops_user_has_role\nBulk exporting 25 record(s) to file \"D:\\tomcat\\uc_export\\Tue_Jun_19_14_27_17_EDT_2018-BULK_EXPORT\\ops_user_has_role.xml\".
\nBulk exporting table: ops_permission\nBulk exporting 8 record(s) to file \"D:\\tomcat\\uc_export\\Tue_Jun_19_14_27_17_EDT_2018-BULK_EXPORT\\ops_permission.xml\".
\nBulk exporting table: ops_user_preference\nNo records exported for table ops_user_preference.
...
\nBulk exporting table: ops_nav_tree_pref\nBulk exporting 1 record(s) to file \"D:\\tomcat\\uc_export\\Tue_Jun_19_14_27_17_EDT_2018-BULK_EXPORT\\ops_nav_tree_pref.xml\".
\nBulk exporting table: ops_ldap\nBulk exporting 1 record(s) to file \"D:\\tomcat\\uc_export\\Tue_Jun_19_14_27_17_EDT_2018-BULK_EXPORT\\ops_ldap.xml\".
\nBulk exporting table: ops_ldap_mapping\nBulk exporting 13 record(s) to file \"D:\\tomcat\\uc_export\\Tue_Jun_19_14_27_17_EDT_2018-BULK_EXPORT\\ops_ldap_mapping.xml\".
\nBulk exporting table: ops_single_sign_on\nBulk exporting 2 record(s) to file \"D:\\tomcat\\uc_export\\Tue_Jun_19_14_27_17_EDT_2018-BULK_EXPORT\\ops_single_sign_on.xml\".
\nBulk exporting table: ops_chart_color\nBulk exporting 26 record(s) to file \"D:\\tomcat\\uc_export\\Tue_Jun_19_14_27_17_EDT_2018-BULK_EXPORT\\ops_chart_color.xml\".
\nBulk exporting table: ops_widget_activity\nNo records exported for table ops_widget_activity.
...
\nBulk exporting table: ops_dashboard\nBulk exporting 1 record(s) to file \"D:\\tomcat\\uc_export\\Tue_Jun_19_14_27_17_EDT_2018-BULK_EXPORT\\ops_dashboard.xml\".
\nBulk exporting table: ops_dashboard_portlet\nNo records exported for table ops_dashboard_portlet.
...
.\nBulk exporting table: ops_unv_tmplt_field_choice\nNo records exported for table ops_unv_tmplt_field_choice.\n",
  "path":  "D:\\tomcat\\uc_export\\Fri_Jun_15_14_27_29_EDT_2018-BULK_EXPORT"
}

Bulk Export with Versions​

Description

URI

http://host_name/uc/resources/serveroperation/bulkexportwithversions

HTTP Method

POST

Description

Performs a Bulk Export with Versions server operation.

Example URI

http://localhost:8080/uc/resources/serveroperation/bulkexportwithversions

Authentication

HTTP Basic

Consumes Content-Type

n/a

Produces Content-Type

application/xml, application/json

Example Response

See Bulk Export with Versions: Example Response.

Response Properties

See Bulk Export: Response Properties.

Bulk Export with Versions: Example Response​

JSON Response
JSON Response
{
  "operation": "Bulk Export",
  "success": true,
  "output": "Bulk export with versions completed successfully.
\nBulk exporting table: ops_abort_action\nNo records exported for table ops_abort_action.
...
\nBulk exporting table: ops_backup\nBulk exporting 3 record(s) to file \"D:\\tomcat\\uc_export\\Tue_Jun_19_14_29_43_EDT_2018-BULK_EXPORT\\ops_backup.xml\".
\nBulk exporting table: ops_bundle\nNo records exported for table ops_bundle.
...
\nBulk exporting table: ops_calendar\nBulk exporting 1 record(s) to file \"D:\\tomcat\\uc_export\\Tue_Jun_19_14_29_43_EDT_2018-BULK_EXPORT\\ops_calendar.xml\".
\nBulk exporting table: ops_config\nBulk exporting 134 record(s) to file \"D:\\tomcat\\uc_export\\Tue_Jun_19_14_29_43_EDT_2018-BULK_EXPORT\\ops_config.xml\".
\nBulk exporting table: ops_credentials\nNo records exported for table ops_credentials.
...
\nBulk exporting table: ops_task_manual\nBulk exporting 1 record(s) to file \"D:\\tomcat\\uc_export\\Tue_Jun_19_14_29_43_EDT_2018-BULK_EXPORT\\ops_task_manual.xml\".
\nBulk exporting table: ops_task_monitor\nNo records exported for table ops_task_monitor.
...
\nBulk exporting table: ops_task_sleep\nBulk exporting 3 record(s) to file \"D:\\tomcat\\uc_export\\Tue_Jun_19_14_29_43_EDT_2018-BULK_EXPORT\\ops_task_sleep.xml\".
\nBulk exporting table: ops_task_sql\nNo records exported for table ops_task_sql.
...
\nBulk exporting table: ops_trigger_manual\nBulk exporting 1 record(s) to file \"D:\\tomcat\\uc_export\\Tue_Jun_19_14_29_43_EDT_2018-BULK_EXPORT\\ops_trigger_manual.xml\".
\nBulk exporting table: ops_trigger_temp\nNo records exported for table ops_trigger_temp.
...
\nBulk exporting table: ops_unix_agent_cluster\nBulk exporting 1 record(s) to file \"D:\\tomcat\\uc_export\\Tue_Jun_19_14_29_43_EDT_2018-BULK_EXPORT\\ops_unix_agent_cluster.xml\".
....
\nBulk exporting table: ops_windows_agent_cluster\nBulk exporting 1 record(s) to file \"D:\\tomcat\\uc_export\\Tue_Jun_19_14_29_43_EDT_2018-BULK_EXPORT\\ops_windows_agent_cluster.xml\".
\nBulk exporting table: ops_win_agent_cluster_join\nNo records exported for table ops_win_agent_cluster_join.
...
\nBulk exporting table: ops_group_has_role\nBulk exporting 6 record(s) to file \"D:\\tomcat\\uc_export\\Tue_Jun_19_14_29_43_EDT_2018-BULK_EXPORT\\ops_group_has_role.xml\".
\nBulk exporting table: ops_user\nBulk exporting 1 record(s) to file \"D:\\tomcat\\uc_export\\Tue_Jun_19_14_29_43_EDT_2018-BULK_EXPORT\\ops_user.xml\".
\nBulk exporting table: ops_user_grmember\nBulk exporting 1 record(s) to file \"D:\\tomcat\\uc_export\\Tue_Jun_19_14_29_43_EDT_2018-BULK_EXPORT\\ops_user_grmember.xml\".
\nBulk exporting table: ops_user_group\nBulk exporting 2 record(s) to file \"D:\\tomcat\\uc_export\\Tue_Jun_19_14_29_43_EDT_2018-BULK_EXPORT\\ops_user_group.xml\".
\nBulk exporting table: ops_user_has_role\nBulk exporting 25 record(s) to file \"D:\\tomcat\\uc_export\\Tue_Jun_19_14_29_43_EDT_2018-BULK_EXPORT\\ops_user_has_role.xml\".
\nBulk exporting table: ops_permission\nBulk exporting 8 record(s) to file \"D:\\tomcat\\uc_export\\Tue_Jun_19_14_29_43_EDT_2018-BULK_EXPORT\\ops_permission.xml\".\nBulk exporting table: ops_user_preference\nNo records exported for table ops_user_preference.\nBulk exporting table: ops_list_grid_pref\nNo records exported for table ops_list_grid_pref.
\nBulk exporting table: ops_list_grid_pinfilter\nNo records exported for table ops_list_grid_pinfilter.
...
\nBulk exporting table: ops_nav_tree_pref\nBulk exporting 1 record(s) to file \"D:\\tomcat\\uc_export\\Tue_Jun_19_14_29_43_EDT_2018-BULK_EXPORT\\ops_nav_tree_pref.xml\".
\nBulk exporting table: ops_ldap\nBulk exporting 1 record(s) to file \"D:\\tomcat\\uc_export\\Tue_Jun_19_14_29_43_EDT_2018-BULK_EXPORT\\ops_ldap.xml\".
\nBulk exporting table: ops_ldap_mapping\nBulk exporting 13 record(s) to file \"D:\\tomcat\\uc_export\\Tue_Jun_19_14_29_43_EDT_2018-BULK_EXPORT\\ops_ldap_mapping.xml\".
\nBulk exporting table: ops_single_sign_on\nBulk exporting 2 record(s) to file \"D:\\tomcat\\uc_export\\Tue_Jun_19_14_29_43_EDT_2018-BULK_EXPORT\\ops_single_sign_on.xml\".
\nBulk exporting table: ops_chart_color\nBulk exporting 26 record(s) to file \"D:\\tomcat\\uc_export\\Tue_Jun_19_14_29_43_EDT_2018-BULK_EXPORT\\ops_chart_color.xml\".
\nBulk exporting table: ops_widget_activity\nNo records exported for table ops_widget_activity.
...
\nBulk exporting table: ops_dashboard\nBulk exporting 1 record(s) to file \"D:\\tomcat\\uc_export\\Tue_Jun_19_14_29_43_EDT_2018-BULK_EXPORT\\ops_dashboard.xml\".
\nBulk exporting table: ops_dashboard_portlet\nNo records exported for table ops_dashboard_portlet.
...
\nBulk exporting table: ops_task_manual_v\nBulk exporting 3 record(s) to file \"D:\\tomcat\\uc_export\\Tue_Jun_19_14_29_43_EDT_2018-BULK_EXPORT\\ops_task_manual_v.xml\".
\nBulk exporting table: ops_task_monitor_v\nNo records exported for table ops_task_monitor_v.
...
\nBulk exporting table: ops_trigger_manual_v\nBulk exporting 1 record(s) to file \"D:\\tomcat\\uc_export\\Tue_Jun_19_14_29_43_EDT_2018-BULK_EXPORT\\ops_trigger_manual_v.xml\".
\nBulk exporting table: ops_trigger_temp_v\nNo records exported for table ops_trigger_temp_v.
...
\nBulk exporting table: ops_zos_step_action_sysop_v\nNo records exported for table ops_zos_step_action_sysop_v.\n",
  "path":  "D:\\tomcat\\uc_export\\Fri_Jun_15_14_27_29_EDT_2018-BULK_EXPORT"
}

Bulk Export Activity​

Description

URI

http://host_name/uc/resources/serveroperation/bulkexportactivity

HTTP Method

POST

Description

Performs a Bulk Export Activity server operation.

Example URI

http://localhost:8080/uc/resources/serveroperation/bulkexportactivity

Authentication

HTTP Basic

Consumes Content-Type

n/a

Produces Content-Type

application/xml, application/json

Example Response

See Bulk Export: XML and JSON Examples.

Response Properties

See Bulk Export: Response Properties.

Bulk Export Activity: Example Response​

Success​

JSON Response
JSON Response
{
  "operation": "Bulk Export Activity",
  "success": true,
  "output": "Bulk export activity completed successfully.
\nBulk exporting table: ops_exec_workflow\nNo records exported for table ops_exec_workflow.
...
\nBulk exporting table: ops_exec_manual\nBulk exporting 13 record(s) to file \"D:\\tomcat\\uc_export\\Tue_Jun_19_14_36_08_EDT_2018-BULK_EXPORT\\ops_exec_manual.xml\".
\nBulk exporting table: ops_exec_email\nNo records exported for table ops_exec_email.
...
\nBulk exporting table: ops_map\nBulk exporting 13 record(s) to file \"D:\\tomcat\\uc_export\\Tue_Jun_19_14_36_08_EDT_2018-BULK_EXPORT\\ops_map.xml\".
\nBulk exporting table: ops_exec_to_resource\nNo records exported for table ops_exec_to_resource.
...
\nBulk exporting table: ops_zos_step_action_sysop\nNo records exported for table ops_zos_step_action_sysop.\n",
  "path": "D:\\tomcat\\uc_export\\Tue_Jun_19_14_36_08_EDT_2018-BULK_EXPORT"
}

Failure​

JSON Response
JSON Response
{
  "operation": "Bulk Export Activity",
  "success": false,
  "output": "Failed to complete bulk export activity due to error(s).\nBulk Export Activity not permitted; Universal Controller property \"Bulk Export Activity Permitted\" is not enabled.\n",
}

Bulk Export Audit​

Description

URI

http://host_name/uc/resources/serveroperation/bulkexportaudit

HTTP Method

POST

Description

Performs a Bulk Export Audit server operation.

Example URI

http://localhost:8080/uc/resources/serveroperation/bulkexportaudit

Authentication

HTTP Basic

Consumes Content-Type

n/a

Produces Content-Type

application/xml, application/json

Example Response

See Bulk Export: XML and JSON Examples.

Response Properties

See Bulk Export: Response Properties.

Bulk Export Audit: Example Response​

JSON Response
JSON Response
{
  "operation": "Bulk Export Audit",
  "success": true,
  "output": "Bulk export audit completed successfully.\nBulk exporting table: ops_audit\nBulk exporting 67 record(s) to file \"D:\\tomcat\\uc_export\\Tue_Jun_19_14_38_35_EDT_2018-BULK_EXPORT\\ops_audit.xml\".\n",
  "path":  "D:\\tomcat\\uc_export\\Fri_Jun_15_14_27_29_EDT_2018-BULK_EXPORT"
}

Bulk Export History​

Description

URI

http://host_name/uc/resources/serveroperation/bulkexporthistory

HTTP Method

POST

Description

Performs a Bulk Export History server operation.

Example URI

http://localhost:8080/uc/resources/serveroperation/bulkexporthistory

Authentication

HTTP Basic

Consumes Content-Type

n/a

Produces Content-Type

application/xml, application/json

Example Response

See Bulk Export: XML and JSON Examples.

Response Properties

See Bulk Export: Response Properties.

Bulk Export History: Example Response​

JSON Response
JSON Response
{
  "operation": "Bulk Export History",
  "success": true,
  "output": "Bulk export history completed successfully.\nBulk exporting table: ops_history\nNo records exported for table ops_history.\n",
  "path":  "D:\\tomcat\\uc_export\\Fri_Jun_15_14_27_29_EDT_2018-BULK_EXPORT"
}

Bulk Export: Response Properties​

Property

UI Field Name

Description

Specifications

operation

n/a

Server Operation that was performed.

success

n/a

Result of the Server Operation.

Boolean; Valid values: true/false.

output

n/a

Output of the server operation.

path

n/a

Directory containing the exported files.

Bulk Import​

Description

URI

http://host_name/uc/resources/serveroperation/bulkimport

HTTP Method

POST

Description

Performs a Bulk Import server operation.

URI Parameters

See Bulk Import: URI Parameters, below.

Example URI

http://localhost:8080/uc/resources/serveroperation/bulkimport?path=path

Authentication

HTTP Basic

Consumes Content-Type

n/a

Produces Content-Type

application/xml, application/json

Example Response

See Bulk Import Example Response.

Response Properties

See Bulk Import Response Properties.

Bulk Import: URI Parameters​

Name

Description

Specifications

Required

path

Directory containing the imported file(s).

Y

info

Some characters in the path parameter may need to be URL-encoded. For example, the backslash character in a Windows path may need to be encoded as %5C as shown below:

http://localhost:8080/uc/resources/serveroperation/bulkImport?path=D:%5Ctomcat%5Cuc_export%5CFri_Jun_15_14_17_33_EDT_2018-BULK_EXPORT

Bulk Import: Example Response​

JSON Response
JSON Response
{
"operation": "Bulk Import",
"success": true,
"output": "Bulk import completed successfully.\nProcessing bulk import directory \"D:\\tomcat\\uc_export\\Fri_Jun_15_14_17_33_EDT_2018-BULK_EXPORT\".\nBulk importing 1 file(s).\nBulk importing file: D:\\tomcat\\uc_export\\Fri_Jun_15_14_17_33_EDT_2018-BULK_EXPORT\\ops_audit.xml\n47 record(s) found in file ops_audit.xml.\n"
}

Bulk Import: Response Properties​

Property

UI Field Name

Description

Specifications

operation

n/a

Server Operation that was performed.

success

n/a

Result of the Server Operation.

Boolean; Valid values: true/false.

output

n/a

Output of the server operation.