Integration Specifications

Integration Overview

Impact Radius is an affiliate marketing platform to help you promote your ecommerce business.

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 currently available for:

• Enterprise

API Endpoints

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

• Retrieve an account

• List all actions

• List all action inquiries

• List all action items

• List all action updates

• List all ads

• List all campaigns

• List all contacts

• List all deals

• List all exception lists

• List all exception list items

• List all invoices

• List all partners

• List all partner groups

• List all promo codes

• List all users

Impact Radius Schema

The Daasity Impact Radius 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.

• Accounts

• Account Inquiries

• Account Inquiry Comments

• Action Items

• Action Updates

• Actions

• Ads

• Campaign Company Contacts

• Campaigns

• Contact Accounts

• Contacts

• Contracts

• Deals

• Exception List Action Trackers

• Exception List Items

• Exception Lists

• Invoice Line Items

• Invoices

• Partner Contacts

• Partner Group Media Partners

• Partner Groups

• Partner Phones

• Partner Programs

• Partner Promotional Methods

• Partner Properties

• Partners

• Promo Codes

• Users

Accounts

• Endpoint: Retrieve an account

• Update Method: UPSERT

• Table Name: [impact_radius.accounts]

JSON Element	Database Column
CompanyName	company_name
Industry.IndustryId	industry_id
Industry.IndustryName	industry_name
Website	website
PrimaryPhoneNumber	primary_phone_number
PrimaryPhoneNumberCountry	primary_phone_number_country
SecondaryPhoneNumber	secondary_phone_number
SecondaryPhoneNumberCountry	secondary_phone_number_country
MinimumContactRating	minimum_contact_rating
Timezone	timezone
Currency	currency
RegisteredForIndirectTax	registered_for_indirect_tax
IndirectTaxNumber	indirect_tax_number
OrganizationType	organization_type
EinSsnForeignTaxId	ein_ssn_foreign_tax_id
CorporateAddress.AddressLine1	corporate_address_line1
CorporateAddress.AddressLine2	corporate_address_line2
CorporateAddress.City	corporate_address_city
CorporateAddress.State	corporate_address_state
CorporateAddress.PostalCode	corporate_address_postal_code
CorporateAddress.Country	corporate_address_country
BillingAddress.AddressLine1	billing_address_line1
BillingAddress.AddressLine2	billing_address_line2
BillingAddress.City	billing_address_city
BillingAddress.State	billing_address_state
BillingAddress.PostalCode	billing_address_postal_code
BillingAddress.Country	billing_address_country
FinancialContact.UserId	financial_contact_user_id
FinancialContact.Name	financial_contact_name
FinancialContact.Email	financial_contact_email
FinancialContact.WorkPhoneNumber	financial_contact_work_phone_number
FinancialContact.WorkPhoneNumberCountry	financial_contact_work_phone_number_country
FinancialContact.CellPhoneNumber	financial_contact_cell_phone_number
FinancialContact.CellPhoneNumberCountry	financial_contact_cell_phone_number_country
TechnicalContact.UserId	technical_contact_user_id
TechnicalContact.Name	technical_contact_name
TechnicalContact.Email	technical_contact_email
TechnicalContact.WorkPhoneNumber	technical_contact_work_phone_number
TechnicalContact.WorkPhoneNumberCountry	technical_contact_work_phone_number_country
TechnicalContact.CellPhoneNumber	technical_contact_cell_phone_number
TechnicalContact.CellPhoneNumberCountry	technical_contact_cell_phone_number_country
SecurityContact.UserId	security_contact_user_id
SecurityContact.Name	security_contact_name
SecurityContact.Email	security_contact_email
SecurityContact.WorkPhoneNumber	security_contact_work_phone_number
SecurityContact.WorkPhoneNumberCountry	security_contact_work_phone_number_country
SecurityContact.CellPhoneNumber	security_contact_cell_phone_number
SecurityContact.CellPhoneNumberCountry	security_contact_cell_phone_number_country
CommercialContact.UserId	commercial_contact_user_id
CommercialContact.Name	commercial_contact_name
CommercialContact.Email	commercial_contact_email
CommercialContact.WorkPhoneNumber	commercial_contact_work_phone_number
CommercialContact.WorkPhoneNumberCountry	commercial_contact_work_phone_number_country
CommercialContact.CellPhoneNumber	commercial_contact_cell_phone_number
CommercialContact.CellPhoneNumberCountry	commercial_contact_cell_phone_number_country
Uri	uri
Daasity-generated	_account_id
Daasity-generated	__integration_id
Daasity-generated	__synced_at
Daasity-generated	__shop_id
	__sync_key

