CData Python Connector for Shopify

Build 23.0.8839

CustomerAddresses

Create, update, delete, and query customer addresses.

Table-Specific Information

Select

The connector uses the Shopify API to process WHERE clause conditions built with the following column and operator. The connector processes other filters client-side within the connector.
  • CustomerId supports the '=,IN' comparison.
  • CustomerUpdatedAt supports the '<,>,<=,>=' comparison.

For example, the following queries are processed server-side:

SELECT * FROM CustomerAddresses WHERE CustomerId = '123'

SELECT * FROM CustomerAddresses WHERE CustomerId IN ('123', '456')

SELECT * FROM CustomerAddresses WHERE CustomerUpdatedAt >= '2018-05-04'

Insert

You must specify the customer Id to create an address.

INSERT INTO CustomerAddresses (CustomerId, Address1, City, Company) VALUES ('123', '1 Rue des Carrieres', 'Suite 1234', 'Montreal')

Update

You must specify the customer Id and the Id of the customer address to update an address.

UPDATE CustomerAddresses SET Zip = '90210' WHERE CustomerId = '123' AND Id = '456'

Delete

You must specify the customer Id and the Id of the customer address to delete an address. You cannot delete a customer's default address.

DELETE FROM CustomerAddresses WHERE CustomerId = '183467180055' AND Id = '292265787415'

Columns

Name Type ReadOnly References Description
Id [KEY] Long True

A unique numeric identifier for the address.

CustomerId [KEY] Long False

Customers.Id

A unique numeric identifier for the customer.

CustomerUpdatedAt Datetime True

The date and time when the customer information was last updated.

Name String False

The customer's name.

FirstName String False

The customer's first name.

LastName String False

The customer's last name.

Company String False

The customer's company.

Address1 String False

The customer's mailing address.

Address2 String False

An additional field for the customer's mailing address.

City String False

The customer's city.

Province String False

The customer's province or state name.

Country String False

The customer's country.

Zip String False

The customer's zip or postal code.

Phone String False

The customer's phone number for this mailing address.

ProvinceCode String False

The two-letter pcode for the customer's province or state.

CountryCode String False

The two-letter country code corresponding to the customer's country.

CountryName String False

The customer's normalized country name.

Default Bool True

Indicates whether this address is the default address for the customer.

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