Power BI Connector for Shopify

Build 24.0.9060

Customers

Retrieves a list of customers.

Table-Specific Information

Select

The connector uses the Shopify API to process WHERE clause conditions built with the following columns and operators. The connector processes other filters client-side within the connector.

  • Id supports the '=,IN' comparison operators.
  • Email supports the '=,!=' comparison operators.
  • Phone supports the '=,!=' comparison operators.
  • State supports the '=,!=' comparison operators.
  • CreatedAt supports the '=,!=,<,>,>=,<=' comparison operators.
  • UpdatedAt supports the '=,!=,<,>,>=,<=' comparison operators.
  • AcceptsMarketing supports the '=,!=' comparison operators.
  • AmountSpentAmount supports the '=,!=' comparison operators.

For example, the following queries are processed server side: 

  SELECT * FROM Customers
  SELECT * FROM Customers WHERE Id = 'Val1'
  SELECT * FROM Customers WHERE Email = 'Val1'
  SELECT * FROM Customers WHERE Phone = 'Val1'
  SELECT * FROM Customers WHERE State = 'Val1'
  SELECT * FROM Customers WHERE CreatedAt = '2023-01-01 11:10:00'
  SELECT * FROM Customers WHERE UpdatedAt = '2023-01-01 11:10:00'
  SELECT * FROM Customers WHERE AcceptsMarketing = true
  SELECT * FROM Customers WHERE AmountSpentAmount = '100.00'

Insert

The following columns can be used to create a new record:

FirstName, LastName, Email, Locale, Note, Phone, Tags, TaxExempt, TaxExemptions, DefaultAddressFirstName, DefaultAddressLastName, DefaultAddressAddress1, DefaultAddressAddress2, DefaultAddressCity, DefaultAddressCompany, DefaultAddressCountry, DefaultAddressPhone, DefaultAddressProvince, DefaultAddressZip, DefaultAddressProvinceCode, DefaultAddressCountryCodeV2, SmsMarketingConsentMarketingState, SmsMarketingConsentMarketingOptInLevel, SmsMarketingConsentConsentUpdatedAt

Update

The following columns can be updated:

FirstName, LastName, Email, Locale, Note, Phone, Tags, TaxExempt, TaxExemptions, DefaultAddressFirstName, DefaultAddressLastName, DefaultAddressAddress1, DefaultAddressAddress2, DefaultAddressCity, DefaultAddressCompany, DefaultAddressCountry, DefaultAddressPhone, DefaultAddressProvince, DefaultAddressZip, DefaultAddressProvinceCode, DefaultAddressCountryCodeV2, SmsMarketingConsentMarketingState, SmsMarketingConsentMarketingOptInLevel, SmsMarketingConsentConsentUpdatedAt

Delete

You can delete entries by specifying the following column:

Id

Columns

Name Type ReadOnly References Description
Id [KEY] String True

A globally-unique ID.

MultipassIdentifier String True

A unique identifier for the customer that's used with Multipass login.

LegacyResourceId String True

The ID of the corresponding resource in the REST Admin API.

ValidEmailAddress Bool True

Whether the email address is formatted correctly. Returns 'true' when the email is formatted correctly and belongs to an existing domain. This doesn't guarantee that the email address actually exists.

DisplayName String True

The full name of the customer, based on the values for first_name and last_name. If the first_name and last_name are not available, then this falls back to the customer's email address, and if that is not available, the customer's phone number.

FirstName String False

The customer's first name.

LastName String False

The customer's last name.

Email String False

The customer's email address.

Locale String False

The customer's locale.

Note String False

A note about the customer.

Phone String False

The customer's phone number.

State String True

The state of the customer's account with the shop.

Tags String False

A comma separated list of tags that have been added to the customer.

CanDelete Bool True

Whether the merchant can delete the customer from their store. A customer can be deleted from a store only if they have not yet made an order. After a customer makes an order, they can't be deleted from a store.

LifetimeDuration String True

The amount of time since the customer was first added to the store. Example: 'about 12 years'.

TaxExempt Bool False

Whether the customer is exempt from being charged taxes on their orders.

TaxExemptions String False

The list of tax exemptions applied to the customer.

UnsubscribeUrl String True

The URL to unsubscribe the customer from the mailing list.

