Affiliate

Affiliates of clients

Fields

Field	Type	Availability	Notes
id	Int!		The record's Refersion id.
status	String		One of ACTIVE, PENDING, DISABLED, DENIED. Affiliates in any other state are never returned, whatever you filter on.
created	String		Unix timestamp in seconds, not an ISO 8601 date. null when the underlying date is unset.
updated	String		Unix timestamp in seconds, not an ISO 8601 date. null when the underlying date is unset.
last_login	String		Unix timestamp in seconds, not an ISO 8601 date. null when the underlying date is unset.
last_conversion	String		Unix timestamp in seconds, not an ISO 8601 date. null when the underlying date is unset.
first_name	String
last_name	String
company	String
email	String
paypal_email	String
address1	String
address2	String
city	String
state	String
zip	String
country	String
registered_ip	String
phone_number	String
unique_merchant_id	String		Your own identifier for the affiliate, if you set one.
custom_fields	[[String]]		The affiliate's answers to your custom registration fields, as a list of [id, label, value] triples. Empty when the affiliate has none.
name	String		Convenience field: first_name and last_name joined with a space.
address	String		Convenience field: the address lines, city, state and country joined into one string.
rfsn_parameter	String		The tracking fragment to append to a destination URL for this affiliate, for example &rfsn=123456.1234c.
registration_source	String		How the affiliate joined your program.
shop	Shop
clicks	[Click]		Takes arguments — see below.
conversions	[Conversion]		Takes arguments — see below.
conversion_triggers	[ConversionTrigger]		Takes arguments — see below.
offer	Offer
payments	[Payment]		Takes arguments — see below.

Sorting

sort accepts id, created, status, last_login, last_conversion on this type, and sorts descending. Any other value is ignored without an error.

Field arguments

clicks

Argument	Type	Notes
id	ID	Returns only the record with this id.
sub_id	ID	Matches the subid carried on the tracking link.
created_from	Int	Unix timestamp in seconds. Exclusive — matches rows created strictly after it.
created_to	Int	Unix timestamp in seconds. Inclusive — matches rows created at or before it.
creative_id	ID	Returns only records tied to this creative.
offer_id	ID	Returns only records tied to this offer.
sort	String	Field to sort by, descending. Each type accepts its own short list — see Sorting on the returned type's page. Anything else is ignored without an error.
limit	Int	Rows to return. Anything outside 1–200 is replaced by 200.
before	ID	Returns only rows with an id lower than this. Cursor-style paging.
after	ID	Returns only rows with an id higher than this. Cursor-style paging.
offset	Int	Rows to skip before returning results.

conversions

Argument	Type	Notes
id	ID	Returns only the record with this id.
status	String	Exact match. The returned type lists the values that can appear.
payment_status	String	Pass UNPAID for records not yet in a payment. Any other value matches records that are already in one.
type	String	Exact match. The returned type lists the values that can appear.
created_from	Int	Unix timestamp in seconds. Exclusive — matches rows created strictly after it.
created_to	Int	Unix timestamp in seconds. Inclusive — matches rows created at or before it.
offer_id	ID	Returns only records tied to this offer.
sort	String	Field to sort by, descending. Each type accepts its own short list — see Sorting on the returned type's page. Anything else is ignored without an error.
limit	Int	Rows to return. Anything outside 1–200 is replaced by 200.
before	ID	Returns only rows with an id lower than this. Cursor-style paging.
after	ID	Returns only rows with an id higher than this. Cursor-style paging.
offset	Int	Rows to skip before returning results.

conversion_triggers

Argument	Type	Notes
id	String	Returns only the record with this id.
status	String	Exact match. The returned type lists the values that can appear.
trigger	String	Exact match on the trigger value — the coupon code, email address, or SKU.
created_from	Int	Unix timestamp in seconds. Exclusive — matches rows created strictly after it.
created_to	Int	Unix timestamp in seconds. Inclusive — matches rows created at or before it.
updated_from	Int	Unix timestamp in seconds. Exclusive — matches rows updated strictly after it.
updated_to	Int	Unix timestamp in seconds. Inclusive — matches rows updated at or before it.
sort	String	Field to sort by, descending. Each type accepts its own short list — see Sorting on the returned type's page. Anything else is ignored without an error.
limit	Int	Rows to return. Anything outside 1–200 is replaced by 200.
before	ID	Returns only rows with an id lower than this. Cursor-style paging.
after	ID	Returns only rows with an id higher than this. Cursor-style paging.
offset	Int	Rows to skip before returning results.

payments

Argument	Type	Notes
id	ID	Returns only the record with this id.
created_from	Int	Unix timestamp in seconds. Exclusive — matches rows created strictly after it.
created_to	Int	Unix timestamp in seconds. Inclusive — matches rows created at or before it.
commission_total	String	Exact match on the stored value. This is not a range filter.
total	String	Exact match on the stored value. This is not a range filter.
sort	String	Field to sort by, descending. Each type accepts its own short list — see Sorting on the returned type's page. Anything else is ignored without an error.
limit	Int	Rows to return. Anything outside 1–200 is replaced by 200.
before	ID	Returns only rows with an id lower than this. Cursor-style paging.
after	ID	Returns only rows with an id higher than this. Cursor-style paging.
offset	Int	Rows to skip before returning results.

Referenced by

• Click.affiliates
• Conversion.affiliate
• ConversionTrigger.affiliate
• Offer.affiliates
• Payment.affiliates
• Query.affiliates

Related

• Queries — the root fields that reach this type.
• Filtering and Sorting — how arguments behave.