[参考]Shopify(パブリックアプリ)で連携することができる『オブジェクト』と『カラム』

本記事について

本記事では、Shopify(パブリックアプリ)で連携することができる『オブジェクト』と『カラム』について紹介します。
※なお、紹介するカラムは、『A』~『Z』の順に記載しています

b→dashとShopify(パブリックアプリ)の連携については、「Shopify(パブリックアプリ)のデータを取り込みたい」をご参照ください。

連携することができる『オブジェクト』と『カラム』

以下では、Shopify(パブリックアプリ)で連携することができる『オブジェクト』と『カラム』について紹介します。

AbandonedCheckouts

『AbandonedCheckouts』のカラム一覧
連携可能なカラム
AbandonedCheckoutUrl
BuyerAcceptsMarketing
BillingAddressFirstName
BillingAddressLastName
BillingAddressAdress1
BillingAddressAdress2
BillingAddressPhone
BillingAddressCity
BillingAddressCompany
BillingAddressZip
BillingAddressProvince
BillingAddressCountry
BillingAddressLatitude
BillingAddressLongitude
BillingAddressName
BillingAddressCountryCode
BillingAddressProvinceCode
BillingAddressDefault
CancelReason
CartToken
Currency
CustomerId
ClosedAt
CompletedAt
CreatedAt
DiscountCodes
Email
Id
LandingSite
Note
ReferringSite
SourceName
SubtotalPrice
ShippingAddressFirstName
ShippingAddressLastName
ShippingAddressAdress1
ShippingAddressAdress2
ShippingAddressPhone
ShippingAddressCity
ShippingAddressCompany
ShippingAddressZip
ShippingAddressProvince
ShippingAddressCountry
ShippingAddressLatitude
ShippingAddressLongitude
ShippingAddressName
ShippingAddressCountryCode
ShippingAddressProvinceCode
ShippingAddressDefault
TotalDiscounts
TotalLineItemsPrice
TotalPrice
TotalTax
TotalWeight
TaxesIncluded
Token
UpdatedAt

AbandonedCheckoutsItems

『AbandonedCheckoutsItems』のカラム一覧
連携可能なカラム
AbandonedCheckoutId
CreatedAt
FulFillmentsService
ItemVariantId
ItemTitle
ItemQuantity
ItemPrice
ItemGrams
ProductId
SKU
UpdatedAt
VariantTitle
Vendor

ApplicationCharges

『ApplicationCharges』のカラム一覧
連携可能なカラム
ApiClientId
ChargeType
CreatedAt
DecoratedReturnUrl
Id
Name
Price
ReturnUrl
Status
Test
UpdatedAt

ApplicationCredit

『ApplicationCredit』のカラム一覧
連携可能なカラム
Amount
Description
Id
Test

Articles

『Articles』のカラム一覧
連携可能なカラム
AdminGraphqlApiId
Author
BlogId
BodyHtml
CreatedAt
Handle
Id
ImageAlt
ImageCreatedAt
ImageHeight
ImageSrc
ImageWidth
ImageAttachment
PublishedAt
PublishedStatus
SummaryHtml
Tags
TemplateSuffix
Title
UpdatedAt
UserId

Assets

『Assets』のカラム一覧
連携可能なカラム
Attachment
Checksum
ContentType
CreatedAt
Key
PublicUrl
Size
ThemeId
UpdatedAt
Value

AssignedFulfillmentOrders

『AssignedFulfillmentOrders』のカラム一覧
連携可能なカラム
AssignedLocationId
DestinationId
DestinationAddress1
DestinationAddress2
DestinationCity
DestinationCompany
DestinationFirstName
DestinationLastName
DestinationPhone
FulfillmentServiceHandle
Id
LineItems
OrderId
Operation
RequestStatus
ShopId
Status

Blogs

『Blogs』のカラム一覧
連携可能なカラム
AdminGraphqlApiId
Commentable
CreatedAt
Feedburner
FeedburnerLocation
Handle
Id
Metafields
Tags
TemplateSuffix
Title
UpdatedAt

CarrierServices

『CarrierServices』のカラム一覧
連携可能なカラム
Active
AdminGraphqlApiId
CallbackUrl
Format
Id
Name
ServiceDiscovery
Type

CollectionListings