Action Inquiries

• Endpoint: List all action inquiries

• Update Method: UPSERT

• Table Name: [impact_radius.action_inquiries]

JSON Element	Database Column
Id	id
CampaignId	campaign_id
CampaignName	campaign_name
MediaPartnerId	media_partner_id
MediaPartnerName	media_partner_name
OrderId	order_id
TransactionDate	transaction_date
TransactionAmount	transaction_amount
InquiryType	inquiry_type
ExpectedPayout	expected_payout
ResolutionDeadlineDate	resolution_deadline_date
TrackingLink	tracking_link
ActionId	action_id
ActionUri	action_uri
AutoApprovalDate	auto_approval_date
ResolutionStatus	resolution_status
RejectReason	reject_reason
FinalPayout	final_payout
ResolutionDate	resolution_date
CreationDate	creation_date
Uri	uri
Daasity-generated	_account_id
Daasity-generated	__integration_id
Daasity-generated	__synced_at
Daasity-generated	__shop_id
	__sync_key

Action Inquiry Comments

• Endpoint: List all action inquiries

• Update Method: UPSERT

• Table Name: [impact_radius.action_inquiry_comments]

JSON Element	Database Column
Comments.User	user
Comments.Comment	comment
Comments.Date	date
Daasity-generated	_account_id
Daasity-generated	__integration_id
Daasity-generated	__synced_at
Daasity-generated	__shop_id
	__sync_key

Action Items

• Endpoint: List all action items

• Update Method: UPSERT

• Table Name: [impact_radius.action_items]

JSON Element	Database Column
Sku	sku
ItemName	item_name
Category	category
Quantity	quantity
SaleAmount	sale_amount
SaleAmountCurrency	sale_amount_currency
Payout	payout
PayoutCurrency	payout_currency
Rebate	rebate
RebateCurrency	rebate_currency
AdjustmentDate	adjustment_date
AdjustmentReason	adjustment_reason
Uri	uri
Daasity-generated	_account_id
Daasity-generated	__integration_id
Daasity-generated	__synced_at
Daasity-generated	__shop_id
	__sync_key

Action Updates

• Endpoint: List all action updates

• Update Method: UPSERT

• Table Name: [impact_radius.action_updates]

JSON Element	Database Column
Id	id
ActionId	action_id
CampaignId	campaign_id
ActionTrackerId	action_tracker_id
EventCode	event_code
MediaPartnerId	media_partner_id
State	state
StateDetail	state_detail
StateDetailDescription	state_detail_description
AdId	ad_id
Disposition	disposition
DeltaPayout	delta_payout
DeltaAmount	delta_amount
Currency	currency
Category	category
SubCategory	sub_category
Sku	sku
Quantity	quantity
CatalogName	catalog_name
CatalogCategory	catalog_category
CatalogDescription	catalog_description
CatalogManufacturer	catalog_manufacturer
CatalogOriginalFormatCategory	catalog_original_format_category
CatalogSubCategory	catalog_sub_category
UpdateDate	update_date
LockingDate	locking_date
ClearingDate	clearing_date
ActionDate	action_date
Oid	oid
CustomerId	customer_id
CustomerStatus	customer_status
Text1	text1
Text2	text2
Text3	text3
CallerId	caller_id
ContractId	contract_id
EventTypeId	event_type_id
EventTypeName	event_type_name
PayoutLevel	payout_level
DefaultPayoutRate	default_payout_rate
PayoutGroup.Id	payout_group_id
PayoutGroup.Rank	payout_group_rank
PayoutGroup.PayoutRate	payout_group_payout_rate
PayoutGroup.Rules	payout_group_rules
SharedId	shared_id
ActionUri	action_uri
Uri	uri
Daasity-generated	_account_id
Daasity-generated	__integration_id
Daasity-generated	__synced_at
Daasity-generated	__shop_id
	__sync_key

