eBay

eBay is a global marketplace where businesses and individuals can buy and sell items.

eBay integration replicates data using the eBay Fulfillment API.

See the Schema section for a list of objects available for replication.

Una visión detallada de este conector, incluye enlaces útiles y funcionalidad compatible.

Función/Capacidad	Detalles de compatibilidad
Compatibilidad con proyectos de Qlik Talend Data Integration	Solo proyectos de replicación. No se admiten proyectos de canalización de datos.
Métodos de actualización de destinos	Tareas de replicación: Aplicar los cambios Guardar cambios Tareas de aterrizaje de datos en un lago de datos: Captura de datos de cambios (CDC)
Administrar los metadatos	No es necesario generar metadatos manualmente.
Evolución del esquema	Solo se admite la operación Cambiar tipo de datos de columna.
Replicación de columnas LOB (NCLOB, CLOB y BLOB)	No admitido.
CDC programado	Obligatorio. Así es como el destino se mantiene actualizado con los cambios en la fuente. Para tareas de replicación, vea Programar tareas Para tareas de aterrizaje en un lago de datos, vea Programación de CDC para tareas de destino/aterrizaje en un lago de datos
Notificaciones	Parcialmente compatible Configuración de notificaciones sobre cambios
Supervisión	Solo CDC, ya que la carga completa no es relevante para este conector. Supervisar una tarea individual de datos
Descarte automático de cargas útiles de columnas JSON	No admitido. Las cargas útiles de columnas JSON en los conjuntos de datos de origen no se deniegan automáticamente en el destino.

Preparing for authentication

To access your data, you need to authenticate the connection with your account credentials.

Asegúrese de que la cuenta que utiliza tenga acceso de lectura a las tablas que desea recuperar.

To retrieve your client secret and ID:

Log into your eBay developer portal.
Go to the Application Keys page.
Enter your application name.
Under either Sandbox or Production, click Create a keyset.
Click OAuth Scopes to confirm the App ID has the required scopes.
In the User Tokens field, enter the redirect URL https://connector.qlik.com/auth/oauth/v3.htm.
Copy and paste your client secret and client ID into a secured file.

Creating the connection

Para más información, vea Conectar con aplicaciones SaaS.

Haga clic en Autenticar cuando haya completado la configuración de conexión requerida.
Es posible que se le solicite que inicie sesión en la aplicación de origen.
Se mostrará una ventana con un código de autenticación.
Copie el código en el portapapeles y regrese al cuadro de diálogo de conexión.
Pegue el código en Autenticación completa con el código proporcionado por la fuente y haga clic en Verificar.
Nota de sugerenciaEs posible que tenga que desplazarse hacia abajo para ver este campo.
Cuando el estado es Verificado, se verifica la autenticación.
Proporcione un nombre para la conexión en Nombre de la conexión.
Seleccione Abrir metadatos de conexión para definir metadatos para la conexión cuando se haya creado.

Connection settings
Setting	Description
Data gateway	Seleccione una Data Movement gateway si su caso de uso así lo requiere. Nota informativa Este campo no está disponible con la suscripción Qlik Talend Cloud Starter porque Data Movement gateway no se admite. Si tiene otro nivel de suscripción y no desea utilizar Data Movement gateway, seleccione Ninguna. Para obtener información sobre las ventajas de Data Movement gateway y los casos de uso que lo requieren, consulte Pasarela de movimiento de datos de Qlik.
Start Date	Indique la fecha, en el formato `MM/DD/YYYY`, a partir de la cual deben replicarse los datos de su fuente a su destino.
Client ID	Client ID.
Client Secret	Client secret.

Schema

Schemas and naming conventions can change from version to version. It is recommended to verify your version before continuing.

The schema and info displayed below is for version 1.

Depending on your destination, table and column names may not appear as they are outlined below.

orders

The orders table contains details about all orders in your eBay seller account.

Note: The integration’s Start Date must be within 90 days of the current date, if initially creating or resetting the integration. Exceeding 90 days will result in an eBay 30830 API error.

Replication Method

Full Table

Primary Key

orderId

Useful links

