Loading Data from Box Platform API to Microsoft SQL Server with dlt in Python

Need help deploying these pipelines, or figuring out how to run them in your data stack?

Join our Slack community or book a call with our support engineer Violetta.

This page provides technical documentation for loading data from the Box Platform API to Microsoft SQL Server using the open-source Python library dlt. The Box Platform API enables secure collaboration with anyone, anywhere, on any device. Microsoft SQL Server is a relational database management system (RDBMS) that allows applications and tools to connect and communicate using Transact-SQL. This guide will walk you through the necessary steps to integrate these technologies, ensuring seamless data transfer and management. For more information on the Box Platform API, visit Box.

dlt Key Features

• Easy to get started: dlt is a Python library that is easy to use and understand. It is designed to be simple to use and easy to understand. Type pip install dlt and you are ready to go.
• Robust Governance Support: dlt pipelines offer robust governance support through pipeline metadata utilization, schema enforcement and curation, and schema change alerts. Read more about Governance Support.
• Supports Multiple Destinations: dlt supports various destinations like Google BigQuery, Microsoft SQL Server, DuckDB, and more. Check out the destinations.
• Schema Evolution: dlt enables proactive governance by alerting users to schema changes, allowing them to take necessary actions. Learn more about Schema Evolution.
• Scalable and Configurable: dlt offers several mechanisms and configuration options to scale up and fine-tune pipelines, including parallel execution and memory buffer adjustments. Read more about Performance.

Getting started with your pipeline locally

OpenAPI Source Generator dlt-init-openapi

This walkthrough makes use of the dlt-init-openapi generator cli tool. You can read more about it here. The code generated by this tool uses the dlt rest_api verified source, docs for this are here.

0. Prerequisites

dlt and dlt-init-openapi requires Python 3.9 or higher. Additionally, you need to have the pip package manager installed, and we recommend using a virtual environment to manage your dependencies. You can learn more about preparing your computer for dlt in our installation reference.

1. Install dlt and dlt-init-openapi

First you need to install the dlt-init-openapi cli tool.

pip install dlt-init-openapi

The dlt-init-openapi cli is a powerful generator which you can use to turn any OpenAPI spec into a dlt source to ingest data from that api. The quality of the generator source is dependent on how well the API is designed and how accurate the OpenAPI spec you are using is. You may need to make tweaks to the generated code, you can learn more about this here.

# generate pipeline
# NOTE: add_limit adds a global limit, you can remove this later
# NOTE: you will need to select which endpoints to render, you 
# can just hit Enter and all will be rendered.
dlt-init-openapi box --url https://raw.githubusercontent.com/box/box-openapi/main/openapi.json --global-limit 2
cd box_pipeline
# install generated requirements
pip install -r requirements.txt

The last command will install the required dependencies for your pipeline. The dependencies are listed in the requirements.txt:

dlt>=0.4.12

You now have the following folder structure in your project:

box_pipeline/
├── .dlt/
│   ├── config.toml          # configs for your pipeline
│   └── secrets.toml         # secrets for your pipeline
├── rest_api/                # The rest api verified source
│   └── ...
├── box/                
│   └── __init__.py          # TODO: possibly tweak this file
├── box_pipeline.py        # your main pipeline script
├── requirements.txt         # dependencies for your pipeline
└── .gitignore               # ignore files for git (not required)

1.1. Tweak box/__init__.py

This file contains the generated configuration of your rest_api. You can continue with the next steps and leave it as is, but you might want to come back here and make adjustments if you need your rest_api source set up in a different way. The generated file for the box source will look like this:

Click to view full file (2025 lines)

from typing import List

import dlt
from dlt.extract.source import DltResource
from rest_api import rest_api_source
from rest_api.typing import RESTAPIConfig


