Get/Search Attribute Values

Recent Requests
Log in to see full request history
TimeStatusUser Agent
Retrieving recent requests…
LoadingLoading…

Use this API to retrieve product attribute values configured for your organisation. Attribute values represent the allowed options for a product attribute, such as Cotton and Polyester for a Material attribute, or Red and Blue for a Colour attribute.

  • Fetch attribute values in bulk across the organisation.
  • Retrieve values for specific attributes using attribute codes.
  • Search attribute values by code using the first few words of the code.
  • Include default (possible) values for an attribute when retrieving a single attribute.
  • Paginate through large sets of attribute values.
  • Filter attribute values by organisation unit (OU) when OU support is enabled.
  • Control the fetch scope using ALL, ORG, or SCOPE.

The response includes attribute metadata, associated value definitions, attribution details, and pagination information.

Example request

curl --location 'https://eu.api.capillarytech.com/v2/product/attributes' \
--header 'Content-Type: application/json' \
--header 'Authorization: Basic ' \
--header 'Cookie: _cfuvid=0fWt9yy.y2VwqKIUGVfG8rQPhyPlJgq44GDboQpHIdE-1762514855992-0.0.1.1-604800000'
curl --location 'https://nightly.api.capillarytech.com/v2/product/attributes?entityCodes=firstName_9749135%2CfirstName_7998165' \
--header 'Content-Type: application/json' \
--header 'Authorization: Basic 0YjA3MTUyZDIzNGI3MA==' \
--header 'Cookie: _cfuvid=adIdLElC8oafEHIbx7hw7GbX277Vu_kA.mTpq2xD18k-1762750332464-0.0.1.1-604800000'
curl --location 'https://nightly.api.capillarytech.com/v2/product/attributes?q=first' \
--header 'Content-Type: application/json' \
--header 'Authorization: Basic b3JnMi50aWxsMMTUyZDIzNGI3MA==' \
--header 'Cookie: _cfuvid=adIdLElC8oafEHIbx7hw7GbX277Vu_kA.mTpq2xD18k-1762750332464-0.0.1.1-604800000'

Prerequisites

Resource information

Pagination supportYes
Batch supportYes

Query Parameters

