Integration Specifications

This article will help you learn about how Daasity replicates data from Narvar, limitations to the data we can extract and where the data is stored in the Narvar schema

Integration Overview

Narvar is an e-commerce package tracking platform that allows you to keep customers up-to-date with timely order status notifications. With Narvar, you can track shipments around the world and provide estimated delivery dates your customers can rely on.

This document provides context on what kind of data is being gathered through this extractor, which endpoints that data is coming from, and how the extracted tables relate to each other.

Integration Availability

This integration is available for:

• Enterprise

API Endpoints

The Daasity Narvar extractor is built based on this Narvar API documentation. The following endpoints are used by Daasity to replicate data from Narvar:

• Returns

Entity Relationship Diagram (ERD)

Click here to view the ERD for the Daasity Narvar integration illustrating the different tables and keys to join across tables.

Narvar Schema

The Daasity Narvar extractor creates these tables using the endpoints and replication methods listed. The data is mapped from source API endpoint to the table based on the mapping logic outlined in each table.

• Returns

• Items

• Exchange Options

• Transactions

• Fee Breakdown

Returns

• Endpoint: Returns

• Update Method: UPSERT

• Table Name: [narvar.returns]

JSON Element	Database Column
MD5(rma::rma_number)	__sync_key
rma::return_status	return_status
rma::rma_number	rma_number
rma::order_number	order_number
rma::return_creation_date	return_creation_date
rma::retailer_name	retailer_name
rma::return_method	return_method
rma::gift	gift
rma::email	email
rma::locale	locale
rma::origin_zip	origin_zip
rma::origin_country	origin_country
rma::estimated_refund	estimated_refund
rma::restocking_fee	restocking_fee
rma::refund_method	refund_method
rma::shopify_order_id	shopify_order_id
rma::original_shopify_order_id	original_shopify_order_id
rma::currency	currency
rma::shop_currency	shop_currency
rma::charge_payment_id	charge_payment_id
rma::transaction_id	transaction_id
rma::package::tracking_number	tracking_number
rma::package::carrier	package_carrier
rma::package::carrier_service_method	package_carrier_service_method
rma::package::destination_id	package_destination_id
rma::package::destination_zip	package_destination_zip
rma::package::destination_city	package_destination_city
rma::package::destination_country	package_destination_country
rma::package::estimated_actual_shipping_fee	package_estimated_actual_shipping_fee
rma::package::shipping_fee	package_shipping_fee
rma::policy::refund_at	policy_refund_at
rma::policy::refund_automation_until	policy_refund_automation_until
rma::policy::mark_as_paid_at	policy_mark_as_paid_at
rma::policy::restock_at	policy_restock_at
rma::policy::restock_automation_until	policy_restock_automation_until
rma::policy::reserve_inventory_at	policy_reserve_inventory_at
rma::policy::reserve_automation_id	policy_reserve_automation_until

Items

• Endpoint: Returns

• Update Method: UPSERT

• Table Name: [narvar.items]

JSON Element	Database Column
MD5(rma::rma_number + item::sku + item::item_id)	__sync_key
rma::rma_number	rma_number
item::sku	sku
item::item_id	item_id
item::reason	reason
item::reason_code	reason_code
item::comment	comment
item::unit_price	unit_price
item::total_item_price	total_item_price
item::transaction_type	transaction_type
item::keep_the_item	keep_the_item
item::child_reason	child_reason
item::child_reason_code	child_reason_code
item::unit_price_original_shop	unit_price_original_shop
item::unit_discount_shop	unit_discount_shop
item::unit_tax_shop	unit_tax_shop
item::unit_final_shop	unit_final_shop
item::unit_price_original_presentment	unit_price_original_presentment
item::unit_discount_presentment	unit_discount_presentment
item::unit_final_presentment	unit_final_presentment
item::current_processing_state::status	processing_state_status
item::current_processing_state::quantity	processing_state_quantity
item::current_processing_state::timestamp	processing_state_timestamp
item::exchange_item::variant_title	exchange_item_variant_title
item::exchange_item::variant_id	exchange_item_variant_id
item::exchange_item::variant_sku	exchange_item_variant_sku
item::exchange_item::product_id	exchange_item_product_id
item::exchange_item::exchange_quantity	exchange_item_exchange_quantity

Exchange Options

• Endpoint: Returns

• Update Method: UPSERT

• Table Name: [narvar.exchange_options]

JSON Element	Database Column
MD5(rma::rma_number + exchange_option::sku + exchange_option::item_id + exchange_option::variant_id + exchange_option::name + exchange_option::value)	__sync_key
rma::rma_number	rma_number
sku	sku
item_id	item_id
variant_id	variant_id
name	name
value	value

Transactions

• Endpoint: Returns

• Update Method: UPSERT

• Table Name: [narvar.transactions]

JSON Element	Database Column
MD5(rma::rma_number + transaction::id)	__sync_key
rma::rma_number	rma_number
transaction::id	id
transaction::timestamp	timestamp
transaction::source	source
transaction::amount	amount
transaction::currency	currency
transaction::refund_method	refund_method
transaction::giftcard_id	giftcard_id
transaction::authorization	auth
transaction::conversion_rate_to_shop	conversion_rate_to_shop

Fee Breakdown

• Endpoint: Returns

• Update Method: UPSERT

• Table Name: [narvar.fee_breakdown]

JSON Element	Database Column
MD5(rma_number + transaction::id + breakdown::description)	__sync_key
rma::rma_number	rma_number
transaction::id	transaction_id
breakdown::fee	fee
breakdown::currency	currency
breakdown::description	description
breakdown::tax_code	tax_code
breakdown::display_with_return_method	display_with_return_method
breakdown::formatted_fee	formatted_fee