@dlt.source(name="box_source", max_table_nesting=2)
def box_source(
        base_url: str = dlt.config.value,
) -> List[DltResource]:

    # source configuration
    source_config: RESTAPIConfig = {
        "client": {
            "base_url": base_url,
            "paginator": {
                "type":
                    "offset",
                "limit":
                    1000,
                "offset_param":
                    "offset",
                "limit_param":
                    "limit",
                "total_path":
                    "total_count",
            },
        },
        "resources": 
        [
        # Authorize a user by sending them through the [Box](https://box.com) website and request their permission to act on their behalf.  This is the first step when authenticating a user using OAuth 2.0. To request a user's authorization to use the Box APIs on their behalf you will need to send a user to the URL with this format.
        {
            "name": "get_authorize",
            "table_name": "authorize",
            "endpoint": {
                "path": "/authorize",
                "params": {
                    "response_type": "FILL_ME_IN", # TODO: fill in required query parameter
                    "client_id": "FILL_ME_IN", # TODO: fill in required query parameter
                    # the parameters below can optionally be configured
                    # "redirect_uri": "OPTIONAL_CONFIG",
                    # "state": "OPTIONAL_CONFIG",
                    # "scope": "OPTIONAL_CONFIG",

                },
            }
        },
        # Retrieves an image of a the user's avatar.
        {
            "name": "get_users_id_avatar",
            "table_name": "avatar",
            "endpoint": {
                "path": "/users/{user_id}/avatar",
                "params": {
                    "user_id": "FILL_ME_IN", # TODO: fill in required path parameter

                },
            }
        },
        # List the Box Skills metadata cards that are attached to a file.
        {
            "name": "get_files_id_metadata_global_box_skills_cards",
            "table_name": "box_skills_card",
            "endpoint": {
                "data_selector": "cards",
                "path": "/files/{file_id}/metadata/global/boxSkillsCards",
                "params": {
                    "file_id": "FILL_ME_IN", # TODO: fill in required path parameter

                },
            }
        },
        # Retrieves the classification metadata instance that has been applied to a file.  This API can also be called by including the enterprise ID in the URL explicitly, for example `/files/:id//enterprise_12345/securityClassification-6VMVochwUWo`.
        {
            "name": "get_files_id_metadata_enterprise_security_classification_6vm_vochw_u_wo",
            "table_name": "client_error",
            "endpoint": {
                "data_selector": "$",
                "path": "/files/{file_id}/metadata/enterprise/securityClassification-6VMVochwUWo",
                "params": {
                    "file_id": "FILL_ME_IN", # TODO: fill in required path parameter

                },
            }
        },
        # Retrieves the instance of a metadata template that has been applied to a file.
        {
            "name": "get_files_id_metadata_id_id",
            "table_name": "client_error",
            "endpoint": {
                "data_selector": "$",
                "path": "/files/{file_id}/metadata/{scope}/{template_key}",
                "params": {
                    "file_id": "FILL_ME_IN", # TODO: fill in required path parameter
                    "scope": "FILL_ME_IN", # TODO: fill in required path parameter
                    "template_key": "FILL_ME_IN", # TODO: fill in required path parameter

                },
            }
        },
        # Retrieves the classification metadata instance that has been applied to a folder.  This API can also be called by including the enterprise ID in the URL explicitly, for example `/folders/:id//enterprise_12345/securityClassification-6VMVochwUWo`.
        {
            "name": "get_folders_id_metadata_enterprise_security_classification_6vm_vochw_u_wo",
            "table_name": "client_error",
            "endpoint": {
                "data_selector": "$",
                "path": "/folders/{folder_id}/metadata/enterprise/securityClassification-6VMVochwUWo",
                "params": {
                    "folder_id": "FILL_ME_IN", # TODO: fill in required path parameter

                },
            }
        },
        # Retrieves the instance of a metadata template that has been applied to a folder. This can not be used on the root folder with ID `0`.
        {
            "name": "get_folders_id_metadata_id_id",
            "table_name": "client_error",
            "endpoint": {
                "data_selector": "$",
                "path": "/folders/{folder_id}/metadata/{scope}/{template_key}",
                "params": {
                    "folder_id": "FILL_ME_IN", # TODO: fill in required path parameter
                    "scope": "FILL_ME_IN", # TODO: fill in required path parameter
                    "template_key": "FILL_ME_IN", # TODO: fill in required path parameter

                },
            }
        },
        # Retrieves a list of pending and active collaborations for a file. This returns all the users that have access to the file or have been invited to the file.
        {
            "name": "get_files_id_collaborations",
            "table_name": "collaboration",
            "endpoint": {
                "data_selector": "order",
                "path": "/files/{file_id}/collaborations",
                "params": {
                    "file_id": "FILL_ME_IN", # TODO: fill in required path parameter
                    # the parameters below can optionally be configured
                    # "fields": "OPTIONAL_CONFIG",
                    # "limit": "OPTIONAL_CONFIG",
                    # "marker": "OPTIONAL_CONFIG",

                },
            }
        },
        # Retrieves a list of pending and active collaborations for a folder. This returns all the users that have access to the folder or have been invited to the folder.
        {
            "name": "get_folders_id_collaborations",
            "table_name": "collaboration",
            "endpoint": {
                "data_selector": "order",
                "path": "/folders/{folder_id}/collaborations",
                "params": {
                    "folder_id": "FILL_ME_IN", # TODO: fill in required path parameter
                    # the parameters below can optionally be configured
                    # "fields": "OPTIONAL_CONFIG",

                },
            }
        },
        # Retrieves a single collaboration.
        {
            "name": "get_collaborations_id",
            "table_name": "collaboration",
            "primary_key": "id",
            "write_disposition": "merge",
            "endpoint": {
                "data_selector": "$",
                "path": "/collaborations/{collaboration_id}",
                "params": {
                    "collaboration_id": "FILL_ME_IN", # TODO: fill in required path parameter
                    # the parameters below can optionally be configured
                    # "fields": "OPTIONAL_CONFIG",

                },
            }
        },
        # Retrieves all pending collaboration invites for this user.
        {
            "name": "get_collaborations",
            "table_name": "collaboration",
            "endpoint": {
                "data_selector": "order",
                "path": "/collaborations",
                "params": {
                    "status": "FILL_ME_IN", # TODO: fill in required query parameter
                    # the parameters below can optionally be configured
                    # "fields": "OPTIONAL_CONFIG",

                },
            }
        },
        # Retrieves all the collaborations for a group. The user must have admin permissions to inspect enterprise's groups.  Each collaboration object has details on which files or folders the group has access to and with what role.
        {
            "name": "get_groups_id_collaborations",
            "table_name": "collaboration",
            "endpoint": {
                "data_selector": "order",
                "path": "/groups/{group_id}/collaborations",
                "params": {
                    "group_id": "FILL_ME_IN", # TODO: fill in required path parameter

                },
            }
        },
        # Returns the list domains that have been deemed safe to create collaborations for within the current enterprise.
        {
            "name": "get_collaboration_whitelist_entries",
            "table_name": "collaboration_allowlist_entry",
            "primary_key": "id",
            "write_disposition": "merge",
            "endpoint": {
                "data_selector": "entries",
                "path": "/collaboration_whitelist_entries",
                "params": {
                    # the parameters below can optionally be configured
                    # "marker": "OPTIONAL_CONFIG",
                    # "limit": "OPTIONAL_CONFIG",

                },
            }
        },
        # Returns a domain that has been deemed safe to create collaborations for within the current enterprise.
        {
            "name": "get_collaboration_whitelist_entries_id",
            "table_name": "collaboration_allowlist_entry",
            "primary_key": "id",
            "write_disposition": "merge",
            "endpoint": {
                "data_selector": "$",
                "path": "/collaboration_whitelist_entries/{collaboration_whitelist_entry_id}",
                "params": {
                    "collaboration_whitelist_entry_id": {
                        "type": "resolve",
                        "resource": "get_collaboration_whitelist_entries",
                        "field": "id",
                    },

                },
            }
        },
        # Returns a list of users who have been exempt from the collaboration domain restrictions.
        {
            "name": "get_collaboration_whitelist_exempt_targets",
            "table_name": "collaboration_allowlist_exempt_target",
            "primary_key": "id",
            "write_disposition": "merge",
            "endpoint": {
                "data_selector": "entries",
                "path": "/collaboration_whitelist_exempt_targets",
                "params": {
                    # the parameters below can optionally be configured
                    # "marker": "OPTIONAL_CONFIG",
                    # "limit": "OPTIONAL_CONFIG",

                },
            }
        },
        # Returns a users who has been exempt from the collaboration domain restrictions.
        {
            "name": "get_collaboration_whitelist_exempt_targets_id",
            "table_name": "collaboration_allowlist_exempt_target",
            "primary_key": "id",
            "write_disposition": "merge",
            "endpoint": {
                "data_selector": "$",
                "path": "/collaboration_whitelist_exempt_targets/{collaboration_whitelist_exempt_target_id}",
                "params": {
                    "collaboration_whitelist_exempt_target_id": {
                        "type": "resolve",
                        "resource": "get_collaboration_whitelist_exempt_targets",
                        "field": "id",
                    },

                },
            }
        },
        # Retrieves all collections for a given user.  Currently, only the `favorites` collection is supported.
        {
            "name": "get_collections",
            "table_name": "collection",
            "endpoint": {
                "data_selector": "order",
                "path": "/collections",
                "params": {
                    # the parameters below can optionally be configured
                    # "fields": "OPTIONAL_CONFIG",

                },
            }
        },
        # Retrieves a list of comments for a file.
        {
            "name": "get_files_id_comments",
            "table_name": "comment",
            "endpoint": {
                "data_selector": "order",
                "path": "/files/{file_id}/comments",
                "params": {
                    "file_id": "FILL_ME_IN", # TODO: fill in required path parameter
                    # the parameters below can optionally be configured
                    # "fields": "OPTIONAL_CONFIG",

                },
            }
        },
        # Retrieves the message and metadata for a specific comment, as well as information on the user who created the comment.
        {
            "name": "get_comments_id",
            "table_name": "comment_full",
            "primary_key": "id",
            "write_disposition": "merge",
            "endpoint": {
                "data_selector": "$",
                "path": "/comments/{comment_id}",
                "params": {
                    "comment_id": "FILL_ME_IN", # TODO: fill in required path parameter
                    # the parameters below can optionally be configured
                    # "fields": "OPTIONAL_CONFIG",

                },
            }
        },
        # Returns the contents of a file in binary format.
        {
            "name": "get_files_id_content",
            "table_name": "content",
            "endpoint": {
                "path": "/files/{file_id}/content",
                "params": {
                    "file_id": "FILL_ME_IN", # TODO: fill in required path parameter
                    # the parameters below can optionally be configured
                    # "version": "OPTIONAL_CONFIG",
                    # "access_token": "OPTIONAL_CONFIG",

                },
            }
        },
        # Returns the contents of a `zip` archive in binary format. This URL does not require any form of authentication and could be used in a user's browser to download the archive to a user's device.  By default, this URL is only valid for a few seconds from the creation of the request for this archive. Once a download has started it can not be stopped and resumed, instead a new request for a zip archive would need to be created.  The URL of this endpoint should not be considered as fixed. Instead, use the [Create zip download](e://post_zip_downloads) API to request to create a `zip` archive, and then follow the `download_url` field in the response to this endpoint.
        {
            "name": "get_zip_downloads_id_content",
            "table_name": "content",
            "endpoint": {
                "path": "/zip_downloads/{zip_download_id}/content",
                "params": {
                    "zip_download_id": "FILL_ME_IN", # TODO: fill in required path parameter

                },
            }
        },
        # Retrieves information about an individual device pin.
        {
            "name": "get_device_pinners_id",
            "table_name": "device_pinner",
            "primary_key": "id",
            "write_disposition": "merge",
            "endpoint": {
                "data_selector": "$",
                "path": "/device_pinners/{device_pinner_id}",
                "params": {
                    "device_pinner_id": "FILL_ME_IN", # TODO: fill in required path parameter

                },
            }
        },
        # Retrieves all the device pins within an enterprise.  The user must have admin privileges, and the application needs the "manage enterprise" scope to make this call.
        {
            "name": "get_enterprises_id_device_pinners",
            "table_name": "device_pinner",
            "primary_key": "id",
            "write_disposition": "merge",
            "endpoint": {
                "data_selector": "entries",
                "path": "/enterprises/{enterprise_id}/device_pinners",
                "params": {
                    "enterprise_id": "FILL_ME_IN", # TODO: fill in required path parameter
                    # the parameters below can optionally be configured
                    # "marker": "OPTIONAL_CONFIG",
                    # "limit": "OPTIONAL_CONFIG",
                    # "direction": "OPTIONAL_CONFIG",

                },
            }
        },
        # Retrieves all email aliases for a user. The collection does not include the primary login for the user.
        {
            "name": "get_users_id_email_aliases",
            "table_name": "email_alias",
            "primary_key": "id",
            "write_disposition": "merge",
            "endpoint": {
                "data_selector": "entries",
                "path": "/users/{user_id}/email_aliases",
                "params": {
                    "user_id": "FILL_ME_IN", # TODO: fill in required path parameter

                },
            }
        },
        # Returns up to a year of past events for a given user or for the entire enterprise.  By default this returns events for the authenticated user. To retrieve events for the entire enterprise, set the `stream_type` to `admin_logs_streaming` for live monitoring of new events, or `admin_logs` for querying across historical events. The user making the API call will need to have admin privileges, and the application will need to have the scope `manage enterprise properties` checked.
        {
            "name": "get_events",
            "table_name": "event",
            "primary_key": "event_id",
            "write_disposition": "merge",
            "endpoint": {
                "data_selector": "entries",
                "path": "/events",
                "params": {
                    # the parameters below can optionally be configured
                    # "stream_type": "all",
                    # "stream_position": "OPTIONAL_CONFIG",
                    # "limit": "100",
                    # "event_type": "OPTIONAL_CONFIG",
                    # "created_after": "OPTIONAL_CONFIG",
                    # "created_before": "OPTIONAL_CONFIG",

                },
            }
        },
        # Retrieves the details about a file.
        {
            "name": "get_files_id",
            "table_name": "file_full",
            "primary_key": "id",
            "write_disposition": "merge",
            "endpoint": {
                "data_selector": "$",
                "path": "/files/{file_id}",
                "params": {
                    "file_id": "FILL_ME_IN", # TODO: fill in required path parameter
                    # the parameters below can optionally be configured
                    # "fields": "OPTIONAL_CONFIG",

                },
            }
        },
        # Gets the information for a shared link on a file.
        {
            "name": "get_files_idget_shared_link",
            "table_name": "file_idget_shared_link",
            "endpoint": {
                "data_selector": "tags",
                "path": "/files/{file_id}#get_shared_link",
                "params": {
                    "fields": "FILL_ME_IN", # TODO: fill in required query parameter

                },
            }
        },
        # Returns a list of files under retention for a retention policy assignment.
        {
            "name": "get_retention_policy_assignments_id_files_under_retention",
            "table_name": "file_mini",
            "primary_key": "id",
            "write_disposition": "merge",
            "endpoint": {
                "data_selector": "entries",
                "path": "/retention_policy_assignments/{retention_policy_assignment_id}/files_under_retention",
                "params": {
                    "retention_policy_assignment_id": "FILL_ME_IN", # TODO: fill in required path parameter
                    # the parameters below can optionally be configured
                    # "marker": "OPTIONAL_CONFIG",
                    # "limit": "OPTIONAL_CONFIG",

                },
            }
        },
        # Returns a list of file versions under retention for a retention policy assignment.
        {
            "name": "get_retention_policy_assignments_id_file_versions_under_retention",
            "table_name": "file_mini",
            "primary_key": "id",
            "write_disposition": "merge",
            "endpoint": {
                "data_selector": "entries",
                "path": "/retention_policy_assignments/{retention_policy_assignment_id}/file_versions_under_retention",
                "params": {
                    "retention_policy_assignment_id": "FILL_ME_IN", # TODO: fill in required path parameter
                    # the parameters below can optionally be configured
                    # "marker": "OPTIONAL_CONFIG",
                    # "limit": "OPTIONAL_CONFIG",

                },
            }
        },
        # Get a list of files with current file versions for a legal hold assignment.  In some cases you may want to get previous file versions instead. In these cases, use the `GET  /legal_hold_policy_assignments/:id/file_versions_on_hold` API instead to return any previous versions of a file for this legal hold policy assignment.  Due to ongoing re-architecture efforts this API might not return all file versions held for this policy ID. Instead, this API will only return the latest file version held in the newly developed architecture. The `GET /file_version_legal_holds` API can be used to fetch current and past versions of files held within the legacy architecture.  This endpoint does not support returning any content that is on hold due to a Custodian collaborating on a Hub.  The `GET /legal_hold_policy_assignments?policy_id={id}` API can be used to find a list of policy assignments for a given policy ID.
        {
            "name": "get_legal_hold_policy_assignments_id_files_on_hold",
            "table_name": "file_mini",
            "primary_key": "id",
            "write_disposition": "merge",
            "endpoint": {
                "data_selector": "entries",
                "path": "/legal_hold_policy_assignments/{legal_hold_policy_assignment_id}/files_on_hold",
                "params": {
                    "legal_hold_policy_assignment_id": {
                        "type": "resolve",
                        "resource": "get_legal_hold_policy_assignments",
                        "field": "id",
                    },
                    # the parameters below can optionally be configured
                    # "marker": "OPTIONAL_CONFIG",
                    # "limit": "OPTIONAL_CONFIG",
                    # "fields": "OPTIONAL_CONFIG",

                },
            }
        },
        # Retrieves the information about a file request.
        {
            "name": "get_file_requests_id",
            "table_name": "file_request",
            "primary_key": "id",
            "write_disposition": "merge",
            "endpoint": {
                "data_selector": "$",
                "path": "/file_requests/{file_request_id}",
                "params": {
                    "file_request_id": "FILL_ME_IN", # TODO: fill in required path parameter

                },
            }
        },
        # Get a list of previous file versions for a legal hold assignment.  In some cases you may only need the latest file versions instead. In these cases, use the `GET  /legal_hold_policy_assignments/:id/files_on_hold` API instead to return any current (latest) versions of a file for this legal hold policy assignment.  Due to ongoing re-architecture efforts this API might not return all files held for this policy ID. Instead, this API will only return past file versions held in the newly developed architecture. The `GET /file_version_legal_holds` API can be used to fetch current and past versions of files held within the legacy architecture.  This endpoint does not support returning any content that is on hold due to a Custodian collaborating on a Hub.  The `GET /legal_hold_policy_assignments?policy_id={id}` API can be used to find a list of policy assignments for a given policy ID.
        {
            "name": "get_legal_hold_policy_assignments_id_file_versions_on_hold",
            "table_name": "file_version",
            "primary_key": "id",
            "write_disposition": "merge",
            "endpoint": {
                "data_selector": "entries",
                "path": "/legal_hold_policy_assignments/{legal_hold_policy_assignment_id}/file_versions_on_hold",
                "params": {
                    "legal_hold_policy_assignment_id": {
                        "type": "resolve",
                        "resource": "get_legal_hold_policy_assignments",
                        "field": "id",
                    },
                    # the parameters below can optionally be configured
                    # "marker": "OPTIONAL_CONFIG",
                    # "limit": "OPTIONAL_CONFIG",
                    # "fields": "OPTIONAL_CONFIG",

                },
            }
        },
        # Retrieve a specific version of a file.  Versions are only tracked for Box users with premium accounts.
        {
            "name": "get_files_id_versions_id",
            "table_name": "file_version_full",
            "primary_key": "id",
            "write_disposition": "merge",
            "endpoint": {
                "data_selector": "$",
                "path": "/files/{file_id}/versions/{file_version_id}",
                "params": {
                    "file_id": "FILL_ME_IN", # TODO: fill in required path parameter
                    "file_version_id": "FILL_ME_IN", # TODO: fill in required path parameter
                    # the parameters below can optionally be configured
                    # "fields": "OPTIONAL_CONFIG",

                },
            }
        },
        # Retrieves information about the legal hold policies assigned to a file version.
        {
            "name": "get_file_version_legal_holds_id",
            "table_name": "file_version_legal_hold",
            "primary_key": "id",
            "write_disposition": "merge",
            "endpoint": {
                "data_selector": "$",
                "path": "/file_version_legal_holds/{file_version_legal_hold_id}",
                "params": {
                    "file_version_legal_hold_id": {
                        "type": "resolve",
                        "resource": "get_file_version_legal_holds",
                        "field": "id",
                    },

                },
            }
        },
        # Get a list of file versions on legal hold for a legal hold assignment.  Due to ongoing re-architecture efforts this API might not return all file versions for this policy ID.  Instead, this API will only return file versions held in the legacy architecture. Two new endpoints will available to request any file versions held in the new architecture.  For file versions held in the new architecture, the `GET /legal_hold_policy_assignments/:id/file_versions_on_hold` API can be used to return all past file versions available for this policy assignment, and the `GET /legal_hold_policy_assignments/:id/files_on_hold` API can be used to return any current (latest) versions of a file under legal hold.  The `GET /legal_hold_policy_assignments?policy_id={id}` API can be used to find a list of policy assignments for a given policy ID.  Once the re-architecture is completed this API will be deprecated.
        {
            "name": "get_file_version_legal_holds",
            "table_name": "file_version_legal_hold",
            "primary_key": "id",
            "write_disposition": "merge",
            "endpoint": {
                "data_selector": "entries",
                "path": "/file_version_legal_holds",
                "params": {
                    "policy_id": "FILL_ME_IN", # TODO: fill in required query parameter
                    # the parameters below can optionally be configured
                    # "marker": "OPTIONAL_CONFIG",
                    # "limit": "OPTIONAL_CONFIG",

                },
            }
        },
        # Retrieves all file version retentions for the given enterprise.
        {
            "name": "get_file_version_retentions",
            "table_name": "file_version_retention",
            "primary_key": "id",
            "write_disposition": "merge",
            "endpoint": {
                "data_selector": "entries",
                "path": "/file_version_retentions",
                "params": {
                    # the parameters below can optionally be configured
                    # "file_id": "OPTIONAL_CONFIG",
                    # "file_version_id": "OPTIONAL_CONFIG",
                    # "policy_id": "OPTIONAL_CONFIG",
                    # "disposition_action": "OPTIONAL_CONFIG",
                    # "disposition_before": "OPTIONAL_CONFIG",
                    # "disposition_after": "OPTIONAL_CONFIG",
                    # "limit": "OPTIONAL_CONFIG",
                    # "marker": "OPTIONAL_CONFIG",

                },
            }
        },
        # Returns information about a file version retention.
        {
            "name": "get_file_version_retentions_id",
            "table_name": "file_version_retention",
            "primary_key": "id",
            "write_disposition": "merge",
            "endpoint": {
                "data_selector": "$",
                "path": "/file_version_retentions/{file_version_retention_id}",
                "params": {
                    "file_version_retention_id": {
                        "type": "resolve",
                        "resource": "get_file_version_retentions",
                        "field": "id",
                    },

                },
            }
        },
        # Retrieves details for a folder, including the first 100 entries in the folder.  Passing `sort`, `direction`, `offset`, and `limit` parameters in query allows you to manage the list of returned [folder items](r://folder--full#param-item-collection).  To fetch more items within the folder, use the [Get items in a folder](e://get-folders-id-items) endpoint.
        {
            "name": "get_folders_id",
            "table_name": "folder",
            "endpoint": {
                "data_selector": "tags",
                "path": "/folders/{folder_id}",
                "params": {
                    "folder_id": "FILL_ME_IN", # TODO: fill in required path parameter
                    # the parameters below can optionally be configured
                    # "fields": "OPTIONAL_CONFIG",
                    # "sort": "OPTIONAL_CONFIG",
                    # "direction": "OPTIONAL_CONFIG",

                },
                "paginator": {
                    "type":
                        "offset",
                    "limit":
                        1000,
                    "offset_param":
                        "offset",
                    "limit_param":
                        "limit",
                    "total_path":
                        "path_collection.total_count",
                },
            }
        },
        # Gets the information for a shared link on a folder.
        {
            "name": "get_folders_idget_shared_link",
            "table_name": "folder_idget_shared_link",
            "endpoint": {
                "data_selector": "tags",
                "path": "/folders/{folder_id}#get_shared_link",
                "params": {
                    "fields": "FILL_ME_IN", # TODO: fill in required query parameter

                },
            }
        },
        # Retrieves folder lock details for a given folder.  You must be authenticated as the owner or co-owner of the folder to use this endpoint.
        {
            "name": "get_folder_locks",
            "table_name": "folder_lock",
            "primary_key": "id",
            "write_disposition": "merge",
            "endpoint": {
                "data_selector": "entries",
                "path": "/folder_locks",
                "params": {
                    "folder_id": "FILL_ME_IN", # TODO: fill in required query parameter

                },
            }
        },
        # Returns the web link represented by a shared link.  A shared web link can be represented by a shared link, which can originate within the current enterprise or within another.  This endpoint allows an application to retrieve information about a shared web link when only given a shared link.
        {
            "name": "get_shared_itemsweb_links",
            "table_name": "folder_mini",
            "endpoint": {
                "data_selector": "path_collection.entries",
                "path": "/shared_items#web_links",
                "params": {
                    # the parameters below can optionally be configured
                    # "fields": "OPTIONAL_CONFIG",

                },
            }
        },
        # Gets the information for a shared link on a web link.
        {
            "name": "get_web_links_idget_shared_link",
            "table_name": "folder_mini",
            "endpoint": {
                "data_selector": "path_collection.entries",
                "path": "/web_links/{web_link_id}#get_shared_link",
                "params": {
                    "fields": "FILL_ME_IN", # TODO: fill in required query parameter

                },
            }
        },
        # Retrieves all of the groups for a given enterprise. The user must have admin permissions to inspect enterprise's groups.
        {
            "name": "get_groups",
            "table_name": "group",
            "endpoint": {
                "data_selector": "order",
                "path": "/groups",
                "params": {
                    # the parameters below can optionally be configured
                    # "filter_term": "OPTIONAL_CONFIG",
                    # "fields": "OPTIONAL_CONFIG",

                },
            }
        },
        # Retrieves information about a group. Only members of this group or users with admin-level permissions will be able to use this API.
        {
            "name": "get_groups_id",
            "table_name": "group_full",
            "primary_key": "id",
            "write_disposition": "merge",
            "endpoint": {
                "data_selector": "$",
                "path": "/groups/{group_id}",
                "params": {
                    "group_id": "FILL_ME_IN", # TODO: fill in required path parameter
                    # the parameters below can optionally be configured
                    # "fields": "OPTIONAL_CONFIG",

                },
            }
        },
        # Retrieves a specific group membership. Only admins of this group or users with admin-level permissions will be able to use this API.
        {
            "name": "get_group_memberships_id",
            "table_name": "group_membership",
            "primary_key": "id",
            "write_disposition": "merge",
            "endpoint": {
                "data_selector": "$",
                "path": "/group_memberships/{group_membership_id}",
                "params": {
                    "group_membership_id": "FILL_ME_IN", # TODO: fill in required path parameter
                    # the parameters below can optionally be configured
                    # "fields": "OPTIONAL_CONFIG",

                },
            }
        },
        # Lists [Slack integration mappings](https://support.box.com/hc/en-us/articles/4415585987859-Box-as-the-Content-Layer-for-Slack) in a users' enterprise.  You need Admin or Co-Admin role to use this endpoint.
        {
            "name": "get_integration_mappings_slack",
            "table_name": "integration_mapping",
            "primary_key": "id",
            "write_disposition": "merge",
            "endpoint": {
                "data_selector": "entries",
                "path": "/integration_mappings/slack",
                "params": {
                    # the parameters below can optionally be configured
                    # "marker": "OPTIONAL_CONFIG",
                    # "limit": "OPTIONAL_CONFIG",
                    # "partner_item_type": "OPTIONAL_CONFIG",
                    # "partner_item_id": "OPTIONAL_CONFIG",
                    # "box_item_id": "OPTIONAL_CONFIG",
                    # "box_item_type": "OPTIONAL_CONFIG",
                    # "is_manually_created": "OPTIONAL_CONFIG",

                },
            }
        },
        # Returns the status of a user invite.
        {
            "name": "get_invites_id",
            "table_name": "invite",
            "primary_key": "id",
            "write_disposition": "merge",
            "endpoint": {
                "data_selector": "$",
                "path": "/invites/{invite_id}",
                "params": {
                    "invite_id": "FILL_ME_IN", # TODO: fill in required path parameter
                    # the parameters below can optionally be configured
                    # "fields": "OPTIONAL_CONFIG",

                },
            }
        },
        # Retrieves a page of items in a folder. These items can be files, folders, and web links.  To request more information about the folder itself, like its size, use the [Get a folder](#get-folders-id) endpoint instead.
        {
            "name": "get_folders_id_items",
            "table_name": "item",
            "endpoint": {
                "data_selector": "order",
                "path": "/folders/{folder_id}/items",
                "params": {
                    "folder_id": "FILL_ME_IN", # TODO: fill in required path parameter
                    # the parameters below can optionally be configured
                    # "fields": "OPTIONAL_CONFIG",
                    # "usemarker": "OPTIONAL_CONFIG",
                    # "marker": "OPTIONAL_CONFIG",
                    # "sort": "OPTIONAL_CONFIG",
                    # "direction": "OPTIONAL_CONFIG",

                },
            }
        },
        # Retrieves the files and folders that have been moved to the trash.  Any attribute in the full files or folders objects can be passed in with the `fields` parameter to retrieve those specific attributes that are not returned by default.  This endpoint defaults to use offset-based pagination, yet also supports marker-based pagination using the `marker` parameter.
        {
            "name": "get_folders_trash_items",
            "table_name": "item",
            "endpoint": {
                "data_selector": "order",
                "path": "/folders/trash/items",
                "params": {
                    # the parameters below can optionally be configured
                    # "fields": "OPTIONAL_CONFIG",
                    # "usemarker": "OPTIONAL_CONFIG",
                    # "marker": "OPTIONAL_CONFIG",
                    # "direction": "OPTIONAL_CONFIG",
                    # "sort": "OPTIONAL_CONFIG",

                },
            }
        },
        # Retrieves the files and/or folders contained within this collection.
        {
            "name": "get_collections_id_items",
            "table_name": "item",
            "endpoint": {
                "data_selector": "order",
                "path": "/collections/{collection_id}/items",
                "params": {
                    "collection_id": "FILL_ME_IN", # TODO: fill in required path parameter
                    # the parameters below can optionally be configured
                    # "fields": "OPTIONAL_CONFIG",

                },
            }
        },
        # Retrieves a list of legal hold policies that belong to an enterprise.
        {
            "name": "get_legal_hold_policies",
            "table_name": "legal_hold_policy",
            "primary_key": "id",
            "write_disposition": "merge",
            "endpoint": {
                "data_selector": "entries",
                "path": "/legal_hold_policies",
                "params": {
                    # the parameters below can optionally be configured
                    # "policy_name": "OPTIONAL_CONFIG",
                    # "fields": "OPTIONAL_CONFIG",
                    # "marker": "OPTIONAL_CONFIG",
                    # "limit": "OPTIONAL_CONFIG",

                },
            }
        },
        # Retrieve a legal hold policy.
        {
            "name": "get_legal_hold_policies_id",
            "table_name": "legal_hold_policy",
            "primary_key": "id",
            "write_disposition": "merge",
            "endpoint": {
                "data_selector": "$",
                "path": "/legal_hold_policies/{legal_hold_policy_id}",
                "params": {
                    "legal_hold_policy_id": {
                        "type": "resolve",
                        "resource": "get_legal_hold_policies",
                        "field": "id",
                    },

                },
            }
        },
        # Retrieves a list of items a legal hold policy has been assigned to.
        {
            "name": "get_legal_hold_policy_assignments",
            "table_name": "legal_hold_policy_assignment",
            "primary_key": "id",
            "write_disposition": "merge",
            "endpoint": {
                "data_selector": "entries",
                "path": "/legal_hold_policy_assignments",
                "params": {
                    "policy_id": "FILL_ME_IN", # TODO: fill in required query parameter
                    # the parameters below can optionally be configured
                    # "assign_to_type": "OPTIONAL_CONFIG",
                    # "assign_to_id": "OPTIONAL_CONFIG",
                    # "marker": "OPTIONAL_CONFIG",
                    # "limit": "OPTIONAL_CONFIG",
                    # "fields": "OPTIONAL_CONFIG",

                },
            }
        },
        # Retrieve a legal hold policy assignment.
        {
            "name": "get_legal_hold_policy_assignments_id",
            "table_name": "legal_hold_policy_assignment",
            "primary_key": "id",
            "write_disposition": "merge",
            "endpoint": {
                "data_selector": "$",
                "path": "/legal_hold_policy_assignments/{legal_hold_policy_assignment_id}",
                "params": {
                    "legal_hold_policy_assignment_id": {
                        "type": "resolve",
                        "resource": "get_legal_hold_policy_assignments",
                        "field": "id",
                    },

                },
            }
        },
        # Retrieves all the groups for a user. Only members of this group or users with admin-level permissions will be able to use this API.
        {
            "name": "get_users_id_memberships",
            "table_name": "membership",
            "endpoint": {
                "data_selector": "order",
                "path": "/users/{user_id}/memberships",
                "params": {
                    "user_id": "FILL_ME_IN", # TODO: fill in required path parameter

                },
            }
        },
        # Retrieves all the members for a group. Only members of this group or users with admin-level permissions will be able to use this API.
        {
            "name": "get_groups_id_memberships",
            "table_name": "membership",
            "endpoint": {
                "data_selector": "order",
                "path": "/groups/{group_id}/memberships",
                "params": {
                    "group_id": "FILL_ME_IN", # TODO: fill in required path parameter

                },
            }
        },
        # Retrieves all metadata for a given file.
        {
            "name": "get_files_id_metadata",
            "table_name": "metadata",
            "endpoint": {
                "data_selector": "entries",
                "path": "/files/{file_id}/metadata",
                "params": {
                    "file_id": "FILL_ME_IN", # TODO: fill in required path parameter

                },
            }
        },
        # Retrieves all metadata for a given folder. This can not be used on the root folder with ID `0`.
        {
            "name": "get_folders_id_metadata",
            "table_name": "metadata",
            "endpoint": {
                "data_selector": "entries",
                "path": "/folders/{folder_id}/metadata",
                "params": {
                    "folder_id": "FILL_ME_IN", # TODO: fill in required path parameter

                },
            }
        },
        # Retrieves a list of all the metadata cascade policies that are applied to a given folder. This can not be used on the root folder with ID `0`.
        {
            "name": "get_metadata_cascade_policies",
            "table_name": "metadata_cascade_policy",
            "primary_key": "id",
            "write_disposition": "merge",
            "endpoint": {
                "data_selector": "entries",
                "path": "/metadata_cascade_policies",
                "params": {
                    "folder_id": "FILL_ME_IN", # TODO: fill in required query parameter
                    # the parameters below can optionally be configured
                    # "owner_enterprise_id": "OPTIONAL_CONFIG",
                    # "marker": "OPTIONAL_CONFIG",
                    # "offset": "OPTIONAL_CONFIG",

                },
            }
        },
        # Retrieve a specific metadata cascade policy assigned to a folder.
        {
            "name": "get_metadata_cascade_policies_id",
            "table_name": "metadata_cascade_policy",
            "primary_key": "id",
            "write_disposition": "merge",
            "endpoint": {
                "data_selector": "$",
                "path": "/metadata_cascade_policies/{metadata_cascade_policy_id}",
                "params": {
                    "metadata_cascade_policy_id": {
                        "type": "resolve",
                        "resource": "get_metadata_cascade_policies",
                        "field": "id",
                    },

                },
            }
        },
        # Retrieves a metadata template by its `scope` and `templateKey` values.  To find the `scope` and `templateKey` for a template, list all templates for an enterprise or globally, or list all templates applied to a file or folder.
        {
            "name": "get_metadata_templates_id_id_schema",
            "table_name": "metadata_field_read",
            "primary_key": "id",
            "write_disposition": "merge",
            "endpoint": {
                "data_selector": "fields",
                "path": "/metadata_templates/{scope}/{template_key}/schema",
                "params": {
                    "template_key": {
                        "type": "resolve",
                        "resource": "get_metadata_templates",
                        "field": "id",
                    },
                    "scope": "FILL_ME_IN", # TODO: fill in required path parameter

                },
            }
        },
        # Finds a metadata template by searching for the ID of an instance of the template.
        {
            "name": "get_metadata_templates",
            "table_name": "metadata_template",
            "primary_key": "id",
            "write_disposition": "merge",
            "endpoint": {
                "data_selector": "entries",
                "path": "/metadata_templates",
                "params": {
                    "metadata_instance_id": "FILL_ME_IN", # TODO: fill in required query parameter

                },
            }
        },
        # Retrieves a metadata template by its ID.
        {
            "name": "get_metadata_templates_id",
            "table_name": "metadata_template",
            "primary_key": "id",
            "write_disposition": "merge",
            "endpoint": {
                "data_selector": "$",
                "path": "/metadata_templates/{template_id}",
                "params": {
                    "template_id": {
                        "type": "resolve",
                        "resource": "get_metadata_templates",
                        "field": "id",
                    },

                },
            }
        },
        # Used to retrieve all generic, global metadata templates available to all enterprises using Box.
        {
            "name": "get_metadata_templates_global",
            "table_name": "metadata_template",
            "primary_key": "id",
            "write_disposition": "merge",
            "endpoint": {
                "data_selector": "entries",
                "path": "/metadata_templates/global",
                "params": {
                    # the parameters below can optionally be configured
                    # "marker": "OPTIONAL_CONFIG",
                    # "limit": "OPTIONAL_CONFIG",

                },
            }
        },
        # Used to retrieve all metadata templates created to be used specifically within the user's enterprise
        {
            "name": "get_metadata_templates_enterprise",
            "table_name": "metadata_template",
            "primary_key": "id",
            "write_disposition": "merge",
            "endpoint": {
                "data_selector": "entries",
                "path": "/metadata_templates/enterprise",
                "params": {
                    # the parameters below can optionally be configured
                    # "marker": "OPTIONAL_CONFIG",
                    # "limit": "OPTIONAL_CONFIG",

                },
            }
        },
        # Return a list of the chunks uploaded to the upload session so far.
        {
            "name": "get_files_upload_sessions_id_parts",
            "table_name": "part",
            "endpoint": {
                "data_selector": "order",
                "path": "/files/upload_sessions/{upload_session_id}/parts",
                "params": {
                    "upload_session_id": "FILL_ME_IN", # TODO: fill in required path parameter

                },
            }
        },
        # Returns information about the recent items accessed by a user, either in the last 90 days or up to the last 1000 items accessed.
        {
            "name": "get_recent_items",
            "table_name": "recent_item",
            "endpoint": {
                "data_selector": "entries",
                "path": "/recent_items",
                "params": {
                    # the parameters below can optionally be configured
                    # "fields": "OPTIONAL_CONFIG",
                    # "limit": "OPTIONAL_CONFIG",
                    # "marker": "OPTIONAL_CONFIG",

                },
            }
        },
        # Retrieves all of the retention policies for an enterprise.
        {
            "name": "get_retention_policies",
            "table_name": "retention_policy",
            "primary_key": "id",
            "write_disposition": "merge",
            "endpoint": {
                "data_selector": "entries",
                "path": "/retention_policies",
                "params": {
                    # the parameters below can optionally be configured
                    # "policy_name": "OPTIONAL_CONFIG",
                    # "policy_type": "OPTIONAL_CONFIG",
                    # "created_by_user_id": "OPTIONAL_CONFIG",
                    # "fields": "OPTIONAL_CONFIG",
                    # "limit": "OPTIONAL_CONFIG",
                    # "marker": "OPTIONAL_CONFIG",

                },
            }
        },
        # Retrieves a retention policy.
        {
            "name": "get_retention_policies_id",
            "table_name": "retention_policy",
            "primary_key": "id",
            "write_disposition": "merge",
            "endpoint": {
                "data_selector": "$",
                "path": "/retention_policies/{retention_policy_id}",
                "params": {
                    "retention_policy_id": {
                        "type": "resolve",
                        "resource": "get_retention_policies",
                        "field": "id",
                    },
                    # the parameters below can optionally be configured
                    # "fields": "OPTIONAL_CONFIG",

                },
            }
        },
        # Returns a list of all retention policy assignments associated with a specified retention policy.
        {
            "name": "get_retention_policies_id_assignments",
            "table_name": "retention_policy_assignment",
            "primary_key": "id",
            "write_disposition": "merge",
            "endpoint": {
                "data_selector": "entries",
                "path": "/retention_policies/{retention_policy_id}/assignments",
                "params": {
                    "retention_policy_id": {
                        "type": "resolve",
                        "resource": "get_retention_policies",
                        "field": "id",
                    },
                    # the parameters below can optionally be configured
                    # "type": "OPTIONAL_CONFIG",
                    # "fields": "OPTIONAL_CONFIG",
                    # "marker": "OPTIONAL_CONFIG",
                    # "limit": "OPTIONAL_CONFIG",

                },
            }
        },
        # Retrieves a retention policy assignment
        {
            "name": "get_retention_policy_assignments_id",
            "table_name": "retention_policy_assignment",
            "primary_key": "id",
            "write_disposition": "merge",
            "endpoint": {
                "data_selector": "$",
                "path": "/retention_policy_assignments/{retention_policy_assignment_id}",
                "params": {
                    "retention_policy_assignment_id": "FILL_ME_IN", # TODO: fill in required path parameter
                    # the parameters below can optionally be configured
                    # "fields": "OPTIONAL_CONFIG",

                },
            }
        },
        # Retrieves the classification metadata template and lists all the classifications available to this enterprise.  This API can also be called by including the enterprise ID in the URL explicitly, for example `/metadata_templates/enterprise_12345/securityClassification-6VMVochwUWo/schema`.
        {
            "name": "get_metadata_templates_enterprise_security_classification_6vm_vochw_u_wo_schema",
            "table_name": "schema",
            "primary_key": "id",
            "write_disposition": "merge",
            "endpoint": {
                "data_selector": "fields",
                "path": "/metadata_templates/enterprise/securityClassification-6VMVochwUWo/schema",
            }
        },
        # Searches for files, folders, web links, and shared files across the users content or across the entire enterprise.
        {
            "name": "get_search",
            "table_name": "search_result_with_shared_link",
            "endpoint": {
                "data_selector": "entries",
                "path": "/search",
                "params": {
                    # the parameters below can optionally be configured
                    # "query": "OPTIONAL_CONFIG",
                    # "scope": "user_content",
                    # "file_extensions": "OPTIONAL_CONFIG",
                    # "created_at_range": "OPTIONAL_CONFIG",
                    # "updated_at_range": "OPTIONAL_CONFIG",
                    # "size_range": "OPTIONAL_CONFIG",
                    # "owner_user_ids": "OPTIONAL_CONFIG",
                    # "recent_updater_user_ids": "OPTIONAL_CONFIG",
                    # "ancestor_folder_ids": "OPTIONAL_CONFIG",
                    # "content_types": "OPTIONAL_CONFIG",
                    # "type": "OPTIONAL_CONFIG",
                    # "trash_content": "non_trashed_only",
                    # "mdfilters": "OPTIONAL_CONFIG",
                    # "sort": "relevance",
                    # "direction": "DESC",
                    # "include_recent_shared_links": "OPTIONAL_CONFIG",
                    # "fields": "OPTIONAL_CONFIG",
                    # "deleted_user_ids": "OPTIONAL_CONFIG",
                    # "deleted_at_range": "OPTIONAL_CONFIG",

                },
                "paginator": {
                    "type":
                        "offset",
                    "limit":
                        200,
                    "offset_param":
                        "offset",
                    "limit_param":
                        "limit",
                    "total_path":
                        "total_count",
                },
            }
        },
        # Returns the file represented by a shared link.  A shared file can be represented by a shared link, which can originate within the current enterprise or within another.  This endpoint allows an application to retrieve information about a shared file when only given a shared link.  The `shared_link_permission_options` array field can be returned by requesting it in the `fields` query parameter.
        {
            "name": "get_shared_items",
            "table_name": "shared_item",
            "endpoint": {
                "data_selector": "tags",
                "path": "/shared_items",
                "params": {
                    # the parameters below can optionally be configured
                    # "fields": "OPTIONAL_CONFIG",

                },
            }
        },
        # Return the folder represented by a shared link.  A shared folder can be represented by a shared link, which can originate within the current enterprise or within another.  This endpoint allows an application to retrieve information about a shared folder when only given a shared link.
        {
            "name": "get_shared_itemsfolders",
            "table_name": "shared_itemsfolder",
            "endpoint": {
                "data_selector": "tags",
                "path": "/shared_items#folders",
                "params": {
                    # the parameters below can optionally be configured
                    # "fields": "OPTIONAL_CONFIG",

                },
            }
        },
        # Get shield information barrier based on provided ID.
        {
            "name": "get_shield_information_barriers_id",
            "table_name": "shield_information_barrier",
            "primary_key": "id",
            "write_disposition": "merge",
            "endpoint": {
                "data_selector": "$",
                "path": "/shield_information_barriers/{shield_information_barrier_id}",
                "params": {
                    "shield_information_barrier_id": {
                        "type": "resolve",
                        "resource": "get_shield_information_barriers",
                        "field": "id",
                    },

                },
            }
        },
        # Retrieves a list of shield information barrier objects for the enterprise of JWT.
        {
            "name": "get_shield_information_barriers",
            "table_name": "shield_information_barrier",
            "primary_key": "id",
            "write_disposition": "merge",
            "endpoint": {
                "data_selector": "entries",
                "path": "/shield_information_barriers",
                "params": {
                    # the parameters below can optionally be configured
                    # "marker": "OPTIONAL_CONFIG",
                    # "limit": "OPTIONAL_CONFIG",

                },
            }
        },
        # Lists shield information barrier reports.
        {
            "name": "get_shield_information_barrier_reports",
            "table_name": "shield_information_barrier_report",
            "primary_key": "id",
            "write_disposition": "merge",
            "endpoint": {
                "data_selector": "entries",
                "path": "/shield_information_barrier_reports",
                "params": {
                    "shield_information_barrier_id": "FILL_ME_IN", # TODO: fill in required query parameter
                    # the parameters below can optionally be configured
                    # "marker": "OPTIONAL_CONFIG",
                    # "limit": "OPTIONAL_CONFIG",

                },
            }
        },
        # Retrieves a shield information barrier report by its ID.
        {
            "name": "get_shield_information_barrier_reports_id",
            "table_name": "shield_information_barrier_report",
            "primary_key": "id",
            "write_disposition": "merge",
            "endpoint": {
                "data_selector": "$",
                "path": "/shield_information_barrier_reports/{shield_information_barrier_report_id}",
                "params": {
                    "shield_information_barrier_report_id": {
                        "type": "resolve",
                        "resource": "get_shield_information_barrier_reports",
                        "field": "id",
                    },

                },
            }
        },
        # Retrieves shield information barrier segment based on provided ID..
        {
            "name": "get_shield_information_barrier_segments_id",
            "table_name": "shield_information_barrier_segment",
            "primary_key": "id",
            "write_disposition": "merge",
            "endpoint": {
                "data_selector": "$",
                "path": "/shield_information_barrier_segments/{shield_information_barrier_segment_id}",
                "params": {
                    "shield_information_barrier_segment_id": {
                        "type": "resolve",
                        "resource": "get_shield_information_barrier_segments",
                        "field": "id",
                    },

                },
            }
        },
        # Retrieves a list of shield information barrier segment objects for the specified Information Barrier ID.
        {
            "name": "get_shield_information_barrier_segments",
            "table_name": "shield_information_barrier_segment",
            "primary_key": "id",
            "write_disposition": "merge",
            "endpoint": {
                "data_selector": "entries",
                "path": "/shield_information_barrier_segments",
                "params": {
                    "shield_information_barrier_id": "FILL_ME_IN", # TODO: fill in required query parameter
                    # the parameters below can optionally be configured
                    # "marker": "OPTIONAL_CONFIG",
                    # "limit": "OPTIONAL_CONFIG",

                },
            }
        },
        # Retrieves a shield information barrier segment member by its ID.
        {
            "name": "get_shield_information_barrier_segment_members_id",
            "table_name": "shield_information_barrier_segment_member",
            "primary_key": "id",
            "write_disposition": "merge",
            "endpoint": {
                "data_selector": "$",
                "path": "/shield_information_barrier_segment_members/{shield_information_barrier_segment_member_id}",
                "params": {
                    "shield_information_barrier_segment_member_id": {
                        "type": "resolve",
                        "resource": "get_shield_information_barrier_segment_members",
                        "field": "id",
                    },

                },
            }
        },
        # Lists shield information barrier segment members based on provided segment IDs.
        {
            "name": "get_shield_information_barrier_segment_members",
            "table_name": "shield_information_barrier_segment_member",
            "primary_key": "id",
            "write_disposition": "merge",
            "endpoint": {
                "data_selector": "entries",
                "path": "/shield_information_barrier_segment_members",
                "params": {
                    "shield_information_barrier_segment_id": "FILL_ME_IN", # TODO: fill in required query parameter
                    # the parameters below can optionally be configured
                    # "marker": "OPTIONAL_CONFIG",
                    # "limit": "OPTIONAL_CONFIG",

                },
            }
        },
        # Retrieves a shield information barrier segment restriction based on provided ID.
        {
            "name": "get_shield_information_barrier_segment_restrictions_id",
            "table_name": "shield_information_barrier_segment_restriction",
            "primary_key": "id",
            "write_disposition": "merge",
            "endpoint": {
                "data_selector": "$",
                "path": "/shield_information_barrier_segment_restrictions/{shield_information_barrier_segment_restriction_id}",
                "params": {
                    "shield_information_barrier_segment_restriction_id": {
                        "type": "resolve",
                        "resource": "get_shield_information_barrier_segment_restrictions",
                        "field": "id",
                    },

                },
            }
        },
        # Lists shield information barrier segment restrictions based on provided segment ID.
        {
            "name": "get_shield_information_barrier_segment_restrictions",
            "table_name": "shield_information_barrier_segment_restriction",
            "primary_key": "id",
            "write_disposition": "merge",
            "endpoint": {
                "data_selector": "entries",
                "path": "/shield_information_barrier_segment_restrictions",
                "params": {
                    "shield_information_barrier_segment_id": "FILL_ME_IN", # TODO: fill in required query parameter
                    # the parameters below can optionally be configured
                    # "marker": "OPTIONAL_CONFIG",
                    # "limit": "OPTIONAL_CONFIG",

                },
            }
        },
        # Gets a sign request by ID.
        {
            "name": "get_sign_requests_id",
            "table_name": "sign_request",
            "primary_key": "id",
            "write_disposition": "merge",
            "endpoint": {
                "data_selector": "$",
                "path": "/sign_requests/{sign_request_id}",
                "params": {
                    "sign_request_id": {
                        "type": "resolve",
                        "resource": "get_sign_requests",
                        "field": "id",
                    },

                },
            }
        },
        # Gets signature requests created by a user. If the `sign_files` and/or `parent_folder` are deleted, the signature request will not return in the list.
        {
            "name": "get_sign_requests",
            "table_name": "sign_request",
            "primary_key": "id",
            "write_disposition": "merge",
            "endpoint": {
                "data_selector": "entries",
                "path": "/sign_requests",
                "params": {
                    # the parameters below can optionally be configured
                    # "marker": "OPTIONAL_CONFIG",
                    # "limit": "OPTIONAL_CONFIG",

                },
            }
        },
        # Gets Box Sign templates created by a user.
        {
            "name": "get_sign_templates",
            "table_name": "sign_template",
            "primary_key": "id",
            "write_disposition": "merge",
            "endpoint": {
                "data_selector": "entries",
                "path": "/sign_templates",
                "params": {
                    # the parameters below can optionally be configured
                    # "marker": "OPTIONAL_CONFIG",
                    # "limit": "OPTIONAL_CONFIG",

                },
            }
        },
        # Fetches details of a specific Box Sign template.
        {
            "name": "get_sign_templates_id",
            "table_name": "sign_template",
            "primary_key": "id",
            "write_disposition": "merge",
            "endpoint": {
                "data_selector": "$",
                "path": "/sign_templates/{template_id}",
                "params": {
                    "template_id": {
                        "type": "resolve",
                        "resource": "get_sign_templates",
                        "field": "id",
                    },

                },
            }
        },
        # Fetches all the storage policies in the enterprise.
        {
            "name": "get_storage_policies",
            "table_name": "storage_policy",
            "primary_key": "id",
            "write_disposition": "merge",
            "endpoint": {
                "data_selector": "entries",
                "path": "/storage_policies",
                "params": {
                    # the parameters below can optionally be configured
                    # "fields": "OPTIONAL_CONFIG",
                    # "marker": "OPTIONAL_CONFIG",
                    # "limit": "OPTIONAL_CONFIG",

                },
            }
        },
        # Fetches a specific storage policy.
        {
            "name": "get_storage_policies_id",
            "table_name": "storage_policy",
            "primary_key": "id",
            "write_disposition": "merge",
            "endpoint": {
                "data_selector": "$",
                "path": "/storage_policies/{storage_policy_id}",
                "params": {
                    "storage_policy_id": {
                        "type": "resolve",
                        "resource": "get_storage_policies",
                        "field": "id",
                    },

                },
            }
        },
        # Fetches all the storage policy assignment for an enterprise or user.
        {
            "name": "get_storage_policy_assignments",
            "table_name": "storage_policy_assignment",
            "primary_key": "id",
            "write_disposition": "merge",
            "endpoint": {
                "data_selector": "entries",
                "path": "/storage_policy_assignments",
                "params": {
                    "resolved_for_type": "FILL_ME_IN", # TODO: fill in required query parameter
                    "resolved_for_id": "FILL_ME_IN", # TODO: fill in required query parameter
                    # the parameters below can optionally be configured
                    # "marker": "OPTIONAL_CONFIG",

                },
            }
        },
        # Fetches a specific storage policy assignment.
        {
            "name": "get_storage_policy_assignments_id",
            "table_name": "storage_policy_assignment",
            "primary_key": "id",
            "write_disposition": "merge",
            "endpoint": {
                "data_selector": "$",
                "path": "/storage_policy_assignments/{storage_policy_assignment_id}",
                "params": {
                    "storage_policy_assignment_id": {
                        "type": "resolve",
                        "resource": "get_storage_policy_assignments",
                        "field": "id",
                    },

                },
            }
        },
        # Retrieves a list of all the tasks for a file. This endpoint does not support pagination.
        {
            "name": "get_files_id_tasks",
            "table_name": "task",
            "primary_key": "id",
            "write_disposition": "merge",
            "endpoint": {
                "data_selector": "entries",
                "path": "/files/{file_id}/tasks",
                "params": {
                    "file_id": "FILL_ME_IN", # TODO: fill in required path parameter

                },
            }
        },
        # Retrieves information about a specific task.
        {
            "name": "get_tasks_id",
            "table_name": "task",
            "primary_key": "id",
            "write_disposition": "merge",
            "endpoint": {
                "data_selector": "$",
                "path": "/tasks/{task_id}",
                "params": {
                    "task_id": "FILL_ME_IN", # TODO: fill in required path parameter

                },
            }
        },
        # Lists all of the assignments for a given task.
        {
            "name": "get_tasks_id_assignments",
            "table_name": "task_assignment",
            "primary_key": "id",
            "write_disposition": "merge",
            "endpoint": {
                "data_selector": "entries",
                "path": "/tasks/{task_id}/assignments",
                "params": {
                    "task_id": "FILL_ME_IN", # TODO: fill in required path parameter

                },
            }
        },
        # Retrieves information about a task assignment.
        {
            "name": "get_task_assignments_id",
            "table_name": "task_assignment",
            "primary_key": "id",
            "write_disposition": "merge",
            "endpoint": {
                "data_selector": "$",
                "path": "/task_assignments/{task_assignment_id}",
                "params": {
                    "task_assignment_id": "FILL_ME_IN", # TODO: fill in required path parameter

                },
            }
        },
        # Returns the current terms of service text and settings for the enterprise.
        {
            "name": "get_terms_of_services",
            "table_name": "terms_of_service",
            "primary_key": "id",
            "write_disposition": "merge",
            "endpoint": {
                "data_selector": "entries",
                "path": "/terms_of_services",
                "params": {
                    # the parameters below can optionally be configured
                    # "tos_type": "OPTIONAL_CONFIG",

                },
            }
        },
        # Fetches a specific terms of service.
        {
            "name": "get_terms_of_services_id",
            "table_name": "terms_of_service",
            "primary_key": "id",
            "write_disposition": "merge",
            "endpoint": {
                "data_selector": "$",
                "path": "/terms_of_services/{terms_of_service_id}",
                "params": {
                    "terms_of_service_id": {
                        "type": "resolve",
                        "resource": "get_terms_of_services",
                        "field": "id",
                    },

                },
            }
        },
        # Retrieves an overview of users and their status for a terms of service, including Whether they have accepted the terms and when.
        {
            "name": "get_terms_of_service_user_statuses",
            "table_name": "terms_of_service_user_status",
            "primary_key": "id",
            "write_disposition": "merge",
            "endpoint": {
                "data_selector": "entries",
                "path": "/terms_of_service_user_statuses",
                "params": {
                    "tos_id": "FILL_ME_IN", # TODO: fill in required query parameter
                    # the parameters below can optionally be configured
                    # "user_id": "OPTIONAL_CONFIG",

                },
            }
        },
        # Retrieves a thumbnail, or smaller image representation, of a file.  Sizes of `32x32`,`64x64`, `128x128`, and `256x256` can be returned in the `.png` format and sizes of `32x32`, `160x160`, and `320x320` can be returned in the `.jpg` format.  Thumbnails can be generated for the image and video file formats listed [found on our community site][1].  [1]: https://community.box.com/t5/Migrating-and-Previewing-Content/File-Types-and-Fonts-Supported-in-Box-Content-Preview/ta-p/327
        {
            "name": "get_files_id_thumbnail_id",
            "table_name": "thumbnail",
            "endpoint": {
                "path": "/files/{file_id}/thumbnail.{extension}",
                "params": {
                    "file_id": "FILL_ME_IN", # TODO: fill in required path parameter
                    # the parameters below can optionally be configured
                    # "min_height": "OPTIONAL_CONFIG",
                    # "min_width": "OPTIONAL_CONFIG",
                    # "max_height": "OPTIONAL_CONFIG",
                    # "max_width": "OPTIONAL_CONFIG",

                },
            }
        },
        # Retrieves information about the user who is currently authenticated.  In the case of a client-side authenticated OAuth 2.0 application this will be the user who authorized the app.  In the case of a JWT, server-side authenticated application this will be the service account that belongs to the application by default.  Use the `As-User` header to change who this API call is made on behalf of.
        {
            "name": "get_users_me",
            "table_name": "tracking_code",
            "endpoint": {
                "data_selector": "tracking_codes",
                "path": "/users/me",
                "params": {
                    # the parameters below can optionally be configured
                    # "fields": "OPTIONAL_CONFIG",

                },
            }
        },
        # Retrieves a file that has been moved to the trash.  Please note that only if the file itself has been moved to the trash can it be retrieved with this API call. If instead one of its parent folders was moved to the trash, only that folder can be inspected using the [`GET /folders/:id/trash`](e://get_folders_id_trash) API.  To list all items that have been moved to the trash, please use the [`GET /folders/trash/items`](e://get-folders-trash-items/) API.
        {
            "name": "get_files_id_trash",
            "table_name": "trash",
            "primary_key": "id",
            "write_disposition": "merge",
            "endpoint": {
                "data_selector": "path_collection.entries",
                "path": "/files/{file_id}/trash",
                "params": {
                    "file_id": "FILL_ME_IN", # TODO: fill in required path parameter
                    # the parameters below can optionally be configured
                    # "fields": "OPTIONAL_CONFIG",

                },
            }
        },
        # Retrieves a folder that has been moved to the trash.  Please note that only if the folder itself has been moved to the trash can it be retrieved with this API call. If instead one of its parent folders was moved to the trash, only that folder can be inspected using the [`GET /folders/:id/trash`](e://get_folders_id_trash) API.  To list all items that have been moved to the trash, please use the [`GET /folders/trash/items`](e://get-folders-trash-items/) API.
        {
            "name": "get_folders_id_trash",
            "table_name": "trash",
            "primary_key": "id",
            "write_disposition": "merge",
            "endpoint": {
                "data_selector": "path_collection.entries",
                "path": "/folders/{folder_id}/trash",
                "params": {
                    "folder_id": "FILL_ME_IN", # TODO: fill in required path parameter
                    # the parameters below can optionally be configured
                    # "fields": "OPTIONAL_CONFIG",

                },
            }
        },
        # Retrieves a web link that has been moved to the trash.
        {
            "name": "get_web_links_id_trash",
            "table_name": "trash",
            "primary_key": "id",
            "write_disposition": "merge",
            "endpoint": {
                "data_selector": "path_collection.entries",
                "path": "/web_links/{web_link_id}/trash",
                "params": {
                    "web_link_id": "FILL_ME_IN", # TODO: fill in required path parameter
                    # the parameters below can optionally be configured
                    # "fields": "OPTIONAL_CONFIG",

                },
            }
        },
        # Return information about an upload session.
        {
            "name": "get_files_upload_sessions_id",
            "table_name": "upload_session",
            "primary_key": "id",
            "write_disposition": "merge",
            "endpoint": {
                "data_selector": "$",
                "path": "/files/upload_sessions/{upload_session_id}",
                "params": {
                    "upload_session_id": "FILL_ME_IN", # TODO: fill in required path parameter

                },
            }
        },
        # Returns a list of all users for the Enterprise along with their `user_id`, `public_name`, and `login`.  The application and the authenticated user need to have the permission to look up users in the entire enterprise.
        {
            "name": "get_users",
            "table_name": "user",
            "endpoint": {
                "data_selector": "order",
                "path": "/users",
                "params": {
                    # the parameters below can optionally be configured
                    # "filter_term": "OPTIONAL_CONFIG",
                    # "user_type": "OPTIONAL_CONFIG",
                    # "external_app_user_id": "OPTIONAL_CONFIG",
                    # "fields": "OPTIONAL_CONFIG",
                    # "usemarker": "OPTIONAL_CONFIG",
                    # "marker": "OPTIONAL_CONFIG",

                },
            }
        },
        # Retrieves information about a user in the enterprise.  The application and the authenticated user need to have the permission to look up users in the entire enterprise.  This endpoint also returns a limited set of information for external users who are collaborated on content owned by the enterprise for authenticated users with the right scopes. In this case, disallowed fields will return null instead.
        {
            "name": "get_users_id",
            "table_name": "user_full",
            "primary_key": "id",
            "write_disposition": "merge",
            "endpoint": {
                "data_selector": "$",
                "path": "/users/{user_id}",
                "params": {
                    "user_id": "FILL_ME_IN", # TODO: fill in required path parameter
                    # the parameters below can optionally be configured
                    # "fields": "OPTIONAL_CONFIG",

                },
            }
        },
        # Retrieve a list of the past versions for a file.  Versions are only tracked by Box users with premium accounts. To fetch the ID of the current version of a file, use the `GET /file/:id` API.
        {
            "name": "get_files_id_versions",
            "table_name": "version",
            "endpoint": {
                "data_selector": "order",
                "path": "/files/{file_id}/versions",
                "params": {
                    "file_id": "FILL_ME_IN", # TODO: fill in required path parameter
                    # the parameters below can optionally be configured
                    # "fields": "OPTIONAL_CONFIG",

                },
            }
        },
        # Retrieve the watermark for a file.
        {
            "name": "get_files_id_watermark",
            "table_name": "watermark",
            "endpoint": {
                "data_selector": "watermark",
                "path": "/files/{file_id}/watermark",
                "params": {
                    "file_id": "FILL_ME_IN", # TODO: fill in required path parameter

                },
            }
        },
        # Retrieve the watermark for a folder.
        {
            "name": "get_folders_id_watermark",
            "table_name": "watermark",
            "endpoint": {
                "data_selector": "watermark",
                "path": "/folders/{folder_id}/watermark",
                "params": {
                    "folder_id": "FILL_ME_IN", # TODO: fill in required path parameter

                },
            }
        },
        # Retrieve information about a web link.
        {
            "name": "get_web_links_id",
            "table_name": "web_link",
            "primary_key": "id",
            "write_disposition": "merge",
            "endpoint": {
                "data_selector": "$",
                "path": "/web_links/{web_link_id}",
                "params": {
                    "web_link_id": "FILL_ME_IN", # TODO: fill in required path parameter

                },
            }
        },
        # Retrieves a specific webhook
        {
            "name": "get_webhooks_id",
            "table_name": "webhook",
            "primary_key": "id",
            "write_disposition": "merge",
            "endpoint": {
                "data_selector": "$",
                "path": "/webhooks/{webhook_id}",
                "params": {
                    "webhook_id": {
                        "type": "resolve",
                        "resource": "get_webhooks",
                        "field": "id",
                    },

                },
            }
        },
        # Returns all defined webhooks for the requesting application.  This API only returns webhooks that are applied to files or folders that are owned by the authenticated user. This means that an admin can not see webhooks created by a service account unless the admin has access to those folders, and vice versa.
        {
            "name": "get_webhooks",
            "table_name": "webhook_mini",
            "primary_key": "id",
            "write_disposition": "merge",
            "endpoint": {
                "data_selector": "entries",
                "path": "/webhooks",
                "params": {
                    # the parameters below can optionally be configured
                    # "marker": "OPTIONAL_CONFIG",
                    # "limit": "OPTIONAL_CONFIG",

                },
            }
        },
        # Returns list of workflows that act on a given `folder ID`, and have a flow with a trigger type of `WORKFLOW_MANUAL_START`.  You application must be authorized to use the `Manage Box Relay` application scope within the developer console in to use this endpoint.
        {
            "name": "get_workflows",
            "table_name": "workflow",
            "primary_key": "id",
            "write_disposition": "merge",
            "endpoint": {
                "data_selector": "entries",
                "path": "/workflows",
                "params": {
                    "folder_id": "FILL_ME_IN", # TODO: fill in required query parameter
                    # the parameters below can optionally be configured
                    # "trigger_type": "OPTIONAL_CONFIG",
                    # "limit": "OPTIONAL_CONFIG",
                    # "marker": "OPTIONAL_CONFIG",

                },
            }
        },
        # Returns the download status of a `zip` archive, allowing an application to inspect the progress of the download as well as the number of items that might have been skipped.  This endpoint can only be accessed once the download has started. Subsequently this endpoint is valid for 12 hours from the start of the download.  The URL of this endpoint should not be considered as fixed. Instead, use the [Create zip download](e://post_zip_downloads) API to request to create a `zip` archive, and then follow the `status_url` field in the response to this endpoint.
        {
            "name": "get_zip_downloads_id_status",
            "table_name": "zip_download_status",
            "endpoint": {
                "data_selector": "$",
                "path": "/zip_downloads/{zip_download_id}/status",
                "params": {
                    "zip_download_id": "FILL_ME_IN", # TODO: fill in required path parameter

                },
            }
        },
        ]
    }

    return rest_api_source(source_config)

