> For the complete documentation index, see [llms.txt](https://dynamicpixels.gitbook.io/dynamicpixels-docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://dynamicpixels.gitbook.io/dynamicpixels-docs/web-api/cloud-tables.md).

# Cloud Tables

Explore the list of Web APIs functions available for managing tables, including detailed descriptions and usage examples.

{% hint style="warning" %}
To use services functions, first ensure that the service is activated before. You can see services by opening "Service Hub" From game's dashboard header. 
{% endhint %}

## DELETE /api/table/{tableId}/{rowId}

> Finds and deletes a row by its unique identifier.

```json
{"openapi":"3.0.4","info":{"title":"DynamicPixels GameService V2","version":"v2"},"paths":{"/api/table/{tableId}/{rowId}":{"delete":{"tags":["Tables"],"summary":"Finds and deletes a row by its unique identifier.","operationId":"DeleteByID","parameters":[{"name":"tableId","in":"path","required":true,"schema":{"type":"string"}},{"name":"rowId","in":"path","required":true,"schema":{"type":"integer","format":"int32"}}],"responses":{"200":{"description":"OK","content":{"text/plain":{"schema":{"$ref":"#/components/schemas/ObjectRowResponse"}},"application/json":{"schema":{"$ref":"#/components/schemas/ObjectRowResponse"}},"text/json":{"schema":{"$ref":"#/components/schemas/ObjectRowResponse"}}}}}}}},"components":{"schemas":{"ObjectRowResponse":{"type":"object","properties":{"row":{"nullable":true}},"additionalProperties":false}}}}
```

## PUT /api/table/{tableId}/delete

> Deletes a row from the table.

```json
{"openapi":"3.0.4","info":{"title":"DynamicPixels GameService V2","version":"v2"},"paths":{"/api/table/{tableId}/delete":{"put":{"tags":["Tables"],"summary":"Deletes a row from the table.","operationId":"Delete","parameters":[{"name":"tableId","in":"path","required":true,"schema":{"type":"string"}}],"requestBody":{"content":{"application/json":{"schema":{"$ref":"#/components/schemas/DeleteByConditionRequest"}},"text/json":{"schema":{"$ref":"#/components/schemas/DeleteByConditionRequest"}},"application/*+json":{"schema":{"$ref":"#/components/schemas/DeleteByConditionRequest"}}}},"responses":{"200":{"description":"OK","content":{"text/plain":{"schema":{"$ref":"#/components/schemas/ActionResponse"}},"application/json":{"schema":{"$ref":"#/components/schemas/ActionResponse"}},"text/json":{"schema":{"$ref":"#/components/schemas/ActionResponse"}}}}}}}},"components":{"schemas":{"DeleteByConditionRequest":{"required":["conditions"],"type":"object","properties":{"conditions":{"$ref":"#/components/schemas/QueryParam"}},"additionalProperties":false},"QueryParam":{"type":"object","properties":{"op":{"type":"string","nullable":true},"field":{"type":"string","nullable":true},"value":{"nullable":true},"values":{"type":"array","items":{},"nullable":true},"list":{"type":"array","items":{"$ref":"#/components/schemas/QueryParam"},"nullable":true}},"additionalProperties":false},"ActionResponse":{"type":"object","properties":{"affected":{"type":"integer","format":"int32"}},"additionalProperties":false}}}}
```

## POST /api/table/{tableId}/delete

> Deletes multiple rows from the table.

```json
{"openapi":"3.0.4","info":{"title":"DynamicPixels GameService V2","version":"v2"},"paths":{"/api/table/{tableId}/delete":{"post":{"tags":["Tables"],"summary":"Deletes multiple rows from the table.","operationId":"DeleteByIDs","parameters":[{"name":"tableId","in":"path","required":true,"schema":{"type":"string"}}],"requestBody":{"content":{"application/json":{"schema":{"$ref":"#/components/schemas/DeleteByIdsRequest"}},"text/json":{"schema":{"$ref":"#/components/schemas/DeleteByIdsRequest"}},"application/*+json":{"schema":{"$ref":"#/components/schemas/DeleteByIdsRequest"}}}},"responses":{"200":{"description":"OK","content":{"text/plain":{"schema":{"$ref":"#/components/schemas/ActionResponse"}},"application/json":{"schema":{"$ref":"#/components/schemas/ActionResponse"}},"text/json":{"schema":{"$ref":"#/components/schemas/ActionResponse"}}}}}}}},"components":{"schemas":{"DeleteByIdsRequest":{"required":["ids"],"type":"object","properties":{"ids":{"type":"array","items":{"type":"integer","format":"int32"}}},"additionalProperties":false},"ActionResponse":{"type":"object","properties":{"affected":{"type":"integer","format":"int32"}},"additionalProperties":false}}}}
```

## POST /api/table/{tableId}/find-one-and-delete

>

```json
{"openapi":"3.0.4","info":{"title":"DynamicPixels GameService V2","version":"v2"},"paths":{"/api/table/{tableId}/find-one-and-delete":{"post":{"tags":["Tables"],"operationId":"DeleteOne","parameters":[{"name":"tableId","in":"path","required":true,"schema":{"type":"string"}}],"requestBody":{"content":{"application/json":{"schema":{"$ref":"#/components/schemas/FindOneAndDeleteRequest"}},"text/json":{"schema":{"$ref":"#/components/schemas/FindOneAndDeleteRequest"}},"application/*+json":{"schema":{"$ref":"#/components/schemas/FindOneAndDeleteRequest"}}}},"responses":{"200":{"description":"OK","content":{"text/plain":{"schema":{"$ref":"#/components/schemas/Row"}},"application/json":{"schema":{"$ref":"#/components/schemas/Row"}},"text/json":{"schema":{"$ref":"#/components/schemas/Row"}}}}}}}},"components":{"schemas":{"FindOneAndDeleteRequest":{"type":"object","properties":{"conditions":{"$ref":"#/components/schemas/QueryParam"},"joins":{"type":"array","items":{"$ref":"#/components/schemas/JoinParams"},"nullable":true}},"additionalProperties":false},"QueryParam":{"type":"object","properties":{"op":{"type":"string","nullable":true},"field":{"type":"string","nullable":true},"value":{"nullable":true},"values":{"type":"array","items":{},"nullable":true},"list":{"type":"array","items":{"$ref":"#/components/schemas/QueryParam"},"nullable":true}},"additionalProperties":false},"JoinParams":{"type":"object","properties":{"table_name":{"type":"string","nullable":true},"local_field":{"type":"string","nullable":true},"foreign_field":{"type":"string","nullable":true}},"additionalProperties":false},"Row":{"type":"object","properties":{"id":{"type":"integer","format":"int32"}},"additionalProperties":false}}}}
```

## PUT /api/table/{tableId}

> Finds rows in a table based on the provided parameters.

```json
{"openapi":"3.0.4","info":{"title":"DynamicPixels GameService V2","version":"v2"},"paths":{"/api/table/{tableId}":{"put":{"tags":["Tables"],"summary":"Finds rows in a table based on the provided parameters.","operationId":"FindMany","parameters":[{"name":"tableId","in":"path","required":true,"schema":{"type":"string"}},{"name":"skip","in":"query","schema":{"type":"integer","format":"int32","default":0}},{"name":"limit","in":"query","schema":{"type":"integer","format":"int32","default":25}}],"requestBody":{"content":{"application/json":{"schema":{"$ref":"#/components/schemas/FindRequest"}},"text/json":{"schema":{"$ref":"#/components/schemas/FindRequest"}},"application/*+json":{"schema":{"$ref":"#/components/schemas/FindRequest"}}}},"responses":{"200":{"description":"OK","content":{"text/plain":{"schema":{"type":"array","items":{}}},"application/json":{"schema":{"type":"array","items":{}}},"text/json":{"schema":{"type":"array","items":{}}}}}}}}},"components":{"schemas":{"FindRequest":{"type":"object","properties":{"conditions":{"$ref":"#/components/schemas/QueryParam"},"sorts":{"type":"object","additionalProperties":{"type":"string"},"nullable":true},"joins":{"type":"array","items":{"$ref":"#/components/schemas/JoinParams"},"nullable":true}},"additionalProperties":false},"QueryParam":{"type":"object","properties":{"op":{"type":"string","nullable":true},"field":{"type":"string","nullable":true},"value":{"nullable":true},"values":{"type":"array","items":{},"nullable":true},"list":{"type":"array","items":{"$ref":"#/components/schemas/QueryParam"},"nullable":true}},"additionalProperties":false},"JoinParams":{"type":"object","properties":{"table_name":{"type":"string","nullable":true},"local_field":{"type":"string","nullable":true},"foreign_field":{"type":"string","nullable":true}},"additionalProperties":false}}}}
```

## PUT /api/table/{tableId}/update

> Updates multiple rows in the table.

```json
{"openapi":"3.0.4","info":{"title":"DynamicPixels GameService V2","version":"v2"},"paths":{"/api/table/{tableId}/update":{"put":{"tags":["Tables"],"summary":"Updates multiple rows in the table.","operationId":"UpdateMany","parameters":[{"name":"tableId","in":"path","required":true,"schema":{"type":"string"}},{"name":"rowId","in":"query","schema":{"type":"integer","format":"int32"}}],"requestBody":{"content":{"application/json":{"schema":{"$ref":"#/components/schemas/UpdateManyRequest"}},"text/json":{"schema":{"$ref":"#/components/schemas/UpdateManyRequest"}},"application/*+json":{"schema":{"$ref":"#/components/schemas/UpdateManyRequest"}}}},"responses":{"200":{"description":"OK","content":{"text/plain":{"schema":{"$ref":"#/components/schemas/Row"}},"application/json":{"schema":{"$ref":"#/components/schemas/Row"}},"text/json":{"schema":{"$ref":"#/components/schemas/Row"}}}}}}}},"components":{"schemas":{"UpdateManyRequest":{"required":["data"],"type":"object","properties":{"data":{"type":"object","additionalProperties":{}},"conditions":{"$ref":"#/components/schemas/QueryParam"}},"additionalProperties":false},"QueryParam":{"type":"object","properties":{"op":{"type":"string","nullable":true},"field":{"type":"string","nullable":true},"value":{"nullable":true},"values":{"type":"array","items":{},"nullable":true},"list":{"type":"array","items":{"$ref":"#/components/schemas/QueryParam"},"nullable":true}},"additionalProperties":false},"Row":{"type":"object","properties":{"id":{"type":"integer","format":"int32"}},"additionalProperties":false}}}}
```

## POST /api/table/{tableId}

> Inserts a new row into the table.

```json
{"openapi":"3.0.4","info":{"title":"DynamicPixels GameService V2","version":"v2"},"paths":{"/api/table/{tableId}":{"post":{"tags":["Tables"],"summary":"Inserts a new row into the table.","operationId":"Insert","parameters":[{"name":"tableId","in":"path","required":true,"schema":{"type":"string"}}],"requestBody":{"content":{"application/json":{"schema":{"$ref":"#/components/schemas/InsertRowRequest"}},"text/json":{"schema":{"$ref":"#/components/schemas/InsertRowRequest"}},"application/*+json":{"schema":{"$ref":"#/components/schemas/InsertRowRequest"}}}},"responses":{"200":{"description":"OK","content":{"text/plain":{"schema":{"$ref":"#/components/schemas/Row"}},"application/json":{"schema":{"$ref":"#/components/schemas/Row"}},"text/json":{"schema":{"$ref":"#/components/schemas/Row"}}}}}}}},"components":{"schemas":{"InsertRowRequest":{"required":["data"],"type":"object","properties":{"data":{"type":"object","additionalProperties":{}}},"additionalProperties":false},"Row":{"type":"object","properties":{"id":{"type":"integer","format":"int32"}},"additionalProperties":false}}}}
```

## POST /api/table/{tableId}/insert

> Inserts multiple new rows into the table.

```json
{"openapi":"3.0.4","info":{"title":"DynamicPixels GameService V2","version":"v2"},"paths":{"/api/table/{tableId}/insert":{"post":{"tags":["Tables"],"summary":"Inserts multiple new rows into the table.","operationId":"InsertMany","parameters":[{"name":"tableId","in":"path","required":true,"schema":{"type":"string"}}],"requestBody":{"content":{"application/json":{"schema":{"$ref":"#/components/schemas/InsertRowsRequest"}},"text/json":{"schema":{"$ref":"#/components/schemas/InsertRowsRequest"}},"application/*+json":{"schema":{"$ref":"#/components/schemas/InsertRowsRequest"}}}},"responses":{"200":{"description":"OK","content":{"text/plain":{"schema":{"$ref":"#/components/schemas/Row"}},"application/json":{"schema":{"$ref":"#/components/schemas/Row"}},"text/json":{"schema":{"$ref":"#/components/schemas/Row"}}}}}}}},"components":{"schemas":{"InsertRowsRequest":{"required":["data"],"type":"object","properties":{"data":{"type":"array","items":{}}},"additionalProperties":false},"Row":{"type":"object","properties":{"id":{"type":"integer","format":"int32"}},"additionalProperties":false}}}}
```

## GET /api/table/{tableId}/{rowId}

> Finds a row by its unique identifier.

```json
{"openapi":"3.0.4","info":{"title":"DynamicPixels GameService V2","version":"v2"},"paths":{"/api/table/{tableId}/{rowId}":{"get":{"tags":["Tables"],"summary":"Finds a row by its unique identifier.","operationId":"FindByID","parameters":[{"name":"tableId","in":"path","required":true,"schema":{"type":"string"}},{"name":"rowId","in":"path","required":true,"schema":{"type":"integer","format":"int32"}}],"responses":{"200":{"description":"OK","content":{"text/plain":{"schema":{"type":"array","items":{"$ref":"#/components/schemas/Row"}}},"application/json":{"schema":{"type":"array","items":{"$ref":"#/components/schemas/Row"}}},"text/json":{"schema":{"type":"array","items":{"$ref":"#/components/schemas/Row"}}}}}}}}},"components":{"schemas":{"Row":{"type":"object","properties":{"id":{"type":"integer","format":"int32"}},"additionalProperties":false}}}}
```

## PUT /api/table/{tableId}/{rowId}

> Finds a row by its unique identifier and updates it.

```json
{"openapi":"3.0.4","info":{"title":"DynamicPixels GameService V2","version":"v2"},"paths":{"/api/table/{tableId}/{rowId}":{"put":{"tags":["Tables"],"summary":"Finds a row by its unique identifier and updates it.","operationId":"Update","parameters":[{"name":"tableId","in":"path","required":true,"schema":{"type":"string"}},{"name":"rowId","in":"path","required":true,"schema":{"type":"integer","format":"int32"}}],"requestBody":{"content":{"application/json":{"schema":{"$ref":"#/components/schemas/UpdateRowRequest"}},"text/json":{"schema":{"$ref":"#/components/schemas/UpdateRowRequest"}},"application/*+json":{"schema":{"$ref":"#/components/schemas/UpdateRowRequest"}}}},"responses":{"200":{"description":"OK","content":{"text/plain":{"schema":{"$ref":"#/components/schemas/Row"}},"application/json":{"schema":{"$ref":"#/components/schemas/Row"}},"text/json":{"schema":{"$ref":"#/components/schemas/Row"}}}}}}}},"components":{"schemas":{"UpdateRowRequest":{"required":["data"],"type":"object","properties":{"data":{"type":"object","additionalProperties":{}}},"additionalProperties":false},"Row":{"type":"object","properties":{"id":{"type":"integer","format":"int32"}},"additionalProperties":false}}}}
```

## POST /api/table/{tableId}/find-one

>

```json
{"openapi":"3.0.4","info":{"title":"DynamicPixels GameService V2","version":"v2"},"paths":{"/api/table/{tableId}/find-one":{"post":{"tags":["Tables"],"operationId":"FindOne","parameters":[{"name":"tableId","in":"path","required":true,"schema":{"type":"string"}}],"requestBody":{"content":{"application/json":{"schema":{"$ref":"#/components/schemas/FindOneRequest"}},"text/json":{"schema":{"$ref":"#/components/schemas/FindOneRequest"}},"application/*+json":{"schema":{"$ref":"#/components/schemas/FindOneRequest"}}}},"responses":{"200":{"description":"OK","content":{"text/plain":{"schema":{"$ref":"#/components/schemas/Row"}},"application/json":{"schema":{"$ref":"#/components/schemas/Row"}},"text/json":{"schema":{"$ref":"#/components/schemas/Row"}}}}}}}},"components":{"schemas":{"FindOneRequest":{"type":"object","properties":{"conditions":{"$ref":"#/components/schemas/QueryParam"},"joins":{"type":"array","items":{"$ref":"#/components/schemas/JoinParams"},"nullable":true}},"additionalProperties":false},"QueryParam":{"type":"object","properties":{"op":{"type":"string","nullable":true},"field":{"type":"string","nullable":true},"value":{"nullable":true},"values":{"type":"array","items":{},"nullable":true},"list":{"type":"array","items":{"$ref":"#/components/schemas/QueryParam"},"nullable":true}},"additionalProperties":false},"JoinParams":{"type":"object","properties":{"table_name":{"type":"string","nullable":true},"local_field":{"type":"string","nullable":true},"foreign_field":{"type":"string","nullable":true}},"additionalProperties":false},"Row":{"type":"object","properties":{"id":{"type":"integer","format":"int32"}},"additionalProperties":false}}}}
```

## POST /api/table/{tableId}/find-one-and-update

>

```json
{"openapi":"3.0.4","info":{"title":"DynamicPixels GameService V2","version":"v2"},"paths":{"/api/table/{tableId}/find-one-and-update":{"post":{"tags":["Tables"],"operationId":"FindOneAndUpdate","parameters":[{"name":"tableId","in":"path","required":true,"schema":{"type":"string"}}],"requestBody":{"content":{"application/json":{"schema":{"$ref":"#/components/schemas/FindOneAndUpdateRequest"}},"text/json":{"schema":{"$ref":"#/components/schemas/FindOneAndUpdateRequest"}},"application/*+json":{"schema":{"$ref":"#/components/schemas/FindOneAndUpdateRequest"}}}},"responses":{"200":{"description":"OK","content":{"text/plain":{"schema":{"$ref":"#/components/schemas/Row"}},"application/json":{"schema":{"$ref":"#/components/schemas/Row"}},"text/json":{"schema":{"$ref":"#/components/schemas/Row"}}}}}}}},"components":{"schemas":{"FindOneAndUpdateRequest":{"required":["data"],"type":"object","properties":{"conditions":{"$ref":"#/components/schemas/QueryParam"},"joins":{"type":"array","items":{"$ref":"#/components/schemas/JoinParams"},"nullable":true},"data":{"type":"object","additionalProperties":{}}},"additionalProperties":false},"QueryParam":{"type":"object","properties":{"op":{"type":"string","nullable":true},"field":{"type":"string","nullable":true},"value":{"nullable":true},"values":{"type":"array","items":{},"nullable":true},"list":{"type":"array","items":{"$ref":"#/components/schemas/QueryParam"},"nullable":true}},"additionalProperties":false},"JoinParams":{"type":"object","properties":{"table_name":{"type":"string","nullable":true},"local_field":{"type":"string","nullable":true},"foreign_field":{"type":"string","nullable":true}},"additionalProperties":false},"Row":{"type":"object","properties":{"id":{"type":"integer","format":"int32"}},"additionalProperties":false}}}}
```