​
Properties

​
Root

​
id
string
App ID - It should be prefixed with appx_ for private apps and app_ for public apps. It should be unique across all apps. Your app ID can only contain letters & numbers. Example: appx_myapp123.
​
name
string
App name - The name of your app. Example: My App.
​
homepage
string
Homepage - The URL of your app’s homepage of your own documentation. Example: https://myapp.com.
​
author
string
Author - The name of the author of the app. Example: ACME Organization.
​
icon_url
string
Icon URL - The URL of the icon of your app. Example: https://myapp.com/icon.png.
​
short_description
string
Short description - A short description of your app. Example: My App is a great app that does great things.
​
description
string
Description - A detailed description of your app. Example: My App is a great app that does great things. It's the best app ever!.
​
version
string
Version - The version of your app. Example: 1.0.0.
​
ui_endpoint
string
UI endpoint - The URL of your app’s UI that will be embedded as an iframe in the Ridiam Console. Example: https://myapp.com.
​
webhook_endpoint
string
Webhook endpoint - The URL of your app’s webhook endpoint. Example: https://myapp.com/api/webhooks.
​
tasks
array
Tasks - An array of tasks that your app can perform. See Task properties for more details.
​
data_hooks
array
Data hooks - An array of data hooks that your app can listen to.See Data hook properties for more details.
​
sql_access
object
SQL access - An object containing your app’s SQL access. See SQL access properties for more details.
​
extra_columns
array
Extra columns - An array of extra columns that your app can add to the user table. See Extra column properties for more details.
​
app_tables
array
App tables - An array of extra tables that your app can add to the database. See App table properties for more details.
​
cube_schemas
object
Cube schemas - A object containing your app tables Cube schemas. See Cube schemas properties for more details.

​
Task

​
id
string
Task ID - The ID of the task, prefixed by your app ID. Example: appx_myapp123_task_1.
​
name
string
Task name - The name of the task. Example: Task 1.
​
description
string
Task description - A description of the task. Example: Example of task.
​
is_cron
boolean
Is cron - Whether the task is a periodic cron job. Example: true.
​
minutes_interval
integer
Minutes interval - The interval in minutes for the cron job. Example: 720.
​
on_multiple_exec
enum
On multiple exec - What to do when the task is executed multiple times concurently. Values: allow, discard_new, retry_later, abort_existing.

​
Data hook

​
id
string
Data hook ID - The ID of the data hook, prefixed by your app ID. Example: appx_myapp123_on_create_user.
​
name
string
Data hook name - The name of the data hook. Example: On create.
​
on
enum
On - When the data hook should be triggered. Values: on_validation, on_success.
​
for
array
For - The kind of data and actions that the data hook should listen to. See Data hook for for more details.

​
Data hook for

​
kind
string
Data kind - The kind of data that the data hook should listen to. Values: user, segment, order, order_item, cart, cart_item, session, custom_event, pageview, appx_myapp_custom_table…
​
action
string
Action - Only for on_success hooks. The action that the data hook should listen to. Values: create, update. For kind == segment values are exit, enter.

​
SQL access

​
predefined_queries
array
Predefined queries - An array of predefined SQL queries that your app can perform. See SQL query properties for more details.
​
tables_permissions
array
Tables permissions - An array of tables that your app can access. See SQL tables permissions for more details.

​
SQL predefined-query

​
id
string
SQL query ID - The ID of the SQL query, prefixed by your app ID. Example: appx_myapp123_sql_query_1.
​
type
enum
SQL query type - The type of the SQL query. Values: select.
​
name
string
SQL query name - The name of the SQL query. Example: SQL query 1.
​
description
string
SQL query description - A description of the SQL query. Example: Example of predefined SQL query.
​
query
string
SQL query - Use * to get full access or provide the specific query like SELECT * FROM `user` WHERE external_id = ?.
​
test_args
array
Test arguments - An array of test arguments for the SQL query. Example: ["user_123"].

​
SQL tables permissions

​
table
string
Table - The name of the table. Values: user, segment, order, order_item, cart, cart_item, session, custom_event, pageview, appx_myapp_custom_table…
​
read
boolean
Read - Whether the app can read the table. Example: true.
​
write
boolean
Write - Whether the app can write to the table. Example: true.

​
Extra column

