GuestBillingAddresses

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

Table Specific Information

Select

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

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

SELECT * FROM [GuestBillingAddresses] WHERE CartId = '123'

INSERT

To create a new GuestBillingAddresses, CartId, and FirstName are required.

INSERT INTO GuestBillingAddresses(CartId,FirstName) VALUES('a9f82365c3552','asdw')

Columns


Name	Type	ReadOnly	Description
Id [KEY]	Int	False	Id
CartId	String	False	cartId
City	String	False	City name
Company	String	False	Company
CountryId	String	False	Country id
CustomerAddressId	Int	False	Customer address id
CustomerId	Int	False	Customer id
Email	String	False	Billing/shipping email
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	Region name
RegionCode	String	False	Region code
RegionId	Int	False	Region id
SameAsBilling	Int	False	Same as billing flag
SaveInAddressBook	Int	False	Save in address book flag
Street	String	False	Street
Suffix	String	False	Suffix
Telephone	String	False	Telephone number
VatId	String	False	Vat id

Power BI Connector for Adobe Commerce

GuestBillingAddresses

Table Specific Information

Select

INSERT

Columns