2. Configuring your source and destination credentials

info

dlt-init-openapi will try to detect which authentication mechanism (if any) is used by the API in question and add a placeholder in your secrets.toml.

• If you know your API needs authentication, but none was detected, you can learn more about adding authentication to the rest_api here.
• OAuth detection currently is not supported, but you can supply your own authentication mechanism as outlined here.

The dlt cli will have created a .dlt directory in your project folder. This directory contains a config.toml file and a secrets.toml file that you can use to configure your pipeline. The automatically created version of these files look like this:

generated config.toml

[runtime]
log_level="INFO"

[sources.box]
# Base URL for the API
# Box Platform API server
base_url = "https://api.box.com/2.0"

generated secrets.toml

[sources.box]
# secrets for your box source
# example_api_key = "example value"

2.1. Adjust the generated code to your usecase

Further help setting up your source and destinations

At this time, the dlt-init-openapi cli tool will always create pipelines that load to a local duckdb instance. Switching to a different destination is trivial, all you need to do is change the destination parameter in box_pipeline.py to mssql and supply the credentials as outlined in the destination doc linked below.

• Read more about setting up the rest_api source in our docs.
• Read more about setting up the Microsoft SQL Server destination in our docs.

3. Running your pipeline for the first time

The dlt cli has also created a main pipeline script for you at box_pipeline.py, as well as a folder box that contains additional python files for your source. These files are your local copies which you can modify to fit your needs. In some cases you may find that you only need to do small changes to your pipelines or add some configurations, in other cases these files can serve as a working starting point for your code, but will need to be adjusted to do what you need them to do.