『CollectionListings』のカラム一覧
連携可能なカラム
BodyHtml
DefaultProductImage
Handle
Id
ImageCreatedAt
ImageSource
PublishedAt
Title
UpdatedAt

Collects

『Collects』のカラム一覧
連携可能なカラム
CollectionId
CreatedAt
Id
ProductId
Position
SortValue
UpdatedAt

Comments

『Comments』のカラム一覧
連携可能なカラム
ArticleId
Author
BlogId
Body
BodyHtml
CreatedAt
Email
Id
Ip
PublishedAt
PublishedStatus
Status
UpdatedAt
UserAgent

Countries

『Countries』のカラム一覧
連携可能なカラム
CollectionId
CreatedAt
Id
ProductId
Position
SortValue
UpdatedAt

CustomCollections

『CustomCollections』のカラム一覧
連携可能なカラム
BodyHtml
Handle
Id
Image
Metafields
ProductId
PublishedAt
PublishedScope
PublishedStatus
SortOrder
TemplateSuffix
Title
UpdatedAt

CustomerAddresses

『CustomerAddresses』のカラム一覧
連携可能なカラム
Address1
Address2
City
Company
Country
CountryCode
CountryName
CustomerId
CustomerUpdatedAt
Default
FirstName
Id
LastName
Name
Phone
Province
ProvinceCode
Zip

Customers

『Customers』のカラム一覧
連携可能なカラム
AcceptsMarketing
CreatedAt
Email
EmailMarketingState
EmailMarketingLevel
EmailMarketingUpdatedAt
FirstName
Id
LastName
LastOrderId
LastOrderName
MultipassIdentifier
Note
OrdersCount
Phone
State
Tags
TaxExempt
TotalSpent
UpdatedAt
VerifiedEmail

DiscountApplications

『DiscountApplications』のカラム一覧
連携可能なカラム
AllocationMethod
Description
OrderId
OrderUpdatedAt
TargetSelection
TargetType
Title
Type
Value
ValueType

DiscountCodes

『DiscountCodes』のカラム一覧
連携可能なカラム
Code
CreatedAt
Id
PriceRuleId
UpdatedAt
UsageCount

DraftOrderItemProperties

『DraftOrderItemProperties』のカラム一覧
連携可能なカラム
DraftOrderId
ItemId
Name
Value

DraftOrderItems

『DraftOrderItems』のカラム一覧
連携可能なカラム
AppliedDiscountTitle
AppliedDiscountDescription
AppliedDiscountValue
AppliedDiscountValueType
AppliedDiscountAmount
Custom
DraftOrderId
FulfillableQuantity
FulFillmentsService
GiftCard
ItemGrams
ItemId
ItemPrice
ItemQuantity
ItemTitle
ItemVariantId
Name
ProductId
Properties
RequiresShipping
SKU
Taxable
TaxLines
VariantTitle
Vendor

DraftOrderItemTaxLines

『DraftOrderItemTaxLines』のカラム一覧
連携可能なカラム
DraftOrderId
ItemId
LineNumber
TaxTitle
TaxRate
TaxPrice

DraftOrders

『DraftOrders』のカラム一覧
連携可能なカラム
AppliedDiscountTitle
AppliedDiscountDescription
AppliedDiscountValue
AppliedDiscountValueType
AppliedDiscountAmount
BillingAddressFirstName
BillingAddressLastName
BillingAddressAddress1
BillingAddressAddress2
BillingAddressPhone
BillingAddressCity
BillingAddressCompany
BillingAddressZip
BillingAddressProvince
BillingAddressCountry
BillingAddressLatitude
BillingAddressLongitude
BillingAddressName
BillingAddressCountryCode
BillingAddressProvinceCode
BillingAddressDefault
CompletedAt
CreatedAt
CustomerId
Currency
Email
Id
InvoiceUrl
InvoiceSentAt
LineAggregate
Name
Note
Tags
TaxesIncluded
TaxExempt
TotalPrice
TotalTax
ShippingAddressFirstName
ShippingAddressLastName
ShippingAddressAddress1
ShippingAddressAddress2
ShippingAddressPhone
ShippingAddressCity
ShippingAddressCompany
ShippingAddressZip
ShippingAddressProvince
ShippingAddressCountry
ShippingAddressLatitude
ShippingAddressLongitude
ShippingAddressName
ShippingAddressCountryCode
ShippingAddressProvinceCode
ShippingAddressDefault
Status
SubtotalPrice
UpdatedAt