​
kind
string
Kind - The kind of data that the extra column should be added to. Example: user, order, order_item, session, pageview, custom_event, cart, cart_item.
​
columns
array
Columns - An array of columns that should be added to the kind. See Column properties for more details.

​
App table

​
name
string
Table name - The name of the table prefixed by your app ID. Example: appx_myapp123_table_1.
​
description
string
Table description - A description of the table. Example: Example of extra table.
​
shard_key
array
Shard key - An array of columns that should be used as the shard key. Example: ["user_id"].
​
unique_key
array
Unique key - An array of columns that should be used as the unique key. The unique_key should at least contain all columns defined in shard_key. Example: ["id", "user_id"].
​
sort_key
array
Sort key - An array of columns that should be used to store the data in a specific order in the database. Example: ["created_at"].
​
columns
array
Columns - An array of columns that should be added to the table. See Column properties for more details.
​
indexes
array
Indexes - An array of indexes that should be added to the table. See Index properties for more details.

​
Table column

​
name
string
Column name - The name of the column. For extra columns, it should be prefixed by your app ID. Example: appx_myapp123_column_a.
​
type
enum
Column type - The type of the column. Values: boolean, number, date, datetime, timestamp, varchar, longtext, json.
​
size
integer
Column size - The size of the column. Required for varchar types. Example: 128.
​
is_required
boolean
Is required - Whether the column is required when inserting records. Example: true.
​
description
string
Column description - A description of the column. Example: Example of extra column.
​
default_boolean
boolean
Default boolean - The default value for the column. Example: true.
​
default_number
number
Default number - The default value for the column. Example: 123.
​
default_date
string
Default date - The default value for the column. Example: 2022-01-01.
​
default_datetime
string
Default datetime - The default value for the column. Example: 2022-01-01T00:00:00Z.
​
default_timestamp
string
Default timestamp - The default value for the column. Example: CURRENT_TIMESTAMP.
​
default_text
string
Default text - The default value for the column. Example: Hello world.
​
default_json
object
Default JSON - The default value for the column. Example: {"key": "value"}.
​
extra_definition
string
Extra definition - The extra definition for the column. Example: ON UPDATE CURRENT_TIMESTAMP.
​
hide_in_analytics
boolean
Hide in analytics - Whether the column should be hidden in analytics. Example: true.

​
Table index

​
name
string
Index name - The name of the index. Example: index_column_varchar.
​
columns
array
Columns - An array of columns that should be used for the index. Example: ["column_varchar"].

​
Cube schemas

Please refer to the Cube schemas documentation for more details.

​
Full example

