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:
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
Endpoint: Retrieve an account
Update Method: UPSERT
Table Name: [
impact_radius.accounts
]
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
]
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
]
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
]
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
]
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
]
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
]
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
]
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
]
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
]
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
]
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
]
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
]
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
]
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
]
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
]
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
]
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
]
Id
id
CreatedDate
created_date
MediaId
media_id
MediaName
media_name
Currency
currency
TotalAmount
total_amount
TotalVatAmount
total_vat_amount
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
]
Contacts.FirstName
first_name
Contacts.LastName
last_name
Contacts.Labels
labels
Contacts.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
]
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
]
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
]
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
]
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
]
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
]
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
]
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
]
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
]
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
Last updated