Events

『Events』のカラム一覧
連携可能なカラム
Arguments
Author
Body
CreatedAt
Description
Id
Message
Path
SubjectId
SubjectType
Verb

Fulfillments

『Fulfillments』のカラム一覧
連携可能なカラム
CreatedAt
FulfillmentOrderId
Id
LineAggregate
LocationId
NotifyCustomer
OrderCreatedAt
OrderId
OrderUpdatedAt
Receipt
Status
TrackingCompany
TrackingNumbers
TrackingUrls
UpdatedAt
VariantInventoryManagement

FulfillmentServices

『FulfillmentServices』のカラム一覧
連携可能なカラム
Cost
CountryCodeOfOrigin
CountryHarmonizedSystemCodes
CreatedAt
HarmonizedSystemCode
Id
ProvinceCodeOfOrigin
RequiresShipping
SKU
Tracked
UpdatedAt

InventoryItems

『InventoryItems』のカラム一覧
連携可能なカラム
Cost
CountryCodeOfOrigin
CountryHarmonizedSystemCodes
CreatedAt
HarmonizedSystemCode
Id
ProvinceCodeOfOrigin
RequiresShipping
SKU
Tracked
UpdatedAt

Locations

『Locations』のカラム一覧
連携可能なカラム
Address1
Address2
City
Country
CountryCode
CountryName
CreatedAt
DeletedAt
Id
Legacy
Name
Phone
Province
UpdatedAt
Zip

Metafield_Customer

『Metafield_Customer』のカラム一覧
連携可能なカラム
Id
Key
Namespace
OwnerId
UpdatedAt
Value

Metafield_Product

『Metafield_Product』のカラム一覧
連携可能なカラム
Id
Key
Namespace
OwnerId
UpdatedAt
Value

NoteAttributes

『NoteAttributes』のカラム一覧
連携可能なカラム
Name
OrderId
OrderUpdatedAt
Value

OrderDiscountCodes

『OrderDiscountCodes』のカラム一覧
連携可能なカラム
Amount
Code
OrderId
OrderUpdatedAt
Type

OrderItemDiscountAllocations

『OrderItemDiscountAllocations』のカラム一覧
連携可能なカラム
amount
ApplicationIndex
ItemId
LineNumber
OrderId
OrderUpdatedAt
PresentmentMoneyAmount
PresentmentMoneyCurrencyCode
ShopMoneyAmount
ShopMoneyCurrencyCode

OrderItemProperties

『OrderItemProperties』のカラム一覧
連携可能なカラム
ItemId
LineNumber
Name
OrderId
OrderUpdatedAt
Value

Orders

