Get all import jobs

get

https://{FusionAppsHost}/crmRestApi/atcProductCatalog/11.13.18.05/tmf-api/productCatalogManagement/v4/importJob

ImportJob Get

Request

Query Parameters
  • Represents the job request submitter name.
  • The comma-separated field names that are returned in the response. The field names are the names that you specify when you create or retrieve a resource.
  • Name of the file uploaded as part of job request
  • The unique identifier of the resource item.
  • The number of resources to be returned in the response. The minimum value that can be specified is 1, and the maximum value that can be specified is 100,000. If the specified value is greater than 100,000, then it defaults to 100,000.
  • The record number from which the retrieval starts. The default value is zero. If no value is specified, then it defaults to zero. The value zero indicates that the retrieval will start from the beginning of the collection.

There's no request body for this operation.

Back to Top

Response

Supported Media Types

200 Response

OK
Body ()
Root Schema : schema
Type: array
Show Source
Nested Schema : ImportJobOracle
Title: ImportJobOracle
Match All
Show Source
Nested Schema : ImportJob
Type: object
Title: ImportJob
Discriminator: @type

Discriminator Values

Show Source
Nested Schema : ImportJobOracle-allOf[1]
Type: object
Show Source
Nested Schema : importSummary
Type: object
Show Source
Nested Schema : resources
Type: array
Show Source
Nested Schema : ImportSummaryResource
Type: object
Title: ImportSummaryResource
This object holds imported resource details like name and count
Show Source

400 Response

Your request couldn't be processed because it contains missing or invalid information, such as a validation error on an input field, a missing required value, and so forth.
Body ()
Root Schema : Error
Type: object
Title: Error
Show Source

401 Response

Your request isn't authorized. The authentication credentials included with this request are missing or invalid.
Body ()
Root Schema : Error
Type: object
Title: Error
Show Source

404 Response

Your request includes a resource URI that doesn't exist.
Body ()
Root Schema : Error
Type: object
Title: Error
Show Source

500 Response

The server encountered something unexpected that prevented it from completing the request.
Body ()
Root Schema : Error
Type: object
Title: Error
Show Source

501 Response

The server doesn't support the functionality required to fulfill the request.
Body ()
Root Schema : Error
Type: object
Title: Error
Show Source
Back to Top

Examples

The following example shows how to get all import jobs by submitting a GET request on the REST resource using cURL.

curl -u username:password -X GET https://{FusionAppsHost}/crmRestApi/atcProductCatalog/11.13.18.05/tmf-api/productCatalogManagement/v4/importJob/

Example of Request Body

The following shows an example of the request body.

https://{OracleAppsHost}/crmRestApi/atcProductCatalog/11.13.18.05/tmf-api/productCatalogManagement/v4/importJob/

Example of Response Body

The following example shows the contents of the response body in JSON format.

