Asana integration summary

Stitch’s Asana integration replicates data using the Asana API. Refer to the Schema section for a list of objects available for replication.

Asana feature snapshot

A high-level look at Stitch's Asana (v2) integration, including release status, useful links, and the features supported in Stitch.

STITCH
Release status

Released on March 5, 2020

Supported by

Singer Community

Stitch plan

Standard

API availability

Available

Singer GitHub repository

singer-io/tap-asana

REPLICATION SETTINGS
Anchor Scheduling

Supported

Advanced Scheduling

Supported

Table-level reset

Unsupported

Configurable Replication Methods

Unsupported

DATA SELECTION
Table selection

Supported

Column selection

Supported

Select all

Supported

TRANSPARENCY
Extraction Logs

Supported

Loading Reports

Supported

Connecting Asana

Asana setup requirements

To set up Asana in Stitch, you need:

  • Access to all the data you want to replicate in Asana. This includes projects, tasks, tags, users, and workspaces. If the user authorizing the integration in Stitch doesn’t have access to something in Asana, Stitch will be unable to replicate it.


Step 1: Add Asana as a Stitch data source

  1. Sign into your Stitch account.
  2. On the Stitch Dashboard page, click the Add Integration button.

  3. Click the Asana icon.

  4. Enter a name for the integration. This is the name that will display on the Stitch Dashboard for the integration; it’ll also be used to create the schema in your destination.

    For example, the name “Stitch Asana” would create a schema called stitch_asana in the destination. Note: Schema names cannot be changed after you save the integration.

Step 2: Define the historical replication start date

The Sync Historical Data setting defines the starting date for your Asana integration. This means that:

  • For tables using Key-based Incremental Replication, data equal to or newer than this date will be replicated to your destination.
  • For tables using Full Table Replication, all data - including records that are older, equal to, or newer than this date - will be replicated to your destination.

Change this setting if you want to replicate data beyond Asana’s default setting of 1 year. For a detailed look at historical replication jobs, check out the Syncing Historical SaaS Data guide.

Step 3: Create a replication schedule

In the Replication Frequency section, you’ll create the integration’s replication schedule. An integration’s replication schedule determines how often Stitch runs a replication job, and the time that job begins.

Asana integrations support the following replication scheduling methods:

To keep your row usage low, consider setting the integration to replicate less frequently. See the Understanding and Reducing Your Row Usage guide for tips on reducing your usage.

Step 4: Authorize Stitch to access Asana

  1. Next, you’ll be prompted to sign into your Asana account.
  2. Enter your Asana credentials and sign into your account.
  3. After the authorization process is successfully completed, you’ll be directed back to Stitch.
  4. Click All Done.

Step 5: Set objects to replicate

The last step is to select the tables and columns you want to replicate. Learn about the available tables for this integration.

Note: If a replication job is currently in progress, new selections won’t be used until the next job starts.

For Asana integrations, you can select:

  1. Individual tables and columns

  2. All tables and columns

Click the tabs to view instructions for each selection method.

  1. In the integration’s Tables to Replicate tab, locate a table you want to replicate.
  2. To track a table, click the checkbox next to the table’s name. A blue checkmark means the table is set to replicate.

  3. To track a column, click the checkbox next to the column’s name. A blue checkmark means the column is set to replicate.

  4. Repeat this process for all the tables and columns you want to replicate.
  5. When finished, click the Finalize Your Selections button at the bottom of the screen to save your selections.
  1. Click into the integration from the Stitch Dashboard page.
  2. Click the Tables to Replicate tab.

  3. In the list of tables, click the box next to the Table Names column.
  4. In the menu that displays, click Track all Tables and Fields:

    The Track all Tables and Fields menu in the Tables to Replicate tab

  5. Click the Finalize Your Selections button at the bottom of the page to save your data selections.

Initial and historical replication jobs

After you finish setting up Asana, its Sync Status may show as Pending on either the Stitch Dashboard or in the Integration Details page.

For a new integration, a Pending status indicates that Stitch is in the process of scheduling the initial replication job for the integration. This may take some time to complete.

Free historical data loads

The first seven days of replication, beginning when data is first replicated, are free. Rows replicated from the new integration during this time won’t count towards your quota. Stitch offers this as a way of testing new integrations, measuring usage, and ensuring historical data volumes don’t quickly consume your quota.