eBay API method

buyer

OBJECT

This is a nested data structure:

username: STRING

buyerCheckoutNotes

STRING

cancelStatus

OBJECT

This is a nested data structure:

cancelRequests: ARRAY, which is also a nested data structure.
- cancelCompletedDate: STRING
- cancelInitiator: STRING
- cancelReason: STRING
- cancelRequestId: STRING
- cancelRequestState: STRING
- cancelRequestedDate: STRING
cancelState: STRING
cancelledDate: STRING

creationDate

STRING

ebayCollectAndRemitTax

BOOLEAN

fulfillmentHrefs

ARRAY

This is a nested data structure.

fulfillmentStartInstructions

ARRAY

This is a nested data structure:

ebaySupportedFulfillment: BOOLEAN
finalDestinationAddress: OBJECT, which is also a nested data structure.
- addressLine1: STRING
- addressLine2: STRING
- city: STRING
- countryCode: STRING
- county: STRING
- postalCode: STRING
- stateOrProvince: STRING
fulfillmentInstructionsType: STRING
maxEstimatedDeliveryDate: STRING
minEstimatedDeliveryDate: STRING
pickupStep: OBJECT, which is also a nested data structure.
- merchantLocationKey: STRING
shippingStep: OBJECT, which is also a nested data structure.
- shipTo: OBJECT, which is also a nested data structure.
  - companyName: STRING
  - contactAddress: OBJECT, which is also a nested data structure.
    - addressLine1: STRING
    - addressLine2: STRING
    - city: STRING
    - countryCode: STRING
    - county: STRING
    - postalCode: STRING
    - stateOrProvince: STRING
  - email: STRING
  - fullName: STRING
  - primaryPhone: OBJECT, which is also a nested data structure.
    - phoneNumber: STRING
- shipToReferenceId: STRING
- shippingCarrierCode: STRING
- shippingServiceCode: STRING

lastModifiedDate

STRING

legacyOrderId

STRING

lineItems

ARRAY

This is a nested data structure:

appliedPromotions: ARRAY, which is also a nested data structure.
- description: STRING
- discountAmount: OBJECT, which is also a nested data structure.
  - convertedFromCurrency: STRING
  - convertedFromValue: STRING
  - currency: STRING
  - value: STRING
- promotionId: STRING
deliveryCost: OBJECT, which is also a nested data structure.
- importCharges: OBJECT, which is also a nested data structure.
  - convertedFromCurrency: STRING
  - convertedFromValue: STRING
  - currency: STRING
  - value: STRING
- shippingCost: OBJECT, which is also a nested data structure.
  - convertedFromCurrency: STRING
  - convertedFromValue: STRING
  - currency: STRING
  - value: STRING
- shippingIntermediationFee: OBJECT, which is also a nested data structure.
  - convertedFromCurrency: STRING
  - convertedFromValue: STRING
  - currency: STRING
  - value: STRING
discountedLineItemCost: OBJECT, which is also a nested data structure.
- convertedFromCurrency: STRING
- convertedFromValue: STRING
- currency: STRING
- value: STRING
ebayCollectAndRemitTaxes: ARRAY, which is also a nested data structure.
- amount: OBJECT, which is also a nested data structure.
  - convertedFromCurrency: STRING
  - convertedFromValue: STRING
  - currency: STRING
  - value: STRING
- taxType: STRING
giftDetails: OBJECT, which is also a nested data structure.
- message: STRING
- recipientEmail: STRING
- senderName: STRING
legacyItemId: STRING
legacyVariationId: STRING
lineItemCost: OBJECT, which is also a nested data structure.
- convertedFromCurrency: STRING
- convertedFromValue: STRING
- currency: STRING
- value: STRING
lineItemFulfillmentInstructions: OBJECT, which is also a nested data structure.
- guaranteedDelivery: BOOLEAN
- maxEstimatedDeliveryDate: STRING
- minEstimatedDeliveryDate: STRING
- shipByDate: STRING
lineItemFulfillmentStatus: STRING
lineItemId: STRING
listingMarketplaceId: STRING
properties: OBJECT, which is also a nested data structure.
- buyerProtection: BOOLEAN
- fromBestOffer: BOOLEAN
- soldViaAdCampaign: BOOLEAN
purchaseMarketplaceId: STRING
quantity: INTEGER
refunds: ARRAY, which is also a nested data structure.
- amount: OBJECT, which is also a nested data structure.
  - convertedFromCurrency: STRING
  - convertedFromValue: STRING
  - currency: STRING
  - value: STRING
