SHP01T202

Source SQL Preview

API 查詢即以此 SQL 對讀取複本執行（ADR 0008）。

SELECT
    [M].[ShoppingCartItemId] AS [ShoppingCartItemId],
    [M].[ShoppingCartId] AS [ShoppingCartId],
    [M].[Sku] AS [Sku],
    [M].[MaterialsID] AS [MaterialsID],
    [M].[Name] AS [Name],
    [M].[AttributesJson] AS [AttributesJson],
    [M].[UnitPrice] AS [UnitPrice],
    [M].[Currency] AS [Currency],
    [M].[Quantity] AS [Quantity],
    [M].[Discount] AS [Discount],
    [M].[Tax] AS [Tax],
    [M].[LineTotal] AS [LineTotal]
FROM [SHP01T202] [M]
;

Projection Query JSON Preview

[
  {
    "ShoppingCartItemId": "ShoppingCartItemId-001",
    "ShoppingCartId": "ShoppingCartId sample",
    "Sku": "Sku sample",
    "MaterialsID": "MaterialsID sample",
    "Name": "Name sample",
    "AttributesJson": "AttributesJson sample",
    "UnitPrice": 123.45,
    "Currency": "Currency sample",
    "Quantity": 123,
    "Discount": 123.45,
    "Tax": 123.45,
    "LineTotal": 123.45,
    "UpdatedAt": "2026-04-08T09:30:00Z"
  }
]

Attributes

Source Joins

Source Mappings