[
    {
        "id": 174437,
        "@type": "ImportJobOracle",
        "contentType": "application/zip",
        "status": "ERROR",
        "fileName": "productOffering5000.zip",
        "createdBy": "booth",
        "path": "",
        "url": "v1/importFile/productOffering5000.zip",
        "errorLog": "Errors importing data for resource productOffering. 4900 error(s) occurred.\n, 100 record(s) rolled back.",
        "importSummary": {
            "id": 174437,
            "totalImportObjects": 1,
            "resources": [
                {
                    "name": "project",
                    "count": 1
                }
            ]
        },
        "errorLogUrl": "v1/importFile/174437.log",
        "creationDate": "2021-04-23 06:52:56.846",
        "completionDate": "2021-04-23 07:12:56.941",
        "href": "https://{OracleAppsHost}/crmRestApi/atcProductCatalog/11.13.18.05/tmf-api/productCatalogManagement/v4/importJob/174437"
    },
    {
        "id": 174415,
        "@type": "ImportJobOracle",
        "contentType": "application/json",
        "status": "SUCCEEDED",
        "fileName": "productOffering5.json",
        "createdBy": "booth",
        "path": "",
        "url": "v1/importFile/productOffering5.json",
        "importSummary": {
            "id": 174415,
            "totalImportObjects": 6,
            "resources": [
                {
                    "name": "project",
                    "count": 1
                },
                {
                    "name": "productOffering",
                    "count": 5
                }
            ]
        },
        "creationDate": "2021-04-23 06:45:28.281",
        "completionDate": "2021-04-23 06:46:59.196",
        "href": "https://{OracleAppsHost}/crmRestApi/atcProductCatalog/11.13.18.05/tmf-api/productCatalogManagement/v4/importJob/174415"
    },
    {
        "id": 174335,
        "@type": "ImportJobOracle",
        "contentType": "application/zip",
        "status": "SUCCEEDED",
        "fileName": "productSpecification5000.zip",
        "createdBy": "booth",
        "path": "",
        "url": "v1/importFile/productSpecification5000.zip",
        "importSummary": {
            "id": 174335,
            "totalImportObjects": 5001,
            "resources": [
                {
                    "name": "project",
                    "count": 1
                },
                {
                    "name": "productSpecification",
                    "count": 5000
                }
            ]
        },
        "creationDate": "2021-04-23 05:54:25.855",
        "completionDate": "2021-04-23 06:22:39.589",
        "href": "https://{OracleAppsHost}/crmRestApi/atcProductCatalog/11.13.18.05/tmf-api/productCatalogManagement/v4/importJob/174335"
    },
    {
        "id": 174192,
        "@type": "ImportJobOracle",
        "contentType": "application/zip",
        "status": "ERROR",
        "fileName": "productSpecification5000.zip",
        "createdBy": "booth",
        "path": "",
        "url": "v1/importFile/productSpecification5000.zip",
        "errorLog": "Errors importing data for resource productSpecification. 131 error(s) occurred.\n, 4069 record(s) rolled back.",
        "importSummary": {
            "id": 174192,
            "totalImportObjects": 801,
            "resources": [
                {
                    "name": "project",
                    "count": 1
                },
                {
                    "name": "productSpecification",
                    "count": 800
                }
            ]
        },
        "errorLogUrl": "v1/importFile/174192.log",
        "creationDate": "2021-04-23 04:44:40.948",
        "completionDate": "2021-04-23 05:23:49.972",
        "href": "https://{OracleAppsHost}/crmRestApi/atcProductCatalog/11.13.18.05/tmf-api/productCatalogManagement/v4/importJob/174192"
    },
    {
        "id": 174165,
        "@type": "ImportJobOracle",
        "contentType": "application/zip",
        "status": "ERROR",
        "fileName": "productSpecification5000.zip",
        "createdBy": "booth",
        "path": "",
        "url": "v1/importFile/productSpecification5000.zip",
        "errorLog": "Errors importing data for resource productSpecification. 0 error(s) occurred.\n, 4400 record(s) rolled back.",
        "importSummary": {
            "id": 174165,
            "totalImportObjects": 601,
            "resources": [
                {
                    "name": "project",
                    "count": 1
                },
                {
                    "name": "productSpecification",
                    "count": 600
                }
            ]
        },
        "errorLogUrl": "v1/importFile/174165.log",
        "creationDate": "2021-04-23 04:31:20.948",
        "completionDate": "2021-04-23 04:57:35.756",
        "href": "https://{OracleAppsHost}/crmRestApi/atcProductCatalog/11.13.18.05/tmf-api/productCatalogManagement/v4/importJob/174165"
    },
    {
        "id": 173491,
        "@type": "ImportJobOracle",
        "contentType": "application/zip",
        "status": "ERROR",
        "fileName": "productOffering5000.zip",
        "createdBy": "booth",
        "path": "",
        "url": "v1/importFile/productOffering5000.zip",
        "errorLog": "Total error count: 20. Errors validating data for resource productOffering. 19 error(s) occurred.\n",
        "importSummary": "",
        "errorLogUrl": "v1/importFile/173491.log",
        "creationDate": "2021-04-22 17:59:21.594",
        "completionDate": "2021-04-22 18:00:19.641",
        "href": "https://{OracleAppsHost}/crmRestApi/atcProductCatalog/11.13.18.05/tmf-api/productCatalogManagement/v4/importJob/173491"
    },
    {
        "id": 173411,
        "@type": "ImportJobOracle",
        "contentType": "application/zip",
        "status": "ERROR",
        "fileName": "productSpecification5000.zip",
        "createdBy": "booth",
        "path": "",
        "url": "v1/importFile/productSpecification5000.zip",
        "errorLog": "Errors importing data for resource productSpecification. 4000 error(s) occurred.\n, 1000 record(s) rolled back.",
        "importSummary": {
            "id": 173411,
            "totalImportObjects": 1,
            "resources": [
                {
                    "name": "project",
                    "count": 1
                }
            ]
        },
        "errorLogUrl": "v1/importFile/173411.log",
        "creationDate": "2021-04-22 17:40:08.106",
        "completionDate": "2021-04-22 17:54:14.077",
        "href": "https://{OracleAppsHost}/crmRestApi/atcProductCatalog/11.13.18.05/tmf-api/productCatalogManagement/v4/importJob/173411"
    },
    {
        "id": 173396,
        "@type": "ImportJobOracle",
        "contentType": "application/json",
        "status": "SUCCEEDED",
        "fileName": "productSpecification2 3.json",
        "createdBy": "booth",
        "path": "",
        "url": "v1/importFile/productSpecification2 3.json",
        "importSummary": {
            "id": 173396,
            "totalImportObjects": 3,
            "resources": [
                {
                    "name": "project",
                    "count": 1
                },
                {
                    "name": "productSpecification",
                    "count": 2
                }
            ]
        },
        "creationDate": "2021-04-22 17:33:23.621",
        "completionDate": "2021-04-22 17:34:39.049",
        "href": "https://{OracleAppsHost}/crmRestApi/atcProductCatalog/11.13.18.05/tmf-api/productCatalogManagement/v4/importJob/173396"
    },
    {
        "id": 173385,
        "@type": "ImportJobOracle",
        "contentType": "application/json",
        "status": "SUCCEEDED",
        "fileName": "productSpecification2 3.json",
        "createdBy": "booth",
        "path": "",
        "url": "v1/importFile/productSpecification2 3.json",
        "importSummary": {
            "id": 173385,
            "totalImportObjects": 3,
            "resources": [
                {
                    "name": "project",
                    "count": 1
                },
                {
                    "name": "productSpecification",
                    "count": 2
                }
            ]
        },
        "creationDate": "2021-04-22 17:32:18.797",
        "completionDate": "2021-04-22 17:33:37.512",
        "href": "https://{OracleAppsHost}/crmRestApi/atcProductCatalog/11.13.18.05/tmf-api/productCatalogManagement/v4/importJob/173385"
    },
    {
        "id": 173355,
        "@type": "ImportJobOracle",
        "contentType": "application/json",
        "status": "ERROR",
        "fileName": "productOffering10.json",
        "createdBy": "booth",
        "path": "",
        "url": "v1/importFile/productOffering10.json",
        "errorLog": "Errors importing data for resource productOffering. 0 error(s) occurred.\n, 1 record(s) rolled back.",
        "importSummary": {
            "id": 173355,
            "totalImportObjects": 10,
            "resources": [
                {
                    "name": "project",
                    "count": 1
                },
                {
                    "name": "productOffering",
                    "count": 9
                }
            ]
        },
        "errorLogUrl": "v1/importFile/173355.log",
        "creationDate": "2021-04-22 17:23:12.596",
        "completionDate": "2021-04-22 17:24:34.834",
        "href": "https://{OracleAppsHost}/crmRestApi/atcProductCatalog/11.13.18.05/tmf-api/productCatalogManagement/v4/importJob/173355"
    },
    {
        "id": 173335,
        "@type": "ImportJobOracle",
        "contentType": "application/json",
        "status": "SUCCEEDED",
        "fileName": "productOffering5.json",
        "createdBy": "booth",
        "path": "",
        "url": "v1/importFile/productOffering5.json",
        "importSummary": {
            "id": 173335,
            "totalImportObjects": 6,
            "resources": [
                {
                    "name": "project",
                    "count": 1
                },
                {
                    "name": "productOffering",
                    "count": 5
                }
            ]
        },
        "creationDate": "2021-04-22 17:15:30.787",
        "completionDate": "2021-04-22 17:16:54.465",
        "href": "https://{OracleAppsHost}/crmRestApi/atcProductCatalog/11.13.18.05/tmf-api/productCatalogManagement/v4/importJob/173335"
    },
    {
        "id": 173319,
        "@type": "ImportJobOracle",
        "contentType": "application/json",
        "status": "SUCCEEDED",
        "fileName": "productOffering2.json",
        "createdBy": "booth",
        "path": "",
        "url": "v1/importFile/productOffering2.json",
        "importSummary": {
            "id": 173319,
            "totalImportObjects": 3,
            "resources": [
                {
                    "name": "project",
                    "count": 1
                },
                {
                    "name": "productOffering",
                    "count": 2
                }
            ]
        },
        "creationDate": "2021-04-22 17:07:05.003",
        "completionDate": "2021-04-22 17:08:28.942",
        "href": "https://{OracleAppsHost}/crmRestApi/atcProductCatalog/11.13.18.05/tmf-api/productCatalogManagement/v4/importJob/173319"
    },
    {
        "id": 173301,
        "@type": "ImportJobOracle",
        "contentType": "application/json",
        "status": "SUCCEEDED",
        "fileName": "productSpecification5.json",
        "createdBy": "booth",
        "path": "",
        "url": "v1/importFile/productSpecification5.json",
        "importSummary": {
            "id": 173301,
            "totalImportObjects": 6,
            "resources": [
                {
                    "name": "project",
                    "count": 1
                },
                {
                    "name": "productSpecification",
                    "count": 5
                }
            ]
        },
        "creationDate": "2021-04-22 17:02:10.217",
        "completionDate": "2021-04-22 17:03:25.055",
        "href": "https://{OracleAppsHost}/crmRestApi/atcProductCatalog/11.13.18.05/tmf-api/productCatalogManagement/v4/importJob/173301"
    },
    {
        "id": 173279,
        "@type": "ImportJobOracle",
        "contentType": "application/json",
        "status": "SUCCEEDED",
        "fileName": "productSpecification2.json",
        "createdBy": "booth",
        "path": "",
        "url": "v1/importFile/productSpecification2.json",
        "importSummary": {
            "id": 173279,
            "totalImportObjects": 3,
            "resources": [
                {
                    "name": "project",
                    "count": 1
                },
                {
                    "name": "productSpecification",
                    "count": 2
                }
            ]
        },
        "creationDate": "2021-04-22 16:54:05.858",
        "completionDate": "2021-04-22 16:55:20.71",
        "href": "https://{OracleAppsHost}/crmRestApi/atcProductCatalog/11.13.18.05/tmf-api/productCatalogManagement/v4/importJob/173279"
    },
    {
        "id": 173259,
        "@type": "ImportJobOracle",
        "contentType": "application/json",
        "status": "ERROR",
        "fileName": "productSpecification2.json",
        "createdBy": "booth",
        "path": "",
        "url": "v1/importFile/productSpecification2.json",
        "errorLog": "Errors importing data for resource productSpecification. 2 error(s) occurred.\n",
        "importSummary": {
            "id": 173259,
            "totalImportObjects": 1,
            "resources": [
                {
                    "name": "project",
                    "count": 1
                }
            ]
        },
        "errorLogUrl": "v1/importFile/173259.log",
        "creationDate": "2021-04-22 16:44:02.164",
        "completionDate": "2021-04-22 16:45:19.406",
        "href": "https://{OracleAppsHost}/crmRestApi/atcProductCatalog/11.13.18.05/tmf-api/productCatalogManagement/v4/importJob/173259"
    },
    {
        "id": 173239,
        "@type": "ImportJobOracle",
        "contentType": "application/json",
        "status": "ERROR",
        "fileName": "productOffering2.json",
        "createdBy": "booth",
        "path": "",
        "url": "v1/importFile/productOffering2.json",
        "errorLog": "Total error count: 2. Errors validating data for resource productOffering. 2 error(s) occurred.\n",
        "importSummary": "",
        "errorLogUrl": "v1/importFile/173239.log",
        "creationDate": "2021-04-22 16:26:56.693",
        "completionDate": "2021-04-22 16:27:39.853",
        "href": "https://{OracleAppsHost}/crmRestApi/atcProductCatalog/11.13.18.05/tmf-api/productCatalogManagement/v4/importJob/173239"
    },
    {
        "id": 173225,
        "@type": "ImportJobOracle",
        "contentType": "application/json",
        "status": "ERROR",
        "fileName": "productOffering2.json",
        "createdBy": "booth",
        "path": "",
        "url": "v1/importFile/productOffering2.json",
        "errorLog": "Total error count: 2. Errors validating data for resource productOffering. 2 error(s) occurred.\n",
        "importSummary": "",
        "errorLogUrl": "v1/importFile/173225.log",
        "creationDate": "2021-04-22 16:16:26.902",
        "completionDate": "2021-04-22 16:17:11.272",
        "href": "https://{OracleAppsHost}/crmRestApi/atcProductCatalog/11.13.18.05/tmf-api/productCatalogManagement/v4/importJob/173225"
    },
    {
        "id": 173220,
        "@type": "ImportJobOracle",
        "contentType": "application/json",
        "status": "ERROR",
        "fileName": "Device_21c_PO - pricelist50priceattached copy.json",
        "createdBy": "booth",
        "path": "",
        "url": "v1/importFile/Device_21c_PO - pricelist50priceattached copy.json",
        "errorLog": "Total error count: 1. ERROR:Error validating data.\nError: records should be an array. Skipping resource \"id\". File name: Device_21c_PO - pricelist50priceattached copy.json",
        "importSummary": "",
        "errorLogUrl": "v1/importFile/173220.log",
        "creationDate": "2021-04-22 16:12:21.601",
        "completionDate": "2021-04-22 16:12:42.985",
        "href": "https://{OracleAppsHost}/crmRestApi/atcProductCatalog/11.13.18.05/tmf-api/productCatalogManagement/v4/importJob/173220"
    },
    {
        "id": 173044,
        "@type": "ImportJobOracle",
        "contentType": "application/json",
        "status": "SUCCEEDED",
        "fileName": "Device_21c_PO - pricelist50priceattached.json",
        "createdBy": "booth",
        "path": "",
        "url": "v1/importFile/Device_21c_PO - pricelist50priceattached.json",
        "importSummary": {
            "id": 173044,
            "totalImportObjects": 2,
            "resources": [
                {
                    "name": "project",
                    "count": 1
                },
                {
                    "name": "productOffering",
                    "count": 1
                }
            ]
        },
        "creationDate": "2021-04-22 13:38:38.378",
        "completionDate": "2021-04-22 13:40:24.642",
        "href": "https://{OracleAppsHost}/crmRestApi/atcProductCatalog/11.13.18.05/tmf-api/productCatalogManagement/v4/importJob/173044"
    },
    {
        "id": 173035,
        "@type": "ImportJobOracle",
        "contentType": "application/json",
        "status": "ERROR",
        "fileName": "Device_21c_PO - pricelist50priceattached.json",
        "createdBy": "booth",
        "path": "",
        "url": "v1/importFile/Device_21c_PO - pricelist50priceattached.json",
        "errorLog": "Total error count: 1. Errors validating data for resource productOffering. 1 error(s) occurred.\n",
        "importSummary": "",
        "errorLogUrl": "v1/importFile/173035.log",
        "creationDate": "2021-04-22 13:34:12.728",
        "completionDate": "2021-04-22 13:34:44.876",
        "href": "https://{OracleAppsHost}/crmRestApi/atcProductCatalog/11.13.18.05/tmf-api/productCatalogManagement/v4/importJob/173035"
    }
]
Back to Top