---
title: "List File Translation Metrics"
method: GET
path: "/fts/file-translation-statuses"
tags: ["File Translation Status Data Set"]
---

# List File Translation Metrics

`GET /fts/file-translation-statuses`

Endpoint to fetch file translation status metrics, including item count and details.

## Query parameters

- `$top` integer
- `$skip` integer
- `$filter` string
- `$count` boolean
- `$expand` string

## Headers

- `Authorization` string, required
- `X-LC-Tenant` string, required

## Response `200`

- object
  - `itemCount` integer
  - `items` FactFts[]
    - `projectId` integer — A unique identifier for the project associated with the file translation status.
    - `customerId` integer — A unique identifier for the customer associated with the file translation status.
    - `languagePairId` integer — A unique identifier for the language pair used in the translation.
    - `sourceFileId` integer — A unique identifier for the source file associated with the translation.
    - `projectCreationDateId` integer — A unique identifier for the date when the project was created.
    - `translationDateId` integer — A unique identifier for the date when the translation was performed.
    - `translatorId` integer — A unique identifier for the translator who performed the translation.
    - `reviewDateId` integer — A unique identifier for the date when the review was performed.
    - `reviewerId` integer — A unique identifier for the reviewer who performed the review.
    - `customerReviewDateId` integer — A unique identifier for the date when the customer review was performed.
    - `customerReviewerId` integer — A unique identifier for the customer reviewer who performed the review.
    - `finalizationDateId` integer — A unique identifier for the date when the translation was finalized.
    - `sourceWords` integer — The total number of source words in the file.
    - `lockedWords` integer — The total number of locked words in the file.
    - `repetitionWords` integer — The total number of repetition words in the file.
    - `crossFileRepetitionWords` integer — The total number of cross-file repetition words in the file.
    - `perfectMatchWords` integer — The total number of perfect match words in the file.
    - `inContextMatchWords` integer — The total number of in-context match words in the file.
    - `exactMatchWords` integer — The total number of exact match words in the file.
    - `fuzzyMatchWords` integer — The total number of fuzzy match words in the file.
    - `newMatchWords` integer — The total number of new match words in the file.
    - `machineTranslationWords` integer — The total number of words translated by machine translation in the file.
    - `translationDuration` integer — The total duration of the translation process, in minutes.
    - `humanTranslatedSegments` integer — The total number of segments translated by human translators in the file.
    - `humanTranslatedWords` integer — The total number of words translated by human translators in the file.
    - `humanTranslatedCharacters` integer — The total number of characters translated by human translators in the file.
    - `reviewDuration` integer — The total duration of the review process, in minutes.
    - `reviewedSegments` integer — The total number of segments reviewed in the file.
    - `reviewedWords` integer — The total number of words reviewed in the file.
    - `reviewedCharacters` integer — The total number of characters reviewed in the file.
    - `pipelineDuration` integer — The total duration of the entire translation pipeline, in minutes.
    - `canceled` boolean — A boolean indicating whether the translation project was canceled.
    - `project` DimProject — Project dimension
      - `internalId` integer — A unique internal identifier for the project.
      - `projectId` string — A unique identifier for the project, as it is in Trados Cloud Platform.
      - `projectShortId` integer — A shortened, numeric identifier for the project, assigned by Trados Cloud Platform.
      - `projectName` string — The name of the project.
      - `projectDescription` string — A detailed description of the project.
      - `projectLocationId` string — The identifier for the location where the project is based or managed.
      - `projectGroupId` string — The identifier for the project group.
      - `projectGroupShortId` integer — A shortened, numeric identifier for the project group, assigned by Trados Cloud Platform.
      - `projectGroupName` string — The name of the group responsible for the project.
      - `projectStatus` 'N/A' | 'created' | 'in_progress' | 'completed' — The current status of the project. Can have the following values: 'created','in_progress','completed','archived'.
      - `projectTemplateId` string — The identifier for the template used to create the project.
      - `projectTemplateName` string — The name of the template used to create the project.
      - `originSystem` string — The originating system or application where the project was created.
      - `sourceLanguage` string — The source language of the project content.
      - `targetLanguages` string — The target languages for the project content, typically a comma-separated list.
      - `createdAt` string, date-time — The date and time when the project was created. Timestamp with 'YYYY-MM-DDTHH:MM:SSZ' format.
      - `quoteCreatedAt` string, date-time — The date and time when the project quote was created. Timestamp with 'YYYY-MM-DDTHH:MM:SSZ' format.
      - `quoteApprovedAt` string, date-time — The date and time when the project quote was approved. Timestamp with 'YYYY-MM-DDTHH:MM:SSZ' format.
      - `completedAt` string, date-time — The date and time when the project was completed. Timestamp with 'YYYY-MM-DDTHH:MM:SSZ' format.
      - `dueAt` string, date-time — The due date and time for the project. Timestamp with 'YYYY-MM-DDTHH:MM:SSZ' format.
      - `deliveredAt` string, date-time — The date and time when the project was delivered. Timestamp with 'YYYY-MM-DDTHH:MM:SSZ' format.
      - `projectSegmentCount` integer — The total number of segments in the project.
      - `projectWordCount` integer — The total number of words in the project.
      - `projectCharacterCount` integer — The total number of characters in the project.
      - `projectFileCount` integer — The total number of files in the project.
      - `projectRevenue` number, float — The total revenue generated by the project.
      - `projectSavings` number, float — The total savings associated with the project.
      - `projectCurrencyCode` string — The currency code (e.g., USD, EUR) for the project financials.
      - `deliveryTimeDiff` integer — The difference in time between the due date and the actual delivery date, measured in seconds.
      - `onTimeStatus` 'N/A' | 'VERY_EARLY' | 'EARLY' | 'ON_TIME' | 'LATE' | 'VERY_LATE' — A status indicating the punctuality of the project's delivery.
      - `projectCreatorName` string — The name of the user who created the project.
      - `projectCreatorId` string — The identifier for the user who created the project.
      - `deleted` boolean — A boolean flag indicating whether the project has been deleted.
      - `customFields` string — A string containing custom fields and values specific to the project. Format: 'customField1 = value1 | customField2 = value2'.
    - `customer` DimCustomer — Customer dimension
      - `internalId` integer — A unique internal identifier for the customer.
      - `customerId` string — A unique identifier for the customer, as it is in Trados Cloud Platform.
      - `customerLocationId` string — The identifier for the location where the customer is based or managed.
      - `customerName` string — The name of the customer.
      - `createdBy` string — The identifier of the user who created the customer.
      - `createdAt` string — The date and time when the customer record was created. Timestamp with 'YYYY-MM-DDTHH:MM:SSZ' format.
      - `keyContactId` string — The identifier for the key contact person for the customer.
      - `keyContactEmail` string — The email address of the key contact person for the customer.
      - `ragStatusName` string — The RAG (Red, Amber, Green) status name indicating the current health or risk status of the customer.
      - `customFields` string — A string containing custom fields and values specific to the customer. Format: 'customField1 = value1 | customField2 = value2'.
      - `deleted` boolean — A boolean flag indicating whether the customer record has been deleted.
    - `languagePair` DimLanguagePair — Language Pair dimension
      - `internalId` integer — A unique internal identifier for the language pair.
      - `sourceLanguageCode` string — The ISO code representing the source language.
      - `sourceEnglishName` string — The English name of the source language.
      - `sourceParentLanguageCode` string — The ISO code of the parent language for the source language, if applicable.
      - `targetLanguageCode` string — The ISO code representing the target language.
      - `targetEnglishName` string — The English name of the target language.
      - `targetParentLanguageCode` string — The code of the parent language for the target language, if applicable.
    - `sourceFile` DimSourceFile
      - `internalId` integer — A unique internal identifier for the source file.
      - `sourceFileId` string — A unique identifier for the source file, as it is in Trados Cloud Platform.
      - `projectId` string — The identifier for the project associated with the source file, as it is in Trados Cloud Platform.
      - `projectName` string — The name of the project associated with the source file.
      - `fileName` string — The name of the source file.
      - `sourceFileLocationId` string — The identifier for the location where the source file is stored.
      - `fileTypeSettingsId` string — The identifier for the file type settings used for processing the source file.
      - `fileRole` string — The role or category of the source file (e.g., source, reference).
      - `batch` integer — The batch number.
      - `sourceFileSegmentCount` integer — The total number of segments in the source file.
      - `sourceFileWordCount` integer — The total number of words in the source file.
      - `sourceFileCharacterCount` integer — The total number of characters in the source file.
      - `createdAt` string, date-time — The date and time when the source file was created. Timestamp with 'YYYY-MM-DDTHH:MM:SSZ' format.
    - `projectCreationDate` DimDate — Date dimension
      - `internalId` integer — A unique internal identifier for the date.
      - `year` integer — The year of the date.
      - `month` integer — The month of the date (1 for January, 2 for February, etc.).
      - `day` integer — The day of the month (1 to 31).
      - `dayOfWeek` integer — The day of the week as a number (1 for Monday, 2 for Tuesday, ..., 7 for Sunday).
      - `dayOfWeekName` string — The name of the day of the week (e.g., Monday, Tuesday, ..., Sunday).
      - `monthName` string — The name of the month (e.g., January, February, ..., December).
      - `dayOfYear` integer — The day of the year (1 to 366).
      - `quarter` integer — The quarter of the year (1 to 4).
      - `yearNumber` string — The year as a string.
      - `monthNumber` string — The month as a string (e.g., '1' for January).
      - `fullDate` string, date — The full date in 'YYYY-MM-DD' format.
    - `translationDate` DimDate — Date dimension
      - `internalId` integer — A unique internal identifier for the date.
      - `year` integer — The year of the date.
      - `month` integer — The month of the date (1 for January, 2 for February, etc.).
      - `day` integer — The day of the month (1 to 31).
      - `dayOfWeek` integer — The day of the week as a number (1 for Monday, 2 for Tuesday, ..., 7 for Sunday).
      - `dayOfWeekName` string — The name of the day of the week (e.g., Monday, Tuesday, ..., Sunday).
      - `monthName` string — The name of the month (e.g., January, February, ..., December).
      - `dayOfYear` integer — The day of the year (1 to 366).
      - `quarter` integer — The quarter of the year (1 to 4).
      - `yearNumber` string — The year as a string.
      - `monthNumber` string — The month as a string (e.g., '1' for January).
      - `fullDate` string, date — The full date in 'YYYY-MM-DD' format.
    - `translator` DimTranslator — Translator dimension
      - `internalId` integer — A unique internal identifier for the translator.
      - `accountUserId` string — A unique identifier for the account user associated with the translator.
      - `firstName` string — The first name of the translator.
      - `lastName` string — The last name of the translator.
      - `userEmail` string — The email address of the translator.
      - `accountUserLocationId` string — The identifier for the location associated with the user's account.
      - `membership` string — Displays the type of membership the user has with the account: member, collaborator(guest).
      - `createdAt` string, date-time — The date and time when the translator's account was created. Timestamp with 'YYYY-MM-DDTHH:MM:SSZ' format.
      - `lastModifiedAt` string, date-time — The date and time when the translator's account was last modified. Timestamp with 'YYYY-MM-DDTHH:MM:SSZ' format.
      - `deletedAt` string, date-time — The date and time when the translator's account was deleted, if applicable. Timestamp with 'YYYY-MM-DDTHH:MM:SSZ' format.
      - `vendorId` string — The identifier for the vendor associated with the translator.
      - `vendorName` string — The name of the vendor associated with the translator.
      - `deleted` boolean — A boolean indicating whether the translator's account has been deleted.
    - `reviewDate` DimDate — Date dimension
      - `internalId` integer — A unique internal identifier for the date.
      - `year` integer — The year of the date.
      - `month` integer — The month of the date (1 for January, 2 for February, etc.).
      - `day` integer — The day of the month (1 to 31).
      - `dayOfWeek` integer — The day of the week as a number (1 for Monday, 2 for Tuesday, ..., 7 for Sunday).
      - `dayOfWeekName` string — The name of the day of the week (e.g., Monday, Tuesday, ..., Sunday).
      - `monthName` string — The name of the month (e.g., January, February, ..., December).
      - `dayOfYear` integer — The day of the year (1 to 366).
      - `quarter` integer — The quarter of the year (1 to 4).
      - `yearNumber` string — The year as a string.
      - `monthNumber` string — The month as a string (e.g., '1' for January).
      - `fullDate` string, date — The full date in 'YYYY-MM-DD' format.
    - `reviewer` DimReviewer — Reviewer dimension
      - `internalId` integer — A unique internal identifier for the reviewer.
      - `accountUserId` string — A unique identifier for the account user associated with the reviewer.
      - `firstName` string — The first name of the reviewer.
      - `lastName` string — The last name of the reviewer.
      - `userEmail` string — The email address of the reviewer.
      - `accountUserLocationId` string — The identifier for the location associated with the user's account.
      - `membership` string — Displays the type of membership the user has with the account: member, collaborator(guest).
      - `createdAt` string, date-time — The date and time when the reviewer's account was created. Timestamp with 'YYYY-MM-DDTHH:MM:SSZ' format.
      - `lastModifiedAt` string, date-time — The date and time when the reviewer's account was last modified. Timestamp with 'YYYY-MM-DDTHH:MM:SSZ' format.
      - `deletedAt` string, date-time — The date and time when the reviewer's account was deleted, if applicable. Timestamp with 'YYYY-MM-DDTHH:MM:SSZ' format.
      - `vendorId` string — The identifier for the vendor associated with the reviewer.
      - `vendorName` string — The name of the vendor associated with the reviewer.
      - `deleted` boolean — A boolean indicating whether the reviewer's account has been deleted.
    - `customerReviewDate` DimDate — Date dimension
      - `internalId` integer — A unique internal identifier for the date.
      - `year` integer — The year of the date.
      - `month` integer — The month of the date (1 for January, 2 for February, etc.).
      - `day` integer — The day of the month (1 to 31).
      - `dayOfWeek` integer — The day of the week as a number (1 for Monday, 2 for Tuesday, ..., 7 for Sunday).
      - `dayOfWeekName` string — The name of the day of the week (e.g., Monday, Tuesday, ..., Sunday).
      - `monthName` string — The name of the month (e.g., January, February, ..., December).
      - `dayOfYear` integer — The day of the year (1 to 366).
      - `quarter` integer — The quarter of the year (1 to 4).
      - `yearNumber` string — The year as a string.
      - `monthNumber` string — The month as a string (e.g., '1' for January).
      - `fullDate` string, date — The full date in 'YYYY-MM-DD' format.
    - `customerReviewer` DimCustomerReviewer — Customer reviewer dimension
      - `internalId` integer — A unique internal identifier for the customer reviewer.
      - `accountUserId` string — A unique identifier for the account user associated with the customer reviewer.
      - `firstName` string — The first name of the customer reviewer.
      - `lastName` string — The last name of the customer reviewer.
      - `userEmail` string — The email address of the customer reviewer.
      - `accountUserLocationId` string — The identifier for the location associated with the user's account.
      - `membership` string — Displays the type of membership the user has with the account: member, collaborator(guest).
      - `createdAt` string, date-time — The date and time when the customer reviewer's account was created. Timestamp with 'YYYY-MM-DDTHH:MM:SSZ' format.
      - `lastModifiedAt` string, date-time — The date and time when the customer reviewer's account was last modified. Timestamp with 'YYYY-MM-DDTHH:MM:SSZ' format.
      - `deletedAt` string, date-time — The date and time when the customer reviewer's account was deleted, if applicable. Timestamp with 'YYYY-MM-DDTHH:MM:SSZ' format.
      - `deleted` boolean — A boolean indicating whether the customer reviewer's account has been deleted.
    - `finalizationDate` DimDate — Date dimension
      - `internalId` integer — A unique internal identifier for the date.
      - `year` integer — The year of the date.
      - `month` integer — The month of the date (1 for January, 2 for February, etc.).
      - `day` integer — The day of the month (1 to 31).
      - `dayOfWeek` integer — The day of the week as a number (1 for Monday, 2 for Tuesday, ..., 7 for Sunday).
      - `dayOfWeekName` string — The name of the day of the week (e.g., Monday, Tuesday, ..., Sunday).
      - `monthName` string — The name of the month (e.g., January, February, ..., December).
      - `dayOfYear` integer — The day of the year (1 to 366).
      - `quarter` integer — The quarter of the year (1 to 4).
      - `yearNumber` string — The year as a string.
      - `monthNumber` string — The month as a string (e.g., '1' for January).
      - `fullDate` string, date — The full date in 'YYYY-MM-DD' format.

## Other responses

- `400` — Bad Request. The request could not be understood by the server. Check error message and details to further understand the cause.
- `401` — Unauthorized request. The user could not be identified.
- `403` — Forbidden request. The user does not have the necessary permissions for the resource.

---

[API](https://skmtc.net/rws/apis/trados-data-bridge-api.md) · [All operations](https://skmtc.net/rws/apis/trados-data-bridge-api/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/rws/trados-data-bridge-api/versions/823ba45e799c/schema)