Asana table reference

Replication Method :

Full Table

Primary Key :

gid

API endpoint :

Get multiple portfolios

The portfolios table contains info about the portfolios in your Asana account.

Custom fields

To replicate task custom fields, select the custom_fields attribute in Stitch. If your destination doesn’t natively support nested data structures, two subtables (tasks__custom_fields, tasks__custom_fields__enum_options) will be created.

archived
BOOLEAN

color
STRING

completed
BOOLEAN

completed_at
DATE-TIME

completed_by
OBJECT

gid
STRING

resource_type
STRING

name
STRING

portfolios (table), completed_by (attribute)

created_at
DATE-TIME

created_by
OBJECT

gid
STRING

resource_type
STRING

name
STRING

portfolios (table), created_by (attribute)

created_from_template
OBJECT

gid
STRING

resource_type
STRING

name
STRING

portfolios (table), created_from_template (attribute)

current_status
STRING

current_status_update
OBJECT

gid
STRING

resource_type
STRING

resource_subtype
STRING

title
STRING

portfolios (table), current_status_update (attribute)

custom_field_settings
ARRAY

gid
STRING

resource_type
STRING

custom_field
OBJECT

gid
STRING

resource_type
STRING

created_by
OBJECT

gid
STRING

resource_type
STRING

name
STRING

portfolios (table), created_by (attribute)

currency_code
STRING

custom_label
STRING

custom_label_position
STRING

date_value
OBJECT

date
STRING

date_time
DATE-TIME

portfolios (table), date_value (attribute)

description
STRING

display_value
STRING

enabled
BOOLEAN

enum_options
ARRAY

gid
STRING

resource_type
STRING

name
STRING

enabled
BOOLEAN

color
STRING

portfolios (table), enum_options (attribute)

enum_value
OBJECT

gid
STRING

resource_type
STRING

name
STRING

enabled
BOOLEAN

color
STRING

portfolios (table), enum_value (attribute)

format
STRING

has_notifications_enabled
BOOLEAN

is_global_to_workspace
BOOLEAN

multi_enum_values
ARRAY

gid
STRING

resource_type
STRING

color
STRING

enabled
BOOLEAN

name
STRING

portfolios (table), multi_enum_values (attribute)

name
STRING

number_value
NUMBER

people_value
ARRAY

gid
STRING

resource_type
STRING

name
STRING

portfolios (table), people_value (attribute)

precision
INTEGER

resource_subtype
STRING

text_value
STRING

type
STRING

portfolios (table), custom_field (attribute)

is_important
BOOLEAN

parent
OBJECT

gid
STRING

resource_type
STRING

name
STRING

portfolios (table), parent (attribute)

project
OBJECT

gid
STRING

resource_type
STRING

name
STRING

portfolios (table), project (attribute)
portfolios (table), custom_field_settings (attribute)

custom_fields
ARRAY

gid
STRING

resource_type
STRING

name
STRING

resource_subtype
STRING

type
STRING

enum_options
ARRAY

gid
STRING

resource_type
STRING

name
STRING

enabled
BOOLEAN

color
STRING

portfolios (table), enum_options (attribute)

enum_value
OBJECT

gid
STRING

resource_type
STRING

name
STRING

enabled
BOOLEAN

color
STRING

portfolios (table), enum_value (attribute)

enabled
BOOLEAN

text_value
STRING

number_value
NUMBER

description
STRING

precision
INTEGER

is_global_to_workspace
BOOLEAN

has_notifications_enabled
BOOLEAN

date_value
OBJECT

date
STRING

date_time
DATE-TIME

portfolios (table), date_value (attribute)

display_value
STRING

multi_enum_values
ARRAY

gid
STRING

resource_type
STRING

color
STRING

enabled
BOOLEAN

name
STRING

portfolios (table), multi_enum_values (attribute)
portfolios (table), custom_fields (attribute)

default_view
STRING

due_date
STRING

due_on
STRING

followers
ARRAY

gid
STRING

resource_type
STRING

name
STRING

portfolios (table), followers (attribute)

gid
STRING

html_notes
STRING

icon
STRING

is_template
BOOLEAN

members
ARRAY

gid
STRING

resource_type
STRING

name
STRING

portfolios (table), members (attribute)

modified_at
DATE-TIME

name
STRING

notes
STRING

owner
OBJECT

gid
STRING

