Get all data sources
GET
/
api
/
datasources
Authorizations
x-api-key
string
headerrequiredResponse
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