so_products = sales_order.get("Product_Details");
info so_products;
prints:
{"product":{"Product_Code":"VOT-700400-2","Currency":"TWD","name":"VOITAIR VA 400 BLACK no base (黑芳香機.無腳架) / VOT-700400-2","id":"1839893000000212252"},"quantity":1,"Discount":0,"total_after_discount":82000,"net_total":82000,"book":null,"Tax":0,"list_price":82000,"unit_price":82000,"quantity_in_stock":-1,"total":82000,"id":"1839893000009394337","product_description":"VOITAIR VA400 divers (黑芳香機.無腳架)","line_tax":[]},{"product":{"Product_Code":"VOT-122900-821","Currency":"TWD","name":"Scent Bottle 200 ml, Wood (木材) / VOT-122900-821","id":"1839893000000212237"},"quantity":1,"Discount":0,"total_after_discount":10400,"net_total":10400,"book":null,"Tax":0,"list_price":10400,"unit_price":10400,"quantity_in_stock":-1,"total":10400,"id":"1839893000009394339","product_description":"Busineess-Arom 200 ml,Wood (木材)","line_tax":[]},{"product":{"Product_Code":"VOT-122900-816","Currency":"TWD","name":"Scent Bottle 200 ml, Mediterranean Sea (地中海) / VOT-122900-816","id":"1839893000000212232"},"quantity":1,"Discount":0,"total_after_discount":10400,"net_total":10400,"book":null,"Tax":0,"list_price":10400,"unit_price":10400,"quantity_in_stock":0,"total":10400,"id":"1839893000009394341","product_description":"Busineess-Arom 200 ml,Mediterranean Sea (地中海)","line_tax":[]}
however, the following:
so_products = sales_order.get("Product_Details");
info so_products.get("product");
returns:
Failed to execute function
- 'TEXT' can not be cast to '[BIGINT]' for the function 'get' Line Number:25
I dont understand what the problem is.