『Orders』のカラム一覧
連携可能なカラム
AppliedDiscountAmount
AppliedDiscountDescription
AppliedDiscountTitle
AppliedDiscountValue
AppliedDiscountValueType
BillingAddressAddress1
BillingAddressAddress2
BillingAddressCity
BillingAddressCompany
BillingAddressCountry
BillingAddressCountryCode
BillingAddressDefault
BillingAddressFirstName
BillingAddressLastName
BillingAddressLatitude
BillingAddressLongitude
BillingAddressName
BillingAddressPhone
BillingAddressProvince
BillingAddressProvinceCode
BillingAddressZip
BrowserIp
BuyerAcceptsMarketing
CancelledAt
CancelReason
CartToken
CheckoutId
CheckoutToken
ClosedAt
ConfirmationNumber
CreatedAt
Currency
CurrentTotalDutiesSetPresentmentMoneyAmount
CurrentTotalDutiesSetShopMoneyAmount
CurrentTotalPriceSetPresentmentMoneyAmount
CurrentTotalPriceSetShopMoneyAmount
CurrentTotalTaxSetPresentmentMoneyAmount
CurrentTotalTaxSetShopMoneyAmount
CurSubtotalPriceSetPresentmentMoneyAmount
CurSubtotalPriceSetShopMoneyAmount
CurTotalAdditionalFeesSetPresentmentMoneyAmount
CurTotalAdditionalFeesSetShopMoneyAmount
CurTotalDiscountsSetPresentmentMoneyAmount
CurTotalDiscountsSetShopMoneyAmount
CustomerFirstName
CustomerId
CustomerLastName
CustomerLocale
DiscountApplicationsAggregate
DiscountCodes
Email
EstimatedTaxes
FinancialStatus
FulfillmentAggregate
FulfillmentStatus
Id
InventoryBehaviour
InvoiceSentAt
InvoiceUrl
LandingSite
LineAggregate
LocationId
Name
Note
NoteAttributesAggregate
Number
Operation
OrderStatusUrl
OriginalTotalDutiesSetPresentmentMoneyAmount
OriginalTotalDutiesSetShopMoneyAmount
OrigTotalAdditionalFeesSetPresentmentMoneyAmount
OrigTotalAdditionalFeesSetShopMoneyAmount
PaymentGatewayNames
PaymentTermsAmount
PaymentTermsCurrency
PaymentTermsDueInDays
PaymentTermsPaymentSchedules
PaymentTermsPaymentTermsName
PaymentTermsPaymentTermsType
Phone
PresentmentCurrency
ProcessedAt
ProcessingMethod
ReferringSite
RefundAggregate
SendFulfillmentReceipt
SendReceipt
ShippingAddressAddress1
ShippingAddressAddress2
ShippingAddressCity
ShippingAddressCompany
ShippingAddressCountry
ShippingAddressCountryCode
ShippingAddressDefault
ShippingAddressFirstName
ShippingAddressLastName
ShippingAddressLatitude
ShippingAddressLongitude
ShippingAddressName
ShippingAddressPhone
ShippingAddressProvince
ShippingAddressProvinceCode
ShippingAddressZip
ShippingAggregate
SourceName
SubtotalPrice
Tags
TaxAggregate
TaxesIncluded
TaxExempt
Test
Token
TotalDiscounts
TotalDiscountsSetPresentmentMoneyAmount
TotalDiscountsSetShopMoneyAmount
TotalLineItemsPriceSetPresentmentMoneyAmount
TotalLineItemsPriceSetShopMoneyAmount
TotalOrderItemsPrice
TotalOutstanding
TotalPrice
TotalPriceSetPresentmentMoneyAmount
TotalPriceSetShopMoneyAmount
TotalShippingPriceSetPresentmentMoneyAmount
TotalShippingPriceSetShopMoneyAmount
TotalShippingPriceSetShopMoneyCurrencyCode
TotalSubtotalSetPresentmentMoneyAmount
TotalSubtotalSetShopMoneyAmount
TotalTax
TotalTaxSetPresentmentMoneyAmount
TotalTaxSetShopMoneyAmount
TotalTipReceived
TotalWeight
UpdatedAt

OrdersItems

『OrdersItems』のカラム一覧
連携可能なカラム
AppliedDiscountAmount
AppliedDiscountDescription
AppliedDiscountTitle
AppliedDiscountValue
AppliedDiscountValueType
FulfillableQuantity
FulFillmentsService
FulfillmentStatus
GiftCard
ItemGrams
ItemId
ItemPrice
ItemQuantity
ItemTitle
ItemVariantId
Name
OrderId
OrderUpdatedAt
ProductId
Properties
RequiresShipping
SKU
Taxable
TotalDiscount
VariantTitle
Vendor

OrderTransactions

『OrderTransactions』のカラム一覧
連携可能なカラム
Amount
Authorization
AVSResultCode
CreatedAt
CreditCardBin
CreditCardCompany
CreditCardExpMonth
CreditCardExpYear
CreditCardName
CreditCardNumber
CreditCardWallet
Currency
CVVResultCode
DeviceId
ErrorCode
Gateway
Id
Kind
LocationId
Message
OrderId
PaymentId
PaymentsRefundsAttributesAcquirerReferenceNumber
PaymentsRefundsAttributesStatus
ProcessedAt
Receipt
ReceiptAuthorization
ReceiptTestcase
SourceName
Status
Test
TotalUnsettledSetPresentmentMoneyAmount
TotalUnsettledSetShopMoneyAmount
UserId

Pages

