Action Database CRUD

Performs reads, creations, updates, or deletes (CRUD) on the API-backed database collections.

Inputs: 1 · Outputs: Then

Settings

Setting	Type	Required	Default	Description
Operation	Select	Yes	Get	The CRUD action to perform: Get, Create, Update, or Delete.
Collection Name	String	Yes	—	The database collection to query or mutate (e.g. forumUser or forumSession).
Entry ID	String	No	—	The direct entry ID for targeted operations. Strongly recommended for update or delete.
Query JSON	Multiline	No	—	Optional JSON filter to locate entries by fields instead of entry ID.
Payload JSON	Multiline	Yes	—	JSON body written on create or merged into the existing entry on update.
Limit	Slider	No	1	Maximum number of entries to return when reading by query.
Skip	Number	No	0	Number of entries to skip before returning results.
Upsert When Missing	Boolean	No	false	If enabled during an update, a new entry is created if no matching entry exists.

Query and Payload Formats

Get Entries by Field Query

• Operation: Get
• Query JSON: {"minecraftUuid":"%player.uuid%"}
• Limit: 1

Create a New Entry

• Operation: Create
• Payload JSON: {"minecraftUuid":"%player.uuid%","forumUserId":"%forum_user_id%","registeredAt":"%date%"}

Update an Entry with Upsert

• Operation: Update
• Query JSON: {"minecraftUuid":"%player.uuid%"}
• Payload JSON: {"lastActive":"%date%","loginCount": 1}
• Upsert When Missing: Enabled