====== Products Resource ====== The Products Resource allows read access to the Sage 100 Products table. ^Resource Method List^^^^^ ^Action^HTTP^URI^Admin?^Description^ |[[#get|get]]|GET|/products?itemCode=||Retrieve product data for one product| |[[#list|list]]|GET|/products \\ /products?offset=&limit= \\ /products?itemType=<1%%|%%2%%|%%3%%|%%4%%|%%5>|Only|Retrieve a list of products| **Resource Table List** \\ Click on the table to view detail. {{page>enhancements:sage100:modules:sde:api:tables:category&inline&noheader&nofooter}} {{page>enhancements:sage100:modules:sde:api:tables:ci_item&inline&noheader&nofooter}} {{page>enhancements:sage100:modules:sde:api:tables:ci_extended_description&inline&noheader&nofooter}} {{page>enhancements:sage100:modules:sde:api:tables:im_warehouse&inline&noheader&nofooter}} {{page>enhancements:sage100:modules:sde:api:tables:ap_vendor_contact&inline&noheader&nofooter}} {{page>enhancements:sage100:modules:sde:api:tables:ap_division&inline&noheader&nofooter}} {{page>enhancements:sage100:modules:sde:api:tables:im_warranty_code&inline&noheader&nofooter}} {{page>enhancements:sage100:modules:sde:api:tables:im_product_line&inline&noheader&nofooter}} {{page>enhancements:sage100:modules:sde:api:tables:im_price_code&inline&noheader&nofooter}} {{page>enhancements:sage100:modules:sde:api:tables:im_buyer_planner_code&inline&noheader&nofooter}} {{page>enhancements:sage100:modules:sde:api:tables:im_sales_promotion&inline&noheader&nofooter}} {{page>enhancements:sage100:modules:sde:api:tables:im_item_vendor&inline&noheader&nofooter}} {{page>enhancements:sage100:modules:sde:api:tables:gl_account&inline&noheader&nofooter}} {{page>enhancements:sage100:modules:sde:api:tables:ap_division&inline&noheader&nofooter}} {{page>enhancements:sage100:modules:sde:api:tables:ap_vendor&inline&noheader&nofooter}} {{page>enhancements:sage100:modules:sde:api:tables:sy_slaes_tax_class&inline&noheader&nofooter}} \\ ===== Resource Methods ===== ==== Get ==== Users and Administrators can retrieve data for a single Product. This can include data from any of the tables associated with the resource. ==== List ==== Users and Administrators can retrieve all product data from the Products Resource. The return can be limited to a number of products by specifying the Limit and Offset. The return can also be limited by passing any non-key column to the resource.