listProfiles

get

/ccapp/v1/profiles

List Profiles. This operation is used to get the collection of customer profiles from Oracle Commerce Cloud. Optionally takes the x-ccasset-language header to get translated content in another language. It can also be used to return the list on a searched string and in a sorted order against various properties of profile.

Request

Supported Media Types
Query Parameters
  • As an alternative to the fields parameter, which explicitly specifies the properties to include, you can use the exclude parameter to include all properties except the ones specified. For example, to return all of the properties of profile except shippingAddresses.
  • Expand controls which properties are returned. Possible values for the expand query parameter are 'basic' to get a limited set of properties, 'globalRoles' to include standard roles along with a user's organizational roles, 'orgProfiles' to fetch basic information of contact(also whether active or inactive) and it's organization roles, 'listProfiles' to get the basic information of the contact without organization information
  • You can use the fields parameter to restrict the set of properties returned to only those you explicitly specify. The properties are specified as a comma-separated list. For example, id and email properties of profile.
  • This is the field to determine number of records to be fetched per REST call.
  • This field determines the offset/starting index from which data to be fetched.
  • If true, then preview profiles will be searched.
  • Query string built as per the SCIM standards that helps to search entered string across contact properties, 'firstName', 'lastName', 'email', 'parentOrganization' and 'profileType' and also dynamic contact properties.
  • This field determines the sort order of the list to be fetched.
  • This field determines the parser to be used. Default parser has limitations and nested queries or complex queries cannot be executed using this default parser. It is recommended to use this flag as true.
Header Parameters
Back to Top

Response

Supported Media Types

200 Response

