Bring data from VTEX to your Lakehouse.
appKey
for API authentication.appToken
for API authentication.example.myvtex.com
, the value to fill in this field is example
.Tip: The stream can be found more easily by typing its name.Select the streams and click Next.
Orders List
orderId
: The order IDcreationDate
: The date and time when the order was createdclientName
: The name of the clienttotalValue
: The total value of the orderpaymentNames
: The payment method namesstatus
: The order statusstatusDescription
: The description of the order statusmarketPlaceOrderId
: The marketplace order IDsequence
: The order sequence numbersalesChannel
: The sales channel IDaffiliateId
: The affiliate IDorigin
: The origin of the orderworkflowInErrorState
: Whether the workflow is in error stateworkflowInRetry
: Whether the workflow is in retry statelastMessageUnread
: The last unread messageshippingEstimatedDate
: The estimated shipping dateShippingEstimatedDateMax
: The maximum estimated shipping dateShippingEstimatedDateMin
: The minimum estimated shipping dateorderIsComplete
: Whether the order is completelistId
: The list IDlistType
: The list typeauthorizedDate
: The date and time when the order was authorizedcallCenterOperatorName
: The name of the call center operatortotalItems
: The total number of items in the ordercurrencyCode
: The currency codeOrder Details
orderId
: The unique identifier for the order.sequence
: The order’s sequence number.marketplaceOrderId
: The order ID from the marketplace.marketplaceServicesEndpoint
: The endpoint for marketplace services.sellerOrderId
: The seller’s unique identifier for the order.origin
: The origin of the order (e.g., Marketplace
, Fulfillment
).affiliateId
: The affiliate ID associated with the order.salesChannel
: The sales channel ID.merchantName
: The name of the merchant.status
: The current status of the order (e.g., handling
, shipped
).statusDescription
: A description of the current order status.value
: The total value of the order.creationDate
: The timestamp when the order was created.lastChange
: The timestamp of the last modification to the order.orderGroup
: The order group ID.followUpEmail
: The follow-up email address.hostname
: The hostname where the order was placed.isCompleted
: A boolean indicating if the order is completed.roundingError
: The rounding error value.orderFormId
: The ID of the order form.allowCancellation
: A boolean indicating if cancellation is allowed.allowEdition
: A boolean indicating if editing is allowed.isCheckedIn
: A boolean indicating if the order is checked in.authorizedDate
: The timestamp when the order was authorized.invoicedDate
: The timestamp when the order was invoiced.cancelReason
: The reason for cancellation.totals
: An array of objects containing total values for the order (e.g., Items
, Shipping
).sellers
: An array of objects detailing the sellers involved in the order.clientPreferencesData.locale
: The client’s locale (e.g., en-US
).clientPreferencesData.optinNewsLetter
: Indicates if the client opted into the newsletter.cancellationData.RequestedByUser
: Indicates if cancellation was requested by the user.cancellationData.RequestedBySystem
: Indicates if cancellation was requested by the system.cancellationData.Reason
: The reason for cancellation.cancellationData.CancellationDate
: The date of cancellation.marketplace.baseURL
: The base URL of the marketplace.marketplace.isCertified
: Indicates if the marketplace is certified.marketplace.name
: The name of the marketplace.storePreferencesData.countryCode
: The country code of the store (e.g., USA
).storePreferencesData.currencyCode
: The currency code of the store (e.g., USD
).storePreferencesData.currencySymbol
: The currency symbol of the store (e.g., $
).storePreferencesData.timeZone
: The time zone of the store.taxData.areTaxesDesignatedByMarketplace
: Indicates if taxes are designated by the marketplace.taxData.taxInfoCollection
: An array of tax information objects.subscriptionData.SubscriptionGroupId
: The ID of the subscription group.subscriptionData.Subscriptions
: An array of subscription objects.itemMetadata.Items
: An array of item metadata objects.invoiceData.address
: Object containing the billing address.changesAttachment.id
: The ID of the changes attachment.changesAttachment.changesData
: An array of objects detailing the changes.callCenterOperatorData.id
: The operator’s ID.callCenterOperatorData.email
: The operator’s email.callCenterOperatorData.userName
: The operator’s username.packageAttachment.packages
: An array of package objects.shippingData.address
: The shipping address.shippingData.logisticsInfo
: An array of logistics information objects.clientProfileData.email
: The client’s email.clientProfileData.firstName
: The client’s first name.clientProfileData.lastName
: The client’s last name.clientProfileData.document
: The client’s document number.clientProfileData.phone
: The client’s phone number.clientProfileData.isCorporate
: Indicates if the client is a corporate customer.clientProfileData.userProfileId
: The user profile ID.ratesAndBenefitsData.id
: The ID of the rates and benefits data.ratesAndBenefitsData.rateAndBenefitsIdentifiers
: An array of rate and benefit identifiers.marketingData.utmSource
: The UTM source.marketingData.utmMedium
: The UTM medium.marketingData.utmCampaign
: The UTM campaign.marketingData.coupon
: The coupon code used.marketingData.marketingTags
: An array of marketing tags.items
: An array of objects, each representing an item in the order.paymentData.transactions
: An array of transaction objects.