- refundDate: STRING
- refundReferenceId: STRING
sku: STRING
soldFormat: STRING
taxes: ARRAY, which is also a nested data structure.
- amount: OBJECT, which is also a nested data structure.
  - convertedFromCurrency: STRING
  - convertedFromValue: STRING
  - currency: STRING
  - value: STRING
title: STRING
total: OBJECT, which is also a nested data structure.
- convertedFromCurrency: STRING
- convertedFromValue: STRING
- currency: STRING
- value: STRING

orderFulfillmentStatus

STRING

orderId

STRING

orderPaymentStatus

STRING

paymentSummary

OBJECT

This is a nested data structure:

payments: ARRAY, which is also a nested data structure.
- amount: OBJECT, which is also a nested data structure.
  - convertedFromCurrency: STRING
  - convertedFromValue: STRING
  - currency: STRING
  - value: STRING
- paymentDate: STRING
- paymentHolds: ARRAY, which is also a nested data structure.
  - expectedReleaseDate: STRING
  - holdAmount: OBJECT, which is also a nested data structure.
    - convertedFromCurrency: STRING
    - convertedFromValue: STRING
    - currency: STRING
    - value: STRING
  - holdReason: STRING
  - holdState: STRING
  - releaseDate: STRING
  - sellerActionsToRelease: ARRAY, which is also a nested data structure.
    - sellerActionToRelease: STRING
- paymentMethod: STRING
- paymentReferenceId: STRING
- paymentStatus: STRING
refunds: ARRAY, which is also a nested data structure.
- amount: OBJECT, which is also a nested data structure.
  - convertedFromCurrency: STRING
  - convertedFromValue: STRING
  - currency: STRING
  - value: STRING
- refundDate: STRING
- refundReferenceId: STRING
- refundStatus: STRING
totalDueSeller: OBJECT, which is also a nested data structure.
- convertedFromCurrency: STRING
- convertedFromValue: STRING
- currency: STRING
- value: STRING

pricingSummary

OBJECT

This is a nested data structure:

adjustment: OBJECT, which is also a nested data structure.
- convertedFromCurrency: STRING
- convertedFromValue: STRING
- currency: STRING
- value: STRING
deliveryCost: OBJECT, which is also a nested data structure.
- convertedFromCurrency: STRING
- convertedFromValue: STRING
- currency: STRING
- value: STRING
deliveryDiscount: OBJECT, which is also a nested data structure.
- convertedFromCurrency: STRING
- convertedFromValue: STRING
- currency: STRING
- value: STRING
fee: OBJECT, which is also a nested data structure.
- convertedFromCurrency: STRING
- convertedFromValue: STRING
- currency: STRING
- value: STRING
priceDiscountSubtotal: OBJECT, which is also a nested data structure.
- convertedFromCurrency: STRING
- convertedFromValue: STRING
- currency: STRING
- value: STRING
priceSubtotal: OBJECT, which is also a nested data structure.
- convertedFromCurrency: STRING
- convertedFromValue: STRING
- currency: STRING
- value: STRING
tax: OBJECT, which is also a nested data structure.
- convertedFromCurrency: STRING
- convertedFromValue: STRING
- currency: STRING
- value: STRING
total: OBJECT, which is also a nested data structure.
- convertedFromCurrency: STRING
- convertedFromValue: STRING
- currency: STRING
- value: STRING

salesRecordReference

STRING

sellerId

STRING

¿Esta página le ha sido útil?

Si encuentra algún problema con esta página o su contenido (errores tipográficos, pasos que faltan o errores técnicos), no dude en ponerse en contacto con nosotros.

Deje aquí sus comentarios