Actions

• Endpoint: List all actions

• Update Method: UPSERT

• Table Name: [impact_radius.actions]

JSON Element	Database Column
Id	id
CampaignId	campaign_id
CampaignName	campaign_name
ActionTrackerName	action_tracker_name
ActionTrackerId	action_tracker_id
EventCode	event_code
MediaPartnerId	media_partner_id
MediaPartnerName	media_partner_name
State	state
AdId	ad_id
ClientCost	client_cost
Payout	payout
DeltaPayout	delta_payout
IntendedPayout	intended_payout
Amount	amount
DeltaAmount	delta_amount
IntendedAmount	intended_amount
Currency	currency
ReferringDate	referring_date
EventDate	event_date
CreationDate	creation_date
LockingDate	locking_date
ClearedDate	cleared_date
ReferringType	referring_type
ReferringDomain	referring_domain
IpAddress	ip_address
PromoCode	promo_code
Oid	oid
CustomerId	customer_id
CustomerPostCode	customer_post_code
CustomerStatus	customer_status
Note	note
CallerId	caller_id
CustomerArea	customer_area
CustomerCity	customer_city
CustomerRegion	customer_region
CustomerCountry	customer_country
SharedId	shared_id
Uri	uri
Daasity-generated	_account_id
Daasity-generated	__integration_id
Daasity-generated	__synced_at
Daasity-generated	__shop_id
	__sync_key

Ads

• Endpoint: List all ads

• Update Method: UPSERT

• Table Name: [impact_radius.ads]

JSON Element	Database Column
Id	id
Name	name
Description	description
CampaignId	campaign_id
CampaignName	campaign_name
AdType	ad_type
LandingPage	landing_page
MobileFallbacks	mobile_fallbacks
CustomAdServingUrl	custom_ad_serving_url
AdCodeTemplate	ad_code_template
IabAdUnit	iab_ad_unit
ThirdPartyServableAdCreativeHeight	third_party_servable_ad_creative_height
ThirdPartyServableAdCreativeWidth	third_party_servable_ad_creative_width
BannerAlternativeTag	banner_alternative_tag
LinkText	link_text
CouponLinkName	coupon_link_name
CouponAllowCustomPromoCode	coupon_allow_custom_promo_code
GetHtmlCodeType	get_html_code_type
CustomisationCharge	customisation_charge
Labels	labels
AllowDeepLinking	allow_deep_linking
MobileReady	mobile_ready
PhoneTracking	phone_tracking
PromoCodeTracking	promo_code_tracking
Language	language
LimitedTimeStartDate	limited_time_start_date
LimitedTimeEndDate	limited_time_end_date
RestrictedMediaPartners	restricted_media_partners
RestrictedMediaPartnerGroups	restricted_media_partner_groups
Season	season
TopSeller	top_seller
DealId	deal_id
DealName	deal_name
DealDescription	deal_description
DealState	deal_state
DealType	deal_type
DealScope	deal_scope
DealProducts	deal_products
DealCategories	deal_categories
DiscountType	discount_type
DiscountAmount	discount_amount
DiscountCurrency	discount_currency
DiscountPercent	discount_percent
DiscountMaximumPercent	discount_maximum_percent
DiscountPercentRangeStart	discount_percent_range_start
DiscountPercentRangeEnd	discount_percent_range_end
Gift	gift
RebateAmount	rebate_amount
RebateCurrency	rebate_currency
DealDefaultPromoCode	deal_default_promo_code
MinimumPurchaseAmount	minimum_purchase_amount
MinimumPurchaseAmountCurrency	minimum_purchase_amount_currency
MaximumSavingsAmount	maximum_savings_amount
MaximumSavingsCurrency	maximum_savings_currency
BogoBuyQuantity	bogo_buy_quantity
BogoBuyScope	bogo_buy_scope
BogoBuyName	bogo_buy_name
BogoBuyImageUrl	bogo_buy_image_url
BogoGetQuantity	bogo_get_quantity
BogoGetScope	bogo_get_scope
BogoGetDiscountType	bogo_get_discount_type
BogoGetName	bogo_get_name
BogoGetImageUrl	bogo_get_image_url
BogoGetDiscountAmount	bogo_get_discount_amount
BogoGetDiscountCurrency	bogo_get_discount_currency
BogoGetDiscountPercent	bogo_get_discount_percent
PurchaseLimitQuantity	purchase_limit_quantity
DealStartDate	deal_start_date
DealEndDate	deal_end_date
SynchAdsPromoCodes	synch_ads_promo_codes
DealRestrictedMediaPartners	deal_restricted_media_partners
DealRestrictedMediaPartnerGroups	deal_restricted_media_partner_groups
Uri	uri
Daasity-generated	_account_id
Daasity-generated	__integration_id
Daasity-generated	__synced_at
Daasity-generated	__shop_id
	__sync_key

