Ok. I'm lost. How do I access the JSON data from this nested query? I used the Xbasic SQL Actions Code Generator Genie to create this.
Here is the result. The JSON formatting didn't follow over.
So, now I want to fill in fields on the UX component...
e.control.ProductName = (what goes here to get the json data).web_PRODUCTNAME
Code:
dim ops as p ops.connectionString = "::Name::SQL" dim ops.sql as c ops.json = .t. 'define the nested sql queries and query properties. each level of indentation denotes a parent-child relationship ops.sql = <<%xstr% {sql: 'SELECT \t* FROM (Inventory_New Inventory_New \t LEFT OUTER JOIN FurnitureCollection FurnitureCollection \t\t ON Inventory_New.Collection = FurnitureCollection.CollectionID \t LEFT OUTER JOIN Web_SleeveLength Web_SleeveLength \t\t ON Inventory_New.web_SleeveLengthID = Web_SleeveLength.SleeveLengthID \t LEFT OUTER JOIN Web_Title Web_Title \t\t ON Inventory_New.web_TitleSelect = Web_Title.TitleID \t LEFT OUTER JOIN Web_Sizes Web_Sizes \t\t ON Inventory_New.web_SizeID = Web_Sizes.SizeID \t LEFT OUTER JOIN Web_ShoulderCut Web_ShoulderCut \t\t ON Inventory_New.web_ShoulderCutID = Web_ShoulderCut.ShoulderCutID \t LEFT OUTER JOIN Web_Pattern Web_Pattern \t\t ON Inventory_New.web_PatternID = Web_Pattern.PatternID \t LEFT OUTER JOIN Web_Neckline Web_Neckline \t\t ON Inventory_New.web_NecklineID = Web_Neckline.NecklineID \t LEFT OUTER JOIN Web_Condition Web_Condition \t\t ON Inventory_New.web_ConditionID = Web_Condition.ConditionID \t LEFT OUTER JOIN Web_CategoryList Web_CategoryList \t\t ON Inventory_New.web_CategorySelect = Web_CategoryList.CategoryListID \t LEFT OUTER JOIN Web_Brands Web_Brands \t\t ON Inventory_New.web_BrandID = Web_Brands.BrandID \t LEFT OUTER JOIN Web_Accents Web_Accents \t\t ON Inventory_New.web_AccentsID = Web_Accents.AccentsID \t LEFT OUTER JOIN OrderItems OrderItems \t\t ON Inventory_New.web_PRODUCT_INFORMATION_ID = OrderItems.PARTNO ) WHERE Inventory_New.web_PRODUCT_INFORMATION_ID = 302910',name: 'Prod',sqlSecurityJSON: ''} {sql: 'SELECT * FROM Product_Variables',name: 'ProdVar',parentKey: 'web_PRODUCT_INFORMATION_ID',key: 'Product_Information_ID',sqlSecurityJSON: ''} {sql: 'SELECT * FROM Product_Variables_Items',name: 'ProdVarItems',parentKey: 'VariableID',key: 'VariableID',sqlSecurityJSON: ''} %xstr% dim args as sql::arguments dim p as p 'execute the definition to get the JSON data p = a5_sql_nested_query_to_json_document(ops,args) if p.hasError = .f. then dim json as c json = p.json else 'there was an error dim errorText as c errorText = p.errortext end if
Code:
[ { "item_id": "103747", "SKU": null, "item_name": null, "category": null, "supplier": null, "cost": null, "price": null, "tax1": null, "tax2": null, "quantity": null, "reorderlevel": null, "location": null, "description": null, "allowAltDescription": null, "has_serial": null, "DateAdded": null, "TimeAdded": null, "DateModified": "07/15/2021", "is_gun": null, "caliber": null, "additionalinfo": null, "serial": null, "manufacturer": null, "model": null, "type": null, "additionalguninfo": null, "new_used": null, "Deleted": null, "Start_Bal": null, "Qty_In": null, "Adjust_Qty": null, "Qty_out": null, "Active": null, "IsTradeIn": null, "TradeInSaleID": null, "FirearmsBookID": null, "GeneralManufacturer": null, "GeneralModel": null, "TaxExempt": null, "QuickButton": null, "NoInventory": null, "Size": "1089", "isBarcode": null, "item_id_name": null, "Copies": null, "StoreGen": null, "VendorModel": null, "Inventory": "F", "isDelete": "F", "Size_Group": null, "FinancePrice": null, "ProductID": null, "ProductVariable": "T", "PriceMultiple": "2.2", "FinanceMultiple": null, "PriceSheetHeader": null, "PriceSheetDescription": null, "ItemWidth": "1", "ItemDepth": "1", "ItemHeight": "1", "canFinance": null, "canLayaway": null, "imageMain": null, "imageDisplay": null, "imageList": null, "BC_Item_ID": null, "BC_Size_Group_ID": null, "BC_Category_ID": null, "BTD_ID": null, "isMobileBarcode": null, "web_PRODUCT_INFORMATION_ID": "302910", "web_PRODUCT_ID_CODE": "141f8c05-6dc1-46a6-82eb-b5e8fc51a424", "web_PRODUCTNAME": "Test Product Name", "web_PRODUCT_SHORT_DESCRIPTION": "", "web_PRODUCTLONGDESCRIPTION": "test product web long description", "web_MARKUP": "40", "web_ASI_DISCOUNT": "40", "web_TemplateName": null, "web_TemplateName2": null, "web_TemplateName3": null, "web_TemplateName4": null, "web_ShipWidth": "23", "web_ShipHeight": "52", "web_ShipDepth": "11", "web_ShipWeight": "14", "web_PrintWidth": "", "web_PrintHeight": "", "web_InternalSKU": "10001961", "web_HardwareSKU": null, "web_SupplierSKU": "TEST", "web_Color": "", "web_BlackColor": null, "web_SilverColor": null, "web_PrimaryImage1": null, "web_Image1": "fcc299b102674704b522b1c03b6cfed4.jpg", "web_ImageThumbnail1": "fcc299b102674704b522b1c03b6cfed4_thumbNail.jpg", "web_ImageThumbnailList1": "fcc299b102674704b522b1c03b6cfed4_thumbNailList.jpg", "web_PrimaryImage2": null, "web_Image2": null, "web_ImageThumbnail2": null, "web_ImageThumbnailList2": null, "web_PrimaryImage3": null, "web_Image3": null, "web_ImageThumbnail3": null, "web_ImageThumbnailList3": null, "web_PrimaryImage4": null, "web_Image4": null, "web_ImageThumbnail4": null, "web_ImageThumbnailList4": null, "web_User_Company_ID": "103338", "web_PricingType": "4", "web_Cost": "55", "web_Wholesale": "0", "web_Retail": "121", "web_lnft_cost": "0", "web_lnft_wholesale": "0", "web_lnft_retail": "0", "web_sqft_cost": "0", "web_sqft_retail": "0", "web_sqft_wholesale": "0", "web_vari_cost": "55", "web_vari_wholesale": "0", "web_vari_retail": "169", "web_SalePrice": "0", "web_SaleStartDate": null, "web_SaleEndDate": null, "web_SaleEnabled": "T", "web_AdvancedPricing": "F", "web_BasicPricing": "T", "web_CalculateAdvanced": "T", "web_Active": "T", "web_ActiveOnWeb": "F", "web_Image1WebLarge": "fcc299b102674704b522b1c03b6cfed4_webLarge.jpg", "web_Image1WebList": "fcc299b102674704b522b1c03b6cfed4_webList.jpg", "web_Image1WebThumb": "fcc299b102674704b522b1c03b6cfed4_webThumb.jpg", "web_Image1WebMobileList": "fcc299b102674704b522b1c03b6cfed4_web1MobileList.jpg", "web_Image1WebMobile": "fcc299b102674704b522b1c03b6cfed4_web1Mobile.jpg", "web_Image2WebLarge": null, "web_Image2WebList": null, "web_Image2WebThumb": null, "web_Image2WebMobileList": null, "web_Image2WebMobile": null, "web_Image3WebLarge": null, "web_Image3WebList": null, "web_Image3WebThumb": null, "web_Image3WebMobileList": null, "web_Image3WebMobile": null, "web_Image4WebLarge": null, "web_Image4WebList": null, "web_Image4WebThumb": null, "web_Image4WebMobileList": null, "web_Image4WebMobile": null, "web_WebProductShortDesc": "Test product web short description", "web_sqin_cost": "0", "web_sqin_wholesale": "0", "web_sqin_retail": "0", "web_Vendor": "", "web_WHOLESALEDISC": "0", "web_ShipWidth2": "", "web_ShipHeight2": "", "web_ShipDepth2": "", "web_FriendlyURL": null, "web_OneOff": "F", "web_BrandID": "0", "web_ConditionID": "7", "web_PatternID": "0", "web_SizeID": "0", "web_CategorySelect": "1021", "web_ColorID": "0", "web_StyleIDSelect": "", "web_NecklineID": "0", "web_MaterialSelect": null, "web_SleeveLengthID": "0", "web_AccentsID": "0", "web_ShoulderCutID": "0", "web_Location": "1A", "web_Bin": "4F", "web_Warehouse": "10", "web_SubCategorySelect": "20", "web_TitleSelect": "0", "web_meta_site_name": "", "web_meta_title": "Test Product Name", "web_meta_description": "New In Box , , Size", "web_meta_image": "", "web_Image1WebZoom": "fcc299b102674704b522b1c03b6cfed4_Image1WebZoom.jpg", "web_Image2WebZoom": null, "web_Image3WebZoom": null, "web_Image4WebZoom": null, "web_isSold": "F", "web_InventoryQty": "3", "web_ShipWeight2": "0", "web_ProductCategory": "", "web_WearDetails": "", "web_Order_ID": null, "web_nonBrand": "T", "web_isFeatured": "F", "web_inStore": "0", "web_isWeb": "1", "UPC_code": null, "isUPC": null, "UPC_ItemName": null, "UPC_Model": null, "UPC_Size": null, "DADD": null, "FurnitureColor": null, "isSpecialOrder": null, "web_RegPrice": "242", "web_RetailMultiplier": null, "QuickButtonOrder": null, "QuickButtonTab": null, "Collection": "", "AssembledUpCharge": null, "AssembledPrice": null, "FoundationCost": null, "FoundationPrice": null, "MattressSetCost": null, "MattressSetRetail": null, "web_Image6WebZoom": null, "web_Image6WebLarge": null, "web_Image6WebThumb": null, "web_Image5WebZoom": null, "web_Image5WebLarge": null, "web_Image5WebThumb": null, "web_Image7WebZoom": null, "web_Image7WebLarge": null, "web_Image7WebThumb": null, "web_Image8WebZoom": null, "web_Image8WebLarge": null, "web_Image8WebThumb": null, "web_Image9WebZoom": null, "web_Image9WebLarge": null, "web_Image9WebThumb": null, "web_Image10WebZoom": null, "web_Image10WebLarge": null, "web_Image10WebThumb": null, "show_web_Image2": null, "show_web_Image3": null, "show_web_Image4": null, "show_web_Image5": null, "show_web_Image6": null, "show_web_Image7": null, "show_web_Image8": null, "show_web_Image9": null, "show_web_Image10": null, "web_Image5": null, "web_Image6": null, "web_Image7": null, "web_Image8": null, "web_Image9": null, "web_Image10": null, "web_ImageThumbnail5": null, "web_ImageThumbnail6": null, "web_ImageThumbnail7": null, "web_ImageThumbnail8": null, "web_ImageThumbnail9": null, "web_ImageThumbnail10": null, "SalePercentOff": "0", "CollectionID": null, "CollectionName": null, "Company_ID": null, "SleeveLengthID": null, "SleeveLength": null, "TitleID": null, "Title": null, "CategoryID": null, "SizeID": null, "Size_1": null, "GroupID": null, "ShoulderCutID": null, "ShoulderCut": null, "PatternID": null, "Pattern": null, "NecklineID": null, "Neckline": null, "ConditionID": "7", "Condition": "New In Box", "CategoryListID": "1021", "Category_1": "Livingroom Furniture", "BrandID": null, "Brand": null, "AccentsID": null, "Accents": null, "ORDERITEMS_ID": "1514", "PARTNO": "302910", "QTY": "1", "DESCRIPTION_1": null, "PRICE_1": "50.6", "EXTENDEDTOTAL": "50.6", "Discount": null, "User_Company_ID": "103338", "ORDERINFO_ID": null, "ProofID": null, "ItemName": "Test Product Name", "Supplier_SKU": null, "Internal_SKU": "Item # 10001961", "ProductIDCode": null, "PrintFile": null, "BasicPricing": null, "AdvancedPricing": null, "ItemStatus": null, "BasicWholesalePrice": null, "BasicRetailPrice": null, "WholesalePricing": null, "CalcPrice": null, "SalesTax": null, "SalesTaxTotal": null, "SalesTaxName": null, "ItemDate": "07-14-2021 19:36:09", "orderimage": null, "orderimagethumb": null, "PricingType": null, "lnft_wholesale": null, "lnft_retail": null, "sqft_wholesale": null, "sqft_retail": null, "vari_wholesale": null, "vari_retail": null, "one_wholesale": null, "one_retail": null, "feetcalc": null, "sqin_cost": null, "sqin_wholesale": null, "sqin_retail": null, "DataFolder": null, "CartSessionID": "kgr3am5ivnzgjnckfgzaiohp", "CartID": null, "Username": null, "PurchaseOrder": "", "SubTotal": null, "CartLinkID": "27a0df1b-54ec-4e06-8ba5-f129570b16c1", "Vendor": null, "ProductLinkID": "6cb709e0-ff9a-4a59-a91e-51f01d2823d5", "qty2": null, "Deleted_1": "F", "OPTIONS": null, "CustomerID": "session.CustomerID", "Time": "12:36:10 00 am", "OneOff": "F", "TimeExp": null, "TimeLeft": null, "RequiredDate": null, "isSold": null, "ProdVar": [ { "VariableID": "1024", "Variable": "Size", "VariableDesc": "", "User_Company_ID": "103338", "CustomerID": null, "Product_Information_ID": "302910", "VarOrder": null, "ProdVarItems": [ { "VarItemID": "1023", "VarItem": "Twin", "VarItemDesc": "", "VariableID": "1024", "User_Company_ID": "103338", "CustomerID": null, "Product_Information_ID": "302910", "VarItemCost": "50", "VarItemWholesale": "0", "VarItemRetail": "100", "VarItemOrder": null, "VarSKU": "", "VarDefault": null }, { "VarItemID": "1026", "VarItem": "Full", "VarItemDesc": "", "VariableID": "1024", "User_Company_ID": "103338", "CustomerID": null, "Product_Information_ID": "302910", "VarItemCost": "0", "VarItemWholesale": "0", "VarItemRetail": "0", "VarItemOrder": null, "VarSKU": "", "VarDefault": null } ] }, { "VariableID": "1037", "Variable": "Color", "VariableDesc": "", "User_Company_ID": "103338", "CustomerID": null, "Product_Information_ID": "302910", "VarOrder": null, "ProdVarItems": [ { "VarItemID": "1027", "VarItem": "Red", "VarItemDesc": "", "VariableID": "1037", "User_Company_ID": "103338", "CustomerID": null, "Product_Information_ID": "302910", "VarItemCost": "0", "VarItemWholesale": "0", "VarItemRetail": "0", "VarItemOrder": null, "VarSKU": "", "VarDefault": null }, { "VarItemID": "1028", "VarItem": "Green", "VarItemDesc": "", "VariableID": "1037", "User_Company_ID": "103338", "CustomerID": null, "Product_Information_ID": "302910", "VarItemCost": "0", "VarItemWholesale": "0", "VarItemRetail": "25", "VarItemOrder": null, "VarSKU": "", "VarDefault": null } ] } ] }, { "item_id": "103747", "SKU": null, "item_name": null, "category": null, "supplier": null, "cost": null, "price": null, "tax1": null, "tax2": null, "quantity": null, "reorderlevel": null, "location": null, "description": null, "allowAltDescription": null, "has_serial": null, "DateAdded": null, "TimeAdded": null, "DateModified": "07/15/2021", "is_gun": null, "caliber": null, "additionalinfo": null, "serial": null, "manufacturer": null, "model": null, "type": null, "additionalguninfo": null, "new_used": null, "Deleted": null, "Start_Bal": null, "Qty_In": null, "Adjust_Qty": null, "Qty_out": null, "Active": null, "IsTradeIn": null, "TradeInSaleID": null, "FirearmsBookID": null, "GeneralManufacturer": null, "GeneralModel": null, "TaxExempt": null, "QuickButton": null, "NoInventory": null, "Size": "1089", "isBarcode": null, "item_id_name": null, "Copies": null, "StoreGen": null, "VendorModel": null, "Inventory": "F", "isDelete": "F", "Size_Group": null, "FinancePrice": null, "ProductID": null, "ProductVariable": "T", "PriceMultiple": "2.2", "FinanceMultiple": null, "PriceSheetHeader": null, "PriceSheetDescription": null, "ItemWidth": "1", "ItemDepth": "1", "ItemHeight": "1", "canFinance": null, "canLayaway": null, "imageMain": null, "imageDisplay": null, "imageList": null, "BC_Item_ID": null, "BC_Size_Group_ID": null, "BC_Category_ID": null, "BTD_ID": null, "isMobileBarcode": null, "web_PRODUCT_INFORMATION_ID": "302910", "web_PRODUCT_ID_CODE": "141f8c05-6dc1-46a6-82eb-b5e8fc51a424", "web_PRODUCTNAME": "Test Product Name", "web_PRODUCT_SHORT_DESCRIPTION": "", "web_PRODUCTLONGDESCRIPTION": "test product web long description", "web_MARKUP": "40", "web_ASI_DISCOUNT": "40", "web_TemplateName": null, "web_TemplateName2": null, "web_TemplateName3": null, "web_TemplateName4": null, "web_ShipWidth": "23", "web_ShipHeight": "52", "web_ShipDepth": "11", "web_ShipWeight": "14", "web_PrintWidth": "", "web_PrintHeight": "", "web_InternalSKU": "10001961", "web_HardwareSKU": null, "web_SupplierSKU": "TEST", "web_Color": "", "web_BlackColor": null, "web_SilverColor": null, "web_PrimaryImage1": null, "web_Image1": "fcc299b102674704b522b1c03b6cfed4.jpg", "web_ImageThumbnail1": "fcc299b102674704b522b1c03b6cfed4_thumbNail.jpg", "web_ImageThumbnailList1": "fcc299b102674704b522b1c03b6cfed4_thumbNailList.jpg", "web_PrimaryImage2": null, "web_Image2": null, "web_ImageThumbnail2": null, "web_ImageThumbnailList2": null, "web_PrimaryImage3": null, "web_Image3": null, "web_ImageThumbnail3": null, "web_ImageThumbnailList3": null, "web_PrimaryImage4": null, "web_Image4": null, "web_ImageThumbnail4": null, "web_ImageThumbnailList4": null, "web_User_Company_ID": "103338", "web_PricingType": "4", "web_Cost": "55", "web_Wholesale": "0", "web_Retail": "121", "web_lnft_cost": "0", "web_lnft_wholesale": "0", "web_lnft_retail": "0", "web_sqft_cost": "0", "web_sqft_retail": "0", "web_sqft_wholesale": "0", "web_vari_cost": "55", "web_vari_wholesale": "0", "web_vari_retail": "169", "web_SalePrice": "0", "web_SaleStartDate": null, "web_SaleEndDate": null, "web_SaleEnabled": "T", "web_AdvancedPricing": "F", "web_BasicPricing": "T", "web_CalculateAdvanced": "T", "web_Active": "T", "web_ActiveOnWeb": "F", "web_Image1WebLarge": "fcc299b102674704b522b1c03b6cfed4_webLarge.jpg", "web_Image1WebList": "fcc299b102674704b522b1c03b6cfed4_webList.jpg", "web_Image1WebThumb": "fcc299b102674704b522b1c03b6cfed4_webThumb.jpg", "web_Image1WebMobileList": "fcc299b102674704b522b1c03b6cfed4_web1MobileList.jpg", "web_Image1WebMobile": "fcc299b102674704b522b1c03b6cfed4_web1Mobile.jpg", "web_Image2WebLarge": null, "web_Image2WebList": null, "web_Image2WebThumb": null, "web_Image2WebMobileList": null, "web_Image2WebMobile": null, "web_Image3WebLarge": null, "web_Image3WebList": null, "web_Image3WebThumb": null, "web_Image3WebMobileList": null, "web_Image3WebMobile": null, "web_Image4WebLarge": null, "web_Image4WebList": null, "web_Image4WebThumb": null, "web_Image4WebMobileList": null, "web_Image4WebMobile": null, "web_WebProductShortDesc": "Test product web short description", "web_sqin_cost": "0", "web_sqin_wholesale": "0", "web_sqin_retail": "0", "web_Vendor": "", "web_WHOLESALEDISC": "0", "web_ShipWidth2": "", "web_ShipHeight2": "", "web_ShipDepth2": "", "web_FriendlyURL": null, "web_OneOff": "F", "web_BrandID": "0", "web_ConditionID": "7", "web_PatternID": "0", "web_SizeID": "0", "web_CategorySelect": "1021", "web_ColorID": "0", "web_StyleIDSelect": "", "web_NecklineID": "0", "web_MaterialSelect": null, "web_SleeveLengthID": "0", "web_AccentsID": "0", "web_ShoulderCutID": "0", "web_Location": "1A", "web_Bin": "4F", "web_Warehouse": "10", "web_SubCategorySelect": "20", "web_TitleSelect": "0", "web_meta_site_name": "", "web_meta_title": "Test Product Name", "web_meta_description": "New In Box , , Size", "web_meta_image": "", "web_Image1WebZoom": "fcc299b102674704b522b1c03b6cfed4_Image1WebZoom.jpg", "web_Image2WebZoom": null, "web_Image3WebZoom": null, "web_Image4WebZoom": null, "web_isSold": "F", "web_InventoryQty": "3", "web_ShipWeight2": "0", "web_ProductCategory": "", "web_WearDetails": "", "web_Order_ID": null, "web_nonBrand": "T", "web_isFeatured": "F", "web_inStore": "0", "web_isWeb": "1", "UPC_code": null, "isUPC": null, "UPC_ItemName": null, "UPC_Model": null, "UPC_Size": null, "DADD": null, "FurnitureColor": null, "isSpecialOrder": null, "web_RegPrice": "242", "web_RetailMultiplier": null, "QuickButtonOrder": null, "QuickButtonTab": null, "Collection": "", "AssembledUpCharge": null, "AssembledPrice": null, "FoundationCost": null, "FoundationPrice": null, "MattressSetCost": null, "MattressSetRetail": null, "web_Image6WebZoom": null, "web_Image6WebLarge": null, "web_Image6WebThumb": null, "web_Image5WebZoom": null, "web_Image5WebLarge": null, "web_Image5WebThumb": null, "web_Image7WebZoom": null, "web_Image7WebLarge": null, "web_Image7WebThumb": null, "web_Image8WebZoom": null, "web_Image8WebLarge": null, "web_Image8WebThumb": null, "web_Image9WebZoom": null, "web_Image9WebLarge": null, "web_Image9WebThumb": null, "web_Image10WebZoom": null, "web_Image10WebLarge": null, "web_Image10WebThumb": null, "show_web_Image2": null, "show_web_Image3": null, "show_web_Image4": null, "show_web_Image5": null, "show_web_Image6": null, "show_web_Image7": null, "show_web_Image8": null, "show_web_Image9": null, "show_web_Image10": null, "web_Image5": null, "web_Image6": null, "web_Image7": null, "web_Image8": null, "web_Image9": null, "web_Image10": null, "web_ImageThumbnail5": null, "web_ImageThumbnail6": null, "web_ImageThumbnail7": null, "web_ImageThumbnail8": null, "web_ImageThumbnail9": null, "web_ImageThumbnail10": null, "SalePercentOff": "0", "CollectionID": null, "CollectionName": null, "Company_ID": null, "SleeveLengthID": null, "SleeveLength": null, "TitleID": null, "Title": null, "CategoryID": null, "SizeID": null, "Size_1": null, "GroupID": null, "ShoulderCutID": null, "ShoulderCut": null, "PatternID": null, "Pattern": null, "NecklineID": null, "Neckline": null, "ConditionID": "7", "Condition": "New In Box", "CategoryListID": "1021", "Category_1": "Livingroom Furniture", "BrandID": null, "Brand": null, "AccentsID": null, "Accents": null, "ORDERITEMS_ID": "1516", "PARTNO": "302910", "QTY": "1", "DESCRIPTION_1": null, "PRICE_1": "169", "EXTENDEDTOTAL": "121", "Discount": null, "User_Company_ID": "103338", "ORDERINFO_ID": null, "ProofID": null, "ItemName": "Test Product Name", "Supplier_SKU": null, "Internal_SKU": "Item # 10001961", "ProductIDCode": null, "PrintFile": null, "BasicPricing": null, "AdvancedPricing": null, "ItemStatus": null, "BasicWholesalePrice": null, "BasicRetailPrice": null, "WholesalePricing": null, "CalcPrice": null, "SalesTax": null, "SalesTaxTotal": null, "SalesTaxName": null, "ItemDate": "07-16-2021 07:39:35", "orderimage": null, "orderimagethumb": null, "PricingType": null, "lnft_wholesale": null, "lnft_retail": null, "sqft_wholesale": null, "sqft_retail": null, "vari_wholesale": null, "vari_retail": null, "one_wholesale": null, "one_retail": null, "feetcalc": null, "sqin_cost": null, "sqin_wholesale": null, "sqin_retail": null, "DataFolder": null, "CartSessionID": "ao1dwq5yop5af1hyv0qwqbdh", "CartID": null, "Username": null, "PurchaseOrder": "", "SubTotal": null, "CartLinkID": "24c5e9eb-fe30-4345-b513-2a249dd53b6a", "Vendor": null, "ProductLinkID": "8d275af9-d3ef-45cc-a62f-11f935b083b3", "qty2": null, "Deleted_1": "F", "OPTIONS": null, "CustomerID": "session.CustomerID", "Time": "12:39:36 00 pm", "OneOff": "F", "TimeExp": null, "TimeLeft": null, "RequiredDate": null, "isSold": null, "ProdVar": [ { "VariableID": "1024", "Variable": "Size", "VariableDesc": "", "User_Company_ID": "103338", "CustomerID": null, "Product_Information_ID": "302910", "VarOrder": null, "ProdVarItems": [ { "VarItemID": "1023", "VarItem": "Twin", "VarItemDesc": "", "VariableID": "1024", "User_Company_ID": "103338", "CustomerID": null, "Product_Information_ID": "302910", "VarItemCost": "50", "VarItemWholesale": "0", "VarItemRetail": "100", "VarItemOrder": null, "VarSKU": "", "VarDefault": null }, { "VarItemID": "1026", "VarItem": "Full", "VarItemDesc": "", "VariableID": "1024", "User_Company_ID": "103338", "CustomerID": null, "Product_Information_ID": "302910", "VarItemCost": "0", "VarItemWholesale": "0", "VarItemRetail": "0", "VarItemOrder": null, "VarSKU": "", "VarDefault": null } ] }, { "VariableID": "1037", "Variable": "Color", "VariableDesc": "", "User_Company_ID": "103338", "CustomerID": null, "Product_Information_ID": "302910", "VarOrder": null, "ProdVarItems": [ { "VarItemID": "1027", "VarItem": "Red", "VarItemDesc": "", "VariableID": "1037", "User_Company_ID": "103338", "CustomerID": null, "Product_Information_ID": "302910", "VarItemCost": "0", "VarItemWholesale": "0", "VarItemRetail": "0", "VarItemOrder": null, "VarSKU": "", "VarDefault": null }, { "VarItemID": "1028", "VarItem": "Green", "VarItemDesc": "", "VariableID": "1037", "User_Company_ID": "103338", "CustomerID": null, "Product_Information_ID": "302910", "VarItemCost": "0", "VarItemWholesale": "0", "VarItemRetail": "25", "VarItemOrder": null, "VarSKU": "", "VarDefault": null } ] } ] } ]
e.control.ProductName = (what goes here to get the json data).web_PRODUCTNAME
Comment