Power BI Connector for BigCommerce

Build 21.0.7930


Returns a list of Customer Addresses. Returns the addresses belonging to a customer.

Table Specific Information


The {i will use the BigCommerce API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the {i.

  • Id supports the '=' comparison.
  • CustomerId supports the '=' comparison.

For example, the following queries are processed server side:

SELECT * FROM CustomerAddresses

SELECT * FROM CustomerAddresses WHERE Id = 1 

SELECT * FROM CustomerAddresses WHERE CustomerId = 5


Name Type Description
Id [KEY] Integer ID of this customer address.
CustomerId Integer ID of the associated customer.
FirstName String The customers first name.
LastName String The customers last name.
Company String The customers company name.
Street1 String The customers street address, line 1.
Street2 String The customers street address, line 2.
City String The customers city/town/suburb.
State String The customers state/province.
Zip String The customers ZIP or postal code.
Country String The customers country. Must be the full country name.
CountryISO2 String 2-letter ISO Alpha-2 code for the customers country.
Phone String The customers phone number.
AddressType String The type of the address.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930