Campaign Company Contacts

• Endpoint: List all campaigns

• Update Method: UPSERT

• Table Name: [impact_radius.campaign_company_contacts]

JSON Element	Database Column
CompanyContacts.FirstName	first_name
CompanyContacts.LastName	last_name
CompanyContacts.EmailAddress	email_address
CompanyContacts.PhoneNumber	phone_number
Id	campaign_id
Daasity-generated	_account_id
Daasity-generated	__integration_id
Daasity-generated	__synced_at
Daasity-generated	__shop_id
	__sync_key

Campaigns

• Endpoint: List all campaigns

• Update Method: UPSERT

• Table Name: [impact_radius.campaigns]

JSON Element	Database Column
Id	id
Name	name
State	state
Categories.PrimaryCategory	categories_primary_category
Categories.PrimarySubCategories	categories_primary_sub
Categories.AdditionalCategory	categories_additional_category
Categories.AdditionalSubCategories	categories_additional_sub
ShortDescription	short_description
LongDescription	long_description
ListInMarketplace	list_in_marketplace
DisplayServicingAgency	display_servicing_agency
Rating	rating
SearchKeywords	search_keywords
ShippingRegions	shipping_regions
Resources.CompanyHomepage	resources_company_homepage
Resources.ExampleLandingPage	resources_example_landing_page
Resources.InformationPage	resources_information_page
Resources.AdditionalRelatedLinks	resources_additional_related_links
GiftCardPayouts	gift_card_payouts
TrademarkBidding	trademark_bidding
ThirdPartyImpressionPixel	third_party_impression_pixel
MobileReadyAds	mobile_ready_ads
DisplayFutureAds	display_future_ads
PromoCodeTracking	promo_code_tracking
TrackingDomain	tracking_domain
SiteDefinition	site_definition
ImpressionTracking	impression_tracking
ViewThroughCrediting	view_through_crediting
IdentityMatching	identity_matching
GatewayTrackingSettings.DefaultLandingPage	gateway_tracking_settings_default_landing_page
GatewayTrackingSettings.MediaPartnerTrackingTemplate	gateway_tracking_settings_media_partner_template
GatewayTrackingSettings.CampaignTrackingTemplate	gateway_tracking_settings_campaign_template
GatewayTrackingSettings.SSLSupport	gateway_tracking_settings_ssl_support
GatewayTrackingSettings.DeepLinking	gateway_tracking_settings_deep_linking
GatewayTrackingSettings.DeepLinkDomains	gateway_tracking_settings_deep_link_domains
GatewayTrackingSettings.ThirdPartyGatewayUrl	gateway_tracking_settings_third_party_url
GatewayTrackingSettings.ThirdPartyGatewayQueryStringParameters	gateway_tracking_settings_third_party_query_string_parameters
GatewayTrackingSettings.UniqueClickWindowLength	gateway_tracking_settings_unique_click_window_length
GatewayTrackingSettings.UniqueClickWindowType	gateway_tracking_settings_unique_click_window_type
DirectTrackingSettings.UnidentifiedName	direct_tracking_settings_unidentified_name
DirectTrackingSettings.SessionWindowLength	direct_tracking_settings_session_window_length
Uri	uri
Daasity-generated	_account_id
Daasity-generated	__integration_id
Daasity-generated	__synced_at
Daasity-generated	__shop_id
	__sync_key

