SHP01T102

Source SQL Preview

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

SELECT
    [M].[ProductId] AS [ProductId],
    [M].[CompanyId] AS [CompanyId],
    [M].[Source] AS [Source],
    [M].[Locale] AS [Locale],
    [M].[ClientId] AS [ClientId],
    [M].[ProductName] AS [ProductName],
    [M].[ProductSize] AS [ProductSize],
    [M].[ProductDesc] AS [ProductDesc],
    [M].[ProductSort] AS [ProductSort],
    [M].[ProductStock] AS [ProductStock],
    [M].[ProductPrice] AS [ProductPrice],
    [M].[SpecialOffer] AS [SpecialOffer],
    [M].[IsOnSale] AS [IsOnSale],
    [M].[IsBestSale] AS [IsBestSale],
    [M].[ProductStatus] AS [ProductStatus],
    [M].[IsDelete] AS [IsDelete],
    [M].[SeoMetaId] AS [SeoMetaId],
    [M].[MinInventory] AS [MinInventory],
    [M].[ExternalSource] AS [ExternalSource],
    [M].[ExternalId] AS [ExternalId],
    [M].[ExtraData] AS [ExtraData]
FROM [SHP01T102] [M]
;

Projection Query JSON Preview

[
  {
    "ProductId": "ProductId-001",
    "CompanyId": "CompanyId sample",
    "Source": "Source sample",
    "Locale": "Locale sample",
    "ClientId": "ClientId sample",
    "ProductName": "ProductName sample",
    "ProductSize": "ProductSize sample",
    "ProductDesc": "ProductDesc sample",
    "ProductSort": 123,
    "ProductStock": 123,
    "ProductPrice": 123.45,
    "SpecialOffer": 123.45,
    "IsOnSale": 123,
    "IsBestSale": 123,
    "ProductStatus": 123,
    "IsDelete": 123,
    "SeoMetaId": "SeoMetaId sample",
    "MinInventory": 123.45,
    "ExternalSource": "ExternalSource sample",
    "ExternalId": "ExternalId sample",
    "ExtraData": "ExtraData sample",
    "UpdatedAt": "2026-04-08T09:30:00Z"
  }
]

Attributes

Source Joins

Source Mappings