LocalStores

Query local stores for a catalog owned by the operation user account.

Table Specific Information

Select

The add-in will use the Pinterest API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the add-in. CatalogId is a required column to access this table.

CatalogId supports the '=' operator.
Id supports the '=,IN' operator.
AdAccountId supports the '=' operator.

For example:

	SELECT * FROM LocalStores WHERE CatalogId = '4842503688348'
	SELECT * FROM LocalStores WHERE CatalogId = '4842503688348' AND Id = '13123627'
	SELECT * FROM LocalStores WHERE CatalogId = '4842503688348' AND Id IN ('13123627', '13123628')
	SELECT * FROM LocalStores WHERE CatalogId = '4842503688348' AND AdAccountId = '549755885175'

Columns


Name	Type	References	Description
Id [KEY]	String		Unique identifier of the local store.
CatalogId	String	Catalogs.Id	Unique identifier of the catalog.
StoreCode	String		Merchant-provided unique code for the store within the catalog.
Name	String		Store name.
AddressPrimary	String		Primary address line of the store.
AddressSecondary	String		Secondary address line of the store.
City	String		City where the store is located.
Region	String		State or region code where the store is located.
PostalCode	String		Postal or ZIP code of the store.
Country	String		Country code (ISO 3166-1 alpha-2) where the store is located.
Latitude	Double		Geographic latitude coordinate of the store.
Longitude	Double		Geographic longitude coordinate of the store.
CreatedAt	Datetime		Timestamp when the store was created.
UpdatedAt	Datetime		Timestamp when the store was last updated.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.


Name	Type	Description
AdAccountId	String		Unique identifier of an ad account.

Excel Add-In for Pinterest

LocalStores

Table Specific Information

Select

Columns

Pseudo-Columns