Contact Accounts

• Endpoint: List all contacts

• Update Method: UPSERT

• Table Name: [impact_radius.contact_accounts]

JSON Element	Database Column
Accounts.Id	id
Accounts.Name	name
Id	contact_id
Daasity-generated	_account_id
Daasity-generated	__integration_id
Daasity-generated	__synced_at
Daasity-generated	__shop_id
	__sync_key

Contacts

• Endpoint: List all contacts

• Update Method: UPSERT

• Table Name: [impact_radius.contacts]

JSON Element	Database Column
Id	id
FirstName	first_name
LastName	last_name
EmailAddress	email_address
Title	title
ProfileImage	profile_image
WorkPhoneNumberCountry	work_phone_number_country
WorkPhoneNumber	work_phone_number
CellphoneNumberCountry	cellphone_number_country
CellphoneNumber	cellphone_number
Editable	editable
Labels	labels
Uri	uri
Daasity-generated	_account_id
Daasity-generated	__integration_id
Daasity-generated	__synced_at
Daasity-generated	__shop_id
	__sync_key

Contracts

• Endpoint: List all contracts

• Update Method: UPSERT

• Table Name: [impact_radius.contracts]

JSON Element	Database Column
Id	id
PartnerId	partner_id
PartnerValue1	partner_value1
Status	status
StartDate	start_date
EndDate	end_date
BrandSignatory	brand_signatory
BrandSignatoryDate	brand_signatory_date
PartnerSignatory	partner_signatory
PartnerSignatoryDate	partner_signatory_date
DateCreated	date_created
DateLastUpdated	date_last_updated
TemplateTerms.TemplateId	template_terms_id
TemplateTerms.VersionId	template_terms_version_id
TemplateTerms.Name	template_terms_name
TemplateTerms.Labels	template_terms_labels
TemplateTerms.Currency	template_terms_currency
EventPayouts.EventPayouts	event_payouts
TemplateTerms.ChangeNotificationPeriod	template_terms_change_notification_period
TemplateTerms.ReturnPolicy	template_terms_return_policy
TemplateTerms.MaxReturnPercentage	template_terms_max_return_percentage
TemplateTerms.CustomCreativePayer	template_terms_custom_creative_payer
PdfUri	pdf_uri
Uri	uri
Daasity-generated	_account_id
Daasity-generated	__integration_id
Daasity-generated	__synced_at
Daasity-generated	__shop_id
	__sync_key

Deals

• Endpoint: List all deals

• Update Method: UPSERT

• Table Name: [impact_radius.deals]

