Get all integration maps

get

/api/boss/data/objects/ora/cxSalesCommon/integration/v1/$en/integrationMaps

Request

Query Parameters
  • Restricts the resource fields. Only the specified fields and mandatory system fields are returned.
  • The resource collection will be queried using the specified filter condition.
  • Restricts the number of resource items returned inside the resource collection. If the limit exceeds the resource count then the framework will only return the available resource items.
    Default Value: 25
  • Defines the starting position of the resource collection. If offset exceeds the resource count then no resource items are returned.
    Default Value: 0
  • Orders a resource collection based on the specified fields. The parameter value is a comma-separated string of field names, each optionally followed by a colon and "asc" (default) or "desc".

There's no request body for this operation.

Back to Top

Response

Default Response

An array of items response
Body ()
Root Schema : integrationMaps_view-default
Match All
Show Source
Nested Schema : __collection_context
Type: object
Show Source
Nested Schema : integrationMaps_view-default-allOf[1]
Type: object
Show Source
Nested Schema : items
Type: array
Show Source
Nested Schema : integrationMaps_view-default_item-response
Match All
Show Source
Nested Schema : integrationMaps_item-response
Match All
Show Source
  • Integration Map
    Title: Integration Map
    Integration maps describe the attribute mappings between objects in Sales and objects in other Oracle applications. The integration process uses these mappings to determine the attributes that need to be synchronized from Sales to the other applications.
  • __busObj_context
Nested Schema : Integration Map
Type: object
Title: Integration Map
Integration maps describe the attribute mappings between objects in Sales and objects in other Oracle applications. The integration process uses these mappings to determine the attributes that need to be synchronized from Sales to the other applications.
Show Source
Nested Schema : __busObj_context
Type: object
Show Source
Nested Schema : integrationMaps_view-default_item-response-allOf[1]
Type: object
Show Source
Nested Schema : $context
Type: object
Show Source
Back to Top

Examples

The following example shows how to get all integration map by submitting a GET request on the REST resource.

cURL Command

curl -X GET --location 'https://servername.fa.us2.oraclecloud.com/api/boss/data/objects/ora/cxSalesCommon/integration/v1/$en/integrationMaps' \
--header 'Content-Type: application/json' \
--header 'Authorization: Bearer <token>

Example of Response Body

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