resource_type
STRING

name
STRING

portfolios (table), owner (attribute)

permalink_url
STRING

portfolio_items
ARRAY

gid
STRING

resource_type
STRING

name
STRING

portfolios (table), portfolio_items (attribute)

project_brief
OBJECT

gid
STRING

resource_type
STRING

portfolios (table), project_brief (attribute)

public
BOOLEAN

resource_type
STRING

start_on
STRING

team
OBJECT

gid
STRING

resource_type
STRING

name
STRING

portfolios (table), team (attribute)

workspace
OBJECT

gid
STRING

resource_type
STRING

name
STRING

portfolios (table), workspace (attribute)

Replication Method :

Key-based Incremental

Replication Key :

modified_at

Primary Key :

gid

Official docs :

Official Docs

The projects table contains info about the projects the user who authorized the Asana integration in Stitch has access to.

archived
BOOLEAN

color
STRING

completed
BOOLEAN

completed_at
DATE-TIME

completed_by
OBJECT

gid
STRING

resource_type
STRING

name
STRING

projects (table), completed_by (attribute)

created_at
DATE-TIME

created_from_template
OBJECT

gid
STRING

resource_type
STRING

name
STRING

projects (table), created_from_template (attribute)

current_status
STRING

current_status_update
OBJECT

gid
STRING

resource_type
STRING

resource_subtype
STRING

title
STRING

projects (table), current_status_update (attribute)

custom_field_settings
ARRAY

gid
STRING

resource_type
STRING

custom_field
OBJECT

gid
STRING

resource_type
STRING

created_by
OBJECT

gid
STRING

resource_type
STRING

name
STRING

projects (table), created_by (attribute)

currency_code
STRING

custom_label
STRING

custom_label_position
STRING

date_value
OBJECT

date
STRING

date_time
DATE-TIME

projects (table), date_value (attribute)

description
STRING

display_value
STRING

enabled
BOOLEAN

enum_options
ARRAY

gid
STRING

resource_type
STRING

name
STRING

enabled
BOOLEAN

color
STRING

projects (table), enum_options (attribute)

enum_value
OBJECT

gid
STRING

resource_type
STRING

name
STRING

enabled
BOOLEAN

color
STRING

projects (table), enum_value (attribute)

format
STRING

has_notifications_enabled
BOOLEAN

is_global_to_workspace
BOOLEAN

multi_enum_values
ARRAY

gid
STRING

resource_type
STRING

color
STRING

enabled
BOOLEAN

name
STRING

projects (table), multi_enum_values (attribute)

name
STRING

number_value
NUMBER

people_value
ARRAY

gid
STRING

resource_type
STRING

name
STRING

projects (table), people_value (attribute)

precision
INTEGER

resource_subtype
STRING

text_value
STRING

type
STRING

projects (table), custom_field (attribute)

is_important
BOOLEAN

parent
OBJECT

gid
STRING

resource_type
STRING

name
STRING

projects (table), parent (attribute)

project
OBJECT

gid
STRING

resource_type
STRING

name
STRING

projects (table), project (attribute)
projects (table), custom_field_settings (attribute)

custom_fields
ARRAY

gid
STRING

resource_type
STRING

name
STRING

resource_subtype
STRING

type
STRING

enum_options
ARRAY

gid
STRING

resource_type
STRING

name
STRING

enabled
BOOLEAN

color
STRING

projects (table), enum_options (attribute)

enum_value
OBJECT

gid
STRING

resource_type
STRING

name
STRING

enabled
BOOLEAN

color
STRING

projects (table), enum_value (attribute)

enabled
BOOLEAN

text_value
STRING

number_value
NUMBER

description
STRING

precision
INTEGER

is_global_to_workspace
BOOLEAN

has_notifications_enabled
BOOLEAN

date_value
OBJECT

date
STRING

date_time
DATE-TIME

projects (table), date_value (attribute)

display_value
STRING

multi_enum_values
ARRAY

gid
STRING

resource_type
STRING

color
STRING

enabled
BOOLEAN

name
STRING

projects (table), multi_enum_values (attribute)
projects (table), custom_fields (attribute)

default_view
STRING

due_date
STRING

due_on
STRING

followers
ARRAY

gid
STRING

resource_type
STRING

name
STRING

projects (table), followers (attribute)

gid
STRING

html_notes
STRING

