SSIS Components for Square

Build 24.0.9062

Locations

Query Location information for a Merchant.

Table Specific Information

Select

The 本製品 will execute all filters to this table client-side, in memory.

Retrieve all Locations:

SELECT * FROM Locations

Columns

Name Type Description
Id [KEY] String The location's unique ID.
Name String The location's name. Location names are set by the account owner and displayed in the dashboard as the location's nickname
Address String The location's physical address.
TimeZone String The IANA Timezone Database identifier for the location's timezone.
Capabilities String Indicates which Square features are enabled for the location.
Status String The location's status.
CreatedAt Datetime The time when the location was created, in RFC 3339 format.
MerchantId String The identifier of the merchant that owns the location.
Country String The location's country, in ISO 3166-1-alpha-2 format.
LanguageCode String The language associated with the location in BCP 47 format.
Currency String The currency used for all transactions at this location, specified in ISO 4217 format.
PhoneNumber String The location's phone_number.
BusinessName String The location's business_name which is shown to its customers.
Type String The location's type, as set by the account owner in the Square dashboard.
WebsiteUrl String The location's website, as set by the account owner in the Square dashboard.

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