Integration of Allegro with BigQuery

Learn how to integrate Allegro with Google BigQuery using WitCloud. Automatically fetch orders, products, and customer data, analyze it in real-time, and optimize your sales performance

Updated

Introduction

This module integrates with the Allegro API, enabling you to collect marketplace data and store it in Google Cloud BigQuery. Gain deeper insights into your data and optimize the performance of your marketing efforts.

Configuration guide

Follow the steps below to connect Allegro with BigQuery. Once the setup is complete, your Allegro data is transferred to your BigQuery project automatically.

Make sure you have admin access to your Allegro account before starting the configuration.

Module setup

Go to Integrations in the menu and click Add integration.

Integrations list with the Add integration button

Select Allegro from the list of available integrations.

Integration catalog with Allegro selected

Enter the Collect name, e.g., Allegro PL. A clear name helps you recognise the data source later.

Collect name field filled in with the example name Allegro PL

Authorization

If you have previously authorized the Allegro module and do not require additional permissions, you can skip this step and pick the existing account from the Select Allegro account drop-down.

Click Authorize.

Authorize button next to the Allegro account field

Log in and grant the necessary permissions.

Allegro login and permissions screen

Select the appropriate account from the Select Allegro account drop-down list.

Select Allegro account drop-down open with an example account

Advanced settings

Click Show advanced settings to change two optional settings:

  • Data freshness (products): how often, in hours, tables like products are refreshed. Enter a value from 4 to 12.
  • Tables to collect: the tables you want to collect. All tables are selected by default; remove the ones you do not need. At least one table must stay selected.

Collect settings with the advanced settings open, showing Data freshness (products) and Tables to collect

Click Next.

Historical data and scheduling

Enter the number of days of history in the Historical Data field. You can fetch up to 365 days of historical data.

Data Collection Settings step with the Historical Data field filled in with 365 days

A data synchronization schedule will be created automatically. More information on this topic can be found here.

Click Create to complete the configuration.

Done! Your Allegro data will now be synchronized with BigQuery, providing you with detailed insights into the performance of your marketplace.

Data schema

Expand the tables below to view the full data schema collected from Allegro.