{
  "id": "appx_default",
  "name": "Default Rimdian app template",
  "homepage": "https://yourwebsite.com",
  "author": "Your Organization",
  "icon_url": "https://eu.rimdian.com/images/apps/custom_app.png",
  "short_description": "Default Rimdian app template.",
  "description": "Default Rimdian app template.",
  "version": "1.0.0",
  "ui_endpoint": "https://localhost:3000",
  "webhook_endpoint": "https://localhost:3000/api/webhooks",
  "tasks": [
    {
      "id": "appx_default_task_1",
      "name": "Task 1",
      "description": "Example of manual task",
      "is_cron": false,
      "on_multiple_exec": "abort_existing"
    },
    {
      "id": "appx_default_task_2",
      "name": "Task 2",
      "description": "Example of cron task",
      "is_cron": true,
      "minutes_interval": 720,
      "on_multiple_exec": "discard_new"
    }
  ],
  "data_hooks": [
    {
      "id": "appx_default_on_create_user",
      "name": "On create",
      "on": "on_success",
      "for": [
        {
          "kind": "user",
          "action": "create"
        }
      ]
    },
    {
      "id": "appx_default_on_update_user",
      "name": "On update",
      "on": "on_success",
      "for": [
        {
          "kind": "user",
          "action": "update"
        }
      ]
    },
    {
      "id": "appx_default_on_exit_segment",
      "name": "On exit segment",
      "on": "on_success",
      "for": [
        {
          "kind": "segment",
          "action": "exit"
        }
      ]
    }
  ],
  "sql_access": {
    "predefined_queries": [
      {
        "id": "appx_default_sql_query_1",
        "type": "select",
        "name": "SQL query 1",
        "description": "Example of predefined SQL query. For security reasons, use predefined queries to just fetch the data you needs",
        "query": "SELECT * FROM `user` WHERE external_id = ?",
        "test_args": ["auth-54-22"]
      }
    ],
    "tables_permissions": [
      {
        "table": "user",
        "read": true,
        "write": false
      },
      {
        "table": "session",
        "read": true,
        "write": false
      }
    ]
  },
  "extra_columns": [
    {
      "kind": "user",
      "columns": [
        {
          "name": "appx_default_column_1",
          "type": "varchar",
          "size": 128,
          "is_required": false,
          "description": "Example of extra column"
        }
      ]
    }
  ],
  "app_tables": [
    {
      "name": "appx_default_table_1",
      "description": "Example of extra table",
      "shard_key": ["id"],
      "unique_key": ["id"],
      "sort_key": ["created_at"],
      "indexes": [
        {
          "name": "index_column_varchar",
          "columns": ["column_varchar"]
        }
      ],
      "columns": [
        {
          "name": "id",
          "type": "varchar",
          "size": 64,
          "description": "id",
          "is_required": true
        },
        {
          "name": "external_id",
          "type": "varchar",
          "size": 256,
          "description": "external_id",
          "is_required": true
        },
        {
          "name": "created_at",
          "type": "datetime",
          "description": "created_at",
          "is_required": true
        },
        {
          "name": "updated_at",
          "type": "datetime",
          "description": "updated_at",
          "is_required": false,
          "hide_in_analytics": true
        },
        {
          "name": "user_id",
          "type": "varchar",
          "size": 64,
          "description": "user_id",
          "is_required": true,
          "hide_in_analytics": true
        },
        {
          "name": "merged_from_user_id",
          "type": "varchar",
          "size": 64,
          "description": "merged_from_user_id",
          "is_required": false,
          "hide_in_analytics": true
        },
        {
          "name": "fields_timestamp",
          "type": "json",
          "description": "fields_timestamp",
          "is_required": true,
          "hide_in_analytics": true
        },
        {
          "name": "db_created_at",
          "type": "timestamp",
          "size": 6,
          "default_timestamp": "CURRENT_TIMESTAMP(6)",
          "description": "db_created_at",
          "is_required": true,
          "hide_in_analytics": true
        },
        {
          "name": "db_updated_at",
          "type": "timestamp",
          "size": 6,
          "default_timestamp": "CURRENT_TIMESTAMP(6)",
          "extra_definition": "ON UPDATE CURRENT_TIMESTAMP",
          "description": "db_created_at",
          "is_required": true,
          "hide_in_analytics": true
        },
        {
          "name": "column_varchar",
          "type": "varchar",
          "size": 128,
          "description": "Example of varchar column",
          "is_required": false
        },
        {
          "name": "column_number",
          "type": "number",
          "description": "Example of number column",
          "is_required": false
        },
        {
          "name": "column_boolean",
          "type": "boolean",
          "description": "Example of boolean column",
          "is_required": false
        },
        {
          "name": "column_datetime",
          "type": "datetime",
          "description": "Example of datetime column",
          "is_required": false
        },
        {
          "name": "column_json",
          "type": "json",
          "description": "Example of json column",
          "is_required": false
        }
      ]
    }
  ],
  "cube_schemas": {
    "Appx_default_table_1": {
      "sql": "SELECT * FROM appx_default_table_1",
      "title": "App table 1",
      "description": "App table 1 description",
      "joins": {
        "Appx_myapp_table_2": {
          "relationship": "one_to_many",
          "sql": "${CUBE}.external_id = ${Appx_myapp_table_2}.table1_external_id"
        }
      },
      "measures": {
        "count": {
          "title": "Count",
          "type": "count",
          "sql": "id",
          "description": "The number of lines"
        }
      },
      "dimensions": {
        "id": {
          "title": "ID",
          "type": "string",
          "sql": "id",
          "primaryKey": true,
          "description": "ID (sha1 of external_id)"
        },
        "external_id": {
          "title": "External ID",
          "type": "string",
          "sql": "external_id",
          "description": "External ID"
        },
        "created_at": {
          "title": "Created at",
          "type": "datetime",
          "sql": "created_at",
          "description": "Created at"
        },
        ...
      }
    },
    "Appx_default_table_2": { 
      ...
    }
  }
}