『Pages』のカラム一覧
連携可能なカラム
AdminGraphqlApiId
Author
BodyHtml
CreatedAt
Handle
Id
Metafields
PublishedAt
PublishedStatus
ShopId
TemplateSuffix
Title
UpdatedAt

Payouts

『Payouts』のカラム一覧
連携可能なカラム
Amount
Currency
Date
Id
Status

PayoutTransactions

『PayoutTransactions』のカラム一覧
連携可能なカラム
Amount
Currency
Fee
Id
Net
PayoutId
PayoutStatus
ProcessedAt
SourceId
SourceOrderId
SourceOrderTransactionId
SourceType
Test
Type

PriceRules

『PriceRules』のカラム一覧
連携可能なカラム
AllocationMethod
CreatedAt
CustomerSelection
EndsAt
EntitledCollectionIds
EntitledCountryIds
EntitledProductIds
EntitledVariantIds
Id
Images
OncePerCustomer
Options
PrerequisiteCollectionIds
PrerequisiteCustomerIds
PrerequisiteProductIds
PrerequisiteQuantityRange
PrerequisiteSavedSearchIds
PrerequisiteShippingPriceRange
PrerequisiteSubtotalRange
PrerequisiteToEntitlementQuantityRatio
PrerequisiteVariantIds
ProductType
PublishedAt
PublishedScope
StartsAt
Tags
TargetSelection
TargetType
TemplateSuffix
Title
UpdatedAt
UsageLimit
Value
ValueType
Vendor

ProductImages

『ProductImages』のカラム一覧
連携可能なカラム
Alt
CreatedAt
FilePath
Height
ImageId
Position
ProductId
Src
UpdatedAt
VariantIds
Width

ProductListings

『ProductListings』のカラム一覧
連携可能なカラム
BodyHtml
CreatedAt
Handle
Images
Options
ProductId
ProductType
PublishedAt
Tags
Title
UpdatedAt
Variants
Vendor

ProductOptions

『ProductOptions』のカラム一覧
連携可能なカラム
Id
Name
Position
ProductId
ProductUpdatedAt
Values

Products

『Products』のカラム一覧
連携可能なカラム
BodyHtml
CreatedAt
Handle
Id
Images
Options
ProductType
PublishedAt
PublishedScope
PublishedStatus
Status
Tags
TemplateSuffix
Title
UpdatedAt
Variants
Vendor

ProductVariants

『ProductVariants』のカラム一覧
連携可能なカラム
Barcode
CompareAtPrice
CreatedAt
FulfillmentService
Grams
Id
ImageId
InventoryItemId
InventoryManagement
InventoryPolicy
InventoryQuantity
Option1
Option2
Option3
Position
Price
ProductId
RequiresShipping
Sku
Taxable
Title
UpdatedAt
Weight
WeightUnit

Provinces

『Provinces』のカラム一覧
連携可能なカラム
Code
CountryId
Id
Name
ShippingZoneId
Tax
TaxName
TaxPercentage
TaxType

RecurringApplicationCharges

『RecurringApplicationCharges』のカラム一覧
連携可能なカラム
ActivatedOn
ApiClientId
BillingOn
CancelledOn
CappedAmount
ConfirmationUrl
CreatedAt
DecoratedReturnUrl
Id
Name
Price
ReturnUrl
Status
Terms
Test
TrialDays
TrialEndsOn
UpdatedAt

Redirects

『Redirects』のカラム一覧
連携可能なカラム
Id
Path
Target

RefundAdjustments

『RefundAdjustments』のカラム一覧
連携可能なカラム
Amount
AmountPresentmentCurrency
AmountPresentmentMoney
AmountShopCurrency
AmountShopMoney
Id
Kind
OrderId
Reason
RefundId
TaxAmount
TaxAmountPresentmentCurrency
TaxAmountPresentmentMoney
TaxAmountShopCurrency
TaxAmountShopMoney

Refunds

『Refunds』のカラム一覧
連携可能なカラム
CreatedAt
Id
LineAggregate
Note
OrderId
OrderTransactionAggregate
OrderUpdatedAt
ProcessedAt
Restock
UserId

RefundsItems

