---
title: "The rows of the Non-compliant affiliates CSV export, as JSON"
method: GET
path: "/projects/{project_id}/exports/affiliate-cases"
tags: ["Reports"]
---

# The rows of the Non-compliant affiliates CSV export, as JSON

`GET /projects/{project_id}/exports/affiliate-cases`

## Request

- Base URL: `https://adslighthouse.com/api/v1`
- URL: `https://adslighthouse.com/api/v1/projects/{project_id}/exports/affiliate-cases`
- Auth: HTTP bearer

Returns exactly the rows and columns of the Non-compliant affiliates CSV export for the same window, filters and case status (all statuses when omitted), paged as JSON. affiliate_id narrows it to one case, as the per-case evidence file does. Each row is an affiliate ID seen behind ads on domains you do not own whose copy used the brand: a lead to review with the partner, not proof of a violation. List values are joined with ' | ' as in the CSV.

## Path parameters

- `project_id` string, required: The project: its id, its brand domain (for example nike.example) or its exact project or brand name. Unknown or ambiguous references return not_found; call list_projects then.

## Query parameters

- `status` 'new' | 'in_progress' | 'resolved' | 'ignored'
- `affiliate_id` string
- `range` '7d' | '14d' | '30d' | '12m' | 'custom': Window ending today: 7d, 14d, 30d (default) or 12m. Use custom with from and to for fixed dates.
- `from` string: First local day, YYYY-MM-DD (custom range).
- `to` string: Last local day, YYYY-MM-DD, included in full (custom range).
- `time_zone` string: IANA time zone for day boundaries, such as America/New_York. Defaults to the time zone of the person the credential acts for.
- `engine` union: Search engine, or a list of engines combined with OR.
  - 'google' | 'bing'
  - string[]
- `device` union: Device, or a list combined with OR.
  - 'desktop' | 'mobile'
  - string[]
- `os` union: Operating system. unspecified matches checks that did not pin one. Must fit the chosen device.
  - 'windows' | 'macos' | 'android' | 'ios' | 'unspecified'
  - string[]
- `country` union: ISO 3166-1 alpha-2 country code such as US, or a list.
  - string
  - string[]
- `location` union: Saved location key: code:<location code>, name:<label> or country:<ISO code>. get_project_details lists the keys that have data.
  - string
  - string[]
- `limit` integer: Items per page, 1 to 200.
- `cursor` string: The next_cursor value from the previous page. Omit it for the first page.

## Response `200`

The rows of the Non-compliant affiliates CSV export, as JSON

- object
  - `configured` boolean, required
  - `data` object[], required
    - `affiliate_id` string, required
    - `affiliate_name` string, required
    - `parameter` string, required
    - `status` 'new' | 'in_progress' | 'resolved' | 'ignored', required
    - `ads` integer, required
    - `networks` string, required
    - `advertiser_domains` string, required
    - `advertiser_names` string, required
    - `countries` string, required
    - `keywords` string, required
    - `matched_brand_terms` string, required
    - `evidence_urls` string, required
    - `first_seen` string, required
    - `last_seen` string, required
    - `trace_outcomes` string, required: Outcomes of the newest redirect traces of the evidence URLs, if traced.
    - `traced_final_urls` string, required: Final landing URLs those traces reached from our servers.
    - `traced_affiliate_ids` string, required: Affiliate identifiers observed in those chains, as parameter=value.
  - `next_cursor` string, nullable, required: Pass as cursor to get the next page; null on the last page.
  - `total_rows` integer, required
  - `window` object, required
    - `from` string, required: First local day included, YYYY-MM-DD.
    - `to` string, required: Last local day included, YYYY-MM-DD.
    - `time_zone` string, required
    - `start` string, required: Inclusive start instant, ISO 8601.
    - `end` string, required: Exclusive end instant, ISO 8601.
  - `request_id` string

## Other responses

- `400`: Invalid parameters, cursor or body.
- `401`: Missing, invalid, expired or revoked credential.
- `403`: The credential lacks the write scope, the plan does not include the API, or the allowance is used up.
- `404`: Unknown project, keyword or run in this account.
- `409`: The idempotency key was already used for a different request.
- `429`: Rate limit reached. Retry after the Retry-After seconds.
- `503`: The requested service or file is temporarily unavailable.

---

[API](https://skmtc.dev/adslighthouse/apis/ads-lighthouse-api.md) · [All operations](https://skmtc.dev/adslighthouse/apis/ads-lighthouse-api/llms.txt) · [OpenAPI document](https://skmtc.dev/adslighthouse/apis/ads-lighthouse-api/revisions/e1a4a40b11a9?raw)