CustomerAddress

CustomerAddress is an auto generated table. The supported operations are Delete, and Querying data from this table.

Table Specific Information

Select

The connector uses the AdobeCommerce API to filter the results by AddressId while the rest of the filter is executed client side within the connector.

You must specify the AddressId column in the WHERE clause to retrieve results from CustomerAddress. AddressId can be used only with the equals (=) operator. For example:

SELECT * FROM [CustomerAddress] WHERE AddressId = '123'

Columns


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

Power BI Connector for Adobe Commerce

CustomerAddress

Table Specific Information

Select

Columns