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]
| 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 |
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 | |
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 |
Last updated