Product Search by ID
- 6 Minutes to read
- DarkLight
Product Search by ID
- 6 Minutes to read
- DarkLight
Article summary
Did you find this summary helpful?
Thank you for your feedback
To search the product by ID, mention the following in the postman and then click Send.
POST
Query Parameters
Expand to see the parameters and description
Parameter | Parameter Type | Data Type | Accepted Values | Description |
vocabularyId | Recommended (Conditionally Optional) | String | GUID | If a valid companyId is provided, vocabularyId is not Required |
companyId | Required (Conditionally Optional) | String | GUID | If a valid vocabularyId is provided, companyId is not Required |
skipCount | Optional | Integer | >=0; (skipCount+takeCount)<10,000 | Used in combination with takeCount to paginate large numbers of product records. Quantity of records to skip before you start taking products. Whatever value is used for the takeCount, add to skipCount for the subsequent call |
takeCount | Optional | Integer | >= 0; Max: 500 | Sets quantity of results to return at one time. Used for parsing large numbers of product records |
useLens | Optional | Boolean | true/false | Based on target party id as contained in Post body, will return effective values only includes all values. Defaults to true. Ex. Using a recipient ID with useLens as true will return the product data applicable to that recipient |
flattenLensedProduct | Optional | Boolean | true/false | Allows for flattening search results. Using this parameter you'll get only the recipient overrides. |
locale | Optional | enum | ISO 639-1 standard | Stores the value passed in a language specific variant. Facilitates different values in different langugages on the same attribute. Defaults to en-US. |
shouldIncludeMissingVocabularyAttributes | Optional | Boolean | true/false | Will determine if attributes not included in your company vocabulary will be returned in search results. Defaults to setting in customer vocabulary, else defaults to false. If set to true, attributes not in vocabulary will return with its GUID. |
You can change the param values of skipCount, takeCount, vocabularyId, useLens, locale, and shouldIncludeMissingVocabularyAttributes according to your requirements.
You can flatten the payload so it gives you an export-only payload containing a single set of attributes projected from the lens.
In order to flatten the payload, use the parameters mentioned below:
useLens = true,
flattenLensedProduct=true
Remember to specify the TargetPartyAlias in the request body!
Headers
Authorization: Specify required Auth Token in the header.
Request Parameters
Expand to see the parameters and description
Parameter | Parameter Type | Data Type | Accepted Values | Description |
TargetPartyAlias | Optional | String | Recipient identifier: GUID or as aliased in customer vocab | Sets the lens through which the product data is returned from search |
OrderBy | Optional | String | Attribute GUID (Ex. Product Name, Date Created, etc.). | Sets return results order |
Desc | Optional | Boolean | true/false | Determines sort order (ascending or descending). |
RecipientAliases | Optional | Array of Strings | Recipients identifiers: GUIDs or as aliased in a customer vocab | Limits the search to products explicitly linked to specific recipients. |
AttributeFilterOperator | Optional | Boolean Operator | AND/OR | Defaults to AND |
OnHold | Optional | Boolean | true/false | Determines if the search returns OnHold products or not. |
Archived | Optional | Boolean | true/false | Determines if the search returns Archived products or not. |
Language | Optional | Enum | ISO 639-1 standard | Defaults to en-US. Sets the Language to be used for search |
DataOwner | Required | String | GUID | Company ID GUID |
ProductIds | Optional | Array of Strings | Product GUIDs | List of Products to be searched |
IdentifierAttributes | Optional | Array of Strings | Attribute GUIDs | List of identifier types to be searched |
Identifiers | Optional | Array of Strings | Identifier strings | Required if you are using “Identifier Attributes”. Contains the list of identifiers to find. |
AttributeExistsFilters | Optional | Array of Strings | Attribute GUIDs | Returns products that has (does not have) desired attribute. |
AttributeFilters | Optional | Array of Strings | Attribute GUIDs | Searches the value of attribute defined. |
SearchType | Part of AttributeFilters | Enum | Contains - has search val within the attribute value searched Prefix, - starts with this search value Suffix, - ends with this search value Fuzzy, - Similar match (fuzzy, a char might be missing in search value for example) Search - exact match for search value | Part of AttributeFilters |
DateFilter | Optional | Array of Strings | See example, includes: Name, Operator, Value, IncludeMissing | Array (see example). Searched date field and defined. |
Name | Required | Enum | CreatedDate, RecordDate LastModifiedDate, DiscontinueDate, ObsolescenceDate, LastPublishedDate | Part of DateFilter |
Operator | Required | Enum | LessThan, LessThanOrEqualTo, GreaterThan, GreaterThanOrEqualTo | Part of DateFilter |
Value | Required | String | Commonly acceptable string representation of a date/time | Part of DateFilter |
IncludeMissing | Required | Boolean | true/false | Part of DateFilter |
WorkflowFilters | Optional | Array of Strings | Workflow, Statuses [] | Contains an array including “Workflow” name and “Statuses” as defined for the customer workflow. |
Workflow | Required | String | Workflow names as aliased in Customer Vocab | Part of WorkflowFilters |
Statuses | Required | Array of Strings | Statuses names as aliased in Customer Vocab | Part of WorkflowFilters |
PackagingTypes | Optional | Enum | Undefined, BaseUnit, Case, Pallet, Display, Pack, Load, SetPack, MixedModule, MultiPack, PrePack, PrePack_Assortment | Used primarily for GDSN package hierarchy |
ExcludeProductIds | Optional | String | Product GUIDs | List of products to be excluded |
Request
{
"TargetPartyAlias": "47f66d9f-9429-48ad-8f2a-267dcd67a346",
"OrderBy": "bda64a3f-507c-49de-883c-fa832c6539e7",
"Desc": false,
"AttributeFilterOperator": "And",
"OnHold": false,
"Archived": false,
"Language": "en-US",
"DataOwner": "0642243f-73e6-4f04-9037-a118112c2e99",
"ProductIds": [
"c3227cbe-8ee1-4781-93d5-05cbb2ff864d"
]
}
Response 200 OK
{
"ErrorMode": "Fail",
"DefaultLocale": "en-US",
"ProducingOperationDetails": {},
"ProductImportData": {
"ProductsToImport": [
{
"ImportMode": "Update",
"ProductIdentifierPropertyOverride": "",
"ProductIdentifierValue": "c3227cbe-8ee1-4781-93d5-05cbb2ff864d",
"TaxonomyNodes": [],
"CatalogItems": [
{
"Party": "77cee940-0b37-43d2-bd47-b88ee8aba398",
"TargetMarket": "840"
}
],
"PackageType": "BaseUnit",
"ImmediateParentDetails": {
"19e106d9-5c46-40f9-9b6f-02205299706f": {
"Quantity": 12
}
},
"RecipientsToLink": [],
"WorkflowId": null,
"ComplexValues": [],
"NutritionalInformationModule": {
"Values": [],
"MultiValues": [],
"ContainerValues": [],
"AssetValues": [],
"DocumentValues": [],
"IsExplicitNullValue": false
},
"LifeCycle": {
"CreatedDate": {
"Value": "2019-06-14T20:45:06.68295Z",
"Delete": false
},
"DiscontinueDate": {
"Value": "2019-08-10T00:00:00",
"Delete": false
},
"DeleteDate": {
"Value": "2019-08-11T00:00:00",
"Delete": false
}
},
"Values": [
{
"Name": "UPC",
"ValuesByLocale": {
"en-US": "053883471146"
},
"Recipient": "",
"Delete": false,
"IsExplicitNullValue": false
},
{
"Name": "MFG Brand Name",
"ValuesByLocale": {
"en-US": "BELLA Contemporary Storage"
},
"Recipient": "",
"Delete": false,
"IsExplicitNullValue": false
},
{
"Name": "Packaging Level",
"ValuesByLocale": {
"en-US": "BASE_UNIT_OR_EACH"
},
"Recipient": "",
"Delete": false,
"IsExplicitNullValue": false
},
{
"Name": "GTIN",
"ValuesByLocale": {
"en-US": "00053883471146"
},
"Recipient": "",
"Delete": false,
"IsExplicitNullValue": false
},
{
"Name": "MFG Name",
"ValuesByLocale": {
"en-US": "F & M Tool and Plastics, Inc."
},
"Recipient": "",
"Delete": false,
"IsExplicitNullValue": false
},
{
"Name": "Short Description",
"ValuesByLocale": {
"en-US": "14 Quart Storage Container"
},
"Recipient": "",
"Delete": false,
"IsExplicitNullValue": false
},
{
"Name": "Country of Origin (numeric)",
"ValuesByLocale": {
"en-US": "840"
},
"Recipient": "",
"Delete": false,
"IsExplicitNullValue": false
},
{
"Name": "Package Width",
"ValuesByLocale": {
"en-US": "11.500"
},
"Recipient": "",
"Delete": false,
"IsExplicitNullValue": false
},
{
"Name": "Package Height UOM",
"ValuesByLocale": {
"en-US": "INH"
},
"Recipient": "",
"Delete": false,
"IsExplicitNullValue": false
},
{
"Name": "Package Width UOM",
"ValuesByLocale": {
"en-US": "INH"
},
"Recipient": "",
"Delete": false,
"IsExplicitNullValue": false
},
{
"Name": "Package Weight UOM",
"ValuesByLocale": {
"en-US": "LBR"
},
"Recipient": "",
"Delete": false,
"IsExplicitNullValue": false
},
{
"Name": "Package Weight",
"ValuesByLocale": {
"en-US": "0.950"
},
"Recipient": "",
"Delete": false,
"IsExplicitNullValue": false
},
{
"Name": "Has Item Been Recalled",
"ValuesByLocale": {
"en-US": "N"
},
"Recipient": "",
"Delete": false,
"IsExplicitNullValue": false
},
{
"Name": "Item is the Lowest Packaging Level",
"ValuesByLocale": {
"en-US": "Y"
},
"Recipient": "",
"Delete": false,
"IsExplicitNullValue": false
},
{
"Name": "Item is Sold to the Consumer",
"ValuesByLocale": {
"en-US": "Y"
},
"Recipient": "",
"Delete": false,
"IsExplicitNullValue": false
},
{
"Name": "Item is Shipped/Despatched at this Packaging Level",
"ValuesByLocale": {
"en-US": "Y"
},
"Recipient": "",
"Delete": false,
"IsExplicitNullValue": false
},
{
"Name": "Package Depth",
"ValuesByLocale": {
"en-US": "15.250"
},
"Recipient": "",
"Delete": false,
"IsExplicitNullValue": false
},
{
"Name": "Market Availability Date",
"ValuesByLocale": {
"en-US": "2013-02-03 00:00:00.000000"
},
"Recipient": "",
"Delete": false,
"IsExplicitNullValue": false
},
{
"Name": "Net Package Quantity/Net Content",
"ValuesByLocale": {
"en-US": "1.0000"
},
"Recipient": "",
"Delete": false,
"IsExplicitNullValue": false
},
{
"Name": "Information Effective Date",
"ValuesByLocale": {
"en-US": "2013-02-03 00:00:00.000000"
},
"Recipient": "",
"Delete": false,
"IsExplicitNullValue": false
},
{
"Name": "Minimum Order Quantity",
"ValuesByLocale": {
"en-US": "12"
},
"Recipient": "",
"Delete": false,
"IsExplicitNullValue": false
},
{
"Name": "Multiple Order Quantity",
"ValuesByLocale": {
"en-US": "12"
},
"Recipient": "",
"Delete": false,
"IsExplicitNullValue": false
},
{
"Name": "Order UOM",
"ValuesByLocale": {
"en-US": "EA"
},
"Recipient": "",
"Delete": false,
"IsExplicitNullValue": false
},
{
"Name": "Package Depth UOM",
"ValuesByLocale": {
"en-US": "INH"
},
"Recipient": "",
"Delete": false,
"IsExplicitNullValue": false
},
{
"Name": "Package Height",
"ValuesByLocale": {
"en-US": "7.250"
},
"Recipient": "",
"Delete": false,
"IsExplicitNullValue": false
},
{
"Name": "Selling UOM",
"ValuesByLocale": {
"en-US": "EA"
},
"Recipient": "",
"Delete": false,
"IsExplicitNullValue": false
},
{
"Name": "Layers Per Pallet",
"ValuesByLocale": {
"en-US": "5"
},
"Recipient": "",
"Delete": false,
"IsExplicitNullValue": false
},
{
"Name": "Items Per Pallet Layer",
"ValuesByLocale": {
"en-US": "9"
},
"Recipient": "",
"Delete": false,
"IsExplicitNullValue": false
}
],
"MultiValues": [],
"ContainerValues": [],
"AssetValues": [],
"IsExplicitNullValue": false
}
],
"ProductIdentifierProperty": ""
}
}
Was this article helpful?