icon
STRING

is_template
BOOLEAN

members
ARRAY

gid
STRING

resource_type
STRING

name
STRING

projects (table), members (attribute)

modified_at
DATE-TIME

name
STRING

notes
STRING

owner
OBJECT

gid
STRING

resource_type
STRING

name
STRING

projects (table), owner (attribute)

permalink_url
STRING

project_brief
OBJECT

gid
STRING

resource_type
STRING

projects (table), project_brief (attribute)

public
BOOLEAN

resource_type
STRING

start_on
STRING

team
OBJECT

gid
STRING

resource_type
STRING

name
STRING

projects (table), team (attribute)

workspace
OBJECT

gid
STRING

resource_type
STRING

name
STRING

projects (table), workspace (attribute)

Replication Method :

Full Table

Primary Key :

gid

API endpoint :

Get sections in a project

The sections table contains info about sections within specified projects in your Asana account.

created_at
DATE-TIME

gid
STRING

name
STRING

project
OBJECT

gid
STRING

resource_type
STRING

name
STRING

sections (table), project (attribute)

projects
ARRAY

gid
STRING

resource_type
STRING

name
STRING

sections (table), projects (attribute)

resource_type
STRING


Replication Method :

Key-based Incremental

Replication Key :

created_at

Primary Key :

gid

API endpoint :

Get stories from a task

The stories table contains info about all stories within specified tasks in your Asana account.

assignee
OBJECT

gid
STRING

resource_type
STRING

name
STRING

stories (table), assignee (attribute)

created_at
DATE-TIME

created_by
OBJECT

gid
STRING

resource_type
STRING

name
STRING

stories (table), created_by (attribute)

custom_field
OBJECT

gid
STRING

resource_type
STRING

date_value
OBJECT

date
STRING

date_time
DATE-TIME

stories (table), date_value (attribute)

display_value
STRING

enabled
BOOLEAN

enum_options
ARRAY

gid
STRING

resource_type
STRING

color
STRING

enabled
BOOLEAN

name
STRING

stories (table), enum_options (attribute)

enum_value
OBJECT

gid
STRING

resource_type
STRING

color
STRING

enabled
BOOLEAN

name
STRING

stories (table), enum_value (attribute)

multi_enum_values
ARRAY

gid
STRING

resource_type
STRING

color
STRING

enabled
BOOLEAN

name
STRING

stories (table), multi_enum_values (attribute)

name
STRING

number_value
NUMBER

resource_subtype
STRING

text_value
STRING

type
STRING

stories (table), custom_field (attribute)

dependency
OBJECT

gid
STRING

resource_type
STRING

name
STRING

resource_subtype
STRING

stories (table), dependency (attribute)

duplicate_of
OBJECT

gid
STRING

resource_type
STRING

name
STRING

resource_subtype
STRING

stories (table), duplicate_of (attribute)

duplicated_from
OBJECT

gid
STRING

resource_type
STRING

name
STRING

resource_subtype
STRING

stories (table), duplicated_from (attribute)

follower
OBJECT

gid
STRING

resource_type
STRING

name
STRING

stories (table), follower (attribute)

gid
STRING

hearted
BOOLEAN

hearts
ARRAY

gid
STRING

user
OBJECT

gid
STRING

resource_type
STRING

name
STRING

stories (table), user (attribute)
stories (table), hearts (attribute)

hearts
NULL

html_text
STRING

is_editable
BOOLEAN

is_edited
BOOLEAN

is_pinned
BOOLEAN

liked
BOOLEAN

likes
ARRAY

gid
STRING

user
OBJECT

gid
STRING

resource_type
STRING

name
STRING

stories (table), user (attribute)
stories (table), likes (attribute)

likes
NULL

new_approval_status
BOOLEAN

new_date_value
OBJECT

start_on
STRING

due_at
DATE-TIME

due_on
STRING

stories (table), new_date_value (attribute)

new_dates
OBJECT

due_at
DATE-TIME

due_on
DATE-TIME

start_on
DATE-TIME

stories (table), new_dates (attribute)

new_enum_value
OBJECT

gid
STRING

resource_type
STRING

color
STRING

enabled
BOOLEAN

name
STRING

stories (table), new_enum_value (attribute)

new_multi_enum_values
ARRAY

gid
STRING

resource_type
STRING

color
STRING

