Daisycon API Reference
The public API procedures may call the internal procedures which should not be used directly as they can be changed without any explicit notification in the newer versions of the connector. Internal procedures can be recognized by the prefix internal_ in their names. Public API procedures do not have such prefix in their names.
Common_Countries
Get all countries
Parameter
<target_table> (optional): Table name to save the data to
<preview> (optional): Preview only, don't write into table
Attribute | Type |
|---|---|
id | bigdecimal |
code | string |
phone_prefix | string |
sepa_country | boolean |
iban_country | boolean |
european_country | boolean |
Common_Languages
Get all languages
Parameter
<target_table> (optional): Table name to save the data to
<preview> (optional): Preview only, don't write into table
Attribute | Type |
|---|---|
code | string |
Common_Productfeeds_Standard
Get all productfeed standards
Parameter
<category_id> (optional): Category ID
<target_table> (optional): Table name to save the data to
<preview> (optional): Preview only, don't write into table
Attribute | Type |
|---|---|
standard_field_id | bigdecimal |
id | string |
category_id | string |
name | string |
description | string |
example_value | string |
format | string |
format_properties | string |
metadata_name | string |
mandatory | boolean |
UID | boolean |
Publisher
Get all publishers
Parameter
<target_table> (optional): Table name to save the data to
<preview> (optional): Preview only, don't write into table
Attribute | Type |
|---|---|
id | bigdecimal |
name | string |
Publisher_Clearinghouse_SuppressionList
Get all suppression lists
Parameter
<publisher_id> (required): Publisher ID
<program_id> (optional): Program ID
<name> (optional): Name
<hash> (optional): MD5 hash of email
<target_table> (optional): Table name to save the data to
<preview> (optional): Preview only, don't write into table
Attribute | Type |
|---|---|
id | bigdecimal |
program_id | bigdecimal |
Publisher_Clicks
A set of clicks, limited to a single month
Parameter
<publisherId> (required): Publisher ID
<startDate> (required): Start date
<endDate> (optional): End date
<type> (optional): Click types ('cpc', 'click', 'clickout')
<media_id> (optional): Media IDs
<advertiser_id> (optional): Advertiser IDs
<program_id> (optional): Program IDs
<ad_id> (optional): Ad IDs
<subid> (optional): Sub ids
<subid_2> (optional): Subid_2
<subid_3> (optional): Subid_3
<target_table> (optional): Table name to save the data to
<preview> (optional): Preview only, don't write into table
Attribute | Type |
|---|---|
date | date |
hour | integer |
type | string |
program_id | integer |
ad_id | integer |
media_id | integer |
subid | string |
subid_2 | string |
subid_3 | string |
commission | bigdecimal |
raw | integer |
unique | integer |
Publisher_Material_Adgroup
Get all adgroups
Parameter
<publisher_id> (required): Publisher ID
<adgroup_id> (optional): Adgroup ID
<program_id> (optional): Program ID
<name> (optional): Name
<locale_id> (optional): Locale ID
<target_table> (optional): Table name to save the data to
<preview> (optional): Preview only, don't write into table
Attribute | Type |
|---|---|
id | bigdecimal |
name | string |
program_id | bigdecimal |
Publisher_Material_Ads
Get all ads
Parameter
<publisher_Id> (required): Publisher ID
<media_id> (required): Media ID
<subscribed_only> (optional): Only show subscribed, defaults to true - media id is required if set to true
<ad_id> (optional): Ad ID
<adgroup_id> (optional): Adgroup ID
<type> (optional): Mime type (image/jpeg, image/jpg, image/png, image/gif, text/html, text/plain)
<dimension> (optional): Ad dimensions format: WIDTHxHEIGHT eg 468x60
<date_modified_start> (optional): Last modification date
<date_modified_end> (optional): Last modification date end
<placeholder_media_id> (optional): replace url placeholder #MEDIA_ID# value
<placeholder_subid> (optional): replace url placeholder #SUBID# value
<placeholder_subid_2> (optional): replace url placeholder #SUBID2# value
<placeholder_subid_3> (optional): replace url placeholder #SUBID3# value
<target_table> (optional): Table name to save the data to
<preview> (optional): Preview only, don't write into table
Attribute | Type |
|---|---|
id | bigdecimal |
last_modified | timestamp |
type | string |
content | string |
click_url | string |
adgroup_id | string |
width | bigdecimal |
height | bigdecimal |
Publisher_Material_Deeplinks
Get all ads with a deeplink
Parameter
<publisher_Id> (required): Publisher ID
<media_id> (required): Media ID
<subscribed_only> (optional): Only show subscribed, defaults to true; media id is required if set to true
<ad_id> (optional): Ad ID
<program_id> (optional): Program ID
<placeholder_media_id> (optional): replace url placeholder #MEDIA_ID# value
<placeholder_subid> (optional): replace url placeholder #SUBID# value
<placeholder_subid_2> (optional): replace url placeholder #SUBID2# value
<placeholder_subid_3> (optional): replace url placeholder #SUBID3# value
<target_table> (optional): Table name to save the data to
<preview> (optional): Preview only, don't write into table
Attribute | Type |
|---|---|
id | bigdecimal |
program_id | bigdecimal |
program_name | string |
url | string |
domain | string |
Publisher_Material_PromotionCodes
Get all promotioncodes
Parameter
<publisher_id> (required): Publisher ID
<program_id> (optional): Program ID
<target_table> (optional): Table name to save the data to
<preview> (optional): Preview only, don't write into table
Attribute | Type |
|---|---|
id | bigdecimal |
program_id | bigdecimal |
promotioncode | string |
measure | string |
start_date | timestamp |
end_date | timestamp |
description | string |
name | string |
click_url | string |
amount | bigdecimal |
currency_code | string |
dedicated_media_id | string |
Publisher_Media
Get all media
Parameter
<publisher_id> (required): Publisher ID
<media_id> (optional): Media ID
<name> (optional): Name
<description> (optional): Description
<mobile> (optional): Mobile ready
<type> (optional): Type (app, blog, cashback, content_site, daily_offer, directory, free_content, coupon_site, reseller, comparison, keyword_marketing, auction, display_network, technology_partner, plugin, incentive, non_incentive, facebook, instagram, pinterest, twitter, youtube)
<cpc_status> (optional): CPC status (approved, disapproved)
<co_status> (optional): CO status (approved, disapproved)
<approval_status> (optional): Approval status (open, pending, approved)
<verification_status> (optional): Verification status (pending, verified)
<locale_id> (optional): Locale ID
<targetgroup_id> (optional): Target group ID
<category_id> (optional): Category ID
<status> (optional): Status (active, deleted, offline)
<target_table> (optional): Table name to save the data to
<preview> (optional): Preview only, don't write into table
Attribute | Type |
|---|---|
id | bigdecimal |
type | string |
name | string |
location | string |
description | string |
searchable | string |
mobile | string |
creation_date | date |
cpc_status | string |
co_status | string |
approval_date | timestamp |
approval_status | string |
verification_status | string |
verification_date | timestamp |
status | string |
country_code | string |
language_id | bigdecimal |
country_id | bigdecimal |
visitors_amount | bigdecimal |
mailinglist_size | bigdecimal |
registration_program_id | string |
locale_ids | bigdecimal |
targetgroup_ids | bigdecimal |
category_ids | bigdecimal |
Publisher_News_V2
Get all news items
Parameter
<publisher_id> (required): Publisher ID
<start> (optional): Start date
<end> (optional): End date
<source> (optional): Source (daisycon, campaign)
<program_id> (optional): Program ID
<locale_id> (optional): Locale ID
<type> (optional): Status (news, update, promotion, coupon)
<title> (optional): Title
<text> (optional): Text
<search> (optional): Search based on keyword
<order_by> (optional): Order by (date, program_name, title, source)
<order_direction> (optional): Order direction (asc, desc) default asc
<target_table> (optional): Table name to save the data to
<preview> (optional): Preview only, don't write into table
Attribute | Type |
|---|---|
id | bigdecimal |
source | string |
date | date |
type | string |
title | string |
text | string |
program_id | bigdecimal |
locale_ids | clob |
Publisher_ProductFeeds_v2_Standard
A set of standard product feeds or the specified one
Parameter
<publisherId> (required): Publisher ID
<standardId> (optional): Standard ID
<program_id> (optional): Program IDs
<media_id> (optional): Media IDs
<category_id> (optional): Category IDs
<currency_id> (optional): Currency IDs
<language_code> (optional): Language code
<name> (optional): Name (wildcards * allowed)
<placeholder_media_id> (optional): Replace url placeholder #MEDIA_ID# value
<placeholder_subid> (optional): Replace url placeholder #SUBID# value
<placeholder_subid_2> (optional): Replace url placeholder #SUBID2# value
<placeholder_subid_3> (optional): Replace url placeholder #SUBID3# value
<target_table> (optional): Table name to save the data to
<preview> (optional): Preview only, don't write into table
Attribute | Type |
|---|---|
id | integer |
category_id | integer |
name | string |
url | string |
standard_field_id | integer |
field_name | string |
description | string |
example_value | string |
mandatory | boolean |
UID | boolean |
format | string |
format_properties | string |
Publisher_Productfeed_v2_Settings
Get searchable fields
Parameter
<publisher_id> (required): Publisher ID
<settings_id> (optional): Filter Settings ID
<csv_enclose_id> (optional): Filter CSV Enclose ID
<csv_explode_id> (optional): Filter CSV Explode ID
<name> (optional): Name
<encoding> (optional): Filter encoding (utf8, iso885915, iso88591, ascii, utf16, windows-1252)
<type> (optional): Filter type
<csv_line_endings> (optional): Filter line ending (CR, LF, CRLF)
<item_tag> (optional): Filter item tag
<root_tag> (optional): Filter root tag
<general_fields> (optional): Filter general fields
<xhtml_strict> (optional): Filter XHTML Strict
<nl2br> (optional): Filter Newline to Break
<html_transform> (optional): Filter HTML Transform (none, strip, encode)
<target_table> (optional): Table name to save the data to
<preview> (optional): Preview only, don't write into table
Attribute | Type |
|---|---|
id | bigdecimal |
name | string |
encoding | string |
type | string |
csv_line_endings | string |
item_tag | string |
root_tag | string |
general_fields | string |
nl2br | string |
html_transform | string |
csv_enclose | string |
csv_delimiter | string |
raw_feed_data | string |
xhtml_strict | boolean |
Publisher_Productfeeds_V2_Program
Get all productfeeds
Parameter
<publisher_id> (required): Publisher ID
<program_id> (optional): Program ID
<media_id> (optional): Media ID
<standard_id> (optional): Standard ID
<currency_id> (optional): Currency ID
<locale_id> (optional): Locale ID
<language_code> (optional): Language code
<name> (optional): Name
<placeholder_media_id> (optional): replace url placeholder #MEDIA_ID# value
<placeholder_subid> (optional): replace url placeholder #SUBID# value
<placeholder_subid_2> (optional): replace url placeholder #SUBID2# value
<placeholder_subid_3> (optional): replace url placeholder #SUBID3# value
<target_table> (optional): Table name to save the data to
<preview> (optional): Preview only, don't write into table
Attribute | Type |
|---|---|
id | bigdecimal |
program_id | bigdecimal |
standard_id | bigdecimal |
currency_id | bigdecimal |
language_code | string |
url | string |
products | string |
dedicated_media_id | string |
locale_ids | clob |
Publisher_Productfeeds_v2_Filters
Get all filters
Parameter
<publisher_id> (required): Publisher ID
<media_id> (optional): Media ID
<settings_id> (optional): Filter Settings ID
<locale_id> (optional): Locale ID
<standard_id> (optional): Standard ID
<program_id> (optional): Program ID
<status> (optional): Filter status (active, inactive)
<language_code> (optional): Language code
<filter_id> (optional): Filter ID
<name> (optional): Name
<target_table> (optional): Table name to save the data to
<preview> (optional): Preview only, don't write into table
Attribute | Type |
|---|---|
id | bigdecimal |
name | string |
language_code | string |
programs | string |
last_call | timestamp |
status | string |
url | string |
media_id | bigdecimal |
locale_id | bigdecimal |
settings_id | bigdecimal |
standard_id | bigdecimal |
program_ids | bigdecimal |
Publisher_Statistics
Get statistics grouped by transaction date
Parameter
<dimension> (required): Dimension (date, hour, day, weekday, month, year, program, media, subid, subid2, subid3, description, cpc, device, ad, demographic)
<publisher_id> (required): Publisher ID
<program_id> (optional): Program ID
<start> (required): Start date
<end> (required): End date
<advertiser_id> (optional): Advertiser ID
<media_id> (optional): Media ID
<ad_id> (optional): Ad ID
<currency_code> (optional): Currency code (ISO 4217)
<affiliatemarketing_id> (optional): Affiliatemarketing ID
<smartviews> (optional): Smartview (click, transaction)
<subid> (optional): Sub id
<subid_2> (optional): Sub id 2
<subid_3> (optional): Sub id 3
<description> (optional): Transaction description
<gender> (optional): Gender (male, female, unknown)
<country_code> (optional): Country code
<age_category> (optional): Age category (1-5, 6-10, 11-15, 16-20, 21-25, 26-30, 31-35, 36-40, 41-45, 46-50, 51-55, 56-60, 61-65, 66-70, 71-75, 76-80, 81-85, 86-90, 91-95, 96-100+)
<region_code> (optional): Region code
<extra_1> (optional): Extra 1
<extra_2> (optional): Extra 2
<extra_3> (optional): Extra 3
<extra_4> (optional): Extra 4
<extra_5> (optional): Extra 5
<invoice_reference_number> (optional): Invoice reference number
<target_table> (optional): Table name to save the data to
<preview> (optional): Preview only, don't write into table
Attribute | Type |
|---|---|
currency_code | string |
click_raw | bigdecimal |
click_unique | bigdecimal |
cpc_raw | bigdecimal |
cpc_unique | bigdecimal |
clickout_raw | bigdecimal |
clickout_unique | bigdecimal |
transaction_unique | bigdecimal |
transaction_open | bigdecimal |
transaction_open_parts | bigdecimal |
transaction_approved | bigdecimal |
transaction_approved_parts | bigdecimal |
transaction_disapproved | bigdecimal |
transaction_disapproved_parts | bigdecimal |
transaction_revenue | bigdecimal |
cpc_amount | bigdecimal |
clickout_amount | bigdecimal |
transaction_open_amount | bigdecimal |
transaction_approved_amount | bigdecimal |
transaction_disapproved_amount | bigdecimal |
transaction_amount | bigdecimal |
date | date |
hour | string |
day | string |
weekday | string |
month | string |
year | string |
program | string |
media | string |
subid | string |
subid2 | string |
subid3 | string |
description | string |
cpc | string |
device | string |
ad | string |
demographic | string |
Publisher_Statistics_Date
Get statistics grouped by transaction date
Parameter
<publisher_id> (required): Publisher ID
<program_id> (optional): Program ID
<start> (required): Start date
<end> (required): End date
<advertiser_id> (optional): Advertiser ID
<media_id> (optional): Media ID
<ad_id> (optional): Ad ID
<currency_code> (optional): Currency code (ISO 4217)
<affiliatemarketing_id> (optional): Affiliatemarketing ID
<smartviews> (optional): Smartview (click, transaction)
<subid> (optional): Sub id
<subid_2> (optional): Sub id 2
<subid_3> (optional): Sub id 3
<description> (optional): Transaction description
<gender> (optional): Gender (male, female, unknown)
<country_code> (optional): Country code
<age_category> (optional): Age category (1-5, 6-10, 11-15, 16-20, 21-25, 26-30, 31-35, 36-40, 41-45, 46-50, 51-55, 56-60, 61-65, 66-70, 71-75, 76-80, 81-85, 86-90, 91-95, 96-100+)
<region_code> (optional): Region code
<extra_1> (optional): Extra 1
<extra_2> (optional): Extra 2
<extra_3> (optional): Extra 3
<extra_4> (optional): Extra 4
<extra_5> (optional): Extra 5
<invoice_reference_number> (optional): Invoice reference number
<target_table> (optional): Table name to save the data to
<preview> (optional): Preview only, don't write into table
Attribute | Type |
|---|---|
date | date |
currency_code | string |
click_raw | bigdecimal |
click_unique | bigdecimal |
cpc_raw | bigdecimal |
cpc_unique | bigdecimal |
clickout_raw | bigdecimal |
clickout_unique | bigdecimal |
transaction_unique | bigdecimal |
transaction_open | bigdecimal |
transaction_open_parts | bigdecimal |
transaction_approved | bigdecimal |
transaction_approved_parts | bigdecimal |
transaction_disapproved | bigdecimal |
transaction_disapproved_parts | bigdecimal |
transaction_revenue | bigdecimal |
cpc_amount | bigdecimal |
clickout_amount | bigdecimal |
transaction_open_amount | bigdecimal |
transaction_approved_amount | bigdecimal |
transaction_disapproved_amount | bigdecimal |
transaction_amount | bigdecimal |
Publisher_Transactions
Get all transactions
Parameter
<publisher_id> (required): Publisher ID
<currency_code> (optional): Currency code (ISO 4217)
<start> (optional): Start date
<end> (optional): End date
<date_click_start> (optional): Click date
<date_click_end> (optional): Click date end
<date_approval_start> (optional): Approval date
<date_approval_end> (optional): Approval date end
<date_modified_start> (optional): Last modification date
<date_modified_end> (optional): Last modification date end
<affiliatemarketing_id> (optional): Affiliatemarketing ID
<advertiser_id> (optional): Advertiser IDs
<media_id> (optional): Media IDs
<program_id> (optional): Program IDs
<ad_id> (optional): Ad IDs
<datafeeds_unique_id> (optional): Datafeeds unique id (32 characters)
<subid> (optional): Sub ids
<subid_2> (optional): Subid_2
<subid_3> (optional): Subid_3
<description> (optional): Transaction description
<status> (optional): Status (approved, disapproved, open)
<transaction_type> (optional): Transaction type (normal, manual_advertiser, manual_publisher)
<part_type> (optional): Part type (product, assist, compensation_upgrade, conversion_attribution)
<country_code> (optional): Country code
<region_code> (optional): Region code
<gender> (optional): Gender (male, female, unknown)
<age_category> (optional): Age category (1-5, 6-10, 11-15, 16-20, 21-25, 26-30, 31-35, 36-40, 41-45, 46-50, 51-55, 56-60, 61-65, 66-70, 71-75, 76-80, 81-85, 86-90, 91-95, 96-100+)
<extra_1> (optional): Extra 1
<extra_2> (optional): Extra 2
<extra_3> (optional): Extra 3
<extra_4> (optional): Extra 4
<extra_5> (optional): Extra 5
<invoice_reference_number> (optional): Invoice reference number
<payable> (optional): Payable (approved_not_yet_payable, approved_and_payable, approved_not_payed, paid_or_pending_payment)
<order_by> (optional): Order by (date, program_name, media_name, publisher_commission_potential, transaction_status)
<order_direction> (optional): Order direction (asc, desc) default asc
<target_table> (optional): Table name to save the data to
<preview> (optional): Preview only, don't write into table
Attribute | Type |
|---|---|
affiliatemarketing_id | string |
part_id | string |
part_date | timestamp |
date_click | timestamp |
currency_code | string |
referer_click | string |
publisher_description | string |
extra_1 | string |
extra_2 | string |
extra_3 | string |
extra_4 | string |
extra_5 | string |
status | string |
media_name | string |
last_modified | timestamp |
referencenumber | string |
subid | string |
subid_2 | string |
subid_3 | string |
ad_id | bigdecimal |
datafeeds_unique_id | string |
media_id | bigdecimal |
revenue | bigdecimal |
approval_date | timestamp |
disapproved_reason | string |
commission | bigdecimal |
program_name | string |
date | timestamp |
program_id | bigdecimal |
ip_hash | string |
country_code | string |
region_code | string |
gender | string |
age | string |
device_type | string |
device_model_id | bigdecimal |
device_platform_id | bigdecimal |
device_browser_id | bigdecimal |
anonymous_ip | string |
Publisher_Transactions_Totals
Get all transaction totals
Parameter
<publisher_id> (required): Publisher ID
<currency_code> (optional): Currency code (ISO 4217)
<start> (optional): Start date
<end> (optional): End date
<date_click_start> (optional): Click date start
<date_click_end> (optional): Click date end
<date_approval_start> (optional): Approval date start
<date_approval_end> (optional): Approval date end
<date_modified_start> (optional): Last modification date start
<date_modified_end> (optional): Last modification date end
<affiliatemarketing_id> (optional): Affiliatemarketing IDs
<advertiser_id> (optional): Advertiser IDs
<media_id> (optional): Media IDs
<program_id> (optional): Program IDs
<ad_id> (optional): Ad IDs
<datafeeds_unique_id> (optional): Datafeeds unique id (32 characters)
<subid> (optional): Sub ids
<subid_2> (optional): Subid_2
<subid_3> (optional): Subid_3
<description> (optional): Transaction description
<status> (optional): Status (approved, disapproved, open)
<transaction_type> (optional): Transaction type (normal, manual_advertiser, manual_publisher)
<country_id> (optional): Country IDs
<region_code> (optional): Region code
<gender> (optional): Gender (male, female, unknown)
<age_category> (optional): Age category (1-5, 6-10, 11-15, 16-20, 21-25, 26-30, 31-35, 36-40, 41-45, 46-50, 51-55, 56-60, 61-65, 66-70, 71-75, 76-80, 81-85, 86-90, 91-95, 96-100+)
<extra_1> (optional): Extra 1
<extra_2> (optional): Extra 2
<extra_3> (optional): Extra 3
<extra_4> (optional): Extra 4
<extra_5> (optional): Extra 5
<invoice_reference_number> (optional): Invoice reference number
<payable> (optional): Payable (approved_not_yet_payable, approved_and_payable, approved_not_payed, paid_or_pending_payment)
<target_table> (optional): Table name to save the data to
<preview> (optional): Preview only, don't write into table
Attribute | Type |
|---|---|
transaction_count | bigdecimal |
status | string |
commission | bigdecimal |
revenue | bigdecimal |
currency_code | string |
Publishers_ProductfeedsSearchFields
Get searchable fields
Parameter
<publisher_id> (required): Publisher ID
<standard_id> (optional): Standard ID
<target_table> (optional): Table name to save the data to
<preview> (optional): Preview only, don't write into table
Attribute | Type |
|---|---|
operator_name | string |
operator | string |
field_name | string |
values | string |
wildcards | boolean |