FieldTypeRequiredDescription
qstringOptionalSearches product attributes by their code. This returns product attributes whose names start with the specified query string. • If provided with entityCodes or entityIds, a warning is returned and the other filters are ignored. • Case-insensitive; supports UTF-8 characters. • Maximum 30 characters.
entityCodesstringOptionalA single or comma-separated list of product attributes code. Use the code parameter from the response of the [Add Product attribute API](https://docs.capillarytech.com/reference/add_product_attributes_v2).Used when q` parameter is not provided.
  • This parameter is ignored if q parameter is provided.
  • Format: Case-insensitive; supports UTF-8 characters.
  • Limits: Maximum 30 codes; 50 characters per code.
entityIdsstringOptionalA single or comma-separated list of product attribute id. Use the value of the id parameter from the response of the Add Product attribute API.Example: 1999, 2000
  • Limits: Maximum 30 ID's.
  • This parameter is ignored if the query parameter q or entityCodes are provided.
includeValuesbooleanOptionalIncludes the default values for the attribute in the response. Only works when retrieving a single product attribute using entityCodes or entityIds. If multiple are passed, the API applies it to the first one and issues a warning. Default: false
valuesLimitintegerOptionalMaximum number of attributes to include when includeValues=true.
Default: 10.
Maximum supported values: 20
valuesOffsetintegerOptionalNumber of default attribute values to skip when includeValues=true. Default: 0.
limitintegerOptionalMaximum number of product attributes to retrieve.
  • Default limit: 10.
  • Maximum supported limit: 100.
offsetintegerOptionalNumber of product attributes to skip from the beginning of the result set. Use for pagination.
sortBystringOptionalField to sort by. Supported values: id, code. Default: id.
sortOrderstringOptionalSort direction. Supported values: ASC, DESC. Default:DESC .
ouCodestringOptionalOrganization unit code. Use to filter product attributes by organizational unit when OU support is enabled.
fetchTypestringOptionalScope of product attributes to fetch. Supported Values: ALL (master org and OU), ORG (master org only), SCOPE (OU only).

Example response

{
    "data": [
        {
            "id": 91381,
            "orgId": 50583,
            "ouId": -1,
            "code": "Material",
            "name": "Fabric Material",
            "type": "String",
            "possibleValues": {
                "data": [
                    {
                        "id": 13544113,
                        "code": "Cotton",
                        "name": ""
                    },
                    {
                        "id": 13544114,
                        "code": "Polyester",
                        "name": ""
                    }
                ],
                "pagination": {
                    "limit": 10,
                    "offset": 0,
                    "total": 2
                }
            },
            "attribution": {
                "createdBy": 50019411,
                "createdDate": "2025-09-19T00:00:00+05:30"
            }
        }
    ],
    "pagination": {
        "limit": 50,
        "offset": 0,
        "total": 1
    }
}
{
    "data": [
        {
            "id": 56319,
            "orgId": 50583,
            "ouId": -1,
            "code": "attribute1",
            "name": "attribute1",
            "type": "String",
            "attribution": {
                "createdBy": 15000449,
                "createdDate": "2022-08-31T00:00:00+05:30"
            }
        },
        {
            "id": 56320,
            "orgId": 50583,
            "ouId": 50025951,
            "code": "attributeou",
            "name": "attributeou",
            "type": "String",
            "attribution": {
                "createdBy": 15000449,
                "createdDate": "2022-09-01T00:00:00+05:30"
            }
        },
        {
            "id": 58593,
            "orgId": 50583,
            "ouId": -1,
            "code": "orange",
            "type": "String",
            "defaultValue": {
                "id": 12536916,
                "code": "na",
                "name": "na1"
            },
            "attribution": {
                "createdBy": 0
            }
        },
        {
            "id": 58594,
            "orgId": 50583,
            "ouId": -1,
            "code": "Category4_code",
            "name": "Category4_code",
            "type": "String",
            "attribution": {
                "createdBy": 50685437,
                "createdDate": "2024-07-02T00:00:00+05:30"
            }
        },
        {
            "id": 58595,
            "orgId": 50583,
            "ouId": -1,
            "code": "Category4_description",
            "name": "Category4_description",
            "type": "String",
            "attribution": {
                "createdBy": 50685437,
                "createdDate": "2024-07-02T00:00:00+05:30"
            }
        },
        {
            "id": 58596,
            "orgId": 50583,
            "ouId": -1,
            "code": "Brand",
            "name": "Brand",
            "type": "String",
            "attribution": {
                "createdBy": 50685437,
                "createdDate": "2024-07-02T00:00:00+05:30"
            }
        },
        {
            "id": 58597,
            "orgId": 50583,
            "ouId": -1,
            "code": "Return_window",
            "name": "Return_window",
            "type": "String",
            "attribution": {
                "createdBy": 50685437,
                "createdDate": "2024-07-02T00:00:00+05:30"
            }
        },
        {
            "id": 58598,
            "orgId": 50583,
            "ouId": -1,
            "code": "Parent_Category",
            "name": "Parent_Category",
            "type": "String",
            "attribution": {
                "createdBy": 50685437,
                "createdDate": "2024-07-02T00:00:00+05:30"
            }
        },
        {
            "id": 58599,
            "orgId": 50583,
            "ouId": -1,
            "code": "L1_Category_code",
            "name": "L1_Category_code",
            "type": "String",
            "attribution": {
                "createdBy": 50685437,
                "createdDate": "2024-07-02T00:00:00+05:30"
            }
        },
        {
            "id": 58600,
            "orgId": 50583,
            "ouId": -1,
            "code": "Category1_description",
            "name": "Category1_description",
            "type": "String",
            "attribution": {
                "createdBy": 50685437,
                "createdDate": "2024-07-02T00:00:00+05:30"
            }
        }
    ],
    "pagination": {
        "limit": 10,
        "offset": 0,
        "total": 21
    }
}

Response Parameters

FieldTypeDescription
dataarrayArray of attribute objects matching the query.
.idlongUnique identifier of the attribute.
.orgIdlongOrganisation ID that owns the attribute.
.ouIdlongOrganisational unit ID. -1 indicates the attribute belongs to the master organisation.
.codestringAttribute code/name.
.namestringAttribute display name (label on the UI).
.typestringData type of the attribute (for example, String, Integer, Boolean, Decimal).
.possibleValuesobjectContainer for the attribute’s permissible values and their pagination details. Appears only if includeValues=true.
..dataarrayArray of possible attribute value objects.
...idlongPossible Attribute value ID.
...codestringPossible attribute value name.
...namestringAttribute value display name (can be blank).
..paginationobjectPagination information for possibleValues.
...limitintegerNumber of values returned per page.
...offsetintegerNumber of values skipped.
...totalintegerTotal number of values matching the query.
.attributionobjectInformation about who created and last updated the attribute.
..createdBylongUser ID that created the attribute.
..createdDatestringTimestamp when the attribute was created. Returned in ISO 8601 format with the organisation’s configured timezone offset (for example, +05:30).
..updatedBylongUser ID that last updated the attribute. Present only if the platform records updates for this entity.
..updatedDatestringTimestamp when the attribute was last updated. ISO 8601 with organisation timezone offset. Present only if recorded.
paginationobjectPagination information for the top-level data list.
.limitintegerNumber of results per page.
.offsetintegerNumber of results skipped.
.totalintegerTotal number of attributes matching the query.
warningsarrayArray of warning messages (if any).

Error & warning codes

CodeTypeDescription
10007ErrorentityCodes cannot have more than 30 comma-separated values.
10008ErrorentityIds cannot have more than 30 comma-separated values.
10004ErrorPagination limit cannot exceed more than 100.
10005ErrorPagination limit cannot be zero or negative.
10006ErrorPagination offset cannot be negative.
10002ErrorOU level product filtering is disabled for your organization, but an ouCode was provided.
10001ErrorThe provided ouCode is invalid or does not exist.
10009WarningSearching by q parameter; entityCodes and entityIds were ignored.
10010WarningSearching by entityCodes; entityIds was ignored.
10015WarningincludeValues is only supported for single entity search and was ignored.
10014WarningInvalid sortBy parameter. Defaulting to sort by id.
10011WarningOne or more blank values provided in entityCodes or entityIds were ignored.
10012WarningOne or more non-numeric values provided in entityIds were ignored.
10013WarningAll provided entityIds were invalid and ignored; the query fetches all entities.

Path Params
integer
required
Headers
string
required
Defaults to Basic bmVlcmFqa3Jpc2huYTpkY2VhNmU1ODlhM2U0M2JhODdkMTFkMTM2ODI2NmMx
string
Response

Language
URL
LoadingLoading…
Response
Click Try It! to start a request and see the response here! Or choose an example:
application/json