Power BI Connector for Adobe Commerce

Build 23.0.8839


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

Table Specific Information


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

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'


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

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


Name Type ReadOnly Description
Id [KEY] Int False


CartId String False


City String False

City name

Company String False


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


Prefix String False


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


Suffix String False


Telephone String False

Telephone number

VatId String False

Vat id

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