Power BI Connector for Square

Build 26.0.9770

Locations

Query Location information for a Merchant.

Table Specific Information

Select

The connector will execute all filters to this table client-side, in memory.

Retrieve all Locations: 

SELECT * FROM Locations

Insert

To create a location, you will need to specify Address and Name. 

INSERT INTO locations (Address, Name) VALUES ('{ "address_line_1": "1234 Peachtree St. NE", "locality": "Atlanta", "administrative_district_level_1": "GA", "postal_code": "30309"}', 'Midtown')

UPDATE

A location can be updated by providing the Id. 

UPDATE locations set name='testlocation' where id='LNX1YQ5C29K9A'

Columns

Name Type ReadOnly Description
Id [KEY] String True

The location's unique ID.

Name String False

The location's name. Location names are set by the account owner and displayed in the dashboard as the location's nickname

Address String False

The location's physical address.

TimeZone String False

The IANA Timezone Database identifier for the location's timezone.

Capabilities String True

Indicates which Square features are enabled for the location.

The allowed values are CREDIT_CARD_PROCESSING, AUTOMATIC_TRANSFERS, UNLINKED_REFUNDS.

Status String False

The location's status.

The allowed values are ACTIVE, INACTIVE.

CreatedAt Datetime True

The time when the location was created, in RFC 3339 format.

MerchantId String True

The identifier of the merchant that owns the location.

Country String True

The location's country, in ISO 3166-1-alpha-2 format.

LanguageCode String False

The language associated with the location in BCP 47 format.

Currency String True

The currency used for all transactions at this location, specified in ISO 4217 format.

PhoneNumber String False

The location's phone_number.

BusinessName String False

The location's business_name which is shown to its customers.

Type String False

The location's type, as set by the account owner in the Square dashboard.

The allowed values are PHYSICAL, MOBILE.

WebsiteUrl String False

The location's website, as set by the account owner in the Square dashboard.

BusinessHours String False

The hours of operation for the location.

Coordinates String False

The physical coordinates (latitude and longitude) of the location.

MCC String False

A four-digit number that describes the kind of goods or services sold at the location. The merchant category code (MCC) of the location as standardized by ISO 18245.

BusinessEmail String False

The email address of the location. This can be unique to the location and is not always the email address for the business owner or account.

Description String False

The free-form text of the location description.

TwitterUsername String False

The location Twitter handle without the @ symbol.

InstagramUsername String False

The location Instagram handle without the @ symbol.

FacebookUrl String False

The Facebook profile URL of the location. The URL should begin with facebook.com/.

LogoUrl String True

The URL of the logo image for the location. The logo is shown on Square-hosted receipts and invoices.

PosBackgroundUrl String True

The URL of the Point of Sale background image for the location.

FullFormatLogoUrl String True

The URL of the wide-format logo image for the location. Used on receipts and invoices.

TaxIdsEuVat String True

The EU VAT number for this location. For example, IE3426675K. (Beta)

TaxIdsFrSiret String True

The 14-digit French business identifier (SIRET) for this location. (Beta)

TaxIdsFrNaf String True

The French activity code (NAF/APE) for this location. (Beta)

TaxIdsEsNif String True

The 9-character Spanish tax identifier (NIF) for this location. (Beta)

TaxIdsJpQii String True

The 14-character Japanese Qualified Invoice Issuer number for this location. (Beta)

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9770