---
title: "Initiates the creation of a telephone number report CSV"
method: GET
path: "/v2/partition/{partitionId}/report/tn/csv_2"
tags: ["Report"]
---

# Initiates the creation of a telephone number report CSV

`GET /v2/partition/{partitionId}/report/tn/csv_2`

## Request

- Base URL: `https://api.alianza.com`
- URL: `https://api.alianza.com/v2/partition/{partitionId}/report/tn/csv_2`
- Auth: API key in header `X-AUTH-TOKEN`
- TypeScript: <https://skmtc.dev/alianza/apis/alianza-public-api/docs/v2/partition/:partitionId/report/tn/csv_2/get.ts> (a function with typed inputs; its response is checked against the schema)

Creates an <a href="#/~schema/Job">asynchronous job</a> that generates a CSV file for download.
<span hidden>Please refer to <a href="jobs.html#monitor-job-progress">monitoring job progress</a> and <a href="jobs.html#get-job-output">retrieving job output</a> for instructions on retrieving the report.</span>

**The CSV headers are:**
* TelephoneNumber
* AccountNumber
* AccountStatus
* ActivatedDate
* AddDate
* Carrier
* CarrierStatus
* CooldownExpireDate
* CooldownRecoveredDate
* CustomerType
* DeletedDate
* DirectoryListingType
* FunctionType
* ParentPartitionName
* PartitionName
* Port
* PortCancelType
* PortCompletionDate
* PortOutDate
* RateCenterName
* RateCenterState
* ServicePackageType
* TemporaryNumber
* TollFree
* 911first_name
* 911last_name
* 911business_name
* 911street_number
* 911street_number_suffix
* 911street_name
* 911street_suffix
* 911state
* 911country
* 911postal_code
* 911pre_directional
* 911post_directional
* 911city
* 911latitude
* 911longitude
* 911first_name_secondary
* 911secondary_location_description
* 911middle_initial
* 911unit
* CSRfirst_name
* CSRlast_name
* CSRbusiness_name
* CSRstreet_number
* CSRstreet_number_suffix
* CSRstreet_name
* CSRstreet_suffix
* CSRstate
* CSRcountry
* CSRpostal_code
* CSRpre_directional
* CSRpost_directional
* CSRcity
* CSRlatitude
* CSRlongitude
* CSRfirst_name_secondary
* CSRsecondary_location_description
* CSRmiddle_initial
* CSRunit

## Path parameters

- `partitionId` string, required

## Query parameters

- `month` integer, required
- `year` integer, required

## Response `202`

Use Jobs API to check status

- Job
  - `id` string
  - `name` string
  - `userId` string
  - `status` 'PENDING' | 'IN_PROGRESS' | 'DONE' | 'FAILED'
  - `errors` JobError[]
    - `error` string
    - `lineNumber` integer
    - `column` string
    - `input` string
  - `inputKey` string
  - `outputKey` string
  - `start` string, date-time
  - `lastUpdated` string, date-time

## Other responses

- `400`: Invalid request parameters
- `401`: Unauthorized
- `404`: Not found
- `412`: Invalid month or year

---

[API](https://skmtc.dev/alianza/apis/alianza-public-api.md) - [All operations](https://skmtc.dev/alianza/apis/alianza-public-api/llms.txt) - [OpenAPI document](https://skmtc.dev/alianza/apis/alianza-public-api/revisions/7223246c352c?raw)