The main pipeline script will look something like this:

import dlt

from box import box_source


if __name__ == "__main__":
    pipeline = dlt.pipeline(
        pipeline_name="box_pipeline",
        destination='duckdb',
        dataset_name="box_data",
        progress="log",
        export_schema_path="schemas/export"
    )
    source = box_source()
    info = pipeline.run(source)
    print(info)

Provided you have set up your credentials, you can run your pipeline like a regular python script with the following command:

python box_pipeline.py

4. Inspecting your load result

You can now inspect the state of your pipeline with the dlt cli:

dlt pipeline box_pipeline info

You can also use streamlit to inspect the contents of your Microsoft SQL Server destination for this:

# install streamlit
pip install streamlit
# run the streamlit app for your pipeline with the dlt cli:
dlt pipeline box_pipeline show

5. Next steps to get your pipeline running in production

One of the beauties of dlt is, that we are just a plain Python library, so you can run your pipeline in any environment that supports Python >= 3.8. We have a couple of helpers and guides in our docs to get you there:

The Deploy section will show you how to deploy your pipeline to

• Deploy with GitHub Actions: Automate your pipeline deployment using GitHub Actions. This CI/CD runner allows you to schedule and trigger your deployments for free.
• Deploy with Airflow and Google Composer: Learn how to deploy your pipeline using Airflow and Google Composer. This guide provides step-by-step instructions for setting up your DAGs and syncing with Airflow.
• Deploy with Google Cloud Functions: Follow the guide on deploying your pipeline with Google Cloud Functions. This serverless approach allows you to deploy your pipeline with ease.
• Explore Other Deployment Options: Check out additional methods for deploying your pipeline in the comprehensive deployment guide. This resource covers various deployment strategies to suit your needs.