JSON Element	Database Column
Id	id
Name	name
Description	description
CampaignId	campaign_id
State	state
Type	type
Scope	scope
Products.ProductName	product_name
Products.ProductImageUrl	product_image_url
Products.ProductBeforePriceAmount	product_before_price_amount
Products.ProductBeforePriceCurrency	product_before_price_currency
Products.ProductAfterPriceAmount	product_after_price_amount
Products.ProductAfterPriceCurrency	product_after_price_currency
Categories	categories
DiscountType	discount_type
DiscountAmount	discount_amount
DiscountCurrency	discount_currency
DiscountPercent	discount_percent
DiscountMaximumPercent	discount_maximum_percent
DiscountPercentRangeStart	discount_percent_range_start
DiscountPercentRangeEnd	discount_percent_range_end
Gift	gift
RebateAmount	rebate_amount
RebateCurrency	rebate_currency
DefaultPromoCode	default_promo_code
MinimumPurchaseAmount	minimum_purchase_amount
MinimumPurchaseAmountCurrency	minimum_purchase_amount_currency
MaximumSavingsAmount	maximum_savings_amount
MaximumSavingsCurrency	maximum_savings_currency
BogoBuyQuantity	bogo_buy_quantity
BogoBuyScope	bogo_buy_scope
BogoBuyName	bogo_buy_name
BogoBuyImageUrl	bogo_buy_image_url
BogoGetQuantity	bogo_get_quantity
BogoGetScope	bogo_get_scope
BogoGetDiscountType	bogo_get_discount_type
BogoGetName	bogo_get_name
BogoGetImageUrl	bogo_get_image_url
BogoGetDiscountAmount	bogo_get_discount_amount
BogoGetDiscountCurrency	bogo_get_discount_currency
BogoGetDiscountPercent	bogo_get_discount_percent
PurchaseLimitQuantity	purchase_limit_quantity
StartDate	start_date
EndDate	end_date
SynchAdsPromoCodes	synch_ads_promo_codes
RestrictedMediaPartners	restricted_media_partners
RestrictedMediaPartnerGroups	restricted_media_partner_groups
Uri	uri
Daasity-generated	_account_id
Daasity-generated	__integration_id
Daasity-generated	__synced_at
Daasity-generated	__shop_id
	__sync_key

Exception List Action Trackers

• Endpoint: List all exception lists

• Update Method: UPSERT

• Table Name: [impact_radius.exception_list_action_trackers]

JSON Element	Database Column
ActionTrackers.Id	action_trackers_id
ActionTrackers.Name	action_trackers_name
Id	exception_list_id
Daasity-generated	_account_id
Daasity-generated	__integration_id
Daasity-generated	__synced_at
Daasity-generated	__shop_id
	__sync_key

Exception List Items

• Endpoint: List all exception list items

• Update Method: UPSERT

• Table Name: [impact_radius.exception_list_items]

JSON Element	Database Column
Id	id
Value	value
Name	name
MatchMode	match_mode
ListId	list_id
CreatedDate	created_date
Uri	uri
Daasity-generated	_account_id
Daasity-generated	__integration_id
Daasity-generated	__synced_at
Daasity-generated	__shop_id
	__sync_key

Exception Lists

• Endpoint: List all exception lists

• Update Method: UPSERT

• Table Name: [impact_radius.exception_lists]

JSON Element	Database Column
Id	id
Name	name
State	state
CampaignId	campaign_id
Type	type
CreatedDate	created_date
DeactivationDate	deactivation_date
NumberOfItems	number_of_items
ItemsUri	items_uri
Uri	uri
Daasity-generated	_account_id
Daasity-generated	__integration_id
Daasity-generated	__synced_at
Daasity-generated	__shop_id
	__sync_key

Invoice Line Items

• Endpoint: List all invoices

• Update Method: UPSERT

• Table Name: [impact_radius.invoice_line_items]

JSON Element	Database Column
LineItems.CampaignId	campaign_id
LineItems.CampaignName	campaign_name
LineItems.Description	description
LineItems.EventMonthYear	event_month_year
LineItems.Actions	actions
LineItems.NetItemAmount	net_item_amount
LineItems.VatItemAmount	vat_item_amount
LineItems.TotalItemAmount	total_item_amount
LineItems.Status	status
LineItems.DueDate	due_date
LineItems.PaidDate	paid_date
Id	invoice_id
Daasity-generated	_account_id
Daasity-generated	__integration_id
Daasity-generated	__synced_at
Daasity-generated	__shop_id
	__sync_key

Invoices

• Endpoint: List all invoices

• Update Method: UPSERT

• Table Name: [impact_radius.invoices]

