{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["API Report","Configuration","Output Parameters","Help"],"not_rendered":{"images":1,"macros":1},"read":"whole","date_system":"1900"}

{"sheet":"API Report","index":0,"n_rows":1,"n_cols":52,"rows_kept":1}
["MF PARTNUMBER","Quantity","price","partNumber","supplierPartNumber","inStock","customerPartNumber","catentryId","multipleQuantity","minimumQuantity","erpPartNumber","parentCatGroupName","leadTimeUOM","productFeatures","unspscCode","cooCode","longDescription","eccn","quoteFlag","ROHSComplianceCode","supplierStockFlag","mfCode","dataSheetUrl","newProductFlag","thumbnail","shortDescription","pdpUrl","endOfLife","packageTypeCode","topSellerFlag","mfTopCategoryId","packageDescription","factoryStock","pfFlag","currency","customReelFlag","mfCategoryId","tariffFeeList","dropShip","htsn","avnetPartNumber","factoryLeadTime","mdmMaterialNumber","countryOfOrigin","isSoftwareAndIsDownloadable","tariffEligibleFlag","designWinFlag","allocationFlag","obsoleteFlag","manufacturerName","scheduleBCode","unspscVersionCode"]

{"sheet":"Configuration","index":1,"n_rows":5,"n_cols":1,"rows_kept":5}
["UserName"]
["Password"]
["WCToken"]
["WCTrustedToken"]
["API Address"]

{"sheet":"Output Parameters","index":2,"n_rows":53,"n_cols":2,"rows_kept":53}
["Field Name","Field Description "]
["MF Partnumber","Manufacturer Partnumber "]
["Quantity","Quantity for which price should be fetched"]
["price","The unit price for the specified quantity"]
["erpPartNumber","Avnet Partnumber"]
["parentCatGroupName","Immediate parent category name"]
["leadTimeUOM","Lead time unit of measure(D-Days; W- Weeks)"]
["productFeatures","Product features list"]
["unspscCode","United Nations Standard Products and Services Code"]
["customerPartNumber","Customer part numbers associated with the product"]
["cooCode","Country of origin code"]
["longDescription","Long Description of the product"]
["eccn","Export Control Classification Number"]
["quoteFlag","Indicates whether it is a Quote product or not"]
["ROHSComplianceCode","ROHS Compliance code of item"]
["supplierStockFlag","Supplier Stock status"]
["mfCode","Manufacturer code"]
["dataSheetUrl","Data Sheet URL"]
["newProductFlag","Indicator for a New product"]
["thumbnail","Product thumbnail Image URL"]
["catentryId","Catentry Id of the product"]
["shortDescription","Short Description of the product"]
["pdpUrl","Product page URL"]
["multipleQuantity","The product can be sold in quantities that are multiples of this quantity"]
["endOfLife","Indicator for End of Life part"]
["packageTypeCode","Code to determine the Package type of the product"]
["topSellerFlag","Top Selling product indicator"]
["mfTopCategoryId","Manufacturer  Top CategoryId"]
["packageDescription","Package Description"]
["factoryStock","Factory Stock Info"]
["pfFlag","Flag indicating Fulfilled by Newark/Farnell"]
["currency","If profile currency exists it will be considered else Store default currency will be displayed."]
["customReelFlag","Custom Reel"]
["mfCategoryId","Manufacturer  CategoryId"]
["tariffFeeList","Tariff information related list"]
["dropShip","Drop Ship"]
["htsn","htsn Number"]
["avnetPartNumber","Avnet Partnumber"]
["factoryLeadTime","factoryLeadTime in Days"]
["mdmMaterialNumber","MdmMaterialNumber"]
["countryOfOrigin","Country where the product originated"]
["partNumber","Internal Part number"]
["isSoftwareAndIsDownloadable","Flag to check if product is software and downloadable"]
["tariffEligibleFlag","Indicates product is Tariff eligible"]
["minimumQuantity","Minimum quantity that can be purchased"]
["supplierPartNumber","Supplier partnumber"]
["designWinFlag","Design Win Flag"]
["allocationFlag","Allocation Flag"]
["obsoleteFlag","Indicator for obsolete items"]
["manufacturerName","Manufacturer Name of the product"]
["scheduleBCode","Schedule B Code "]
["unspscVersionCode","UNSPSC VersionCode"]
["inStock","In Stock quantity"]

{"sheet":"Help","index":3,"n_rows":6,"n_cols":1,"rows_kept":6}
["Help "]
["How do I retrieve Product Details  ?\na) Ensure details in the configuration sheet are completed first. For queries related to configuration sheet please contact AvnetAPI@avnet.com..\nb) Open the API Report sheet. Enter Product Manufacturer number and Quantity columns\nc) Switch from “Home” to “Avnet API” upper-left hand tab in the excel menu\nd) Click on \"Fetch All\" Button to retrieve product details\n"]
["\nCan I refresh data of one product ? \nYes, place the cursor on the specific row, then Switch to “Avnet API” Tab  and click on “Fetch Row” button.\n"]
["\nCan I rearrange and delete columns in API Report sheet ?\nExcept “MF PARTNUMBER”  and “Quantity” other columns can be re-arranged and/or  deleted.\n\n "]
["Where do I find description about a particular Field ?\n Please refer to “Output Parameters” sheet for the description details.\n"]
["\nI deleted column(s) in Report Sheet, how do I add those back ?\nYou can refer to the “Output Parameters” sheet.  Copy the required “Field Name” and add it as a new column to the API Report sheet. Clicking on Fetch All Button will retrieve the info."]