Transaction API

The transaction API is used to call the transactions. To do this, the following parameter must be appended to the API call:

API	parameter

API	parameter
transactions	get-statistic_transactions

Example: https://www.domain.de/api//ACCESS-TOKEN/publisher/ID/get-statistic_transactions.csv

For the transaction API there are additional parameters that can be queried. Below is a list of all parameters:

Transaction API filters

parameter	value	description	example

parameter	value	description	example
condition[l:advertiser]	ID of the advertiser as integer.	All transactions that are stored under the given advertiser ID within the program.	condition[l:advertiser]=1
condition[l:projects]	ID of the project as integer.	All transactions that are stored under the given project ID within the program.	condition[l:projects]=1234
condition[l:campaigns]	ID of the campaign as integer.	All transactions that are stored under the given campaign ID within the program.	condition[l:campaigns]=1
condition[timetype]	0 = creation date 1 = processing date 2 = payout date	All transactions that have been created/processed/payed out in a certain period.	condition[timetype]=1

Definition of the fields delivered by the transaction api

The columns of downloaded transactions contain the following parameters:

criterion	encrypted transaction id
trackingtime	timestamp of the transaction
advertiser_id	id of the advertiser within the system
campaign_title	title of the campaign
campaign_id	id of the campaign within the system
project_id	id of the project
project_title	title of the project
event	type of transaction – lead, sale, bonus
payoutdate	Payout date - empty if not payed out yet, format: YYYY-MM-DD HH:MM:SS
processingdate	Processing time - empty if not processed yet, format: YYYY-MM-DD HH:MM:SS
salary_id	internal salary id, -1 if not payed out yet
salary	Credit note number – document can be downloaded as unter settings =>billing
clicktime	timestamp of the click - format: YYYY-MM-DD HH:MM:SS
subid	Subid you passed in click / postview - default: NONE
referrer	The click referrer if determinable – default: ://NONE
admedia_id	admedia id which led to the transaction
status	0 = open \| 1 = confirmed \| 2 = canceled \| 3 = paid
reason_of_cancellation	cancel reason (if given)
provision	your provision
turnover	net basked value
trigger_id	internal id of the event
trigger_title	name of the event
basket_count	in case of basket-tracking, the number of items in the basket, otherwise 0