{
    "items": [
        {
            "integrationMapId": "300100576881595",
            "name": "Integrate Products",
            "description": "Synchronize product create or update in Sales with CPQ.",
            "integrationMapNumber": "DATAINTG-699",
            "sourceObject": "Product",
            "seededFlag": true,
            "integrationSpec": "{\"BeforeHandler\":\"com.oracle.osc.aspects.consumer.product.BeforeHandlerImpl\",\"MapTransform\":{\"Transform\":\"{\\n$.Product.Name:$.upsertParts.partSetups.items[*].partDisplayNumber\\n$.Product.InventoryItemId:$.upsertParts.partSetups.items[*].partnerPartId\\n$.Product.OrganizationId:$.upsertParts.partSetups.items[*].partnerOrganizationId\\n$.Product.DefaultPeriodicityCode:$.upsertParts.partSetups.items[*].pricePeriod\\n$.Product.DefaultPeriods:$.upsertParts.partSetups.items[*].numberOfPricePeriods\\n$.Product.DefaultPriceTypeCode:$.upsertParts.partSetups.items[*].priceType\\n$.Product.ItemNumber:$.upsertParts.partSetups.items[*].partNumber\\n$.Product.DefaultUOMCode:$.upsertParts.partSetups.items[*].defaultUOMCode\\n$.Product.ProductTypeCode:$.upsertParts.partSetups.items[*].salesProductType\\n$.Product.EligibleToSell:$.upsertParts.partSetups.items[*].eligibleToSell\\n$.Product.CSSEnabled:$.upsertParts.partSetups.items[*].enableSelfService\\n$.Product.EligibleForService:$.upsertParts.partSetups.items[*].eligibleForService\\n$.Product.ProcessingDays:$.upsertParts.partSetups.items[*].leadTime\\n$.\\\"1\\\":$.upsertParts.partSetups.items[*].directBuy.lookupCode\\n}\",\"Invoke\":{\"ConnectionReference\":\"ORA_CPQ_APP\",\"EndPointURI\":\"/rest/v14/partSetups/actions/upsertParts\",\"EndPointAction\":\"POST\",\"EndPointHeaders\":\"\"}},\"IntegrationStepName\":\"IntegrateProduct\"}",
            "createdBy": "MHoope",
            "timeCreated": "2023-06-20T14:26:27.333951Z",
            "updatedBy": "MHoope",
            "timeUpdated": "2023-06-20T14:26:27.333951Z",
            "lockedFlag": false,
            "activeFlag": false,
            "$id": "DATAINTG-699",
            "$context": {
                "etag": "1",
                "links": {
                    "$self": {
                        "href": "https://servername.fa.us2.oraclecloud.com/api/boss/data/objects/ora/cxSalesCommon/integration/v1/integrationMaps/DATAINTG-699"
                    }
                }
            }
        },
        {
            "integrationMapId": "300100576881593",
            "name": "Integrate Products",
            "description": "Synchronize product create or update in Sales with CPQ.",
            "integrationMapNumber": "DATAINTG-067",
            "sourceObject": "Product",
            "seededFlag": true,
            "integrationSpec": "{\"BeforeHandler\":\"com.oracle.osc.aspects.consumer.product.BeforeHandlerImpl\",\"MapTransform\":{\"Transform\":\"{\\n$.Product.Name:$.upsertParts.partSetups.items[*].partDisplayNumber\\n$.Product.InventoryItemId:$.upsertParts.partSetups.items[*].partnerPartId\\n$.Product.OrganizationId:$.upsertParts.partSetups.items[*].partnerOrganizationId\\n$.Product.DefaultPeriodicityCode:$.upsertParts.partSetups.items[*].pricePeriod\\n$.Product.DefaultPeriods:$.upsertParts.partSetups.items[*].numberOfPricePeriods\\n$.Product.DefaultPriceTypeCode:$.upsertParts.partSetups.items[*].priceType\\n$.Product.ItemNumber:$.upsertParts.partSetups.items[*].partNumber\\n$.Product.DefaultUOMCode:$.upsertParts.partSetups.items[*].defaultUOMCode\\n$.Product.ProductTypeCode:$.upsertParts.partSetups.items[*].salesProductType\\n$.Product.EligibleToSell:$.upsertParts.partSetups.items[*].eligibleToSell\\n$.Product.CSSEnabled:$.upsertParts.partSetups.items[*].enableSelfService\\n$.Product.EligibleForService:$.upsertParts.partSetups.items[*].eligibleForService\\n$.Product.ProcessingDays:$.upsertParts.partSetups.items[*].leadTime\\n$.\\\"1\\\":$.upsertParts.partSetups.items[*].directBuy.lookupCode\\n}\",\"Invoke\":{\"ConnectionReference\":\"ORA_CPQ_APP\",\"EndPointURI\":\"/rest/v14/partSetups/actions/upsertParts\",\"EndPointAction\":\"POST\",\"EndPointHeaders\":\"\"}},\"IntegrationStepName\":\"IntegrateProduct\"}",
            "createdBy": "MHoope",
            "timeCreated": "2023-06-20T12:32:18.144399Z",
            "updatedBy": "MHoope",
            "timeUpdated": "2023-06-20T12:32:18.144399Z",
            "lockedFlag": false,
            "activeFlag": false,
            "$id": "DATAINTG-067",
            "$context": {
                "etag": "1",
                "links": {
                    "$self": {
                        "href": "https://servername.fa.us2.oraclecloud.com/api/boss/data/objects/ora/cxSalesCommon/integration/v1/integrationMaps/DATAINTG-067"
                    }
                }
            }
        },
        {
            "integrationMapId": "300100576881592",
            "name": "Integrate Products",
            "description": "Synchronize product create or update in Sales with CPQ.",
            "integrationMapNumber": "DATAINTG-859",
            "sourceObject": "Product",
            "seededFlag": true,
            "integrationSpec": "{\"BeforeHandler\":\"com.oracle.osc.aspects.consumer.product.BeforeHandlerImpl\",\"MapTransform\":{\"Transform\":\"{\\n$.Product.Name:$.upsertParts.partSetups.items[*].partDisplayNumber\\n$.Product.InventoryItemId:$.upsertParts.partSetups.items[*].partnerPartId\\n$.Product.OrganizationId:$.upsertParts.partSetups.items[*].partnerOrganizationId\\n$.Product.DefaultPeriodicityCode:$.upsertParts.partSetups.items[*].pricePeriod\\n$.Product.DefaultPeriods:$.upsertParts.partSetups.items[*].numberOfPricePeriods\\n$.Product.DefaultPriceTypeCode:$.upsertParts.partSetups.items[*].priceType\\n$.Product.ItemNumber:$.upsertParts.partSetups.items[*].partNumber\\n$.Product.DefaultUOMCode:$.upsertParts.partSetups.items[*].defaultUOMCode\\n$.Product.ProductTypeCode:$.upsertParts.partSetups.items[*].salesProductType\\n$.Product.EligibleToSell:$.upsertParts.partSetups.items[*].eligibleToSell\\n$.Product.CSSEnabled:$.upsertParts.partSetups.items[*].enableSelfService\\n$.Product.EligibleForService:$.upsertParts.partSetups.items[*].eligibleForService\\n$.Product.ProcessingDays:$.upsertParts.partSetups.items[*].leadTime\\n$.\\\"1\\\":$.upsertParts.partSetups.items[*].directBuy.lookupCode\\n}\",\"Invoke\":{\"ConnectionReference\":\"ORA_CPQ_APP\",\"EndPointURI\":\"/rest/v14/partSetups/actions/upsertParts\",\"EndPointAction\":\"POST\",\"EndPointHeaders\":\"\"}},\"IntegrationStepName\":\"IntegrateProduct\"}",
            "createdBy": "MHoope",
            "timeCreated": "2023-06-20T11:52:01.167677Z",
            "updatedBy": "MHoope",
            "timeUpdated": "2023-06-20T11:52:01.167677Z",
            "lockedFlag": false,
            "activeFlag": false,
            "$id": "DATAINTG-859",
            "$context": {
                "etag": "1",
                "links": {
                    "$self": {
                        "href": "https://servername.fa.us2.oraclecloud.com/api/boss/data/objects/ora/cxSalesCommon/integration/v1/integrationMaps/DATAINTG-859"
                    }
                }
            }
        },
        {
            "integrationMapId": "300100575711592",
            "name": "Upsert Product in CPQ",
            "description": "Synchronize product create or update in Sales with CPQ.",
            "integrationMapNumber": "DATAINTG-100",
            "sourceObject": "Product",
            "seededFlag": true,
            "integrationSpec": "{\"BeforeHandler\":\"com.oracle.osc.aspects.consumer.product.BeforeHandlerImpl\",\"MapTransform\":{\"Transform\":\"{\\n$.Product.ProductTranslation[*].Description:$.upsertParts.partSetups.items[*].translations.items[*].description\\n$.lookup($.Product.ProductTranslation[*].Language,'CPQ_LANGUAGES'):$.upsertParts.partSetups.items[*].translations.items[*].language.languageCode\\n$.Product.Name:$.upsertParts.partSetups.items[*].partDisplayNumber\\n$.Product.InventoryItemId:$.upsertParts.partSetups.items[*].partnerPartId\\n$.Product.OrganizationId:$.upsertParts.partSetups.items[*].partnerOrganizationId\\n$.Product.DefaultPeriodicityCode:$.upsertParts.partSetups.items[*].pricePeriod\\n$.Product.DefaultPeriods:$.upsertParts.partSetups.items[*].numberOfPricePeriods\\n$.Product.DefaultPriceTypeCode:$.upsertParts.partSetups.items[*].priceType\\n$.Product.ItemNumber:$.upsertParts.partSetups.items[*].partNumber\\n$.Product.DefaultUOMCode:$.upsertParts.partSetups.items[*].defaultUOMCode\\n$.Product.ProductTypeCode:$.upsertParts.partSetups.items[*].salesProductType\\n$.Product.EligibleToSell:$.upsertParts.partSetups.items[*].eligibleToSell\\n$.Product.CSSEnabled:$.upsertParts.partSetups.items[*].enableSelfService\\n$.Product.EligibleForService:$.upsertParts.partSetups.items[*].eligibleForService\\n$.Product.ProcessingDays:$.upsertParts.partSetups.items[*].leadTime\\n$.\\\"1\\\":$.upsertParts.partSetups.items[*].directBuy.lookupCode\\n}\",\"Invoke\":{\"ConnectionReference\":\"ORA_CPQ_APP\",\"EndPointURI\":\"\/rest\/v14\/partSetups\/actions\/upsertParts\",\"EndPointAction\":\"POST\",\"EndPointHeaders\":\"\"}},\"IntegrationStepName\":\"IntegrateProduct\"}",
            "createdBy": "FUSION_APPS_CRM_SOA_APPID",
            "timeCreated": "2023-04-04T22:38:55Z",
            "updatedBy": "FUSION_APPS_CRM_SOA_APPID",
            "timeUpdated": "2023-06-18T05:37:48Z",
            "lockedFlag": false,
            "activeFlag": true,
            "$id": "DATAINTG-100",
            "$context": {
                "etag": "3",
                "links": {
                    "$self": {
                        "href": "https://servername.fa.us2.oraclecloud.com/api/boss/data/objects/ora/cxSalesCommon/integration/v1/integrationMaps/DATAINTG-100"
                    }
                }
            }
        }
    ],
    "hasMore": false
}
Back to Top