Exports

Introduction

Next to the default exports in the interface, Daisycon also offers exporting of data using the Daisycon API and certain data via URL exports. These exports can be found in the Daisycon Interface on their pages using the handy link icon under export.

An export URL will look like this:

https://export.daisycon.com/publishers/{publisher_id}/{export_base_path}/{export_format}?filter_field=filter_value&filter_field2=filter_value2&token=exporttoken&[email protected]

The default generated URL will always export in CSV, but does allow you to modify the filters in query params. Documentation for customizing these exports can be found here on this page.

Available URL exports

Below you’ll find all availabe URL exports and their export definition.

Campaign export

An export containing all campaigns available for your account.

Base URL: /publishers/{publisher_id}/program/{export_format}
Available formats: csv, xml, json, xlsx
Filter name Required Multiple* Filter format
default_category_id No Yes Number : Availabe values
media_id No No Number
language No No String : en, fr, de, nl
Default: en
locale_id No Yes Number : Availabe values
type No Yes String : affiliatemarketing, leadgeneration
subscription_status No Yes String : open, approved, disapproved, nosubscription
extra No Yes String : cashback, deeplink, productfeed, socialmedia, emailmarketing, keywordmarketing

* Use a comma (,) to separate multiple values e.g. open,approved

Campaign commission export

An export containing the commissions for all campaigns available for your account.

Base URL: /publishers/{publisher_id}/program/commission/{export_format}
Available formats: csv, xml, json, xlsx
Filter name Required Multiple* Filter format
default_category_id No Yes Number : Availabe values
media_id No No Number
locale_id No Yes Number : Availabe values
type No Yes String : affiliatemarketing, leadgeneration
subscription_status No Yes String : open, approved, disapproved, nosubscription
extra No Yes String : cashback, deeplink, productfeed, socialmedia, emailmarketing, keywordmarketing

* Use a comma (,) to separate multiple values e.g. open,approved

Promotioncode export

An export containing promotioncodes available for your account

Base URL: /publishers/{publisher_id}/material/promotioncodes/{export_format}
Available formats: csv, xml, json, xlsx, rss
Filter name Required Multiple* Filter format
media_id Yes No Number
default_category_id No Yes Number : Availabe values
locale_id No Yes Number : Availabe values
program_id No Yes Number
subscription_status No Yes String : open, approved, disapproved, nosubscription

* Use a comma (,) to separate multiple values e.g. open,approved

Transaction export

An export containing transactions generated in your account.

Base URL: /publishers/{publisher_id}/transactions/{export_format}
Available formats: csv, xml, json, xlsx
Filter name Required Multiple* Filter format
start_date Yes** No American date notation YYYY-MM-DD
end_date Yes** No American date notation YYYY-MM-DD
media_id No Yes Number
last_number_days No** Yes Number

* Use a comma (,) to separate multiple values e.g. open,approved
** start_date and end_date are omitted if you use last_number_days

Build your own URL

To export any of the available exports you can eather use the export URL link within the Daisycon Interface or you can build your own URL.

The URL base looks like this:

https://export.daisycon.com/{export_base_path}/{export_format}?token={exporttoken}&username={username}

Generate authentication token

First you’ll need to generate an authentication token for the export you’re going to make.

  • First grab the desired export’s base URL and enter your publisher id and the export format you want for example publisher 1234, transactions and csv.
    This should leave you with an URL like this:

    /publishers/1234/transactions/csv

    . (note that the / infront is mandatory)

  • Place this URL in the /export/token service below after authenticating and press try it out.
  • The service will return an export token to you.
  • Now place the chosen base URL, the token and the username you’ve used to authenticate with in the URL

    https://export.daisycon.com/{export_base_path}/{export_format}?token={exporttoken}&username={username}

    This should result into the following:

    https://export.daisycon.com/publishers/1234/transactions/csv?token=dfj3c8j3jgcggh3hshsc&[email protected]

  • Don’t forget to add the required filters, and this URL should work for automated exports

Adjust filter

Filtering in a custom export is quite simple. Just check out the availabe filters for your desired export and add them to your export URL like this

&{filter_name}={filter_value}

Using the example above and filtering on start and end_date your URL should look like this

https://export.daisycon.com/publishers/1234/transactions/csv?token=dfj3c8j3jgcggh3hshsc&[email protected]&start_date=2017-01-01&end_date=2017-01-01

Invalidating all export tokens

If you’ve given your export URL’s to other people and you want to remove their access you can invalidate all export tokens. By doing this you’ll need to regenerate all tokens you wish to use yourself.

Just call the export/token/refresh service below after entering your login credentials and press Try it Out.