Get all item details
get
/fscmRestApi/resources/11.13.18.05/shoppingCatalogItemDetails
Request
Query Parameters
-
expand: string
When this parameter is provided, the specified children are included in the resource payload (instead of just a link). The value of this query parameter is "all" or "". More than one child can be specified using comma as a separator. Example: ?expand=Employees,Localizations. Nested children can also be provided following the format "Child.NestedChild" (Example: ?expand=Employees.Managers). If a nested child is provided (Example: Employees.Managers), the missing children will be processed implicitly. For example, "?expand=Employees.Managers" is the same as "?expand=Employees,Employees.Managers" (which will expand Employees and Managers).
-
fields: string
This parameter filters the resource fields. Only the specified fields are returned, which means that if no fields are specified, no fields are returned (useful to get only the links). If an indirect child resource is provided (Example: Employees.Managers), the missing children will be processed implicitly. For example, "?fields=Employees.Managers:Empname" is the same as "?fields=;Employees:;Employees.Managers:Empname" (which will only return the "Empname" field for Managers). the value of this query parameter is a list of resource fields. The attribute can be a direct (Example: Employees) or indirect (Example: Employees.Managers) child. It cannot be combined with expand query parameter. If both are provided, only fields will be considered.
Format: ?fields=Attribute1,Attribute2
Format for fields in child resource: ?fields=Accessor1:Attribute1,Attribute2 -
finder: string
Used as a predefined finder to search the collection.
Format: ?finder=<finderName>;<variableName>=<variableValue>,<variableName2>=<variableValue2>
The following are the available finder names and corresponding finder variables:- FindById: Finds catalog item details according to the search object identifier and user preference identifier.
Finder Variables:- GuidedBuyingEnabledFlag; string; Contains one of the following values: true or false. If true, then it returns the master item document for an item that's on a blanket purchase agreement. If false, then it doesn't return the master item document for an item that's on blanket purchase agreement. This is used for the feature Procure Goods from Preferred Sources During Catalog Shopping. This attribute's default value is false.
- SearchObjectId; integer; Value that uniquely identifies the search object referenced by the catalog item.
- UserPreferenceId; integer; Value that uniquely identifies the user preference referenced by the catalog item.
- FindByRequisitionLineId: Finds details of the item referenced by the requisition line.
Finder Variables:- RequisitionLineId; integer; Value that uniquely identifies the requisition line for which the information is queried.
- PrimaryKey: Finds catalog item details according to the primary key.
Finder Variables:- SearchObjectId; integer; Value that uniquely identifies the search object referenced by the catalog item.
- FindById: Finds catalog item details according to the search object identifier and user preference identifier.
-
limit: integer
This parameter restricts the number of resources returned inside the resource collection. If the limit exceeds the resource count then the framework will only return the available resources.
-
links: string
This parameter can be used to show only certain links while accessing a singular resource or a resource collection. The parameter value format is a comma-separated list of : <link_relation>
Example:
self,canonical -
offset: integer
Used to define the starting position of the resource collection. If offset exceeds the resource count then no resources are returned. Default value is 0.
-
onlyData: boolean
The resource item payload will be filtered in order to contain only data (no links section, for example).
-
orderBy: string
This parameter orders a resource collection based on the specified fields. The parameter value is a comma-separated string of attribute names, each optionally followed by a colon and "asc" or "desc". Specify "asc" for ascending and "desc" for descending. The default value is "asc". For example, ?orderBy=field1:asc,field2:desc
-
q: string
This query parameter defines the where clause. The resource collection will be queried using the provided expressions. The value of this query parameter is one or more expressions. Example: ?q=Deptno>=10 and <= 30;Loc!=NY
Format: ?q=expression1;expression2
You can use these queryable attributes to filter this collection resource using the q query parameter:- SearchObjectId; integer; Value that uniquely identifies the search object referenced by the catalog item.
- SourceDocumentHeaderId; integer; Value that uniquely identifies the agreement header.
- SourceDocumentLineId; integer; Value that uniquely identifies the agreement line.
-
totalResults: boolean
The resource collection representation will include the "estimated row count" when "?totalResults=true", otherwise the count is not included. The default value is "false".
Header Parameters
-
Metadata-Context:
If the REST API supports runtime customizations, the shape of the service may change during runtime. The REST client may isolate itself from these changes or choose to interact with the latest version of the API by specifying this header. For example: Metadata-Context:sandbox="TrackEmployeeFeature".
-
REST-Framework-Version:
The protocol version between a REST client and service. If the client does not specify this header in the request the server will pick a default version for the API.
There's no request body for this operation.
Back to TopResponse
Supported Media Types
- application/json
Default Response
The following table describes the default response for this task.
Headers
-
Metadata-Context:
If the REST API supports runtime customizations, the shape of the service may change during runtime. The REST client may isolate itself from these changes or choose to interact with the latest version of the API by specifying this header. For example: Metadata-Context:sandbox="TrackEmployeeFeature".
-
REST-Framework-Version:
The protocol version between a REST client and service. If the client does not specify this header in the request the server will pick a default version for the API.
Root Schema : shoppingCatalogItemDetails
Type:
Show Source
object-
count(required): integer
The number of resource instances returned in the current range.
-
hasMore(required): boolean
Indicates whether more resources are available on the server than the subset returned in the response. If the value is true, then there are more resources to retrieve from the server. The default value is false.
-
items: array
Items
Title:
ItemsThe items in the collection. -
limit(required): integer
The actual paging size used by the server.
-
links(required): array
Links
Title:
LinksThe link relations associated with the resource instance. -
offset(required): integer
The offset value used in the current page.
-
totalResults: integer
The estimated row count when "?totalResults=true", otherwise the count is not included.
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : shoppingCatalogItemDetails-item-response
Type:
Show Source
object-
AllowDescriptionOverrideForBPAFlag: boolean
Read Only:
trueMaximum Length:1Contains one of the following values: true, false, or NULL. If true, then the blanket purchase agreement line allows a description override. If false, then the blanket purchase agreement line doesn't allow a description override. If NULL, then the value is not available. This attribute doesn't have a default value. -
AllowMasterItemDescriptionUpdateFlag: boolean
Title:
Allow Purchasing Document Description UpdateRead Only:trueMaximum Length:1Contains one of the following values: true, false, or NULL. If true, then the master item allows description updates on purchasing documents. If false, then the master item doesn't allow description updates on purchasing documents. If NULL, then the value is not available. This attribute doesn't have a default value. -
AllowPriceOverrideForBPAFlag: boolean
Read Only:
trueMaximum Length:1Contains one of the following values: true, false, or NULL. If true, then the blanket purchase agreement line allows a price override. If false, then the blanket purchase agreement line doesn't allow a price override. If NULL, then the value is not available. This attribute doesn't have a default value. -
Amount: number
Read Only:
trueAmount of the service items in the currency of the buying company. -
Availability: string
Title:
AvailabilityRead Only:trueMaximum Length:700Value that shows the availability of the goods and services. -
BPAPriceLimit: number
Title:
Price LimitRead Only:truePrice limit set on a blanket purchase agreement line that allows price override. -
buyingOptions: array
Buying Options
Title:
Buying OptionsThe Buying Options resource gets the different buying options when an item is referenced by multiple agreements. -
CategoryName: string
Read Only:
trueMaximum Length:255Name of the category that classifies the agreement line. -
Comments: string
Title:
CommentsRead Only:trueMaximum Length:700Comments on the agreement line. -
CreatedBy: string
Read Only:
trueMaximum Length:64User who created the item details. -
CreationDate: string
(date-time)
Read Only:
trueDate on which the user created the item details. -
CurrencyCode: string
Read Only:
trueAbbreviation that identifies the item currency. -
ImageURL: string
Read Only:
trueMaximum Length:700URL (Uniform Resource Locator) of the image of the agreement line. -
InternallyTransferableItemFlag: boolean
Title:
ShippableRead Only:trueMaximum Length:1Contains one of the following values: true or false. If true, then the item is internally transferrable. If false, then the item isn't internally transferrable. This attribute doesn't have a default value. -
InternalTransferOrderEnabledFlag: boolean
Title:
Transfer Orders EnabledRead Only:trueMaximum Length:1Contains one of the following values: true or false. If true, then the item is enabled for internal transfer orders. If false, then the item is disabled for internal transfer orders. This attribute doesn't have a default value. -
ItemCatalogCategoryId: integer
Read Only:
trueValue that uniquely identifies the category of the item. -
itemGTINRelationships: array
Item GTIN Relationships
Title:
Item GTIN RelationshipsThe Item GTIN Relationships resource gets the global trade item number (GTIN) details for the master item. -
itemImages: array
Item Images
Title:
Item ImagesThe Item Images resource gets the images for the master item. -
itemManufacturers: array
Item Manufacturers
Title:
Item ManufacturersThe Item Manufacturers resource gets the manufacturer details for the master item. -
ItemNumber: string
Read Only:
trueMaximum Length:300Name of the master item. -
ItemRevision: string
Read Only:
trueMaximum Length:255Revision of the master item. -
itemRevisions: array
Item Revisions
Title:
Item RevisionsA revision represents a particular version of an item. -
itemSuppliers: array
Item Suppliers
Title:
Item SuppliersThe Item Suppliers resource gets the supplier details for the master item. -
LastUpdateDate: string
(date-time)
Read Only:
trueDate on which the user last updated the item details. -
LastUpdatedBy: string
Read Only:
trueMaximum Length:64User who last updated the item details. -
LeadTime: number
Title:
Lead Time DaysRead Only:trueTime taken by the supplier to deliver the goods once an order is placed. -
LineType: string
Title:
Line TypeRead Only:trueMaximum Length:30Type of agreement line. Valid values are Goods or Services or any user-defined line type. -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
LongDescription: string
Read Only:
trueMaximum Length:255Long description of the item. -
Manufacturer: string
Read Only:
trueMaximum Length:700Name of the party who manufactures the item. -
ManufacturerPartNumber: string
Read Only:
trueMaximum Length:700Number issued by the manufacturer that uniquely identifies the individual product. -
OrderTypeLookupCode: string
Read Only:
trueMaximum Length:25Abbreviation that identifies the type of agreement line. Valid values are QUANTITY Services or FIXED Services. -
PackagingString: string
Read Only:
trueMaximum Length:255Unit of measure of the packaged supply items. -
PurchasingEnabledFlag: boolean
Title:
PurchasableRead Only:trueMaximum Length:1Contains one of the following values: true or false. If true, then the item is enabled for purchasing. If false, then the item is disabled for purchasing. This attribute doesn't have a default value. -
RestrictSubinventories: string
Read Only:
trueValue that specifies whether the item is restricted by subinventories. -
SearchObjectId: integer
(int64)
Value that uniquely identifies the search object referenced by the catalog item.
-
ShortDescription: string
Read Only:
trueMaximum Length:255Description of the item. -
SourceDocumentHeaderId: integer
(int64)
Value that uniquely identifies the agreement header.
-
SourceDocumentHeaderNumber: string
Title:
AgreementRead Only:trueMaximum Length:30Number that identifies the agreement on which the item is available. -
SourceDocumentLineId: integer
(int64)
Value that uniquely identifies the agreement line.
-
StockEnabled: string
Title:
StockedRead Only:trueMaximum Length:1Value that specifies whether the item is stockable in the deliver-to organization. -
SupplierItem: string
Read Only:
trueMaximum Length:300Number that identifies the supplier item. -
SupplierItemAuxiliaryId: string
Read Only:
trueMaximum Length:255Value that uniquely identifies the supplier item auxiliary. -
SupplierName: string
Read Only:
trueMaximum Length:360Name of the supplier of the item or agreement. -
UnitOfMeasure: string
Read Only:
trueMaximum Length:255Unit of measure that the item uses. -
UnitPrice: number
Read Only:
truePrice of the item in the currency of the buying company. -
UNSPSC: string
Title:
UNSPSCRead Only:trueMaximum Length:700Value that uniquely identifies the goods and services that are bought. -
UOMCode: string
Read Only:
trueMaximum Length:255Abbreviation that identifies the unit of measure.
Nested Schema : Buying Options
Type:
arrayTitle:
Buying OptionsThe Buying Options resource gets the different buying options when an item is referenced by multiple agreements.
Show Source
Nested Schema : Item GTIN Relationships
Type:
arrayTitle:
Item GTIN RelationshipsThe Item GTIN Relationships resource gets the global trade item number (GTIN) details for the master item.
Show Source
Nested Schema : Item Images
Type:
arrayTitle:
Item ImagesThe Item Images resource gets the images for the master item.
Show Source
Nested Schema : Item Manufacturers
Type:
arrayTitle:
Item ManufacturersThe Item Manufacturers resource gets the manufacturer details for the master item.
Show Source
Nested Schema : Item Revisions
Type:
arrayTitle:
Item RevisionsA revision represents a particular version of an item.
Show Source
Nested Schema : Item Suppliers
Type:
arrayTitle:
Item SuppliersThe Item Suppliers resource gets the supplier details for the master item.
Show Source
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : shoppingCatalogItemDetails-buyingOptions-item-response
Type:
Show Source
object-
Amount: number
Read Only:
trueAmount of the service items in the currency of the buying company. -
CategoryName: string
Read Only:
trueMaximum Length:250Name of the category that classifies the agreement line. -
Comments: string
Title:
CommentsRead Only:trueMaximum Length:700Comments on the agreement line. -
CurrencyCode: string
Read Only:
trueMaximum Length:15Abbreviation that identifies the item currency. -
ImageURL: string
Read Only:
trueMaximum Length:255URL (Uniform Resource Locator) of the image of the agreement line. -
ItemNumber: string
Read Only:
trueMaximum Length:300Name of the master item. -
LineType: string
Title:
Line TypeRead Only:trueMaximum Length:30Type of agreement line. Valid values are Goods or Services. -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
LongDescription: string
Read Only:
trueMaximum Length:255Long description of the item. -
Manufacturer: string
Title:
ManufacturerRead Only:trueMaximum Length:700Name of the party who manufactures the item. -
ManufacturerPartNumber: string
Title:
Manufacturer Part NumberRead Only:trueMaximum Length:700Number issued by the manufacturer that uniquely identifies the individual product. -
PackagingString: string
Read Only:
trueMaximum Length:255Unit of measure of the packaged supply items. -
SearchObjectId: integer
(int64)
Value that uniquely identifies the goods and services that are bought.
-
ShortDescription: string
Title:
DescriptionRead Only:trueMaximum Length:240Description of the item. -
SourceDocumentHeaderId: integer
(int64)
Value that uniquely identifies the agreement header.
-
SourceDocumentHeaderNumber: string
Title:
AgreementRead Only:trueMaximum Length:30Number that identifies the agreement on which the item is available. -
SourceDocumentLineId: integer
(int64)
Value that uniquely identifies the agreement line.
-
SupplierItem: string
Title:
Supplier ItemRead Only:trueMaximum Length:300Number that identifies the supplier item. -
SupplierItemAuxiliaryId: string
Title:
Supplier Item Auxiliary IdentifierRead Only:trueMaximum Length:255Value that uniquely identifies the supplier item auxiliary. -
SupplierName: string
Read Only:
trueMaximum Length:360Name of the supplier of the agreement line. -
UnitPrice: number
Title:
PriceRead Only:truePrice of the item in the currency of the buying company. -
UNSPSC: string
Title:
UNSPSCRead Only:trueMaximum Length:700Value that uniquely identifies the goods and services that are bought. -
UOMCode: string
Title:
UOM CodeRead Only:trueMaximum Length:3Abbreviation that identifies the unit of measure.
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : link
Type:
Show Source
object-
href: string
Title:
hyperlink referenceThe URI to the related resource. -
kind: string
Title:
kindAllowed Values:[ "collection", "item", "describe", "other" ]The kind of the related resource. -
name: string
Title:
nameThe name of the link to the related resource. -
properties: object
properties
-
rel: string
Title:
relationAllowed Values:[ "self", "lov", "parent", "canonical", "child", "enclosure", "action", "custom" ]The name of the relation to the resource instance. Example: self.
Nested Schema : properties
Type:
Show Source
object-
changeIndicator: string
Change indicator or the ETag value of the resource instance.
Nested Schema : shoppingCatalogItemDetails-itemGTINRelationships-item-response
Type:
Show Source
object-
GTIN: string
Title:
GTINRead Only:trueMaximum Length:255Value that uniquely identifies the global trade item number (GTIN) of the master item. -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
PartyType: string
Read Only:
trueMaximum Length:255Type of party of the global trade item number (GTIN). Values can be blank, a supplier, or a manufacturer. -
UOM: string
Title:
UOMRead Only:trueMaximum Length:25Abbreviation that identifies the unit of measure for which the global trade item number (GTIN) is defined.
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : shoppingCatalogItemDetails-itemImages-item-response
Type:
Show Source
object-
DownloadInfo: string
Title:
DownloadInfoJSON formatted string containing information required to programmatically retrieve a file attachment. -
FileWebImage: string
(byte)
Title:
File Web ImageRead Only:trueBase64-encoded image of the file displayed in .png format if the source is a convertible image. -
ItemImageURL: string
Read Only:
trueUniform resource locator (URL) of the item image. -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
PostProcessingAction: string
Title:
PostProcessingActionName of the action that can be performed after an attachment is uploaded.
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : shoppingCatalogItemDetails-itemManufacturers-item-response
Type:
Show Source
object-
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
Manufacturer: string
Title:
ManufacturerRead Only:trueMaximum Length:360Name of the manufacturer of the item. -
ManufacturerPartNumber: string
Title:
Manufacturer Part NumberRead Only:trueMaximum Length:150Number issued by the manufacturer that uniquely identifies the individual part. This attribute differentiates the part from similar parts and counterfeits.
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : shoppingCatalogItemDetails-itemRevisions-item-response
Type:
Show Source
object-
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
Revision: string
Title:
Revision CodeRead Only:trueMaximum Length:18Revision of the master item.
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : shoppingCatalogItemDetails-itemSuppliers-item-response
Type:
Show Source
object-
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
Supplier: string
Title:
SupplierRead Only:trueMaximum Length:360Name of the supplier of the master item. -
SupplierPartNumber: string
Title:
Supplier ItemRead Only:trueMaximum Length:150Number issued by the supplier that uniquely identifies the individual part. This attribute differentiates the part from similar parts and counterfeits.
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source