enabled
BOOLEAN

name
STRING

stories (table), new_multi_enum_values (attribute)

new_name
STRING

new_number_value
NUMBER

new_people_value
ARRAY

gid
STRING

resource_type
STRING

name
STRING

stories (table), new_people_value (attribute)

new_resource_subtype
STRING

new_section
OBJECT

gid
STRING

resource_type
STRING

name
STRING

stories (table), new_section (attribute)

new_text_value
STRING

num_hearts
INTEGER

num_likes
INTEGER

old_approval_status
STRING

old_date_value
OBJECT

start_on
STRING

due_at
DATE-TIME

due_on
STRING

stories (table), old_date_value (attribute)

old_dates
OBJECT

due_at
DATE-TIME

due_on
DATE-TIME

start_on
DATE-TIME

stories (table), old_dates (attribute)

old_enum_value
OBJECT

gid
STRING

resource_type
STRING

color
STRING

enabled
BOOLEAN

name
STRING

stories (table), old_enum_value (attribute)

old_multi_enum_values
ARRAY

gid
STRING

resource_type
STRING

color
STRING

enabled
BOOLEAN

name
STRING

stories (table), old_multi_enum_values (attribute)

old_name
STRING

old_number_value
NUMBER

old_people_value
ARRAY

gid
STRING

resource_type
STRING

name
STRING

stories (table), old_people_value (attribute)

old_resource_subtype
STRING

old_section
OBJECT

gid
STRING

resource_type
STRING

name
STRING

stories (table), old_section (attribute)

old_text_value
STRING

previews
ARRAY

fallback
STRING

footer
STRING

header
STRING

header_link
STRING

html_text
STRING

text
STRING

title
STRING

title_link
STRING

stories (table), previews (attribute)

previews
NULL

project
OBJECT

gid
STRING

resource_type
STRING

name
STRING

stories (table), project (attribute)

resource_subtype
STRING

resource_type
STRING

source
STRING

sticker_name
STRING

story
OBJECT

gid
STRING

resource_type
STRING

created_at
DATE-TIME

created_by
OBJECT

gid
STRING

resource_type
STRING

name
STRING

stories (table), created_by (attribute)

resource_subtype
STRING

name
STRING

text
STRING

stories (table), story (attribute)

tag
OBJECT

gid
STRING

resource_type
STRING

name
STRING

stories (table), tag (attribute)

target
OBJECT

gid
STRING

name
STRING

resource_type
STRING

resource_subtype
STRING

stories (table), target (attribute)

task
OBJECT

gid
STRING

resource_type
STRING

name
STRING

resource_subtype
STRING

stories (table), task (attribute)

text
STRING

type
STRING


Replication Method :

Key-based Incremental

Replication Key :

created_at

Primary Key :

gid

Official docs :

Official Docs

The tags table contains info about the tags in your Asana account. A tag is a label that can be attached to any task in Asana.

color
STRING

created_at
DATE-TIME

followers
ARRAY

gid
STRING

resource_type
STRING

name
STRING

tags (table), followers (attribute)

gid
STRING

name
STRING

notes
STRING

permalink_url
STRING

resource_type
STRING

workspace
OBJECT

gid
STRING

resource_type
STRING

name
STRING

tags (table), workspace (attribute)

Replication Method :

Key-based Incremental

Replication Key :

modified_at

Primary Key :

gid

Official docs :

Official Docs

The tasks table contains info about the tasks in your Asana account.

Custom fields

To replicate task custom fields, select the custom_fields attribute in Stitch. If your destination doesn’t natively support nested data structures, two subtables (tasks__custom_fields, tasks__custom_fields__enum_options) will be created.

approval_status
STRING

assignee
OBJECT

gid
STRING

resource_type
STRING

name
STRING

tasks (table), assignee (attribute)

assignee_section
OBJECT

gid
STRING

resource_type
STRING

name
STRING

tasks (table), assignee_section (attribute)

assignee_status
STRING

completed
BOOLEAN

completed_at
DATE-TIME

completed_by
OBJECT

gid
STRING

resource_type
STRING

name
STRING

tasks (table), completed_by (attribute)

created_at
DATE-TIME

custom_fields
ARRAY

gid
STRING

resource_type
STRING

name
STRING

resource_subtype
STRING

type
STRING

enum_options
ARRAY

gid
STRING

resource_type
STRING