JSON Element	Database Column
Id	id
CreatedDate	created_date
MediaId	media_id
MediaName	media_name
Currency	currency
TotalAmount	total_amount
TotalVatAmount	total_vat_amount
PDF	pdf
Uri	uri
Daasity-generated	_account_id
Daasity-generated	__integration_id
Daasity-generated	__synced_at
Daasity-generated	__shop_id
	__sync_key

Partner Contacts

• Endpoint: List all partners

• Update Method: UPSERT

• Table Name: [impact_radius.partner_contacts]

JSON Element	Database Column
Contacts.FirstName	first_name
Contacts.LastName	last_name
Contacts.Labels	labels
Contacts.Email	email
Contacts.IsPrimary	is_primary
Id	partner_id
Daasity-generated	_account_id
Daasity-generated	__integration_id
Daasity-generated	__synced_at
Daasity-generated	__shop_id
	__sync_key

Partner Group Media Partners

• Endpoint: List all partner groups

• Update Method: UPSERT

• Table Name: [impact_radius.partner_group_media_partners]

JSON Element	Database Column
MediaPartners.PartnerId	partner_id
MediaPartners.PartnerName	partner_name
MediaPartners.PartnerUri	partner_uri
GroupId	partner_group_id
Daasity-generated	_account_id
Daasity-generated	__integration_id
Daasity-generated	__synced_at
Daasity-generated	__shop_id
	__sync_key

Partner Groups

• Endpoint: List all partner groups

• Update Method: UPSERT

• Table Name: [impact_radius.partner_groups]

JSON Element	Database Column
Groups.GroupId	group_id
Groups.GroupName	group_name
Id	partner_id
Daasity-generated	_account_id
Daasity-generated	__integration_id
Daasity-generated	__synced_at
Daasity-generated	__shop_id
	__sync_key

Partner Phones

• Endpoint: List all partners

• Update Method: UPSERT

• Table Name: [impact_radius.partner_phones]

JSON Element	Database Column
Phones.Type	type
Phones.Country	country
Phones.Number	number
Id	partner_id
Daasity-generated	_account_id
Daasity-generated	__integration_id
Daasity-generated	__synced_at
Daasity-generated	__shop_id
	__sync_key

Partner Programs

• Endpoint: List all partners

• Update Method: UPSERT

• Table Name: [impact_radius.partner_programs]

JSON Element	Database Column
Programs.Id	id
Programs.Name	name
Programs.ContractId	contract_id
Programs.ContractName	contract_name
Programs.JoinDate	join_date
Programs.ExpirationDate	expiration_date
Id	parnter_id
Daasity-generated	_account_id
Daasity-generated	__integration_id
Daasity-generated	__synced_at
Daasity-generated	__shop_id
	__sync_key

Partner Promotional Methods

• Endpoint: List all partners

• Update Method: UPSERT

• Table Name: [impact_radius.partner_promotional_methods]

JSON Element	Database Column
PromotionalMethods.Type	type
PromotionalMethods.IsPrimary	is_primary
Id	partner_id
Daasity-generated	_account_id
Daasity-generated	__integration_id
Daasity-generated	__synced_at
Daasity-generated	__shop_id
	__sync_key

Partner Properties

• Endpoint: List all partners

• Update Method: UPSERT

• Table Name: [impact_radius.partner_properties]

JSON Element	Database Column
Properties.Id	id
Properties.Name	name
Properties.Type	type
Properties.Platform	platform
Properties.Url	url
Properties.Doe	doe
Properties.Dlu	dlu
Id	partner_id
Daasity-generated	_account_id
Daasity-generated	__integration_id
Daasity-generated	__synced_at
Daasity-generated	__shop_id
	__sync_key

Partners

• Endpoint: List all partners

• Update Method: UPSERT

• Table Name: [impact_radius.partners]