VerifiedEmail Bool True

Whether the customer has verified their email address. Defaults to 'true' if the customer is created through the Shopify admin or API.

HasTimelineComment Bool True

Whether the timeline subject has a timeline comment. If true, then a timeline comment exists.

NumberOfOrders String True

The number of orders that the customer has made at the store in their lifetime.

ProductSubscriberStatus String True

Possible subscriber states of a customer defined by their subscription contracts.

CreatedAt Datetime True

The date and time when the customer was added to the store.

UpdatedAt Datetime True

The date and time when the customer was last updated.

AcceptsMarketing Bool True

Whether the customer has agreed to receive marketing materials.

AmountSpentAmount Decimal True

Decimal money amount.

AmountSpentCurrencyCode String True

Currency of the money.

DefaultAddressId String True

A globally-unique ID.

DefaultAddressCoordinatesValidated Bool True

Whether the address coordinates are valid.

DefaultAddressName String True

The full name of the customer, based on firstName and lastName.

DefaultAddressFirstName String False

The first name of the customer.

DefaultAddressLastName String False

The last name of the customer.

DefaultAddressAddress1 String False

The first line of the address. Typically the street address or PO Box number.

DefaultAddressAddress2 String False

The second line of the address. Typically the number of the apartment, suite, or unit.

DefaultAddressCity String False

The name of the city, district, village, or town.

DefaultAddressCompany String False

The name of the customer's company or organization.

DefaultAddressCountry String False

The name of the country.

DefaultAddressLatitude Double True

The latitude coordinate of the customer address.

DefaultAddressLongitude Double True

The longitude coordinate of the customer address.

DefaultAddressPhone String False

A unique phone number for the customer. Formatted using E. 164 standard. For example, _+16135551111_.

DefaultAddressProvince String False

The region of the address, such as the province, state, or district.

DefaultAddressZip String False

The zip or postal code of the address.

DefaultAddressFormattedArea String True

A comma-separated list of the values for city, province, and country.

DefaultAddressProvinceCode String False

The two-letter code for the region. For example, ON.

DefaultAddressCountryCodeV2 String False

The two-letter code for the country of the address. For example, US.

EmailMarketingConsentMarketingState String True

The current email marketing state for the customer.

EmailMarketingConsentMarketingOptInLevel String True

The marketing subscription opt-in level, as described by the M3AAWG best practices guidelines, that the customer gave when they consented to receive marketing material by email.

EmailMarketingConsentConsentUpdatedAt Datetime True

The date and time at which the customer consented to receive marketing material by email. The customer's consent state reflects the consent record with the most recent 'consent_updated_at' date. If no date is provided, then the date and time at which the consent information was sent is used.

ImageId String True

A unique ID for the image.

ImageWidth Int True

The original width of the image in pixels. Returns 'null' if the image is not hosted by Shopify.

ImageAltText String True

A word or phrase to share the nature or contents of an image.

ImageHeight Int True

The original height of the image in pixels. Returns 'null' if the image is not hosted by Shopify.

ImageUrl String True

The location of the image as a URL.

LastOrderId String True

A globally-unique ID.

MarketId String True

A globally-unique ID.

MergeableReason String True

The reason why the customer can't be merged with another customer.

MergeableErrorFields String True

The list of fields preventing the customer from being merged.

MergeableIsMergeable Bool True

Whether the customer can be merged with another customer.

MergeableMergeInProgressJobId String True

The UUID of the merge job.

MergeableMergeInProgressResultingCustomerId String True

The ID of the customer resulting from the merge.

MergeableMergeInProgressStatus String True

The status of the customer merge request.

SmsMarketingConsentMarketingState String False

The current SMS marketing state for the customer.

SmsMarketingConsentConsentCollectedFrom String True

The source from which the SMS marketing information for the customer was collected.

SmsMarketingConsentMarketingOptInLevel String False

The marketing subscription opt-in level that was set when the customer consented to receive marketing information.

SmsMarketingConsentConsentUpdatedAt Datetime False

The date and time when the customer consented to receive marketing material by SMS. If no date is provided, then the date and time when the consent information was sent is used.

StatisticsPredictedSpendTier String True

The predicted spend tier of a customer with a shop.

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