Power BI Connector for Salesforce

Build 26.0.9770

WebStore

Represents a digital storefront configured for a Salesforce commerce implementation.

Columns

Name Type ReadOnly References Description
Id [KEY] String True

Unique identifier for the record.

OwnerId String False

ID of the user who owns the record.

IsDeleted Bool True

Indicates whether the record has been moved to the Recycle Bin.

Name String False

Name of the record.

CurrencyIsoCode String False

ISO code for the currency in which the revenue amount is expressed.

CreatedDate Datetime True

Date and time when the record was created.

CreatedById String True

User.Id

ID of the user who created the record.

LastModifiedById String True

User.Id

ID of the user who last modified the record.

LastViewedDate Datetime True

Date and time when the record was last viewed in the user interface.

LastReferencedDate Datetime True

Date and time when the record was last referenced.

Type String False

Type of account or classification.

DefaultLanguage String False

Default language used by the web store.

SupportedLanguages String False

Languages supported by the web store.

MaxValuesPerFacet Int False

Maximum number of values displayed per search facet in the web store.

PaginationSize Int False

Number of items displayed per page in the web store.

StrikethroughPricebookId String False

Pricebook2.Id

ID of the price book used to display strikethrough, or original, pricing.

OptionsGuestBrowsingEnabled Bool False

Field containing OptionsGuestBrowsingEnabled information.

OptionsCommerceEinsteinDeployed Bool False

Indicates whether the “Commerce Einstein Deployed” option is enabled.

OptionsCommerceEinsteinActivitiesTracked Bool False

Indicates whether the “Commerce Einstein Activities Tracked” option is enabled.

OptionsSkipAdditionalEntitlementCheckForSearch Bool False

Indicates whether the “Skip Additional Entitlement Check For Search” option is enabled.

OptionsAutoFacetingEnabled Bool False

Indicates whether the “Auto Faceting Enabled” option is enabled.

OptionsCartToOrderAutoCustomFieldMapping Bool False

Indicates whether the “Cart To Order Auto Custom Field Mapping” option is enabled.

OptionsGuestCartEnabled Bool False

Field containing OptionsGuestCartEnabled information.

OptionsGuestCheckoutEnabled Bool False

Field containing OptionsGuestCheckoutEnabled information.

OptionsCartAsyncProcessingEnabled Bool False

Field containing OptionsCartAsyncProcessingEnabled information.

OptionsDuplicateCartItemsEnabled Bool False

Field containing OptionsDuplicateCartItemsEnabled information.

OptionsSkuDetectionEnabled Bool False

Field containing OptionsSkuDetectionEnabled information.

OptionsCartCalculateEnabled Bool False

Indicates whether the “Cart Calculate Enabled” option is enabled.

OptionsPreserveGuestCartEnabled Bool False

Field containing OptionsPreserveGuestCartEnabled information.

OptionsSplitShipmentEnabled Bool False

Field containing OptionsSplitShipmentEnabled information.

SupportedCurrencies String False

Currencies supported by the web store.

PricingStrategy String False

Strategy used to determine pricing displayed in the web store.

CheckoutTimeToLive Int False

Length of time a checkout session remains valid before expiring.

CheckoutValidAfterDate Datetime False

Date after which checkout sessions are considered valid.

LocationId String True

Location.Id

ID of the location associated with the web store, such as for inventory.

Description String False

Description of the record.

ProductGrouping String False

Method used to group products in the web store.

GuestCartTimeToLive Int False

Length of time a guest shopping cart remains valid before expiring.

DefaultTaxLocaleType String False

Type classification for DefaultTaxLocale.

ExternalReference String True

Field containing ExternalReference information.

SortByPricebookId String False

Pricebook2.Id

ID of the price book used to sort products by price in the web store.

OrderLifeCycleType String False

Type of order lifecycle process used by the web store.

OrderActivationStatus String False

Status indicating whether orders are actively being processed for the web store.

SystemModstamp Datetime True

Date and time when the record was last modified by a user or by an automated process.

LastModifiedDate Datetime True

Date and time when the record was last modified.

Pseudocolumns

Pseudocolumn fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.

Name Type Description
OwnerIdType String

Specifies the type of the 'OwnerId' polymorphic field to use in the statement.

OwnerIdExternalFieldName String

Specifies the external field name of the 'OwnerId' polymorphic field to use in an INSERT/UPDATE/UPSERT statement

SOQL String

Specifies the SOQL query to execute against the Salesforce servers. If this pseudo column is set from the WHERE clause it will take precedence over the original query.

ExternalIdColumn String

Specifies the external Id column to use if performing an insert. If this value is specified, upsert will be used when the INSERT command is called.

FilterScope String

Optional scope to limit the records returned from queries. This property can take one of these values: Delegated, Everything, Mine, MineAndMyGroups, My_Territory, My_Team_Territory, or Team.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9770