Cloud Tables

API References for Cloud Data Storage Service

Explore the list of API functions available in TypeScript for managing tables, including detailed descriptions and usage examples.

To use service functions, first ensure that the service is activated before. You can see services by opening "Service Hub" From the game's dashboard header.

Find Rows​

This function helps to find some rows with specific conditions, if table's permission was set to 'Users rows', you can get only rows that were inserted by current user. Find functions accept some options:

Skip, Limit: Skip and limit help you to implement.

Sorts: This item accepts a dictionary of the field's name and the enum of order.

Joins: This item helps you to join multiple tables with specific conditions. Every Join has these items:

new JoinParams{
    TableName = "Another Table ID",
    foreignField = "col name",
    localField = "col name"
}

Conditions: This item helps to get specific rows, conditions have two types, Single and Combiners.

• Single: These conditions apply a logic to queries:

new Eq("player_ startid", 20).ToQuery(),

• Combiners: And-Or conditions give the ability to combine multiple conditions.

new And(
    new Eq("player_id", 20),
    new Eq("status", 1)
).ToQuery(),

DynamicPixels.Table.Find(input: FindParams): Promise<object[]>;

Find Row By ID​

This function return a row with specific id, if table's permission was set to 'Users rows', you can get only rows that were inserted by current user.

DynamicPixels.Table.FindById(input: FindByIdParams): Promise<object>;

Find Row By ID Then Delete​

This function deletes a row with specific id and will return the last values of it, if table's permission was set to 'Users rows', you can get only rows that were inserted by current user.

DynamicPixels.Table.FindByIdAndDelete(input: FindByIdAndDeleteParams): Promise<object>;

Find Row By ID Then Update​

This function update a row with specific id and will return the last values of it, if table's permission was set to 'Users rows', you can get only rows that were inserted by the current user.

DynamicPixels.Table.FindByIdAndUpdate(input: FindByIdAndUpdateParams): Promise<object>;

Insert New Row​

This function inserts a new row with passed data and return new created row.

DynamicPixels.Table.Insert(input: InsertParams): Promise<object>;

Insert Many Rows​

This function inserts multiple rows with passed data and returns new created rows.

DynamicPixels.Table.InsertMany(input: InsertManyParams): void;

Update many Rows​

You can update multiple rows with specific conditions with this function.

DynamicPixels.Table.UpdateMany(input: UpdateManyParams): void;

Delete Row By ID​

This function deletes a row with a specific id

DynamicPixels.Table.Delete(input: DeleteParams): Promise<object>;

Delete Many Rows​

This function deletes multiple rows with specific ids

DynamicPixels.Table.DeleteMany(input: DeleteManyParams): void;