JSON Element	Database Column
Id	id
Name	name
Description	description
Website	website
State	state
Address.Country	address_country
Address.Address1	address_address1
Address.Address2	address_address2
Address.City	address_city
Address.State	address_state
Address.PostalCode	address_postal_code
Phone.Country	phone_country
Phone.Number	phone_number
Currency	currency
Timezone	timezone
IndirectTax.Country	indirect_tax_country
IndirectTax.Number	indirect_tax_number
PartnerType	partner_type
PromotionalCountries	promotional_countries
PromotionalCategories	promotional_categories
LinkedAccounts	linked_accounts
PartnerValues.Value1	partner_values_value1
PartnerValues.Value2	partner_values_value2
PartnerValues.Value3	partner_values_value3
AccountManager	account_manager
DateCreated	date_created
DateLastUpdated	date_last_updated
CreatedBy	created_by
LastUpdatedBy	last_updated_by
Uri	uri
Daasity-generated	_account_id
Daasity-generated	__integration_id
Daasity-generated	__synced_at
Daasity-generated	__shop_id
	__sync_key

Promo Codes

• Endpoint: List all promo codes

• Update Method: UPSERT

• Table Name: [impact_radius.promo_codes]

JSON Element	Database Column
Id	id
Code	code
Type	type
CreditPolicy	credit_policy
CampaignId	campaign_id
CampaignName	campaign_name
AssignedPartnerId	assigned_partner_id
AssignedPartnerName	assigned_partner_name
CreatedDate	created_date
StartDate	start_date
EndDate	end_date
State	state
DealId	deal_id
DealName	deal_name
DealDescription	deal_description
DealState	deal_state
DealType	deal_type
DealScope	deal_scope
DealProducts	deal_products
DealCategories	deal_categories
DiscountType	discount_type
DiscountAmount	discount_amount
DiscountCurrency	discount_currency
DiscountPercent	discount_percent
DiscountMaximumPercent	discount_maximum_percent
DiscountPercentRangeStart	discount_percent_range_start
DiscountPercentRangeEnd	discount_percent_range_end
Gift	gift
RebateAmount	rebate_amount
RebateCurrency	rebate_currency
DealDefaultPromoCode	deal_default_promo_code
MinimumPurchaseAmount	minimum_purchase_amount
MinimumPurchaseAmountCurrency	minimum_purchase_amount_currency
MaximumSavingsAmount	maximum_savings_amount
MaximumSavingsCurrency	maximum_savings_currency
BogoBuyQuantity	bogo_buy_quantity
BogoBuyScope	bogo_buy_scope
BogoBuyName	bogo_buy_name
BogoBuyImageUrl	bogo_buy_image_url
BogoGetQuantity	bogo_get_quantity
BogoGetScope	bogo_get_scope
BogoGetDiscountType	bogo_get_discount_type
BogoGetName	bogo_get_name
BogoGetImageUrl	bogo_get_image_url
BogoGetDiscountAmount	bogo_get_discount_amount
BogoGetDiscountCurrency	bogo_get_discount_currency
BogoGetDiscountPercent	bogo_get_discount_percent
PurchaseLimitQuantity	purchase_limit_quantity
DealStartDate	deal_start_date
DealEndDate	deal_end_date
SynchAdsPromoCodes	synch_ads_promo_codes
DealRestrictedMediaPartners	deal_restricted_media_partners
DealRestrictedMediaPartnerGroups	deal_restricted_media_partner_groups
Uri	uri
Daasity-generated	_account_id
Daasity-generated	__integration_id
Daasity-generated	__synced_at
Daasity-generated	__shop_id
	__sync_key

Users

• Endpoint: List all users

• Update Method: UPSERT

• Table Name: [impact_radius.users]

JSON Element	Database Column
Id	id
FirstName	first_name
LastName	last_name
Username	username
Type	type
State	state
Language	language
ProductRoles.Product	product
ProductRoles.AccessibleCampaigns	accessible_campaigns
ProductRoles.Role	role
JoinedDate	joined_date
DateLastUpdated	date_last_updated
LastUpdatedBy	last_updated_by
CreatedBy	created_by
Uri	uri
Daasity-generated	_account_id
Daasity-generated	__integration_id
Daasity-generated	__synced_at
Daasity-generated	__shop_id
	__sync_key