Power BI Connector for Adobe Commerce

Build 23.0.8839


CustomerAccountShippingAddress is an auto generated table. The supported operations are Querying data from this table.

Table Specific Information


The 本製品 will use the AdobeCommerce API to filter the results by CustomerId while the rest of the filter is executed client side within the 本製品.

The CustomerId column must be specified in the WHERE clause to retrieve results from CustomerAccountShippingAddress. CustomerId can be used only with the equals (=) operator. For example:

SELECT * FROM [CustomerAccountShippingAddress] WHERE CustomerId = '123'


Name Type Description
Id [KEY] Int ID
City String City name
Company String Company
CountryId String Country code in ISO_3166-2 format
CustomerId Int Customer ID
DefaultBilling Bool If this address is default billing address
DefaultShipping Bool If this address is default shipping address.
ExtensionAttributes String This is an auto-generated column
Fax String Fax number
Firstname String First name
Lastname String Last name
Middlename String Middle name
Postcode String Postcode
Prefix String Prefix
Region String This is an auto-generated column
RegionId Int Region ID
Street String Street
Suffix String Suffix
Telephone String Telephone number
VatId String Vat id

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839