Data schema for allegro_billing_entries
Field NameModeType
idNULLABLESTRING
occurredAtNULLABLETIMESTAMP
typeNULLABLERECORD
โ”œโ”€ type.idNULLABLESTRING
โ”œโ”€ type.nameNULLABLESTRING
valueNULLABLERECORD
โ”œโ”€ value.amountNULLABLEFLOAT
โ”œโ”€ value.currencyNULLABLESTRING
taxNULLABLERECORD
โ”œโ”€ tax.percentageNULLABLEFLOAT
balanceNULLABLERECORD
โ”œโ”€ balance.amountNULLABLEFLOAT
โ”œโ”€ balance.currencyNULLABLESTRING
offerNULLABLERECORD
โ”œโ”€ offer.idNULLABLESTRING
โ”œโ”€ offer.nameNULLABLESTRING
orderNULLABLERECORD
โ”œโ”€ order.idNULLABLESTRING
Data schema for allegro_categories
Field NameModeType
idNULLABLESTRING
leafNULLABLEBOOLEAN
nameNULLABLESTRING
optionsNULLABLERECORD
โ”œโ”€ options.advertisementNULLABLEBOOLEAN
โ”œโ”€ options.advertisementPriceOptionalNULLABLEBOOLEAN
โ”œโ”€ options.variantsByColorPatternAllowedNULLABLEBOOLEAN
โ”œโ”€ options.offersWithProductPublicationEnabledNULLABLEBOOLEAN
โ”œโ”€ options.productCreationEnabledNULLABLEBOOLEAN
โ”œโ”€ options.customParametersEnabledNULLABLEBOOLEAN
โ”œโ”€ options.sellerCanRequirePurchaseCommentsNULLABLEBOOLEAN
parentNULLABLERECORD
โ”œโ”€ parent.idNULLABLESTRING
Data schema for allegro_orders
Field NameModeType
idNULLABLESTRING
messageToSellerNULLABLESTRING
buyerNULLABLERECORD
โ”œโ”€ buyer.idNULLABLESTRING
โ”œโ”€ buyer.emailNULLABLESTRING
โ”œโ”€ buyer.loginNULLABLESTRING
โ”œโ”€ buyer.firstNameNULLABLESTRING
โ”œโ”€ buyer.lastNameNULLABLESTRING
โ”œโ”€ buyer.companyNameNULLABLESTRING
โ”œโ”€ buyer.guestNULLABLEBOOLEAN
โ”œโ”€ buyer.personalIdentityNULLABLESTRING
โ”œโ”€ buyer.phoneNumberNULLABLESTRING
โ”œโ”€ buyer.preferencesNULLABLERECORD
โ”‚ โ”œโ”€ buyer.preferences.languageNULLABLESTRING
โ”œโ”€ buyer.addressNULLABLERECORD
โ”‚ โ”œโ”€ buyer.address.streetNULLABLESTRING
โ”‚ โ”œโ”€ buyer.address.cityNULLABLESTRING
โ”‚ โ”œโ”€ buyer.address.postCodeNULLABLESTRING
โ”‚ โ”œโ”€ buyer.address.countryCodeNULLABLESTRING
paymentNULLABLERECORD
โ”œโ”€ payment.idNULLABLESTRING
โ”œโ”€ payment.typeNULLABLESTRING
โ”œโ”€ payment.providerNULLABLESTRING
โ”œโ”€ payment.finishedAtNULLABLETIMESTAMP
โ”œโ”€ payment.paidAmountNULLABLERECORD
โ”‚ โ”œโ”€ payment.paidAmount.amountNULLABLEFLOAT
โ”‚ โ”œโ”€ payment.paidAmount.currencyNULLABLESTRING
โ”œโ”€ payment.reconciliationNULLABLERECORD
โ”‚ โ”œโ”€ payment.reconciliation.amountNULLABLEFLOAT
โ”‚ โ”œโ”€ payment.reconciliation.currencyNULLABLESTRING
โ”œโ”€ payment.featuresREPEATEDSTRING
statusNULLABLESTRING
fulfillmentNULLABLERECORD
โ”œโ”€ fulfillment.statusNULLABLESTRING
โ”œโ”€ fulfillment.shipmentSummaryNULLABLERECORD
โ”‚ โ”œโ”€ fulfillment.shipmentSummary.lineItemsSentNULLABLESTRING
deliveryNULLABLERECORD
โ”œโ”€ delivery.addressNULLABLERECORD
โ”‚ โ”œโ”€ delivery.address.firstNameNULLABLESTRING
โ”‚ โ”œโ”€ delivery.address.lastNameNULLABLESTRING
โ”‚ โ”œโ”€ delivery.address.streetNULLABLESTRING
โ”‚ โ”œโ”€ delivery.address.cityNULLABLESTRING
โ”‚ โ”œโ”€ delivery.address.zipCodeNULLABLESTRING
โ”‚ โ”œโ”€ delivery.address.countryCodeNULLABLESTRING
โ”‚ โ”œโ”€ delivery.address.companyNameNULLABLESTRING
โ”‚ โ”œโ”€ delivery.address.phoneNumberNULLABLESTRING
โ”‚ โ”œโ”€ delivery.address.modifiedAtNULLABLETIMESTAMP
โ”œโ”€ delivery.methodNULLABLERECORD
โ”‚ โ”œโ”€ delivery.method.idNULLABLESTRING
โ”‚ โ”œโ”€ delivery.method.nameNULLABLESTRING
โ”œโ”€ delivery.pickupPointNULLABLERECORD
โ”‚ โ”œโ”€ delivery.pickupPoint.idNULLABLESTRING
โ”‚ โ”œโ”€ delivery.pickupPoint.nameNULLABLESTRING
โ”‚ โ”œโ”€ delivery.pickupPoint.descriptionNULLABLESTRING
โ”‚ โ”œโ”€ delivery.pickupPoint.addressNULLABLERECORD
โ”‚ โ”‚ โ”œโ”€ delivery.pickupPoint.address.streetNULLABLESTRING
โ”‚ โ”‚ โ”œโ”€ delivery.pickupPoint.address.zipCodeNULLABLESTRING
โ”‚ โ”‚ โ”œโ”€ delivery.pickupPoint.address.cityNULLABLESTRING
โ”‚ โ”‚ โ”œโ”€ delivery.pickupPoint.address.countryCodeNULLABLESTRING
โ”œโ”€ delivery.costNULLABLERECORD
โ”‚ โ”œโ”€ delivery.cost.amountNULLABLEFLOAT
โ”‚ โ”œโ”€ delivery.cost.currencyNULLABLESTRING
โ”œโ”€ delivery.timeNULLABLERECORD
โ”‚ โ”œโ”€ delivery.time.fromNULLABLETIMESTAMP
โ”‚ โ”œโ”€ delivery.time.toNULLABLETIMESTAMP
โ”‚ โ”œโ”€ delivery.time.guaranteedNULLABLERECORD
โ”‚ โ”‚ โ”œโ”€ delivery.time.guaranteed.fromNULLABLETIMESTAMP
โ”‚ โ”‚ โ”œโ”€ delivery.time.guaranteed.toNULLABLETIMESTAMP
โ”‚ โ”œโ”€ delivery.time.dispatchNULLABLERECORD
โ”‚ โ”‚ โ”œโ”€ delivery.time.dispatch.fromNULLABLETIMESTAMP
โ”‚ โ”‚ โ”œโ”€ delivery.time.dispatch.toNULLABLETIMESTAMP
โ”œโ”€ delivery.smartNULLABLEBOOLEAN
โ”œโ”€ delivery.calculatedNumberOfPackagesNULLABLEINTEGER
invoiceNULLABLERECORD
โ”œโ”€ invoice.requiredNULLABLEBOOLEAN
โ”œโ”€ invoice.addressNULLABLERECORD
โ”‚ โ”œโ”€ invoice.address.streetNULLABLESTRING
โ”‚ โ”œโ”€ invoice.address.cityNULLABLESTRING
โ”‚ โ”œโ”€ invoice.address.zipCodeNULLABLESTRING
โ”‚ โ”œโ”€ invoice.address.countryCodeNULLABLESTRING
โ”‚ โ”œโ”€ invoice.address.companyNULLABLERECORD
โ”‚ โ”‚ โ”œโ”€ invoice.address.company.nameNULLABLESTRING
โ”‚ โ”‚ โ”œโ”€ invoice.address.company.idsREPEATEDRECORD
โ”‚ โ”‚ โ”‚ โ”œโ”€ invoice.address.company.ids.typeNULLABLESTRING
โ”‚ โ”‚ โ”‚ โ”œโ”€ invoice.address.company.ids.valueNULLABLESTRING
โ”‚ โ”‚ โ”œโ”€ invoice.address.company.vatPayerStatusNULLABLESTRING
โ”‚ โ”‚ โ”œโ”€ invoice.address.company.taxIdNULLABLESTRING
โ”‚ โ”œโ”€ invoice.address.naturalPersonNULLABLERECORD
โ”‚ โ”‚ โ”œโ”€ invoice.address.naturalPerson.firstNameNULLABLESTRING
โ”‚ โ”‚ โ”œโ”€ invoice.address.naturalPerson.lastNameNULLABLESTRING
โ”œโ”€ invoice.dueDateNULLABLEDATE
lineItemsREPEATEDRECORD
โ”œโ”€ lineItems.idNULLABLESTRING
โ”œโ”€ lineItems.offerNULLABLERECORD
โ”‚ โ”œโ”€ lineItems.offer.idNULLABLESTRING
โ”‚ โ”œโ”€ lineItems.offer.nameNULLABLESTRING
โ”‚ โ”œโ”€ lineItems.offer.externalNULLABLERECORD
โ”‚ โ”‚ โ”œโ”€ lineItems.offer.external.idNULLABLESTRING
โ”‚ โ”œโ”€ lineItems.offer.productSetNULLABLERECORD
โ”‚ โ”‚ โ”œโ”€ lineItems.offer.productSet.productsREPEATEDRECORD
โ”‚ โ”‚ โ”‚ โ”œโ”€ lineItems.offer.productSet.products.idNULLABLESTRING
โ”‚ โ”‚ โ”‚ โ”œโ”€ lineItems.offer.productSet.products.quantityNULLABLEINTEGER
โ”œโ”€ lineItems.quantityNULLABLEINTEGER
โ”œโ”€ lineItems.originalPriceNULLABLERECORD
โ”‚ โ”œโ”€ lineItems.originalPrice.amountNULLABLEFLOAT
โ”‚ โ”œโ”€ lineItems.originalPrice.currencyNULLABLESTRING
โ”œโ”€ lineItems.priceNULLABLERECORD
โ”‚ โ”œโ”€ lineItems.price.amountNULLABLEFLOAT
โ”‚ โ”œโ”€ lineItems.price.currencyNULLABLESTRING
โ”œโ”€ lineItems.reconciliationNULLABLERECORD
โ”‚ โ”œโ”€ lineItems.reconciliation.valueNULLABLERECORD
โ”‚ โ”‚ โ”œโ”€ lineItems.reconciliation.value.amountNULLABLEFLOAT
โ”‚ โ”‚ โ”œโ”€ lineItems.reconciliation.value.currencyNULLABLESTRING
โ”‚ โ”œโ”€ lineItems.reconciliation.typeNULLABLESTRING
โ”‚ โ”œโ”€ lineItems.reconciliation.quantityNULLABLEINTEGER
โ”œโ”€ lineItems.selectedAdditionalServicesREPEATEDRECORD
โ”‚ โ”œโ”€ lineItems.selectedAdditionalServices.definitionIdNULLABLESTRING
โ”‚ โ”œโ”€ lineItems.selectedAdditionalServices.nameNULLABLESTRING
โ”‚ โ”œโ”€ lineItems.selectedAdditionalServices.priceNULLABLERECORD
โ”‚ โ”‚ โ”œโ”€ lineItems.selectedAdditionalServices.price.amountNULLABLEFLOAT
โ”‚ โ”‚ โ”œโ”€ lineItems.selectedAdditionalServices.price.currencyNULLABLESTRING
โ”‚ โ”œโ”€ lineItems.selectedAdditionalServices.quantityNULLABLEINTEGER
โ”œโ”€ lineItems.vouchersREPEATEDRECORD
โ”‚ โ”œโ”€ lineItems.vouchers.codeNULLABLESTRING
โ”‚ โ”œโ”€ lineItems.vouchers.typeNULLABLESTRING
โ”‚ โ”œโ”€ lineItems.vouchers.statusNULLABLESTRING
โ”‚ โ”œโ”€ lineItems.vouchers.externalTransactionIdNULLABLESTRING
โ”‚ โ”œโ”€ lineItems.vouchers.valueNULLABLERECORD
โ”‚ โ”‚ โ”œโ”€ lineItems.vouchers.value.amountNULLABLEFLOAT
โ”‚ โ”‚ โ”œโ”€ lineItems.vouchers.value.currencyNULLABLESTRING
โ”œโ”€ lineItems.taxNULLABLERECORD
โ”‚ โ”œโ”€ lineItems.tax.rateNULLABLEFLOAT
โ”‚ โ”œโ”€ lineItems.tax.subjectNULLABLESTRING
โ”‚ โ”œโ”€ lineItems.tax.exemptionNULLABLESTRING
โ”œโ”€ lineItems.boughtAtNULLABLETIMESTAMP
surchargesREPEATEDRECORD
โ”œโ”€ surcharges.idNULLABLESTRING
โ”œโ”€ surcharges.typeNULLABLESTRING
โ”œโ”€ surcharges.providerNULLABLESTRING
โ”œโ”€ surcharges.finishedAtNULLABLETIMESTAMP
โ”œโ”€ surcharges.paidAmountNULLABLERECORD
โ”‚ โ”œโ”€ surcharges.paidAmount.amountNULLABLEFLOAT
โ”‚ โ”œโ”€ surcharges.paidAmount.currencyNULLABLESTRING
โ”œโ”€ surcharges.reconciliationNULLABLERECORD
โ”‚ โ”œโ”€ surcharges.reconciliation.amountNULLABLEFLOAT
โ”‚ โ”œโ”€ surcharges.reconciliation.currencyNULLABLESTRING
โ”œโ”€ surcharges.featuresREPEATEDSTRING
discountsREPEATEDRECORD
โ”œโ”€ discounts.typeNULLABLESTRING
noteNULLABLERECORD
โ”œโ”€ note.textNULLABLESTRING
marketplaceNULLABLERECORD
โ”œโ”€ marketplace.idNULLABLESTRING
summaryNULLABLERECORD
โ”œโ”€ summary.totalToPayNULLABLERECORD
โ”‚ โ”œโ”€ summary.totalToPay.amountNULLABLEFLOAT
โ”‚ โ”œโ”€ summary.totalToPay.currencyNULLABLESTRING
updatedAtNULLABLETIMESTAMP
revisionNULLABLESTRING
Data schema for allegro_products
Field NameModeType
idNULLABLESTRING
nameNULLABLESTRING
categoryNULLABLERECORD
โ”œโ”€ category.idNULLABLESTRING
primaryImageNULLABLERECORD
โ”œโ”€ primaryImage.urlNULLABLESTRING
sellingModeNULLABLERECORD
โ”œโ”€ sellingMode.formatNULLABLESTRING
โ”œโ”€ sellingMode.priceNULLABLERECORD
โ”‚ โ”œโ”€ sellingMode.price.amountNULLABLEFLOAT
โ”‚ โ”œโ”€ sellingMode.price.currencyNULLABLESTRING
โ”œโ”€ sellingMode.minimalPriceNULLABLERECORD
โ”‚ โ”œโ”€ sellingMode.minimalPrice.amountNULLABLEFLOAT
โ”‚ โ”œโ”€ sellingMode.minimalPrice.currencyNULLABLESTRING
โ”œโ”€ sellingMode.startingPriceNULLABLERECORD
โ”‚ โ”œโ”€ sellingMode.startingPrice.amountNULLABLEFLOAT
โ”‚ โ”œโ”€ sellingMode.startingPrice.currencyNULLABLESTRING
saleInfoNULLABLERECORD
โ”œโ”€ saleInfo.currentPriceNULLABLERECORD
โ”‚ โ”œโ”€ saleInfo.currentPrice.amountNULLABLEFLOAT
โ”‚ โ”œโ”€ saleInfo.currentPrice.currencyNULLABLESTRING
โ”œโ”€ saleInfo.biddersCountNULLABLEINTEGER
stockNULLABLERECORD
โ”œโ”€ stock.availableNULLABLEINTEGER
โ”œโ”€ stock.soldNULLABLEINTEGER
statsNULLABLERECORD
โ”œโ”€ stats.watchersCountNULLABLEINTEGER
โ”œโ”€ stats.visitsCountNULLABLEINTEGER
publicationNULLABLERECORD
โ”œโ”€ publication.statusNULLABLESTRING
โ”œโ”€ publication.startingAtNULLABLETIMESTAMP
โ”œโ”€ publication.startedAtNULLABLETIMESTAMP
โ”œโ”€ publication.endingAtNULLABLETIMESTAMP
โ”œโ”€ publication.endedAtNULLABLETIMESTAMP
โ”œโ”€ publication.marketplacesNULLABLERECORD
โ”‚ โ”œโ”€ publication.marketplaces.baseNULLABLERECORD
โ”‚ โ”‚ โ”œโ”€ publication.marketplaces.base.idNULLABLESTRING
โ”‚ โ”œโ”€ publication.marketplaces.additionalREPEATEDRECORD
โ”‚ โ”‚ โ”œโ”€ publication.marketplaces.additional.idNULLABLESTRING
afterSalesServicesNULLABLERECORD
โ”œโ”€ afterSalesServices.impliedWarrantyNULLABLERECORD
โ”‚ โ”œโ”€ afterSalesServices.impliedWarranty.idNULLABLESTRING
โ”œโ”€ afterSalesServices.returnPolicyNULLABLERECORD
โ”‚ โ”œโ”€ afterSalesServices.returnPolicy.idNULLABLESTRING
โ”œโ”€ afterSalesServices.warrantyNULLABLERECORD
โ”‚ โ”œโ”€ afterSalesServices.warranty.idNULLABLESTRING
additionalServicesNULLABLERECORD
โ”œโ”€ additionalServices.idNULLABLESTRING
externalNULLABLERECORD
โ”œโ”€ external.idNULLABLESTRING
deliveryNULLABLERECORD
โ”œโ”€ delivery.shippingRatesNULLABLERECORD
โ”‚ โ”œโ”€ delivery.shippingRates.idNULLABLESTRING
b2bNULLABLERECORD
โ”œโ”€ b2b.buyableOnlyByBusinessNULLABLEBOOLEAN
fundraisingCampaignNULLABLERECORD
โ”œโ”€ fundraisingCampaign.idNULLABLESTRING
additionalMarketplacesNULLABLERECORD
โ”œโ”€ additionalMarketplaces.allegro-czNULLABLERECORD
โ”‚ โ”œโ”€ additionalMarketplaces.allegro-cz.publicationNULLABLERECORD
โ”‚ โ”‚ โ”œโ”€ additionalMarketplaces.allegro-cz.publication.stateNULLABLESTRING
โ”‚ โ”œโ”€ additionalMarketplaces.allegro-cz.sellingModeNULLABLERECORD
โ”‚ โ”‚ โ”œโ”€ additionalMarketplaces.allegro-cz.sellingMode.priceNULLABLERECORD
โ”‚ โ”‚ โ”‚ โ”œโ”€ additionalMarketplaces.allegro-cz.sellingMode.price.amountNULLABLEFLOAT
โ”‚ โ”‚ โ”‚ โ”œโ”€ additionalMarketplaces.allegro-cz.sellingMode.price.currencyNULLABLESTRING
โ”‚ โ”œโ”€ additionalMarketplaces.allegro-cz.statsNULLABLERECORD
โ”‚ โ”‚ โ”œโ”€ additionalMarketplaces.allegro-cz.stats.watchersCountNULLABLEINTEGER
โ”‚ โ”‚ โ”œโ”€ additionalMarketplaces.allegro-cz.stats.visitsCountNULLABLEINTEGER
โ”‚ โ”œโ”€ additionalMarketplaces.allegro-cz.stockNULLABLERECORD
โ”‚ โ”‚ โ”œโ”€ additionalMarketplaces.allegro-cz.stock.soldNULLABLEINTEGER
Data schema for allegro_returns
Field NameModeType
idNULLABLESTRING
createdAtNULLABLETIMESTAMP
referenceNumberNULLABLESTRING
orderIdNULLABLESTRING
buyerNULLABLERECORD
โ”œโ”€ buyer.emailNULLABLESTRING
โ”œโ”€ buyer.loginNULLABLESTRING
itemsREPEATEDRECORD
โ”œโ”€ items.offerIdNULLABLESTRING
โ”œโ”€ items.quantityNULLABLEINTEGER
โ”œโ”€ items.nameNULLABLESTRING
โ”œโ”€ items.priceNULLABLERECORD
โ”‚ โ”œโ”€ items.price.amountNULLABLEFLOAT
โ”‚ โ”œโ”€ items.price.currencyNULLABLESTRING
โ”œโ”€ items.urlNULLABLESTRING
โ”œโ”€ items.reasonNULLABLERECORD
โ”‚ โ”œโ”€ items.reason.typeNULLABLESTRING
โ”‚ โ”œโ”€ items.reason.userCommentNULLABLESTRING
refundNULLABLERECORD
โ”œโ”€ refund.bankAccountNULLABLERECORD
โ”‚ โ”œโ”€ refund.bankAccount.ownerNULLABLESTRING
โ”‚ โ”œโ”€ refund.bankAccount.accountNumberNULLABLESTRING
โ”‚ โ”œโ”€ refund.bankAccount.swiftNULLABLESTRING
โ”‚ โ”œโ”€ refund.bankAccount.addressNULLABLERECORD
โ”‚ โ”‚ โ”œโ”€ refund.bankAccount.address.streetNULLABLESTRING
โ”‚ โ”‚ โ”œโ”€ refund.bankAccount.address.cityNULLABLESTRING
โ”‚ โ”‚ โ”œโ”€ refund.bankAccount.address.postCodeNULLABLESTRING
โ”‚ โ”‚ โ”œโ”€ refund.bankAccount.address.countryCodeNULLABLESTRING
โ”‚ โ”œโ”€ refund.bankAccount.ibanNULLABLESTRING
rejectionNULLABLERECORD
โ”œโ”€ rejection.reasonNULLABLESTRING
โ”œโ”€ rejection.codeNULLABLESTRING
โ”œโ”€ rejection.createdAtNULLABLETIMESTAMP
parcelsREPEATEDRECORD
โ”œโ”€ parcels.createdAtNULLABLETIMESTAMP
โ”œโ”€ parcels.waybillNULLABLESTRING
โ”œโ”€ parcels.transportingWaybillNULLABLESTRING
โ”œโ”€ parcels.carrierIdNULLABLESTRING
โ”œโ”€ parcels.transportingCarrierIdNULLABLESTRING
โ”œโ”€ parcels.senderNULLABLERECORD
โ”‚ โ”œโ”€ parcels.sender.phoneNumberNULLABLESTRING
marketplaceIdNULLABLESTRING
statusNULLABLESTRING