『RefundsItems』のカラム一覧
連携可能なカラム
AppliedDiscountAmount
AppliedDiscountDescription
AppliedDiscountTitle
AppliedDiscountValue
AppliedDiscountValueType
FulfillableQuantity
FulFillmentsService
FulfillmentStatus
GiftCard
ItemGrams
ItemId
ItemPrice
ItemQuantity
ItemTitle
ItemVariantId
LocationId
Name
OrderID
ProductId
Properties
RefundId
RefundQuantity
RefundRestockType
RefundSubtotal
RefundSubtotalPresentmentAmount
RefundSubtotalPresentmentCurrencyCode
RefundSubtotalShopAmount
RefundSubtotalShopCurrencyCode
RefundTotalTax
RefundTotalTaxPresentmentAmount
RefundTotalTaxPresentmentCurrencyCode
RefundTotalTaxShopAmount
RefundTotalTaxShopCurrencyCode
RequiresShipping
SKU
Taxable
TotalDiscount
VariantTitle
Vendor

RefundTransactions

『RefundTransactions』のカラム一覧
連携可能なカラム
Amount
Authorization
CreatedAt
Currency
DeviceId
ErrorCode
Gateway
GraphqlAPIId
Kind
LocationId
Message
OrderId
ParentId
ProcessedAt
RefundId
SourceName
Status
Test
TransactionsId
UserId

Reports

『Reports』のカラム一覧
連携可能なカラム
Category
Id
Name
ShopifyQl
UpdatedAt

ScriptTags

『ScriptTags』のカラム一覧
連携可能なカラム
Cache
CreatedAt
DisplayScope
Event
Id
Src
UpdatedAt

ShippingItemDiscountAllocations

『ShippingItemDiscountAllocations』のカラム一覧
連携可能なカラム
Amount
DiscountApplicationIndex
ItemId
LineNumber
OrderId
OrderUpdatedAt
PresentmentMoneyAmount
PresentmentMoneyCurrencyCode
ShopMoneyAmount
ShopMoneyCurrencyCode

ShippingItems

『ShippingItems』のカラム一覧
連携可能なカラム
CarrierIdentifier
Code
Id
OrderId
OrderUpdatedAt
Price
RequestedFulfillmentServiceId
Source
Title

ShippingZones

『ShippingZones』のカラム一覧
連携可能なカラム
CarrierShippingRateProviders
Countries
Id
LocationGroupId
Name
PriceBasedShippingRates
ProfileId
WeightBasedShippingRates

Shop

『Shop』のカラム一覧
連携可能なカラム
Address1
Address2
City
Country
CountryCode
CountryName
CountryTaxes
CreatedAt
Currency
CustomerEmail
Domain
Email
GoogleAppsDomain
GoogleAppsLoginEnabled
HasDiscounts
HasGiftCards
HasStorefront
IANATimezone
Id
Latitude
Longitude
MoneyFormat
MoneyWithCurrencyFormat
MyshopifyDomain
Name
PasswordEnabled
Phone
PlanDisplayName
PlanName
PrimaryLocale
Province
ProvinceCode
SetupRequired
ShopOwner
Source
TaxesIncluding
TaxShipping
Timezone
UpdatedAt
WeightUnit
Zip

SmartCollections

『SmartCollections』のカラム一覧
連携可能なカラム
BodyHtml
Disjunctive
Handle
Id
Image
ProductId
PublishedAt
PublishedScope
PublishedStatus
Rules
SortOrder
TemplateSuffix
Title
UpdatedAt

TaxItems

『TaxItems』のカラム一覧
連携可能なカラム
ChannelLiable
LineNumber
OrderId
OrderUpdatedAt
TaxItemPrice
TaxItemRate
TaxItemTitle

Themes

『Themes』のカラム一覧
連携可能なカラム
AdminGraphqlApiId
CreatedAt
Id
Name
Previewable
Processing
Role
ThemeStoreId
UpdatedAt

UsageCharges

『UsageCharges』のカラム一覧
連携可能なカラム
BalanceRemaining
BalanceUsed
BillingOn
CreatedAt
Description
Id
Price
RecurringApplicationId
RiskLevel

Users

『Users』のカラム一覧
連携可能なカラム
AccountOwner
AdminGraphQLAPIId
Bio
Email
FirstName
Id
IM
LastName
Locale
Permissions
Phone
ReceiveAnnouncements
ScreenName
TFAEnabled
Url
UserType