Following model is returned when operation succeeds.
Body ()
Root Schema : listProfiles_response
Type: object
Show Source
Nested Schema : items
Type: array
list of shopper profiles
Show Source
Nested Schema : items
Type: object
Show Source
Nested Schema : billingAddress
Type: object
Default billing address of the profile
Show Source
Nested Schema : creditCards
Type: array
List of user credit cards.
Show Source
Nested Schema : derivedPriceListGroup
Type: object
The derived price list group from the user's parent organization
Show Source
Nested Schema : derivedSalePriceList
Type: object
The derived sale price list from the user's parent organization
Show Source
Nested Schema : derivedShippingSurchargePriceList
Type: object
The derived shipping surcharge price list from the user's parent organization
Show Source
Nested Schema : dynamicInternalOnlyProperty
Type: object
The value of the internalOnly dynamic property
Nested Schema : dynamicProperty
Type: object
the value of the dynamic property
Nested Schema : loyaltyPrograms
Type: array
Loyalty Programs Information
Show Source
Nested Schema : parentOrganization
Type: object
This attribute is added for 'Account Based Commerce', this is required only in case of 'Account Based Commerce', this is the id of organization to which user is associated
Show Source
Nested Schema : priceListGroup
Type: object
The associated price list group for this user
Show Source
Nested Schema : roles
Type: array
List of user roles.
Show Source
Nested Schema : secondaryOrganizations
Type: array
List of secondary organizations associated to profile. It will be empty always. Secondary Organizations associated to the profile can be fetched using organization endpoints
Show Source
Nested Schema : profile_shippingAddress
Type: object
Default shipping address of the profile (Deprecated, please use ???shippingAddresses??? instead).
Show Source
Nested Schema : shippingAddresses
Type: array
List of shipping addresses associated with profile.
Show Source
Nested Schema : shippingSurchargePriceList
Type: object
The shipping surcharge price list for this user
Show Source
Nested Schema : translations
Type: array
List of available locales for the user
Show Source
Nested Schema : types
Type: array
The types tagged to the address
Show Source
Nested Schema : items
Type: object
Show Source
Nested Schema : items
Type: object
Show Source
Nested Schema : cardProps
Type: object
Nested Schema : items
Type: object
Show Source
Nested Schema : billingAddress
Type: object
Default billing address of the profile
Show Source
Nested Schema : secondaryAddresses
Type: array
List of shipping addresses associated with profile.
Show Source
Nested Schema : shippingAddress
Type: object
Default shipping address of the profile
Show Source
Nested Schema : items
Type: object
Show Source
Nested Schema : items
Type: object
Show Source
Nested Schema : relativeTo
Type: object
Organization in which the role applies. Present only if type is organizationalRole.
Show Source
Nested Schema : items
Type: object
Show Source
Nested Schema : billingAddress
Type: object
Default billing address of the profile
Show Source
Nested Schema : secondaryAddresses
Type: array
List of shipping addresses associated with profile.
Show Source
Nested Schema : shippingAddress
Type: object
Default shipping address of the profile
Show Source
Nested Schema : types
Type: array
The types tagged to the address
Show Source
Nested Schema : items
Type: object
Show Source
Nested Schema : items
Type: object
Show Source
Nested Schema : types
Type: array
The types tagged to the address
Show Source
Nested Schema : items
Type: object
Show Source
Nested Schema : types
Type: array
The types tagged to the address
Show Source
Nested Schema : items
Type: object
Show Source
Nested Schema : types
Type: array
The types tagged to the address
Show Source
Nested Schema : items
Type: object
Show Source
Nested Schema : profile_shippingAddress_response
Type: object
Shipping address associated with the profile
Show Source
Nested Schema : types
Type: array
The types tagged to the address
Show Source
Nested Schema : items
Type: object
Show Source
Nested Schema : items
Type: object
Show Source
Example Response (application/json)
{
    "total":3,
    "totalResults":3,
    "offset":0,
    "limit":3,
    "links":[
        {
            "rel":"self",
            "href":"http://localhost:9080/ccadmin/v1/profiles?limit=20&offset=0&sort=email:asc&q=lastName%20co%20%22test%22%20or%20email%20co%20%22test%22%20and%20profileType%20eq%20%22b2b_user%22%20and%20parentOrganization%20eq%20%22null%22%20and%20roles.function%20eq%20%22buyer%22"
        }
    ],
    "sort":[
        {
            "property":"email",
            "order":"asc"
        },
        {
            "property":"firstName",
            "order":"asc"
        },
        {
            "property":"lastName",
            "order":"asc"
        }
    ],
    "items":[
        {
            "derivedPriceListGroup":null,
            "lastPurchaseDate":null,
            "lastName":"jetu#$%^&test",
            "GDPRProfileP13nConsentDate":null,
            "GDPRProfileP13nConsentGranted":false,
            "gender":"female",
            "catalog":null,
            "roles":[
                {
                    "function":"buyer",
                    "relativeTo":{
                        "id":"100001"
                    },
                    "repositoryId":"100006",
                    "name":"Buyer",
                    "id":"100006",
                    "type":"organizationalRole"
                }
            ],
            "locale":"en",
            "parentOrganization":{
                "name":"Oracle",
                "repositoryId":"100001",
                "description":"Oracle Org",
                "active":true,
                "shippingAddress":{
                },
                "secondaryAddresses":[
                    {
                        "firstName":"Harry",
                        "lastName":"Potter",
                        "country":"United States",
                        "types":[
                            {
                                "displayName":"Shipping",
                                "repositoryId":"ss-10001",
                                "id":"ss-10001"
                            },
                            {
                                "displayName":"Billing",
                                "repositoryId":"ss-10002",
                                "id":"ss-10002"
                            }
                        ],
                        "phoneNumber":"9088988999",
                        "city":"Arcadia",
                        "address2":"Suite 400",
                        "address1":"Grundy Lane",
                        "postalCode":"91006",
                        "repositoryId":"110033",
                        "state":"CA"
                    }
                ],
                "id":"100001",
                "billingAddress":{
                },
                "externalOrganizationId":"EXT_ORG_1"
            },
            "shippingSurchargePriceList":null,
            "receiveEmailDate":null,
            "firstPurchaseDate":null,
            "profileType":"b2b_user",
            "translations":{
            },
            "registrationDate":null,
            "id":"120015",
            "email":"example@example.com",
            "daytimeTelephoneNumber":null,
            "derivedSalePriceList":null,
            "taxExempt":false,
            "customerContactId":null,
            "receiveEmail":"no",
            "active":true,
            "priceListGroup":null,
            "dateOfBirth":null,
            "lastVisitDate":null,
            "previousVisitDate":null,
            "firstName":"jetu&",
            "creditCards":[
                {
                    "expirationYear":"2017",
                    "tokenExpiryDate":null,
                    "gatewayConfigId":null,
                    "expirationMonth":"1",
                    "creditCardType":"Visa",
                    "source":null,
                    "iin":null,
                    "token":null,
                    "cardProps":{
                    },
                    "nameOnCard":null,
                    "creditCardNumber":"4539082039396288",
                    "repositoryId":"se-usercc110031",
                    "nickname":"Visa",
                    "tokenCreatedDate":"2018-10-01T09:02:10.181Z",
                    "cardSavedDate":null,
                    "id":"se-usercc110031",
                    "expirationDayOfMonth":null
                }
            ],
            "repositoryId":"120015",
            "firstVisitDate":null,
            "shippingAddress":null,
            "lastActivity":"2017-01-09T19:21:39.000Z",
            "userType":null,
            "billingAddress":null,
            "derivedShippingSurchargePriceList":null,
            "secondaryOrganizations":[
            ],
            "shippingAddresses":[
            ]
        },
        {
            "derivedPriceListGroup":null,
            "lastPurchaseDate":null,
            "lastName":"!@#$%^&*",
            "GDPRProfileP13nConsentDate":null,
            "GDPRProfileP13nConsentGranted":false,
            "gender":"female",
            "catalog":null,
            "roles":[
                {
                    "function":"buyer",
                    "relativeTo":{
                        "id":"100001"
                    },
                    "repositoryId":"100006",
                    "name":"Buyer",
                    "id":"100006",
                    "type":"organizationalRole"
                }
            ],
            "locale":"en",
            "parentOrganization":{
                "name":"Oracle",
                "repositoryId":"100001",
                "description":"Oracle Org",
                "active":true,
                "shippingAddress":{
                },
                "secondaryAddresses":[
                    {
                        "firstName":"Harry",
                        "lastName":"Potter",
                        "country":"United States",
                        "types":[
                            {
                                "displayName":"Shipping",
                                "repositoryId":"ss-10001",
                                "id":"ss-10001"
                            },
                            {
                                "displayName":"Billing",
                                "repositoryId":"ss-10002",
                                "id":"ss-10002"
                            }
                        ],
                        "phoneNumber":"9088988999",
                        "city":"Arcadia",
                        "address2":"Suite 400",
                        "address1":"Grundy Lane",
                        "postalCode":"91006",
                        "repositoryId":"110033",
                        "state":"CA"
                    }
                ],
                "id":"100001",
                "billingAddress":{
                },
                "externalOrganizationId":"EXT_ORG_1"
            },
            "shippingSurchargePriceList":null,
            "receiveEmailDate":null,
            "firstPurchaseDate":null,
            "profileType":"b2b_user",
            "translations":{
            },
            "registrationDate":null,
            "id":"130000",
            "email":"test1@abc.com",
            "daytimeTelephoneNumber":null,
            "derivedSalePriceList":null,
            "taxExempt":false,
            "customerContactId":null,
            "receiveEmail":"no",
            "active":true,
            "priceListGroup":null,
            "dateOfBirth":null,
            "lastVisitDate":null,
            "previousVisitDate":null,
            "firstName":"test1",
            "repositoryId":"130000",
            "firstVisitDate":null,
            "shippingAddress":null,
            "lastActivity":"2017-01-09T19:21:39.000Z",
            "userType":null,
            "billingAddress":null,
            "derivedShippingSurchargePriceList":null,
            "secondaryOrganizations":[
            ],
            "shippingAddresses":[
            ]
        },
        {
            "derivedPriceListGroup":null,
            "lastPurchaseDate":null,
            "lastName":"Test",
            "GDPRProfileP13nConsentDate":null,
            "GDPRProfileP13nConsentGranted":false,
            "gender":"female",
            "catalog":null,
            "roles":[
                {
                    "function":"buyer",
                    "relativeTo":{
                        "id":"100001"
                    },
                    "repositoryId":"100006",
                    "name":"Buyer",
                    "id":"100006",
                    "type":"organizationalRole"
                }
            ],
            "locale":"en",
            "parentOrganization":{
                "name":"Oracle",
                "repositoryId":"100001",
                "description":"Oracle Org",
                "active":true,
                "shippingAddress":{
                },
                "secondaryAddresses":[
                    {
                        "firstName":"Harry",
                        "lastName":"Potter",
                        "country":"United States",
                        "types":[
                            {
                                "displayName":"Shipping",
                                "repositoryId":"ss-10001",
                                "id":"ss-10001"
                            },
                            {
                                "displayName":"Billing",
                                "repositoryId":"ss-10002",
                                "id":"ss-10002"
                            }
                        ],
                        "phoneNumber":"9088988999",
                        "city":"Arcadia",
                        "address2":"Suite 400",
                        "address1":"Grundy Lane",
                        "postalCode":"91006",
                        "repositoryId":"110033",
                        "state":"CA"
                    }
                ],
                "id":"100001",
                "billingAddress":{
                },
                "externalOrganizationId":"EXT_ORG_1"
            },
            "shippingSurchargePriceList":null,
            "receiveEmailDate":null,
            "firstPurchaseDate":null,
            "profileType":"b2b_user",
            "translations":{
            },
            "loyaltyPrograms":[
                {
                    "programName":"XTRAREWARDS",
                    "repositoryId":100001,
                    "membershipId":"abc123",
                    "programId":"prog1",
                    "status":"Enrolled"
                },
                {
                    "programName":"XTRAMILES",
                    "repositoryId":100002,
                    "membershipId":"xyz123",
                    "programId":"prog2",
                    "status":"Enrolled"
                }
            ],
            "registrationDate":null,
            "id":"120008",
            "email":"test@example.com",
            "daytimeTelephoneNumber":null,
            "derivedSalePriceList":null,
            "taxExempt":false,
            "customerContactId":"CRMID_12345",
            "receiveEmail":"no",
            "active":true,
            "priceListGroup":null,
            "dateOfBirth":null,
            "lastVisitDate":null,
            "previousVisitDate":null,
            "firstName":"test",
            "repositoryId":"120008",
            "firstVisitDate":null,
            "shippingAddress":null,
            "lastActivity":"2017-01-09T19:21:39.000Z",
            "userType":null,
            "billingAddress":null,
            "derivedShippingSurchargePriceList":null,
            "secondaryOrganizations":[
            ],
            "shippingAddresses":[
            ]
        }
    ]
}

Default Response

The error response. The following are the internal error codes thrown by this API when the request processing fails in Oracle Commerce Cloud: |Error Code|Description| |------------------|------------------| |100070|Invalid Query Expression.| |22000|If the profile id passes is null or empty| |22001|If there was any internal error while getting the profile| |10002|The value x for parameter 'y' is invalid. 'y' can be 'limit', 'offset' or 'sort'.| |22002|If there was no profile found with the given id| |22039|If there was any internal error while listing the profiles|
Body ()
Root Schema : errorModel
Type: object
Show Source
Nested Schema : errors
Type: array
An optional list of errors if multiple errors were encountered
Show Source
Nested Schema : items
Type: object
Show Source
Back to Top