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

Question

Accepted Answer

本記事について

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

※ 紹介するカラムは『A』～『Z』の順に記載しています

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

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

以下では、Shopify（パブリックアプリ）で連携することができる『オブジェクト』と『カラム』について、頭文字ごとに紹介します。各見出しをクリックすると、その頭文字で始まるオブジェクトの連携可能なカラム一覧が表示されます。

『A』で始まるオブジェクト（7件）

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

AbandonedCheckoutId CreatedAt FulFillmentsService ItemVariantId ItemTitle ItemQuantity ItemPrice ItemGrams ProductId SKU UpdatedAt VariantTitle Vendor

ApplicationCharges

ApiClientId ChargeType CreatedAt DecoratedReturnUrl Id Name Price ReturnUrl Status Test UpdatedAt

ApplicationCredit

Amount Description Id Test

Articles

AdminGraphqlApiId Author BlogId BodyHtml CreatedAt Handle Id ImageAlt ImageCreatedAt ImageHeight ImageSrc ImageWidth ImageAttachment PublishedAt PublishedStatus SummaryHtml Tags TemplateSuffix Title UpdatedAt UserId

Assets

Attachment Checksum ContentType CreatedAt Key PublicUrl Size ThemeId UpdatedAt Value

AssignedFulfillmentOrders

AssignedLocationId DestinationId DestinationAddress1 DestinationAddress2 DestinationCity DestinationCompany DestinationFirstName DestinationLastName DestinationPhone FulfillmentServiceHandle Id LineItems OrderId Operation RequestStatus ShopId Status

『B』で始まるオブジェクト（1件）

Blogs

AdminGraphqlApiId Commentable CreatedAt Feedburner FeedburnerLocation Handle Id Metafields Tags TemplateSuffix Title UpdatedAt

『C』で始まるオブジェクト（8件）

CarrierServices

Active AdminGraphqlApiId CallbackUrl Format Id Name ServiceDiscovery Type

CollectionListings

BodyHtml DefaultProductImage Handle Id ImageCreatedAt ImageSource PublishedAt Title UpdatedAt

Collects

CollectionId CreatedAt Id ProductId Position SortValue UpdatedAt

Comments

ArticleId Author BlogId Body BodyHtml CreatedAt Email Id Ip PublishedAt PublishedStatus Status UpdatedAt UserAgent

Countries

CollectionId CreatedAt Id ProductId Position SortValue UpdatedAt

CustomCollections

BodyHtml Handle Id Image Metafields ProductId PublishedAt PublishedScope PublishedStatus SortOrder TemplateSuffix Title UpdatedAt

CustomerAddresses

Address1 Address2 City Company Country CountryCode CountryName CustomerId CustomerUpdatedAt Default FirstName Id LastName Name Phone Province ProvinceCode Zip

Customers

AcceptsMarketing CreatedAt Email EmailMarketingState EmailMarketingLevel EmailMarketingUpdatedAt FirstName Id LastName LastOrderId LastOrderName MultipassIdentifier Note OrdersCount Phone State Tags TaxExempt TotalSpent UpdatedAt VerifiedEmail

『D』で始まるオブジェクト（6件）

DiscountApplications

AllocationMethod Description OrderId OrderUpdatedAt TargetSelection TargetType Title Type Value ValueType

DiscountCodes

Code CreatedAt Id PriceRuleId UpdatedAt UsageCount

DraftOrderItemProperties

DraftOrderId ItemId Name Value

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

DraftOrderId ItemId LineNumber TaxTitle TaxRate TaxPrice

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

『E』で始まるオブジェクト（1件）

Events

Arguments Author Body CreatedAt Description Id Message Path SubjectId SubjectType Verb

『F』で始まるオブジェクト（2件）

Fulfillments

CreatedAt FulfillmentOrderId Id LineAggregate LocationId NotifyCustomer OrderCreatedAt OrderId OrderUpdatedAt Receipt Status TrackingCompany TrackingNumbers TrackingUrls UpdatedAt VariantInventoryManagement

FulfillmentServices

Cost CountryCodeOfOrigin CountryHarmonizedSystemCodes CreatedAt HarmonizedSystemCode Id ProvinceCodeOfOrigin RequiresShipping SKU Tracked UpdatedAt

『I』で始まるオブジェクト（1件）

InventoryItems

Cost CountryCodeOfOrigin CountryHarmonizedSystemCodes CreatedAt HarmonizedSystemCode Id ProvinceCodeOfOrigin RequiresShipping SKU Tracked UpdatedAt

『L』で始まるオブジェクト（1件）

Locations

