SHP01T101

Source SQL Preview

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

SELECT
    [M].[ProductCategoryId] AS [ProductCategoryId],
    [M].[CompanyId] AS [CompanyId],
    [M].[Source] AS [Source],
    [M].[Locale] AS [Locale],
    [M].[ClientId] AS [ClientId],
    [M].[ParentCategoryId] AS [ParentCategoryId],
    [M].[Layer] AS [Layer],
    [M].[Sort] AS [Sort],
    [M].[ProductCategoryName] AS [ProductCategoryName],
    [M].[ProductCategoryDesc] AS [ProductCategoryDesc],
    [M].[ImagePath] AS [ImagePath],
    [M].[SeoMetaId] AS [SeoMetaId],
    [M].[IntroductionVideoUrl] AS [IntroductionVideoUrl],
    [M].[IntroductionTitle] AS [IntroductionTitle],
    [M].[Subtitle] AS [Subtitle],
    [M].[IsHidden] AS [IsHidden],
    [M].[IsDelete] AS [IsDelete],
    [M].[ExternalSource] AS [ExternalSource],
    [M].[ExternalId] AS [ExternalId],
    [M].[ExtraData] AS [ExtraData]
FROM [SHP01T101] [M]
;

Projection Query JSON Preview

[
  {
    "ProductCategoryId": "ProductCategoryId-001",
    "CompanyId": "CompanyId sample",
    "Source": "Source sample",
    "Locale": "Locale sample",
    "ClientId": "ClientId sample",
    "ParentCategoryId": "ParentCategoryId sample",
    "Layer": 123,
    "Sort": "Sort sample",
    "ProductCategoryName": "ProductCategoryName sample",
    "ProductCategoryDesc": "ProductCategoryDesc sample",
    "ImagePath": "ImagePath sample",
    "SeoMetaId": "SeoMetaId sample",
    "IntroductionVideoUrl": "IntroductionVideoUrl sample",
    "IntroductionTitle": "IntroductionTitle sample",
    "Subtitle": "Subtitle sample",
    "IsHidden": "IsHidden sample",
    "IsDelete": 123,
    "ExternalSource": "ExternalSource sample",
    "ExternalId": "ExternalId sample",
    "ExtraData": "ExtraData sample",
    "UpdatedAt": "2026-04-08T09:30:00Z"
  }
]

Attributes

Source Joins

Source Mappings