name
STRING

enabled
BOOLEAN

color
STRING

tasks (table), enum_options (attribute)

enum_value
OBJECT

gid
STRING

resource_type
STRING

name
STRING

enabled
BOOLEAN

color
STRING

tasks (table), enum_value (attribute)

enabled
BOOLEAN

text_value
STRING

number_value
NUMBER

description
STRING

precision
INTEGER

is_global_to_workspace
BOOLEAN

has_notifications_enabled
BOOLEAN

created_by
OBJECT

gid
STRING

resource_type
STRING

name
STRING

tasks (table), created_by (attribute)

currency_code
STRING

custom_label
STRING

custom_label_position
STRING

date_value
OBJECT

date
STRING

date_time
DATE-TIME

tasks (table), date_value (attribute)

display_value
STRING

format
STRING

multi_enum_values
ARRAY

gid
STRING

resource_type
STRING

color
STRING

enabled
BOOLEAN

name
STRING

tasks (table), multi_enum_values (attribute)

people_value
ARRAY

gid
STRING

resource_type
STRING

name
STRING

tasks (table), people_value (attribute)
tasks (table), custom_fields (attribute)

dependencies
ARRAY

gid
STRING

resource_type
STRING

name
STRING

tasks (table), dependencies (attribute)

dependents
ARRAY

gid
STRING

resource_type
STRING

name
STRING

tasks (table), dependents (attribute)

due_at
DATE-TIME

due_on
DATE-TIME

external
OBJECT

gid
STRING

data
STRING

tasks (table), external (attribute)

followers
ARRAY

gid
STRING

resource_type
STRING

name
STRING

tasks (table), followers (attribute)

gid
STRING

hearted
BOOLEAN

hearts
ARRAY

gid
STRING

user
OBJECT

gid
STRING

resource_type
STRING

name
STRING

tasks (table), user (attribute)
tasks (table), hearts (attribute)

hearts
NULL

html_notes
STRING

is_rendered_as_seperator
BOOLEAN

liked
BOOLEAN

likes
ARRAY

gid
STRING

user
OBJECT

gid
STRING

resource_type
STRING

name
STRING

tasks (table), user (attribute)
tasks (table), likes (attribute)

likes
NULL

memberships
ARRAY

project
OBJECT

gid
STRING

resource_type
STRING

name
STRING

tasks (table), project (attribute)

section
OBJECT

gid
STRING

resource_type
STRING

name
STRING

tasks (table), section (attribute)
tasks (table), memberships (attribute)

memberships
NULL

modified_at
DATE-TIME

name
STRING

notes
STRING

num_hearts
INTEGER

num_likes
INTEGER

num_subtasks
INTEGER

parent
OBJECT

gid
STRING

resource_type
STRING

name
STRING

resource_subtype
STRING

tasks (table), parent (attribute)

permalink_url
STRING

projects
ARRAY

gid
STRING

resource_type
STRING

name
STRING

tasks (table), projects (attribute)

resource_subtype
STRING

resource_type
STRING

start_at
DATE-TIME

start_on
STRING

tags
ARRAY

gid
STRING

resource_type
STRING

name
STRING

tasks (table), tags (attribute)

workspace
OBJECT

gid
STRING

resource_type
STRING

name
STRING

tasks (table), workspace (attribute)

Replication Method :

Full Table

Primary Key :

gid

API endpoint :

Get teams for a user

The teams table contains info about teams that belong to a specified user in your Asana account.

description
STRING

gid
STRING

html_description
STRING

name
STRING

organization
OBJECT

gid
STRING

resource_type
STRING

name
STRING

teams (table), organization (attribute)

permalink_url
STRING

resource_type
STRING

users
ARRAY

gid
STRING

resource_type
STRING

name
STRING

teams (table), users (attribute)

visibility
STRING


Replication Method :

Full Table

Primary Key :

gid

Official docs :

Official Docs

The users table contains info about the users in your Asana account.

email
STRING

gid
STRING

name
STRING

photo
OBJECT

image_21x21
STRING

image_27x27
STRING

image_36x36
STRING

image_60x60
STRING

image_128x128
STRING

image_1024x1024
STRING

users (table), photo (attribute)

resource_type
STRING

workspaces
ARRAY

gid
STRING

resource_type
STRING

name
STRING

users (table), workspaces (attribute)

workspaces