Onvo Documentation
APIs
Datasources
Get:Get All Data Sources

Get all data sources

GET
/
api
/
datasources

Authorizations

x-api-key
string
headerrequired

Response

200 - application/json

The response is of type object.

[
    {
        "id": "2e335065-0fb5-47c0-97b0-e603a15efdd8",
        "created_at": "2024-01-17T11:55:26.929359+00:00",
        "last_updated_at": "2024-01-17T12:00:03.629+00:00",
        "title": "Airtable test",
        "source": "airtable",
        "config": "{\"baseId\":\"appV4eljLGnPbPnUU\",\"baseName\":\"Sample Customers.csv\",\"tableId\":\"tbl7ZBUFUNA3kx7GL\",\"tableName\":\"Imported table\"}",
        "columns": [
            {
                "title": "State",
                "description": "The state where the customer is located."
            },
            {
                "title": "Customer ID",
                "description": "The unique identifier for the customer."
            },
            {
                "title": "City",
                "description": "The city where the customer is located."
            },
            {
                "title": "Segment",
                "description": "The customer segment (e.g., Consumer, Corporate, etc.)."
            },
            {
                "title": "Country",
                "description": "The country where the customer is located."
            },
            {
                "title": "Postal Code",
                "description": "The postal code of the customer's location."
            },
            {
                "title": "Region",
                "description": "The region where the customer is located."
            }
        ],
        "parameters": "[]",
        "description": "",
        "team": "ee5b08c6-5167-4425-bbc3-a746fe4a7ead",
        "created_by": {
            "id": "5899f99d-a449-4bfa-8769-19c097aaf1f6",
            "updated_at": "2024-01-17T10:14:12.62603+00:00",
            "full_name": "Ronnel Davis",
            "avatar_url": "https://upload.wikimedia.org/wikipedia/commons/8/89/Portrait_Placeholder.png",
            "email": "ronneldavis1996@gmail.com",
            "phone_number": "8075065108"
        },
        "last_updated_by": {
            "id": "5899f99d-a449-4bfa-8769-19c097aaf1f6",
            "updated_at": "2024-01-17T10:14:12.62603+00:00",
            "full_name": "Ronnel Davis",
            "avatar_url": "https://upload.wikimedia.org/wikipedia/commons/8/89/Portrait_Placeholder.png",
            "email": "ronneldavis1996@gmail.com",
            "phone_number": "8075065108"
        },
        "size": 15,
        "sample_data": "[{\"State\":\"Michigan\",\"Customer ID\":\"PO-18865\",\"City\":\"Westland\",\"Segment\":\"Consumer\",\"Country\":\"United States\",\"Postal Code\":\"48185\",\"Region\":\"Central\"},{\"State\":\"South Dakota\",\"Customer ID\":\"EM-13825\",\"City\":\"Sioux Falls\",\"Segment\":\"Corporate\",\"Country\":\"United States\",\"Postal Code\":\"57103\",\"Region\":\"Central\"},{\"State\":\"Missouri\",\"Customer ID\":\"MC-17635\",\"City\":\"Saint Louis\",\"Segment\":\"Corporate\",\"Country\":\"United States\",\"Postal Code\":\"63116\",\"Region\":\"Central\"},{\"State\":\"Delaware\",\"Customer ID\":\"VM-21835\",\"City\":\"Newark\",\"Segment\":\"Consumer\",\"Country\":\"United States\",\"Postal Code\":\"19711\",\"Region\":\"East\"},{\"State\":\"New York\",\"Customer ID\":\"AP-10720\",\"City\":\"New York City\",\"Segment\":\"Home Office\",\"Country\":\"United States\",\"Postal Code\":\"10035\",\"Region\":\"East\"},{\"State\":\"Virginia\",\"Customer ID\":\"AS-10090\",\"City\":\"Charlottesville\",\"Segment\":\"Consumer\",\"Country\":\"United States\",\"Postal Code\":\"22901\",\"Region\":\"South\"},{\"State\":\"Tennessee\",\"Customer ID\":\"JE-15745\",\"City\":\"Memphis\",\"Segment\":\"Consumer\",\"Country\":\"United States\",\"Postal Code\":\"38109\",\"Region\":\"South\"},{\"State\":\"Illinois\",\"Customer ID\":\"KL-16645\",\"City\":\"Chicago\",\"Segment\":\"Consumer\",\"Country\":\"United States\",\"Postal Code\":\"60610\",\"Region\":\"Central\"},{\"State\":\"Ohio\",\"Customer ID\":\"JR-16210\",\"City\":\"Springfield\",\"Segment\":\"Corporate\",\"Country\":\"United States\",\"Postal Code\":\"45503\",\"Region\":\"East\"},{\"State\":\"New York\",\"Customer ID\":\"JG-15805\",\"City\":\"New York City\",\"Segment\":\"Corporate\",\"Country\":\"United States\",\"Postal Code\":\"10024\",\"Region\":\"East\"}]"
    },
    {
        "id": "30f1b94c-a03d-41aa-bb2a-bc94890f1926",
        "created_at": "2024-01-17T16:31:06.014144+00:00",
        "last_updated_at": "2024-01-17T16:31:28.528+00:00",
        "title": "File test",
        "source": "file",
        "config": "{\"url\":\"http://localhost:54321/storage/v1/object/sign/data-sources/ee5b08c6-5167-4425-bbc3-a746fe4a7ead/datasource:30f1b94c-a03d-41aa-bb2a-bc94890f1926/Airbnb.csv?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJ1cmwiOiJkYXRhLXNvdXJjZXMvZWU1YjA4YzYtNTE2Ny00NDI1LWJiYzMtYTc0NmZlNGE3ZWFkL2RhdGFzb3VyY2U6MzBmMWI5NGMtYTAzZC00MWFhLWJiMmEtYmM5NDg5MGYxOTI2L0FpcmJuYi5jc3YiLCJpYXQiOjE3MDU1MDkwNzgsImV4cCI6MTczNzA0NTA3OH0.kstAzDO6_pizKI8wQAvQkNCmHoVNzfiJjbcJtpHJ5vo\",\"filename\":\"Airbnb.csv\",\"type\":\"csv\"}",
        "columns": [
            {
                "title": "Date",
                "description": "The date in the format 'D-Mon'"
            },
            {
                "title": "Guest",
                "description": "The name of the guest"
            },
            {
                "title": "Phone number",
                "description": "The phone number of the guest"
            },
            {
                "title": "Total nights",
                "description": "The total number of nights stayed"
            },
            {
                "title": "Confirmed Amt",
                "description": "The confirmed amount in currency format (e.g., '3,880.00')"
            },
            {
                "title": "GST",
                "description": "The GST amount in currency format (e.g., '200.00')"
            },
            {
                "title": "Received by Bank",
                "description": "The amount received by the bank in currency format (e.g., '3,680.00')"
            }
        ],
        "parameters": "[]",
        "description": "",
        "team": "ee5b08c6-5167-4425-bbc3-a746fe4a7ead",
        "created_by": {
            "id": "5899f99d-a449-4bfa-8769-19c097aaf1f6",
            "updated_at": "2024-01-17T10:14:12.62603+00:00",
            "full_name": "Ronnel Davis",
            "avatar_url": "https://upload.wikimedia.org/wikipedia/commons/8/89/Portrait_Placeholder.png",
            "email": "ronneldavis1996@gmail.com",
            "phone_number": "8075065108"
        },
        "last_updated_by": {
            "id": "5899f99d-a449-4bfa-8769-19c097aaf1f6",
            "updated_at": "2024-01-17T10:14:12.62603+00:00",
            "full_name": "Ronnel Davis",
            "avatar_url": "https://upload.wikimedia.org/wikipedia/commons/8/89/Portrait_Placeholder.png",
            "email": "ronneldavis1996@gmail.com",
            "phone_number": "8075065108"
        },
        "size": 4,
        "sample_data": "[{\"Date\":\"1-Jul\",\"Guest\":\"Siddharth Manmdhan\",\"Phone number\":\"\",\"Total nights\":\"1\",\"Confirmed Amt\":\" \\t3,880.00\",\"GST\":\"200.00\",\"Received by Bank\":\" \\t3,680.00\"},{\"Date\":\"6-Jul\",\"Guest\":\"John Umman\",\"Phone number\":\"\",\"Total nights\":\"1\",\"Confirmed Amt\":\" \\t3,880.00\",\"GST\":\"200.00\",\"Received by Bank\":\" \\t3,680.00\"},{\"Date\":\"8-Jul\",\"Guest\":\"Irshad PP\",\"Phone number\":\"\",\"Total nights\":\"1\",\"Confirmed Amt\":\" \\t3,880.00\",\"GST\":\"200.00\",\"Received by Bank\":\" \\t3,680.00\"},{\"Date\":\"9-Jul\",\"Guest\":\"Avith M Lal\",\"Phone number\":\"\",\"Total nights\":\"1\",\"Confirmed Amt\":\" \\t3,317.40\",\"GST\":\"171.00\",\"Received by Bank\":\" \\t3,146.40\"},{\"Date\":\"11-Jul\",\"Guest\":\"Shams Nazar\",\"Phone number\":\"\",\"Total nights\":\"2\",\"Confirmed Amt\":\" \\t7,760.00\",\"GST\":\"400.00\",\"Received by Bank\":\" \\t7,360.00\"},{\"Date\":\"14-Jul\",\"Guest\":\"Kevin Thomas\",\"Phone number\":\"\",\"Total nights\":\"1\",\"Confirmed Amt\":\" \\t3,317.40\",\"GST\":\"171.00\",\"Received by Bank\":\" \\t3,146.40\"},{\"Date\":\"15-Jul\",\"Guest\":\"Kevin Thomas\",\"Phone number\":\"\",\"Total nights\":\"1\",\"Confirmed Amt\":\" \\t3,880.00\",\"GST\":\"200.00\",\"Received by Bank\":\" \\t3,680.00\"},{\"Date\":\"16-Jul\",\"Guest\":\"Anna Binu\",\"Phone number\":\"\",\"Total nights\":\"1\",\"Confirmed Amt\":\" \\t3,298.00\",\"GST\":\"170.00\",\"Received by Bank\":\" \\t3,128.00\"},{\"Date\":\"18-Jul\",\"Guest\":\"Faiza M\",\"Phone number\":\"\",\"Total nights\":\"2\",\"Confirmed Amt\":\" \\t7,760.00\",\"GST\":\"400.00\",\"Received by Bank\":\" \\t7,360.00\"},{\"Date\":\"22-Jul\",\"Guest\":\"Prabhath CA\",\"Phone number\":\"\",\"Total nights\":\"1\",\"Confirmed Amt\":\" \\t3,880.00\",\"GST\":\"200.00\",\"Received by Bank\":\" \\t3,680.00\"}]"
    },
    {
        "id": "9fa19a4d-8852-4228-b0f5-f10ade43f576",
        "created_at": "2024-01-17T16:31:47.377513+00:00",
        "last_updated_at": "2024-01-17T16:38:54.071+00:00",
        "title": "Google sheet test",
        "source": "google-sheet",
        "config": "{\"docId\":\"1-LSXe4MAkOsN0xIKqk3kPQUWksFHsW8QZYG8pYW96GE\",\"sheetId\":0,\"sheetName\":\"Sheet1\"}",
        "columns": [
            {
                "title": "Subscription",
                "description": "The name of the subscription service (string)"
            },
            {
                "title": "Amount per month",
                "description": "The monthly subscription amount in currency (number)"
            },
            {
                "title": "Next renewal",
                "description": "The date of the next renewal in the format 'Month Day, Year' (string)"
            },
            {
                "title": "Status",
                "description": "The status of the subscription (string)"
            }
        ],
        "parameters": "[]",
        "description": "",
        "team": "ee5b08c6-5167-4425-bbc3-a746fe4a7ead",
        "created_by": {
            "id": "5899f99d-a449-4bfa-8769-19c097aaf1f6",
            "updated_at": "2024-01-17T10:14:12.62603+00:00",
            "full_name": "Ronnel Davis",
            "avatar_url": "https://upload.wikimedia.org/wikipedia/commons/8/89/Portrait_Placeholder.png",
            "email": "ronneldavis1996@gmail.com",
            "phone_number": "8075065108"
        },
        "last_updated_by": {
            "id": "5899f99d-a449-4bfa-8769-19c097aaf1f6",
            "updated_at": "2024-01-17T10:14:12.62603+00:00",
            "full_name": "Ronnel Davis",
            "avatar_url": "https://upload.wikimedia.org/wikipedia/commons/8/89/Portrait_Placeholder.png",
            "email": "ronneldavis1996@gmail.com",
            "phone_number": "8075065108"
        },
        "size": 1,
        "sample_data": "[{\"Subscription\":\"Netflix\",\"Amount per month\":\"650\",\"Next renewal\":\"October 1, 2022\",\"Status\":\"\"},{\"Subscription\":\"Game pass ultimate\",\"Amount per month\":\"499\",\"Next renewal\":\"October 3, 2022\",\"Status\":\"\"},{\"Subscription\":\"iCloud 200GB\",\"Amount per month\":\"199\",\"Next renewal\":\"\",\"Status\":\"\"},{\"Subscription\":\"Google one\",\"Amount per month\":\"130\",\"Next renewal\":\"October 9, 2022\",\"Status\":\"\"},{\"Subscription\":\"Disney+ hotstar\",\"Amount per month\":\"125\",\"Next renewal\":\"March 4, 2023\",\"Status\":\"\"},{\"Subscription\":\"GitHub copilot\",\"Amount per month\":\"0\",\"Next renewal\":\"October 21, 2022\",\"Status\":\"\"},{\"Subscription\":\"Spotify\",\"Amount per month\":\"119\",\"Next renewal\":\"October 18, 2022\",\"Status\":\"Cancelled\"},{\"Subscription\":\"YouTube premium\",\"Amount per month\":\"249\",\"Next renewal\":\"October 17, 2022\",\"Status\":\"Cancelled\"},{\"Subscription\":\"Apple one\",\"Amount per month\":\"365\",\"Next renewal\":\"October 14, 2022\",\"Status\":\"Cancelled\"},{\"Subscription\":\"Amazon prime\",\"Amount per month\":\"320\",\"Next renewal\":\"October 18, 2022\",\"Status\":\"Cancelled\"}]"
    },
    {
        "id": "937b32c1-412c-4397-af87-5644ab41bbf7",
        "created_at": "2024-01-19T16:39:50.039927+00:00",
        "last_updated_at": "2024-01-19T16:48:14.855+00:00",
        "title": "MongoDB",
        "source": "mongodb",
        "config": "{\"url\":\"mongodb+srv://onvo:onvo@cluster0.qllzhbg.mongodb.net/?retryWrites=true&w=majority\",\"database\":\"admin\",\"collection\":\"sample_airbnb\"}",
        "columns": [],
        "parameters": "[]",
        "description": "",
        "team": "ee5b08c6-5167-4425-bbc3-a746fe4a7ead",
        "created_by": {
            "id": "5899f99d-a449-4bfa-8769-19c097aaf1f6",
            "updated_at": "2024-01-17T10:14:12.62603+00:00",
            "full_name": "Ronnel Davis",
            "avatar_url": "https://upload.wikimedia.org/wikipedia/commons/8/89/Portrait_Placeholder.png",
            "email": "ronneldavis1996@gmail.com",
            "phone_number": "8075065108"
        },
        "last_updated_by": {
            "id": "5899f99d-a449-4bfa-8769-19c097aaf1f6",
            "updated_at": "2024-01-17T10:14:12.62603+00:00",
            "full_name": "Ronnel Davis",
            "avatar_url": "https://upload.wikimedia.org/wikipedia/commons/8/89/Portrait_Placeholder.png",
            "email": "ronneldavis1996@gmail.com",
            "phone_number": "8075065108"
        },
        "size": 0,
        "sample_data": "[]"
    },
    {
        "id": "fb252707-58e5-4958-bbe4-e1bab726a7ee",
        "created_at": "2024-01-18T09:58:05.210116+00:00",
        "last_updated_at": "2024-01-18T09:58:05.210116+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": {
            "id": "5899f99d-a449-4bfa-8769-19c097aaf1f6",
            "updated_at": "2024-01-17T10:14:12.62603+00:00",
            "full_name": "Ronnel Davis",
            "avatar_url": "https://upload.wikimedia.org/wikipedia/commons/8/89/Portrait_Placeholder.png",
            "email": "ronneldavis1996@gmail.com",
            "phone_number": "8075065108"
        },
        "last_updated_by": {
            "id": "5899f99d-a449-4bfa-8769-19c097aaf1f6",
            "updated_at": "2024-01-17T10:14:12.62603+00:00",
            "full_name": "Ronnel Davis",
            "avatar_url": "https://upload.wikimedia.org/wikipedia/commons/8/89/Portrait_Placeholder.png",
            "email": "ronneldavis1996@gmail.com",
            "phone_number": "8075065108"
        },
        "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": "fbef48dd-177e-4512-a906-bf5791e1bf05",
        "created_at": "2024-01-18T09:58:05.300625+00:00",
        "last_updated_at": "2024-01-18T09:58:05.300625+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": {
            "id": "5899f99d-a449-4bfa-8769-19c097aaf1f6",
            "updated_at": "2024-01-17T10:14:12.62603+00:00",
            "full_name": "Ronnel Davis",
            "avatar_url": "https://upload.wikimedia.org/wikipedia/commons/8/89/Portrait_Placeholder.png",
            "email": "ronneldavis1996@gmail.com",
            "phone_number": "8075065108"
        },
        "last_updated_by": {
            "id": "5899f99d-a449-4bfa-8769-19c097aaf1f6",
            "updated_at": "2024-01-17T10:14:12.62603+00:00",
            "full_name": "Ronnel Davis",
            "avatar_url": "https://upload.wikimedia.org/wikipedia/commons/8/89/Portrait_Placeholder.png",
            "email": "ronneldavis1996@gmail.com",
            "phone_number": "8075065108"
        },
        "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\"}]"
    },
    {
        "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": {
            "id": "5899f99d-a449-4bfa-8769-19c097aaf1f6",
            "updated_at": "2024-01-17T10:14:12.62603+00:00",
            "full_name": "Ronnel Davis",
            "avatar_url": "https://upload.wikimedia.org/wikipedia/commons/8/89/Portrait_Placeholder.png",
            "email": "ronneldavis1996@gmail.com",
            "phone_number": "8075065108"
        },
        "last_updated_by": {
            "id": "5899f99d-a449-4bfa-8769-19c097aaf1f6",
            "updated_at": "2024-01-17T10:14:12.62603+00:00",
            "full_name": "Ronnel Davis",
            "avatar_url": "https://upload.wikimedia.org/wikipedia/commons/8/89/Portrait_Placeholder.png",
            "email": "ronneldavis1996@gmail.com",
            "phone_number": "8075065108"
        },
        "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": {
            "id": "5899f99d-a449-4bfa-8769-19c097aaf1f6",
            "updated_at": "2024-01-17T10:14:12.62603+00:00",
            "full_name": "Ronnel Davis",
            "avatar_url": "https://upload.wikimedia.org/wikipedia/commons/8/89/Portrait_Placeholder.png",
            "email": "ronneldavis1996@gmail.com",
            "phone_number": "8075065108"
        },
        "last_updated_by": {
            "id": "5899f99d-a449-4bfa-8769-19c097aaf1f6",
            "updated_at": "2024-01-17T10:14:12.62603+00:00",
            "full_name": "Ronnel Davis",
            "avatar_url": "https://upload.wikimedia.org/wikipedia/commons/8/89/Portrait_Placeholder.png",
            "email": "ronneldavis1996@gmail.com",
            "phone_number": "8075065108"
        },
        "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\"}]"
    },
    {
        "id": "dc7c03cb-89ed-4036-a597-6086760be083",
        "created_at": "2024-01-23T10:53:16.403091+00:00",
        "last_updated_at": "2024-01-23T11:25:27.737+00:00",
        "title": "Quickbooks test",
        "source": "quickbooks",
        "config": "{\"company_id\":3018,\"resource\":\"bank_accounts\"}",
        "columns": [],
        "parameters": "[]",
        "description": "",
        "team": "ee5b08c6-5167-4425-bbc3-a746fe4a7ead",
        "created_by": {
            "id": "5899f99d-a449-4bfa-8769-19c097aaf1f6",
            "updated_at": "2024-01-17T10:14:12.62603+00:00",
            "full_name": "Ronnel Davis",
            "avatar_url": "https://upload.wikimedia.org/wikipedia/commons/8/89/Portrait_Placeholder.png",
            "email": "ronneldavis1996@gmail.com",
            "phone_number": "8075065108"
        },
        "last_updated_by": {
            "id": "5899f99d-a449-4bfa-8769-19c097aaf1f6",
            "updated_at": "2024-01-17T10:14:12.62603+00:00",
            "full_name": "Ronnel Davis",
            "avatar_url": "https://upload.wikimedia.org/wikipedia/commons/8/89/Portrait_Placeholder.png",
            "email": "ronneldavis1996@gmail.com",
            "phone_number": "8075065108"
        },
        "size": 0,
        "sample_data": "[]"
    }
]

You can find all properties for Data sources in the concepts at this link