---
title: "Projects (Localazy)"
description: "Projects"
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/localazy/Localazy.Localazy.Projects
original: https://documentation.invantive.eu/en/datamodels/localazy/Localazy.Localazy.Projects
updated: 2026-11-01T16:18:45Z
license: https://documentation.invantive.eu/en/
---

# Projects: Localazy Projects

`insert` `REST`

- Catalog: `Localazy`
- Schema: `Localazy`
- Primary Keys: `id`
- Label: Projects

Can retrieve data and change data using `insert`.

## Summary

Projects.

## API Source

- Endpoint: `/projects?organization=true&languages=true`

## Performance Characteristics

| Characteristic | Value |
|---|---:|
| Average access latency (ms) | 137 |
| Full scan rows per minute | 1,310 |

The result can be cached on the client.

## Table Columns

The columns of the table `Projects` are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|:---:|---|---|
| `description` | `varchar2` | itgen_lcy_description | [ ] | filters on the platform, writable | Project description. |
| `id` | `varchar2` | ID | [x] | filters on the platform, writable | ID. |
| `image` | `varchar2` | itgen_lcy_image | [ ] | filters on the platform, writable | Full URL to the project image or empty string if there is no image available. |
| `name` | `varchar2` | Name | [x] | filters on the platform, writable | Project name. |
| `orgId` | `varchar2` | itgen_lcy_orgid | [x] | filters on the platform, writable | dentifier of the organization the project belongs to. |
| `organization_additionalMt` | `char` | itgen_lcy_organization_additionalmt | [x] | filters on the platform, writable, `organization.additionalMt` |  |
| `organization_availableKeys` | `int32` | itgen_lcy_organization_availablekeys | [x] | filters on the platform, writable, `organization.availableKeys` |  |
| `organization_connectedApps` | `char` | itgen_lcy_organization_connectedapps | [x] | filters on the platform, writable, `organization.connectedApps` |  |
| `organization_figma` | `char` | itgen_lcy_organization_figma | [x] | filters on the platform, writable, `organization.figma` |  |
| `organization_formatConversions` | `char` | itgen_lcy_organization_formatconversions | [x] | filters on the platform, writable, `organization.formatConversions` |  |
| `organization_mtPretranslate` | `char` | itgen_lcy_organization_mtpretranslate | [x] | filters on the platform, writable, `organization.mtPretranslate` |  |
| `organization_releaseTags` | `char` | itgen_lcy_organization_releasetags | [x] | filters on the platform, writable, `organization.releaseTags` |  |
| `organization_screenshots` | `char` | itgen_lcy_organization_screenshots | [x] | filters on the platform, writable, `organization.screenshots` |  |
| `organization_screenshotsForFigma` | `char` | itgen_lcy_organization_screenshotsforfigma | [x] | filters on the platform, writable, `organization.screenshotsForFigma` |  |
| `organization_usedKeys` | `int32` | itgen_lcy_organization_usedkeys | [x] | filters on the platform, writable, `organization.usedKeys` |  |
| `organization_webhooks` | `char` | itgen_lcy_organization_webhooks | [x] | filters on the platform, writable, `organization.webhooks` |  |
| `role` | `varchar2` | itgen_lcy_role | [x] | filters on the platform, writable | Role of the current user accessing API (based on the token); one of none, translator, trusted_translator, reviewer, manager, owner and developer. |
| `slug` | `varchar2` | itgen_lcy_slug | [x] | filters on the platform, writable | Project slug. Can be used instead of id in requests where projectId is required. |
| `sourceLanguage` | `int32` | itgen_lcy_sourcelanguage | [ ] | filters on the platform, writable | he identifier of the source language of the project. |
| `tone` | `varchar2` | itgen_lcy_tone | [x] | filters on the platform, writable | Project tone; one of not_specified, formal and informal. |
| `type` | `varchar2` | Type | [x] | filters on the platform, writable | Project type; one of public, private and restricted. |
| `url` | `varchar2` | itgen_lcy_url | [x] | filters on the platform, writable | Full URL to the project on Localazy. |

## Referenced By

- [ProjectLanguages](Localazy.Localazy.ProjectLanguages) `project_id` (Key)

## Sample Queries

```sql
--
-- Lcy Sample Query Projects
--
-- Table documentation: https://documentation.invantive.eu/2017R2/localazy-data-model/webhelp/localazy-connector-localazy-projects.html
--
select *
from   Localazy.Localazy.Projects@lcy
limit  100
```



## Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver:

- [Localazy](/en/release-notes/drivers?driver=localazy)

