Onvo Documentation
APIs
Dashboards
Dashboard Datasources
Get:Get All Datasources in Dashboard

Get all datasources in dashboard

GET
/
api
/
dashboards
/
{id}
/
datasources

Authorizations

x-api-key
string
headerrequired

Response

200 - application/json

The response is of type object.

[
    {
        "id": "bce247c9-079a-414f-af8f-49a24598d8b9",
        "created_at": "2024-01-21T15:54:42.14785+00:00",
        "last_updated_at": "2024-01-21T15:54:42.14785+00:00",
        "title": "Sample Customers",
        "source": "file",
        "config": "{\"type\":\"csv\",\"url\":\"https://eiexmihxmtknazmbqnsa.supabase.co/storage/v1/object/public/assets/Sample%20Customers.csv\"}",
        "columns": [
            {
                "title": "Customer ID",
                "description": "A unique identifier for the customer across tables"
            },
            {
                "title": "City",
                "description": "City of residence"
            },
            {
                "title": "Country",
                "description": "Country of residence"
            },
            {
                "title": "Segment",
                "description": "Segment of customer according to purchasing habits"
            },
            {
                "title": "State",
                "description": "State of residence"
            },
            {
                "title": "Postal Code",
                "description": "Postal Code of customer"
            },
            {
                "title": "Region",
                "description": "Region of residence"
            }
        ],
        "parameters": "[]",
        "description": "A sample datasource containing the details of customers in an e-commerce setting",
        "team": "ee5b08c6-5167-4425-bbc3-a746fe4a7ead",
        "created_by": "5899f99d-a449-4bfa-8769-19c097aaf1f6",
        "last_updated_by": "5899f99d-a449-4bfa-8769-19c097aaf1f6",
        "size": 118,
        "sample_data": "[{\"Customer ID\":\"CG-12520\",\"City\":\"Henderson\",\"Country\":\"United States\",\"Segment\":\"Consumer\",\"State\":\"Kentucky\",\"Postal Code\":\"42420\",\"Region\":\"South\"},{\"Customer ID\":\"DV-13045\",\"City\":\"Los Angeles\",\"Country\":\"United States\",\"Segment\":\"Corporate\",\"State\":\"California\",\"Postal Code\":\"90036\",\"Region\":\"West\"},{\"Customer ID\":\"SO-20335\",\"City\":\"Fort Lauderdale\",\"Country\":\"United States\",\"Segment\":\"Consumer\",\"State\":\"Florida\",\"Postal Code\":\"33311\",\"Region\":\"South\"},{\"Customer ID\":\"BH-11710\",\"City\":\"Los Angeles\",\"Country\":\"United States\",\"Segment\":\"Consumer\",\"State\":\"California\",\"Postal Code\":\"90032\",\"Region\":\"West\"},{\"Customer ID\":\"AA-10480\",\"City\":\"Concord\",\"Country\":\"United States\",\"Segment\":\"Consumer\",\"State\":\"North Carolina\",\"Postal Code\":\"28027\",\"Region\":\"South\"},{\"Customer ID\":\"IM-15070\",\"City\":\"Seattle\",\"Country\":\"United States\",\"Segment\":\"Consumer\",\"State\":\"Washington\",\"Postal Code\":\"98103\",\"Region\":\"West\"},{\"Customer ID\":\"HP-14815\",\"City\":\"Fort Worth\",\"Country\":\"United States\",\"Segment\":\"Home Office\",\"State\":\"Texas\",\"Postal Code\":\"76106\",\"Region\":\"Central\"},{\"Customer ID\":\"PK-19075\",\"City\":\"Madison\",\"Country\":\"United States\",\"Segment\":\"Consumer\",\"State\":\"Wisconsin\",\"Postal Code\":\"53711\",\"Region\":\"Central\"},{\"Customer ID\":\"AG-10270\",\"City\":\"West Jordan\",\"Country\":\"United States\",\"Segment\":\"Consumer\",\"State\":\"Utah\",\"Postal Code\":\"84084\",\"Region\":\"West\"},{\"Customer ID\":\"ZD-21925\",\"City\":\"San Francisco\",\"Country\":\"United States\",\"Segment\":\"Consumer\",\"State\":\"California\",\"Postal Code\":\"94109\",\"Region\":\"West\"}]"
    },
    {
        "id": "a0242622-ca73-4353-87b1-4e0af2051b07",
        "created_at": "2024-01-21T15:54:42.161692+00:00",
        "last_updated_at": "2024-01-21T15:54:42.161692+00:00",
        "title": "Sample Orders",
        "source": "file",
        "config": "{\"type\":\"csv\",\"url\":\"https://eiexmihxmtknazmbqnsa.supabase.co/storage/v1/object/public/assets/Sample%20Orders.csv\"}",
        "columns": [
            {
                "title": "Row ID",
                "description": "A serial number for every row"
            },
            {
                "title": "Order ID",
                "description": "A unique ID for every order"
            },
            {
                "title": "Order Date",
                "description": "Order Date in YYYY-MM-DD format"
            },
            {
                "title": "Ship Date",
                "description": "Ship Date in YYYY-MM-DD format"
            },
            {
                "title": "Ship Mode",
                "description": "The type of shipping for the order"
            },
            {
                "title": "Customer ID",
                "description": "Customer ID"
            },
            {
                "title": "Product ID",
                "description": "Product ID"
            },
            {
                "title": "Category",
                "description": "Category of product"
            },
            {
                "title": "Sub-Category",
                "description": "Sub-Category of product"
            },
            {
                "title": "Product Name",
                "description": "name of the product"
            },
            {
                "title": "Sales",
                "description": "Sales price in USD"
            },
            {
                "title": "Quantity",
                "description": "Quantity as a whole number"
            },
            {
                "title": "Discount",
                "description": "Discount as a percentage from 0-1"
            },
            {
                "title": "Profit",
                "description": "Profit in USD (can be negative)"
            }
        ],
        "parameters": "[]",
        "description": "A sample datasource containing the details of orders in an e-commerce setting",
        "team": "ee5b08c6-5167-4425-bbc3-a746fe4a7ead",
        "created_by": "5899f99d-a449-4bfa-8769-19c097aaf1f6",
        "last_updated_by": "5899f99d-a449-4bfa-8769-19c097aaf1f6",
        "size": 3454,
        "sample_data": "[{\"Row ID\":\"1\",\"Order ID\":\"CA-2017-152156\",\"Order Date\":\"2017-11-08\",\"Ship Date\":\"2017-11-11\",\"Ship Mode\":\"Second Class\",\"Customer ID\":\"CG-12520\",\"Product ID\":\"FUR-BO-10001798\",\"Category\":\"Furniture\",\"Sub-Category\":\"Bookcases\",\"Product Name\":\"Bush Somerset Collection Bookcase\",\"Sales\":\"261.96\",\"Quantity\":\"2\",\"Discount\":\"0\",\"Profit\":\"41.9136\"},{\"Row ID\":\"2\",\"Order ID\":\"CA-2017-152156\",\"Order Date\":\"2017-11-08\",\"Ship Date\":\"2017-11-11\",\"Ship Mode\":\"Second Class\",\"Customer ID\":\"CG-12520\",\"Product ID\":\"FUR-CH-10000454\",\"Category\":\"Furniture\",\"Sub-Category\":\"Chairs\",\"Product Name\":\"Hon Deluxe Fabric Upholstered Stacking Chairs, Rounded Back\",\"Sales\":\"731.94\",\"Quantity\":\"3\",\"Discount\":\"0\",\"Profit\":\"219.582\"},{\"Row ID\":\"3\",\"Order ID\":\"CA-2017-138688\",\"Order Date\":\"2017-06-12\",\"Ship Date\":\"2017-06-16\",\"Ship Mode\":\"Second Class\",\"Customer ID\":\"DV-13045\",\"Product ID\":\"OFF-LA-10000240\",\"Category\":\"Office Supplies\",\"Sub-Category\":\"Labels\",\"Product Name\":\"Self-Adhesive Address Labels for Typewriters by Universal\",\"Sales\":\"14.62\",\"Quantity\":\"2\",\"Discount\":\"0\",\"Profit\":\"6.8714\"},{\"Row ID\":\"4\",\"Order ID\":\"US-2016-108966\",\"Order Date\":\"2016-10-11\",\"Ship Date\":\"2016-10-18\",\"Ship Mode\":\"Standard Class\",\"Customer ID\":\"SO-20335\",\"Product ID\":\"FUR-TA-10000577\",\"Category\":\"Furniture\",\"Sub-Category\":\"Tables\",\"Product Name\":\"Bretford CR4500 Series Slim Rectangular Table\",\"Sales\":\"957.5775\",\"Quantity\":\"5\",\"Discount\":\"0.45\",\"Profit\":\"-383.031\"},{\"Row ID\":\"5\",\"Order ID\":\"US-2016-108966\",\"Order Date\":\"2016-10-11\",\"Ship Date\":\"2016-10-18\",\"Ship Mode\":\"Standard Class\",\"Customer ID\":\"SO-20335\",\"Product ID\":\"OFF-ST-10000760\",\"Category\":\"Office Supplies\",\"Sub-Category\":\"Storage\",\"Product Name\":\"Eldon Fold 'N Roll Cart System\",\"Sales\":\"22.368\",\"Quantity\":\"2\",\"Discount\":\"0.2\",\"Profit\":\"2.5164\"},{\"Row ID\":\"6\",\"Order ID\":\"CA-2015-115812\",\"Order Date\":\"2015-06-09\",\"Ship Date\":\"2015-06-14\",\"Ship Mode\":\"Standard Class\",\"Customer ID\":\"BH-11710\",\"Product ID\":\"FUR-FU-10001487\",\"Category\":\"Furniture\",\"Sub-Category\":\"Furnishings\",\"Product Name\":\"Eldon Expressions Wood and Plastic Desk Accessories, Cherry Wood\",\"Sales\":\"48.86\",\"Quantity\":\"7\",\"Discount\":\"0\",\"Profit\":\"14.1694\"},{\"Row ID\":\"7\",\"Order ID\":\"CA-2015-115812\",\"Order Date\":\"2015-06-09\",\"Ship Date\":\"2015-06-14\",\"Ship Mode\":\"Standard Class\",\"Customer ID\":\"BH-11710\",\"Product ID\":\"OFF-AR-10002833\",\"Category\":\"Office Supplies\",\"Sub-Category\":\"Art\",\"Product Name\":\"Newell 322\",\"Sales\":\"7.28\",\"Quantity\":\"4\",\"Discount\":\"0\",\"Profit\":\"1.9656\"},{\"Row ID\":\"8\",\"Order ID\":\"CA-2015-115812\",\"Order Date\":\"2015-06-09\",\"Ship Date\":\"2015-06-14\",\"Ship Mode\":\"Standard Class\",\"Customer ID\":\"BH-11710\",\"Product ID\":\"TEC-PH-10002275\",\"Category\":\"Technology\",\"Sub-Category\":\"Phones\",\"Product Name\":\"Mitel 5320 IP Phone VoIP phone\",\"Sales\":\"907.152\",\"Quantity\":\"6\",\"Discount\":\"0.2\",\"Profit\":\"90.7152\"},{\"Row ID\":\"9\",\"Order ID\":\"CA-2015-115812\",\"Order Date\":\"2015-06-09\",\"Ship Date\":\"2015-06-14\",\"Ship Mode\":\"Standard Class\",\"Customer ID\":\"BH-11710\",\"Product ID\":\"OFF-BI-10003910\",\"Category\":\"Office Supplies\",\"Sub-Category\":\"Binders\",\"Product Name\":\"DXL Angle-View Binders with Locking Rings by Samsill\",\"Sales\":\"18.504\",\"Quantity\":\"3\",\"Discount\":\"0.2\",\"Profit\":\"5.7825\"},{\"Row ID\":\"10\",\"Order ID\":\"CA-2015-115812\",\"Order Date\":\"2015-06-09\",\"Ship Date\":\"2015-06-14\",\"Ship Mode\":\"Standard Class\",\"Customer ID\":\"BH-11710\",\"Product ID\":\"OFF-AP-10002892\",\"Category\":\"Office Supplies\",\"Sub-Category\":\"Appliances\",\"Product Name\":\"Belkin F5C206VTEL 6 Outlet Surge\",\"Sales\":\"114.9\",\"Quantity\":\"5\",\"Discount\":\"0\",\"Profit\":\"34.47\"}]"
    }
]