The running in production section will teach you about:

• How to Monitor your pipeline: Learn how to effectively monitor your dlt pipeline in production to ensure smooth operation and quick issue detection. How to Monitor your pipeline
• Set up alerts: Set up alerts to get notified about critical events and issues in your dlt pipeline, helping you to take immediate action. Set up alerts
• Set up tracing: Implement tracing in your dlt pipeline to get detailed insights into the pipeline's execution and performance. And set up tracing

Available Sources and Resources

For this verified source the following sources and resources are available

Source Box Platform API

Access and manage Box Platform data including files, users, comments, and storage policies.

Resource Name	Write Disposition	Description
task	append	Task resource in Box Platform API
upload_session	append	Upload session resource in Box Platform API
comment_full	append	Full comment resource in Box Platform API
file_mini	append	Mini file resource in Box Platform API
device_pinner	append	Device pinner resource in Box Platform API
web_link	append	Web link resource in Box Platform API
folder_lock	append	Folder lock resource in Box Platform API
thumbnail	append	Thumbnail resource in Box Platform API
user	append	User resource in Box Platform API
file_request	append	File request resource in Box Platform API
file_version	append	File version resource in Box Platform API
legal_hold_policy_assignment	append	Legal hold policy assignment resource in Box Platform API
group	append	Group resource in Box Platform API
storage_policy	append	Storage policy resource in Box Platform API
version	append	Version resource in Box Platform API
retention_policy_assignment	append	Retention policy assignment resource in Box Platform API
watermark	append	Watermark resource in Box Platform API
retention_policy	append	Retention policy resource in Box Platform API
file_version_retention	append	File version retention resource in Box Platform API
client_error	append	Client error resource in Box Platform API
collaboration_allowlist_exempt_target	append	Collaboration allowlist exempt target resource in Box Platform API
search_result_with_shared_link	append	Search result with shared link resource in Box Platform API
sign_request	append	Sign request resource in Box Platform API
collaboration	append	Collaboration resource in Box Platform API
box_skills_card	append	Box skills card resource in Box Platform API
sign_template	append	Sign template resource in Box Platform API
folder	append	Folder resource in Box Platform API
zip_download_status	append	Zip download status resource in Box Platform API
integration_mapping	append	Integration mapping resource in Box Platform API
shield_information_barrier_segment_member	append	Shield information barrier segment member resource in Box Platform API
authorize	append	Authorize resource in Box Platform API
collaboration_allowlist_entry	append	Collaboration allowlist entry resource in Box Platform API
shield_information_barrier_report	append	Shield information barrier report resource in Box Platform API
item	append	Item resource in Box Platform API
file_idget_shared_link	append	File ID get shared link resource in Box Platform API
recent_item	append	Recent item resource in Box Platform API
metadata_template	append	Metadata template resource in Box Platform API
collection	append	Collection resource in Box Platform API
shield_information_barrier	append	Shield information barrier resource in Box Platform API
terms_of_service_user_status	append	Terms of service user status resource in Box Platform API
file_version_full	append	Full file version resource in Box Platform API
group_full	append	Full group resource in Box Platform API
terms_of_service	append	Terms of service resource in Box Platform API
email_alias	append	Email alias resource in Box Platform API
metadata_field_read	append	Metadata field read resource in Box Platform API
metadata_cascade_policy	append	Metadata cascade policy resource in Box Platform API
shared_item	append	Shared item resource in Box Platform API
metadata	append	Metadata resource in Box Platform API
webhook_mini	append	Mini webhook resource in Box Platform API
webhook	append	Webhook resource in Box Platform API
group_membership	append	Group membership resource in Box Platform API
workflow	append	Workflow resource in Box Platform API
event	append	Event resource in Box Platform API
content	append	Content resource in Box Platform API
shield_information_barrier_segment	append	Shield information barrier segment resource in Box Platform API
task_assignment	append	Task assignment resource in Box Platform API
tracking_code	append	Tracking code resource in Box Platform API
shield_information_barrier_segment_restriction	append	Shield information barrier segment restriction resource in Box Platform API
user_full	append	Full user resource in Box Platform API
invite	append	Invite resource in Box Platform API
shared_itemsfolder	append	Shared items folder resource in Box Platform API
comment	append	Comment resource in Box Platform API
membership	append	Membership resource in Box Platform API
folder_mini	append	Mini folder resource in Box Platform API
part	append	Part resource in Box Platform API
legal_hold_policy	append	Legal hold policy resource in Box Platform API
storage_policy_assignment	append	Storage policy assignment resource in Box Platform API
avatar	append	Avatar resource in Box Platform API
file_version_legal_hold	append	File version legal hold resource in Box Platform API
trash	append	Trash resource in Box Platform API
file_full	append	Full file resource in Box Platform API
folder_idget_shared_link	append	Folder ID get shared link resource in Box Platform API
schema	append	Schema resource in Box Platform API

Additional pipeline guides

• Load data from IFTTT to Microsoft SQL Server in python with dlt
• Load data from Attio to DuckDB in python with dlt
• Load data from Google Analytics to PostgreSQL in python with dlt
• Load data from Pinterest to Snowflake in python with dlt
• Load data from Attio to AWS S3 in python with dlt
• Load data from Google Sheets to EDB BigAnimal in python with dlt
• Load data from GitHub to Timescale in python with dlt
• Load data from Clubhouse to MotherDuck in python with dlt
• Load data from Braze to Snowflake in python with dlt
• Load data from Zendesk to Databricks in python with dlt