ODBC Driver for Shopify

Build 24.0.9060

Users

Query Users.

View-Specific Information

Select

The driver uses the Shopify API to process WHERE clause conditions built with the following column and operator. The driver processes other filters client-side within the driver.

  • Id supports the '=,IN' comparison operators.

For example, the following queries are processed server side:

  SELECT * FROM Users
  SELECT * FROM Users WHERE Id = 123

Columns

Name Type References Description
Id [KEY] Long The ID of the user.
FirstName String The first name of the user.
Email String The email of the user.
Url String The url of the user.
IM String The IM of the user.
ScreenName String The screen name of the user.
Phone String The phone number of the of the user.
LastName String The last name of the user.
AccountOwner Bool If the user is the account owner.
ReceiveAnnouncements Bool If the user receives announcements.
Bio String The bio of the user.
Permissions String The list of permissions of the user.
Locale String The Locale of the user.
UserType String The type of the user.
AdminGraphQLAPIId String The Admin GraphQL API Id of the user.
TFAEnabled Bool If TFA is enabled.

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