Address1 Address2 City Country CountryCode CountryName CreatedAt DeletedAt Id Legacy Name Phone Province UpdatedAt Zip

『M』で始まるオブジェクト（2件）

Metafield_Customer

Id Key Namespace OwnerId UpdatedAt Value

Metafield_Product

Id Key Namespace OwnerId UpdatedAt Value

『N』で始まるオブジェクト（1件）

NoteAttributes

Name OrderId OrderUpdatedAt Value

『O』で始まるオブジェクト（6件）

OrderDiscountCodes

Amount Code OrderId OrderUpdatedAt Type

OrderItemDiscountAllocations

amount ApplicationIndex ItemId LineNumber OrderId OrderUpdatedAt PresentmentMoneyAmount PresentmentMoneyCurrencyCode ShopMoneyAmount ShopMoneyCurrencyCode

OrderItemProperties

ItemId LineNumber Name OrderId OrderUpdatedAt Value

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

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

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

『P』で始まるオブジェクト（10件）

Pages

AdminGraphqlApiId Author BodyHtml CreatedAt Handle Id Metafields PublishedAt PublishedStatus ShopId TemplateSuffix Title UpdatedAt

Payouts

Amount Currency Date Id Status

PayoutTransactions

Amount Currency Fee Id Net PayoutId PayoutStatus ProcessedAt SourceId SourceOrderId SourceOrderTransactionId SourceType Test Type

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

Alt CreatedAt FilePath Height ImageId Position ProductId Src UpdatedAt VariantIds Width

ProductListings

BodyHtml CreatedAt Handle Images Options ProductId ProductType PublishedAt Tags Title UpdatedAt Variants Vendor

ProductOptions

Id Name Position ProductId ProductUpdatedAt Values

Products

BodyHtml CreatedAt Handle Id Images Options ProductType PublishedAt PublishedScope PublishedStatus Status Tags TemplateSuffix Title UpdatedAt Variants Vendor

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

Code CountryId Id Name ShippingZoneId Tax TaxName TaxPercentage TaxType

『R』で始まるオブジェクト（7件）

RecurringApplicationCharges

ActivatedOn ApiClientId BillingOn CancelledOn CappedAmount ConfirmationUrl CreatedAt DecoratedReturnUrl Id Name Price ReturnUrl Status Terms Test TrialDays TrialEndsOn UpdatedAt

Redirects

Id Path Target

RefundAdjustments

Amount AmountPresentmentCurrency AmountPresentmentMoney AmountShopCurrency AmountShopMoney Id Kind OrderId Reason RefundId TaxAmount TaxAmountPresentmentCurrency TaxAmountPresentmentMoney TaxAmountShopCurrency TaxAmountShopMoney

Refunds

CreatedAt Id LineAggregate Note OrderId OrderTransactionAggregate OrderUpdatedAt ProcessedAt Restock UserId

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

Amount Authorization CreatedAt Currency DeviceId ErrorCode Gateway GraphqlAPIId Kind LocationId Message OrderId ParentId ProcessedAt RefundId SourceName Status Test TransactionsId UserId

Reports

Category Id Name ShopifyQl UpdatedAt

『S』で始まるオブジェクト（6件）

ScriptTags

Cache CreatedAt DisplayScope Event Id Src UpdatedAt

ShippingItemDiscountAllocations

Amount DiscountApplicationIndex ItemId LineNumber OrderId OrderUpdatedAt PresentmentMoneyAmount PresentmentMoneyCurrencyCode ShopMoneyAmount ShopMoneyCurrencyCode

ShippingItems

CarrierIdentifier Code Id OrderId OrderUpdatedAt Price RequestedFulfillmentServiceId Source Title

ShippingZones

CarrierShippingRateProviders Countries Id LocationGroupId Name PriceBasedShippingRates ProfileId WeightBasedShippingRates

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

BodyHtml Disjunctive Handle Id Image ProductId PublishedAt PublishedScope PublishedStatus Rules SortOrder TemplateSuffix Title UpdatedAt

『T』で始まるオブジェクト（2件）

TaxItems

ChannelLiable LineNumber OrderId OrderUpdatedAt TaxItemPrice TaxItemRate TaxItemTitle

Themes

AdminGraphqlApiId CreatedAt Id Name Previewable Processing Role ThemeStoreId UpdatedAt

『U』で始まるオブジェクト（2件）

UsageCharges

BalanceRemaining BalanceUsed BillingOn CreatedAt Description Id Price RecurringApplicationId RiskLevel

Users

AccountOwner AdminGraphQLAPIId Bio Email FirstName Id IM LastName Locale Permissions Phone ReceiveAnnouncements ScreenName TFAEnabled Url UserType