GET a list of all products
GET/v/pc
- Requires Data Viewer ApiKey permissions.
- Example URI: https://instancename.piminto.com/api/en-us/v/pc
Provides the ability to retrieve information about all products in the PIMS system.
Returns
Returns information about all products in the PIMS system.
This endpoint is especially useful for those who need quick access to a list of all available products in the system, and is a valuable tool for developers and other users wishing to create applications or analyze product-related data.
Request
Query Parameters
Possible values: Value must match regular expression ^\w+\|(asc|desc)$
Sorting field and the sorting order for this field, separator '|'
example order by SKU in ascending order: sku|asc
The number of items per page
The page number
Header Parameters
View name from the PIM's view Dictionary. ✔If the ApiView parameter is not passed- data is returned according to default View defined for access group.
Responses
- 200
success
- application/json
- Schema
- Example (from schema)
Schema
- Array [
- ]
products object[]required
Collection objects Product
data object
attributes object
Detailed information about the product, its variants, their corresponding attributes, and values
Unique product code or number.
Collection of categories that the product is assigned to.
Presented the relative path of the category that is calculated and uses '>' as a separator for the category name.
Status of the product. Can only take the following values: active, inactive, deleted.
Link to internal or external image asset in the form of a url.
Short description of the product.
Presented as a recommended attribute
It can be any attribute from your Pims system. The attribute 'rod_diameter' is provided here as an example for the variation SKU.
Collection of attributes for the current product and the SKUs in the variation_skus collection. The values of these attribute data are set as variations of the product.
Collection of sku's that are variations of the current product. This field value is automatically maintained by the PIMS.
List of sku's that are variations of the current product. This field value is automatically maintained by the PIMS.
variation_matrix object
A JSON object in which the variation SKUs act as keys, and their attribute-value pairs act as values. It represents dynamic data that can vary depending on the product and its variations.
The following JSON schema is provided as an example only, where:
Part-number01, Part-number02- are the variation SKU keys.
rod_diameter- is an attribute of the variation SKUs, which can be any attribute from your Pims system. The attribute 'rod_diameter' is provided here as an example.
Part-number01 object
Part-number02 object
Part-number00 object
Unique product code or number.
definition objectrequired
Complete information about the structure of each attribute in the PIMs system.
status object
label objectrequired
comment objectrequired
variation_skus object
comment objectrequired
label objectrequired
variation_attributes object
label objectrequired
comment objectrequired
variation_of object
label objectrequired
comment objectrequired
sku object
comment objectrequired
label objectrequired
rod_diameter object
label objectrequired
dictionary object
comment objectrequired
price object
label objectrequired
comment objectrequired
title object
label objectrequired
comment objectrequired
categories object
label objectrequired
comment objectrequired
thumbnail object
comment objectrequired
label objectrequired
The status of the API request. A value of "OK" indicates that the request was successfully sent and processed.
The number of products found
{
"products": [
{
"data": {
"attributes": {
"sku": "Part-number00",
"categories": [
"Category-1 Name > Category-2 Name"
],
"status": "active",
"thumbnail": "string",
"title": "Title PART-number00",
"price": "100.00",
"rod_diameter": "2.875 in (7.3 cm)",
"variation_attributes": [
"rod_diameter"
],
"variation_of": null,
"variation_skus": [
[
"Part-number01",
"Part-number02"
]
],
"variation_matrix": {
"Part-number01": {
"rod_diameter": [
"1.66 in (4.22 cm)"
]
},
"Part-number02": {
"rod_diameter": [
"2.625 in (6.67 cm)"
]
},
"Part-number00": {
"rod_diameter": [
"2.875 in (7.3 cm)"
]
}
}
}
},
"sku": "Part-number00"
}
],
"definition": {
"status": {
"type": "string",
"collection": "string",
"isUnique": "string",
"label": {
"en-us": "string"
},
"validation": "string",
"isSearchable": "string",
"isIndexable": "string",
"isFilterable": "string",
"group": "string",
"comment": {
"en-us": "string"
}
},
"variation_skus": {
"isUnique": "string",
"dictionaryIsStatic": "string",
"comment": {
"en-us": "string"
},
"value": "string",
"collection": "string",
"isIndexable": "string",
"label": {
"en-us": "string"
},
"validation": "string",
"group": "string",
"type": "string",
"isSearchable": "string",
"isSimpleType": "string",
"isFilterable": "string"
},
"variation_attributes": {
"isSearchable": "string",
"group": "string",
"type": "string",
"label": {
"en-us": "string"
},
"isIndexable": "string",
"validation": "string",
"isFilterable": "string",
"isSimpleType": "string",
"value": "string",
"comment": {
"en-us": "string"
},
"dictionaryIsStatic": "string",
"isUnique": "string",
"collection": "string"
},
"variation_of": {
"isSimpleType": "string",
"isFilterable": "string",
"type": "string",
"group": "string",
"validation": "string",
"label": {
"en-us": "string"
},
"isIndexable": "string",
"isSearchable": "string",
"collection": "string",
"dictionaryIsStatic": "string",
"isUnique": "string",
"value": "string",
"comment": {
"en-us": "string"
}
},
"sku": {
"isFilterable": "string",
"collection": "string",
"isSearchable": "string",
"comment": {
"en-us": "string"
},
"group": "string",
"type": "string",
"label": {
"en-us": "string"
},
"isIndexable": "string",
"isUnique": "string",
"validation": "string"
},
"rod_diameter": {
"collection": "string",
"isFilterable": "string",
"type": "string",
"isIndexable": "string",
"isUnique": "string",
"isSimpleType": "string",
"group": "string",
"label": {
"en-us": "string"
},
"dictionary": {
"visible": [
0
],
"sortingMethod": "string",
"columns": [
"string"
],
"validation": [
null
],
"sorting": [
null
],
"unique": [
0
],
"data": [
"string"
]
},
"validation": "string",
"value": "string",
"isSearchable": "string",
"comment": {
"en-us": "string"
},
"dictionaryIsStatic": "string"
},
"price": {
"value": "string",
"label": {
"en-us": "string"
},
"comment": {
"en-us": "string"
},
"collection": "string",
"group": "string",
"isFilterable": "string",
"isSimpleType": "string",
"validation": "string",
"isIndexable": "string",
"isUnique": "string",
"type": "string",
"isSearchable": "string",
"dictionaryIsStatic": "string"
},
"title": {
"isFilterable": "string",
"group": "string",
"collection": "string",
"label": {
"en-us": "string"
},
"comment": {
"en-us": "string"
},
"isIndexable": "string",
"isUnique": "string",
"validation": "string",
"isSearchable": "string",
"type": "string"
},
"categories": {
"type": "string",
"collection": "string",
"label": {
"en-us": "string"
},
"isUnique": "string",
"isFilterable": "string",
"isSearchable": "string",
"isIndexable": "string",
"validation": "string",
"group": "string",
"comment": {
"en-us": "string"
}
},
"thumbnail": {
"comment": {
"en-us": "string"
},
"group": "string",
"collection": "string",
"type": "string",
"isSearchable": "string",
"isFilterable": "string",
"isIndexable": "string",
"validation": "string",
"label": {
"en-us": "string"
},
"isUnique": "string"
}
},
"status": "OK",
"sku_count": 1
}