{"info":{"_postman_id":"397aeed5-5850-41bd-be8a-10339a4f4f2e","name":"Distil.ai Public API Documentation","description":"<html><head></head><body><p>All Distil APIs are built using REST conventions and designed to have a predictable URL structure.</p>\n<p>They use many standard HTTP features, including methods (POST, GET, PUT, DELETE) and error response codes. All HubSpot API calls are made under <a href=\"https://public-api-distil.ai\">https://public-api-distil.ai</a> and all responses return standard JSON.</p>\n<h1 id=\"authentication-authorization\">Authentication / Authorization</h1>\n<p>Authentication is via API key, which is created within the Distil.ai interface when a new API Connection is added to your account (<em><strong>Settings</strong></em> &gt; <em><strong>Integrations</strong></em> &gt; <em><strong>Add Connection</strong></em> &gt; <em><strong>API</strong></em>). The API Key can be found in the <em><strong>Edit Connection</strong></em> settings for the API Connection</p>\n<p>When making a request the API key is added to every request in the <strong>Authorization</strong> Request Header.</p>\n<h1 id=\"data-types\">Data Types</h1>\n<p>The following are the data types that are currently supported by Distil:</p>\n<div class=\"click-to-expand-wrapper is-table-wrapper\"><table>\n<thead>\n<tr>\n<th>Type</th>\n<th>Description</th>\n</tr>\n</thead>\n<tbody>\n<tr>\n<td>STRING</td>\n<td>This covers all text based types such as String / Varchar / Text / Char - with no upper character limit</td>\n</tr>\n<tr>\n<td>BOOLEAN</td>\n<td>This can accept the following values as boolean values: True / False</td>\n</tr>\n<tr>\n<td>INT</td>\n<td>Any whole integer value</td>\n</tr>\n<tr>\n<td>DECIMAL</td>\n<td>Any non-whole numerical value with decimal point precision</td>\n</tr>\n<tr>\n<td>DATE</td>\n<td>A Date without any time precision.  A format can be supplied for the field definition to explicitly set the expected format.  See <strong>Date Format</strong> section</td>\n</tr>\n<tr>\n<td>DATETIME</td>\n<td>A Date with time precision.  A format can be supplied for the field definition to explicitly set the expected format.  See <strong>Date Format</strong> section</td>\n</tr>\n</tbody>\n</table>\n</div><h1 id=\"date-format\">Date Format</h1>\n<p>For both the DATE and DATETIME Attribute types, an additional <code>format</code> parameter can be supplied.  Here are some example formats and dates:</p>\n<div class=\"click-to-expand-wrapper is-table-wrapper\"><table>\n<thead>\n<tr>\n<th>Format specification</th>\n<th>Example date</th>\n</tr>\n</thead>\n<tbody>\n<tr>\n<td>yyyy-MM-dd</td>\n<td>2021-06-30</td>\n</tr>\n<tr>\n<td>dd.MM.yy</td>\n<td>30.06.21</td>\n</tr>\n<tr>\n<td>yyyy-MM-dd HH:mm</td>\n<td>2021-06-30 10:19</td>\n</tr>\n<tr>\n<td>yyyy dd MM HH:mm:ss</td>\n<td>2021 30 06 10:19:03</td>\n</tr>\n</tbody>\n</table>\n</div><h1 id=\"data-source-types\">Data Source Types</h1>\n<p>Distil understands four main types of data structures.  It is possible using the API to create Data Sources which accept each of these.  They are:</p>\n<div class=\"click-to-expand-wrapper is-table-wrapper\"><table>\n<thead>\n<tr>\n<th>Data Source Type</th>\n<th>Description</th>\n</tr>\n</thead>\n<tbody>\n<tr>\n<td>CUSTOMER</td>\n<td>Data pertinent to your Customers</td>\n</tr>\n<tr>\n<td>PRODUCT</td>\n<td>Product data which Customers can purchase from any source</td>\n</tr>\n<tr>\n<td>ORDER</td>\n<td>Order Data described at the line item level, so if an Order has multiple items, then multiple records will need to be sent, and Distil will re-combine into the full Order record</td>\n</tr>\n<tr>\n<td>CONTENT</td>\n<td>Content such as blogs, news etc, i.e. content articles which cannot be purchased</td>\n</tr>\n</tbody>\n</table>\n</div></body></html>","schema":"https://schema.getpostman.com/json/collection/v2.0.0/collection.json","toc":[{"content":"Authentication / Authorization","slug":"authentication-authorization"},{"content":"Data Types","slug":"data-types"},{"content":"Date Format","slug":"date-format"},{"content":"Data Source Types","slug":"data-source-types"}],"owner":"12377032","collectionId":"397aeed5-5850-41bd-be8a-10339a4f4f2e","publishedId":"TVeiBq6N","public":true,"customColor":{"top-bar":"95C734","right-sidebar":"303030","highlight":"95C734"},"publishDate":"2020-11-06T10:16:06.000Z"},"item":[{"name":"List All Datasources","event":[{"listen":"test","script":{"id":"ea900ba6-9e07-4305-b621-e6e51e407d89","exec":[""],"type":"text/javascript"}}],"id":"fe4fd5bc-f4d3-455b-82c0-93d1f6a5a0b9","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"auth":{"type":"noauth","isInherited":false},"method":"GET","header":[{"key":"Authorization","value":"{api_key}","type":"text"}],"body":{"mode":"raw","raw":"","options":{"raw":{"language":"json"}}},"url":"https://public-api.distil.ai/api/connection/","description":"<p>Retrieves the details of all datasources that exist within a Distil.ai API Integration</p>\n","urlObject":{"protocol":"https","path":["api","connection",""],"host":["public-api","distil","ai"],"query":[],"variable":[]}},"response":[{"id":"3d79516f-7137-434b-bcb3-aaf8110fb66f","name":"List All Datasources","originalRequest":{"method":"GET","header":[{"key":"Authorization","value":"{api_key}","type":"text"}],"body":{"mode":"raw","raw":"","options":{"raw":{"language":"json"}}},"url":"https://public-api.distil.ai/api/connection/"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Cache-Control","value":"no-cache, no-store, max-age=0, must-revalidate"},{"key":"Pragma","value":"no-cache"},{"key":"Transfer-Encoding","value":"chunked"},{"key":"Content-Type","value":"application/json;charset=UTF-8"},{"key":"Content-Encoding","value":"gzip"},{"key":"Expires","value":"0"},{"key":"X-XSS-Protection","value":"1; mode=block"},{"key":"X-Frame-Options","value":"DENY"},{"key":"X-Content-Type-Options","value":"nosniff"},{"key":"Strict-Transport-Security","value":"max-age=31536000 ; includeSubDomains"},{"key":"Referrer-Policy","value":"no-referrer"},{"key":"Date","value":"Tue, 03 Nov 2020 12:30:11 GMT"}],"cookie":[],"responseTime":null,"body":"[\n    {\n        \"id\": \"MjQ=\",\n        \"name\": \"DataSource Name\",\n        \"description\": \"Example DataSource with all field types\",\n        \"type\": \"CUSTOMER\",\n        \"icon\": \"SQLSERVER\",\n        \"attributes\": [\n            {\n                \"id\": \"MjY1\",\n                \"name\": \"customer_key\",\n                \"displayName\": \"customer_key\",\n                \"createdDate\": \"2020-11-03 12:25:14\",\n                \"notNullCount\": null,\n                \"tag\": \"NONE\",\n                \"format\": null,\n                \"type\": \"STRING\"\n            },\n            {\n                \"id\": \"MjY2\",\n                \"name\": \"id\",\n                \"displayName\": \"Unique ID - mandatory\",\n                \"createdDate\": \"2020-11-03 12:25:14\",\n                \"notNullCount\": null,\n                \"tag\": \"CUSTOMER_EXTERNAL_ID\",\n                \"format\": null,\n                \"type\": \"STRING\"\n            },\n            {\n                \"id\": \"MjY3\",\n                \"name\": \"EMAIL\",\n                \"displayName\": \"Email\",\n                \"createdDate\": \"2020-11-03 12:25:14\",\n                \"notNullCount\": null,\n                \"tag\": \"CUSTOMER_EMAIL_ADDRESS\",\n                \"format\": null,\n                \"type\": \"STRING\"\n            },\n            {\n                \"id\": \"MjY4\",\n                \"name\": \"boolean\",\n                \"displayName\": \"Boolean\",\n                \"createdDate\": \"2020-11-03 12:25:14\",\n                \"notNullCount\": null,\n                \"tag\": \"NONE\",\n                \"format\": null,\n                \"type\": \"BOOLEAN\"\n            },\n            {\n                \"id\": \"MjY5\",\n                \"name\": \"integer\",\n                \"displayName\": \"Integer\",\n                \"createdDate\": \"2020-11-03 12:25:14\",\n                \"notNullCount\": null,\n                \"tag\": \"NONE\",\n                \"format\": null,\n                \"type\": \"INT\"\n            },\n            {\n                \"id\": \"Mjcw\",\n                \"name\": \"Decimal\",\n                \"displayName\": \"Decimal\",\n                \"createdDate\": \"2020-11-03 12:25:14\",\n                \"notNullCount\": null,\n                \"tag\": \"NONE\",\n                \"format\": null,\n                \"type\": \"DECIMAL\"\n            },\n            {\n                \"id\": \"Mjcx\",\n                \"name\": \"Date\",\n                \"displayName\": \"Date\",\n                \"createdDate\": \"2020-11-03 12:25:14\",\n                \"notNullCount\": null,\n                \"tag\": \"NONE\",\n                \"format\": \"yyyy-MM-dd\",\n                \"type\": \"DATE\"\n            },\n            {\n                \"id\": \"Mjcy\",\n                \"name\": \"Date_formatted\",\n                \"displayName\": \"Date Formatted\",\n                \"createdDate\": \"2020-11-03 12:25:14\",\n                \"notNullCount\": null,\n                \"tag\": \"NONE\",\n                \"format\": \"yyyy.MM.dd\",\n                \"type\": \"DATE\"\n            },\n            {\n                \"id\": \"Mjcz\",\n                \"name\": \"Datetime\",\n                \"displayName\": \"Datetime\",\n                \"createdDate\": \"2020-11-03 12:25:14\",\n                \"notNullCount\": null,\n                \"tag\": \"NONE\",\n                \"format\": \"yyyy-MM-dd HH:mm:ss\",\n                \"type\": \"DATETIME\"\n            },\n            {\n                \"id\": \"Mjc0\",\n                \"name\": \"Datetime_formatted\",\n                \"displayName\": \"Datetime Formatted\",\n                \"createdDate\": \"2020-11-03 12:25:14\",\n                \"notNullCount\": null,\n                \"tag\": \"NONE\",\n                \"format\": \"yyyy.DD.mm hh:mm:ss\",\n                \"type\": \"DATETIME\"\n            }\n        ],\n        \"recordsCount\": null,\n        \"lastSyncDate\": null,\n        \"ingestEndpoint\": \"https://public-api.distil.ai/api/connection/MjQ=/data\"\n    }\n]"}],"_postman_id":"fe4fd5bc-f4d3-455b-82c0-93d1f6a5a0b9"},{"name":"Create Datasource","event":[{"listen":"test","script":{"id":"1a6498e4-dd27-415e-8de6-fe2fd7e668f2","exec":[""],"type":"text/javascript","packages":{},"requests":{}}}],"id":"55b4b18e-9585-4968-abae-6ca3d4f21dea","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"auth":{"type":"noauth","isInherited":false},"method":"POST","header":[{"key":"Authorization","value":"{api_key}","type":"text"}],"body":{"mode":"raw","raw":"{\n  \"name\": \"DataSource With All Data Types\",\n  \"description\": \"Example DataSource with all field types - to demonstrate all permutations of using Data Types and the format specifier\",\n  \"type\": \"CUSTOMER\",\n  \"attributes\": [\n    {\n      \"name\": \"id\",\n      \"displayName\": \"Unique ID - mandatory\",\n      \"type\": \"STRING\"\n    },\n    {\n      \"name\": \"Email\",\n      \"displayName\": \"Customers Email Address\",\n      \"type\": \"STRING\"\n    },\n    {\n      \"name\": \"Subscribed\",\n      \"displayName\": \"Whether the Customer is Subscribed to the newsletter\",\n      \"type\": \"BOOLEAN\"\n    },\n    {\n      \"name\": \"Age\",\n      \"type\": \"INT\"\n    },\n    {\n      \"name\": \"Weight\",\n      \"displayName\": \"Weight in Kgs\",\n      \"type\": \"DECIMAL\"\n    },\n    {\n      \"name\": \"Registration_Date\",\n      \"type\": \"DATE\"\n    },\n    {\n      \"name\": \"BirthDate\",\n      \"type\": \"DATE\",\n      \"format\": \"yyyy.MM.dd\"\n    },\n    {\n      \"name\": \"DateCreated\",\n      \"type\": \"DATETIME\"\n    },\n    {\n      \"name\": \"DateUpdated\",\n      \"type\": \"DATETIME\",\n      \"format\": \"yyyy-MM-dd HH:mm:ss\"\n    }\n    ]\n}","options":{"raw":{"language":"json"}}},"url":"https://public-api.distil.ai/api/connection","description":"<p>Creates a new datasource within a Distil.ai API Integration</p>\n<p>The body of the request is in JSON format and should include the following elements:</p>\n<div class=\"click-to-expand-wrapper is-table-wrapper\"><table>\n<thead>\n<tr>\n<th>Field</th>\n<th>Description</th>\n<th>Mandatory</th>\n</tr>\n</thead>\n<tbody>\n<tr>\n<td>name</td>\n<td>The name of the Data Source - this will appear in the Integration</td>\n<td>YES</td>\n</tr>\n<tr>\n<td>description</td>\n<td>The description for the Data Source</td>\n<td>YES</td>\n</tr>\n<tr>\n<td>type</td>\n<td>The type of data this Data Source represents.  <br /><br />See <a href=\"#data-source-types\">Data Source Types</a></td>\n<td>YES</td>\n</tr>\n<tr>\n<td>icon</td>\n<td>The icon to associate to the Data Source.  This will appear on the Tab for the Data Source in the Customer Data Screen.  <br /><br />Possible values for this are: POSTGRESQL, MYSQL, SQLSERVER, REDSHIFT, MAILCHIMP, SALESFORCE, CAMPAIGN_MONITOR, KLAVIYO, DOT_DIGITAL, API_CONNECTION</td>\n<td>NO - Defaults to API_CONNECTION</td>\n</tr>\n<tr>\n<td>attributes</td>\n<td>An array of Attributes to describe all of the fields within the Data Source</td>\n<td>YES - All mandatory attributes for the specified DataSource type should be supplied</td>\n</tr>\n</tbody>\n</table>\n</div><h4 id=\"attribute-fields-definition\">Attribute Fields Definition</h4>\n<p>The following are the details of the field definition for attributes that can be supplied with the Data Source definition :</p>\n<div class=\"click-to-expand-wrapper is-table-wrapper\"><table>\n<thead>\n<tr>\n<th>Field</th>\n<th>Description</th>\n<th>Mandatory</th>\n</tr>\n</thead>\n<tbody>\n<tr>\n<td>name</td>\n<td>The name of the field / attribute from the external system</td>\n<td>YES</td>\n</tr>\n<tr>\n<td>description</td>\n<td>The description of the field / attribute</td>\n<td>NO</td>\n</tr>\n<tr>\n<td>displayName</td>\n<td>How you would like the name of the field to be seen within Distil</td>\n<td>NO - will be inferred from the name if not supplied</td>\n</tr>\n<tr>\n<td>type</td>\n<td>The <a href=\"#data-types\">Data Type</a> for the field.</td>\n<td>YES</td>\n</tr>\n</tbody>\n</table>\n</div><hr />\n<p>There are multiple example requests supplied on the right to give examples of each request for the different DataSource Types</p>\n","urlObject":{"protocol":"https","path":["api","connection"],"host":["public-api","distil","ai"],"query":[],"variable":[]}},"response":[{"id":"f33986bb-7683-4f99-9994-30540d935493","name":"CUSTOMER - All Different Attribute Data Types","originalRequest":{"method":"POST","header":[{"key":"Authorization","type":"text","value":"{api_key}"}],"body":{"mode":"raw","raw":"{\n  \"name\": \"DataSource With All Data Types\",\n  \"description\": \"Example DataSource with all field types - to demonstrate all permutations of using Data Types and the format specifier\",\n  \"type\": \"CUSTOMER\",\n  \"attributes\": [\n    {\n      \"name\": \"id\",\n      \"displayName\": \"Unique ID - mandatory\",\n      \"type\": \"STRING\"\n    },\n    {\n      \"name\": \"Email\",\n      \"displayName\": \"Customers Email Address\",\n      \"type\": \"STRING\"\n    },\n    {\n      \"name\": \"Subscribed\",\n      \"displayName\": \"Whether the Customer is Subscribed to the newsletter\",\n      \"type\": \"BOOLEAN\"\n    },\n    {\n      \"name\": \"Age\",\n      \"type\": \"INT\"\n    },\n    {\n      \"name\": \"Weight\",\n      \"displayName\": \"Weight in Kgs\",\n      \"type\": \"DECIMAL\"\n    },\n    {\n      \"name\": \"Registration_Date\",\n      \"type\": \"DATE\"\n    },\n    {\n      \"name\": \"BirthDate\",\n      \"type\": \"DATE\",\n      \"format\": \"yyyy.MM.dd\"\n    },\n    {\n      \"name\": \"DateCreated\",\n      \"type\": \"DATETIME\"\n    },\n    {\n      \"name\": \"DateUpdated\",\n      \"type\": \"DATETIME\",\n      \"format\": \"yyyy-MM-dd HH:mm:ss\"\n    }\n    ]\n}","options":{"raw":{"language":"json"}}},"url":"https://public-api.distil.ai/api/connection"},"_postman_previewlanguage":null,"header":null,"cookie":[],"responseTime":null,"body":null},{"id":"52caa0be-0bb9-484a-8e81-446f91854974","name":"CUSTOMER - With recognised fields","originalRequest":{"method":"POST","header":[{"key":"Authorization","type":"text","value":"{api_key}"}],"body":{"mode":"raw","raw":"{\n  \"name\": \"Customer DataSource With recognised fields\",\n  \"description\": \"Example DataSource with all fields which are recognised by Distil and have significance\",\n  \"type\": \"CUSTOMER\",\n  \"attributes\": [\n        {\n            \"name\": \"id\",\n            \"displayName\": \"Unique ID - mandatory\",\n            \"type\": \"STRING\"\n        },\n        {\n            \"name\": \"Email\",\n            \"displayName\": \"Customers Email Address\",\n            \"type\": \"STRING\"\n        },\n        {\n            \"name\": \"Postcode\",      \n            \"type\": \"STRING\"\n        },\n        {\n            \"name\": \"FirstName\",\n            \"type\": \"STRING\"\n        },\n        {\n            \"name\": \"LastName\",\n            \"type\": \"STRING\"\n        },\n        {\n            \"name\": \"Phone\",\n            \"type\": \"STRING\"\n        },\n        {\n            \"name\": \"Country\",\n            \"type\": \"STRING\"\n        }\n    ]\n}","options":{"raw":{"language":"json"}}},"url":"https://public-api.distil.ai/api/connection"},"_postman_previewlanguage":null,"header":null,"cookie":[],"responseTime":null,"body":null},{"id":"b0023160-56e9-44b7-8c5e-c0881f3936b1","name":"CONTENT - With recognised fields","originalRequest":{"method":"POST","header":[{"key":"Authorization","type":"text","value":"{api_key}"}],"body":{"mode":"raw","raw":"{\n  \"name\": \"Content DataSource With recognised fields\",\n  \"description\": \"Example DataSource with all fields which are recognised by Distil and have significance\",\n  \"type\": \"CONTENT\",\n  \"attributes\": [\n        {\n            \"name\": \"id\",\n            \"displayName\": \"Unique Content ID - MANDATORY\",\n            \"type\": \"STRING\"\n        },\n        {\n            \"name\": \"Title\",\n            \"displayName\": \"Content title - MANDATORY\",\n            \"type\": \"STRING\"\n        },\n        {\n            \"name\": \"Url\",      \n            \"displayName\": \"Content link - MANDATORY\",\n            \"type\": \"STRING\"\n        },\n        {\n            \"name\": \"Image\",\n            \"type\": \"STRING\"\n        },\n        {\n            \"name\": \"Description\",\n            \"type\": \"STRING\"\n        },\n        {\n            \"name\": \"Available\",\n            \"type\": \"BOOLEAN\"\n        },\n        {\n            \"name\": \"Keywords\",\n            \"type\": \"STRING\"\n        },\n        {\n            \"name\" : \"PublishedOn\",\n            \"type\" : \"DATETIME\"\n        }\n    ]\n}","options":{"raw":{"language":"json"}}},"url":"https://public-api.distil.ai/api/connection"},"_postman_previewlanguage":null,"header":null,"cookie":[],"responseTime":null,"body":null},{"id":"727a1cd7-be39-4e3c-9298-de3c2849ee3d","name":"ORDER - With recognised fields","originalRequest":{"method":"POST","header":[{"key":"Authorization","type":"text","value":"{api_key}"}],"body":{"mode":"raw","raw":"{\n  \"name\": \"Order DataSource\",\n  \"description\": \"Order DataSource with all recognised fields\",\n  \"type\": \"ORDER\",\n  \"attributes\": [\n    {\n      \"name\": \"id\",\n      \"displayName\": \"Unique Order Line Item ID - MANDATORY\",\n      \"type\": \"STRING\"\n    },\n    {\n      \"name\": \"customer_id\",\n      \"displayName\": \"Customer ID - MANDATORY\",\n      \"type\": \"STRING\"\n    },\n    {\n      \"name\": \"product_id\",\n      \"displayName\": \"Product ID - MANDATORY\",\n      \"type\": \"STRING\"\n    },\n    {\n      \"name\": \"qty\",\n      \"displayName\": \"Quantity - MANDATORY\",\n      \"type\": \"INT\"\n    },\n    {\n      \"name\": \"timestamp\",\n      \"displayName\": \"Purchase date - MANDATORY\",\n      \"type\": \"DATETIME\",\n      \"format\": \"yyyy.DD.mm hh:mm:ss\"\n    },      \n    {\n      \"name\": \"customer_email_address\",\n      \"type\": \"STRING\"\n    },\n    {\n      \"name\": \"customer_mobile_phone_no\",\n      \"type\": \"STRING\"\n    },\n    {\n      \"name\": \"order_id\",\n      \"type\": \"INT\"\n    },\n    {\n      \"name\": \"payment_method\",\n      \"type\": \"STRING\"\n    },\n    {\n      \"name\": \"item_id\",\n      \"type\": \"STRING\"\n    },\n    {\n      \"name\": \"billing_address_line1\",\n      \"type\": \"STRING\"\n    },\n    {\n      \"name\": \"billing_address_line2\",\n      \"type\": \"STRING\"\n    },\n    {\n      \"name\": \"billing_address_line3\",\n      \"type\": \"STRING\"\n    },\n    {\n      \"name\": \"billing_address_line_postal_code\",\n      \"type\": \"STRING\"\n    },\n    {\n      \"name\": \"billing_address_line_region\",\n      \"type\": \"STRING\"\n    },\n    {\n      \"name\": \"billing_address_line_town\",\n      \"type\": \"STRING\"\n    },\n    {\n      \"name\": \"currency\",\n      \"type\": \"STRING\"\n    },\n    {\n      \"name\": \"postal_address_country\",\n      \"type\": \"STRING\"\n    },\n    {\n      \"name\": \"postal_address_line1\",\n      \"type\": \"STRING\"\n    },\n    {\n      \"name\": \"postal_address_line2\",\n      \"type\": \"STRING\"\n    },\n    {\n      \"name\": \"postal_address_line3\",\n      \"type\": \"STRING\"\n    },\n    {\n      \"name\": \"postal_address_postal_code\",\n      \"type\": \"STRING\"\n    },\n    {\n      \"name\": \"postal_address_region\",\n      \"type\": \"STRING\"\n    },\n    {\n      \"name\": \"postal_address_line_town\",\n      \"type\": \"STRING\"\n    },\n    {\n      \"name\": \"status\",\n      \"type\": \"STRING\"\n    },\n    {\n      \"name\": \"line_value_ex_tax\",\n      \"type\": \"DECIMAL\"\n    },\n    {\n      \"name\": \"line_value_inc_tax\",\n      \"type\": \"DECIMAL\"\n    }\n    ]\n}\n\n","options":{"raw":{"language":"json"}}},"url":"https://public-api.distil.ai/api/connection"},"_postman_previewlanguage":null,"header":null,"cookie":[],"responseTime":null,"body":null},{"id":"21ad0e2e-c134-4114-9108-8f2be54f1a25","name":"PRODUCT - With recognised fields","originalRequest":{"method":"POST","header":[{"key":"Authorization","type":"text","value":"{api_key}"}],"body":{"mode":"raw","raw":"{\n  \"name\": \"A Product data source\",\n  \"description\": \"All Products\",\n  \"type\": \"PRODUCT\",\n  \"attributes\": [\n    {\n      \"name\": \"id\",\n      \"displayName\": \"ID - Mandatory\",\n      \"type\": \"STRING\"\n    },\n    {\n      \"name\": \"title\",\n      \"displayName\": \"Title - Mandatory\",\n      \"type\": \"STRING\"\n    },\n    {\n      \"name\": \"Url\",\n      \"displayName\": \"URL - Mandatory\",\n      \"type\": \"STRING\"\n    },\n    {\n      \"name\": \"Available\",\n      \"displayName\": \"Available - Mandatory\",\n      \"type\": \"BOOLEAN\"\n    },\n    {\n      \"name\": \"thumbnail\",\n      \"type\": \"STRING\"\n    },\n    {\n      \"name\": \"description\",\n      \"type\": \"STRING\"\n    },\n    {\n      \"name\": \"list_price_inc_tax\",\n      \"type\": \"DECIMAL\"\n    },\n    {\n      \"name\": \"list_price_ex_tax\",\n      \"type\": \"DECIMAL\"\n    },\n    {\n      \"name\": \"price_breaks_description\",\n      \"type\": \"STRING\"\n    },                \n    {\n      \"name\": \"category\",\n      \"type\": \"STRING\"\n    }    \n  ]\n}\n\n","options":{"raw":{"language":"json"}}},"url":"https://public-api.distil.ai/api/connection"},"_postman_previewlanguage":null,"header":null,"cookie":[],"responseTime":null,"body":null}],"_postman_id":"55b4b18e-9585-4968-abae-6ca3d4f21dea"},{"name":"Get Datasource Details","event":[{"listen":"test","script":{"id":"b2b66112-062d-406c-b2a9-b27ec603cb2b","exec":[""],"type":"text/javascript"}}],"id":"940ac8dd-6b92-4589-bb3e-d35d740d98ab","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"auth":{"type":"noauth","isInherited":false},"method":"GET","header":[{"key":"Authorization","value":"{api_key}","type":"text"}],"body":{"mode":"raw","raw":"","options":{"raw":{"language":"json"}}},"url":"https://public-api.distil.ai/api/connection/{datasource_id}","description":"<p>Retrieves the details of a specified existing datasource within a Distil API Integration.</p>\n<p>The Datasource ID can be found by calling the <strong>List All Datasources</strong> operation.</p>\n","urlObject":{"protocol":"https","path":["api","connection","{datasource_id}"],"host":["public-api","distil","ai"],"query":[],"variable":[]}},"response":[{"id":"95b7e7e8-9001-4656-888d-00ad02a32d19","name":"Retrieve Datasource Details","originalRequest":{"method":"GET","header":[{"key":"Authorization","value":"{api_key}","type":"text"}],"body":{"mode":"raw","raw":"","options":{"raw":{"language":"json"}}},"url":"https://public-api.distil.ai/api/connection/{datasource_id}"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Cache-Control","value":"no-cache, no-store, max-age=0, must-revalidate"},{"key":"Pragma","value":"no-cache"},{"key":"Transfer-Encoding","value":"chunked"},{"key":"Content-Type","value":"application/json;charset=UTF-8"},{"key":"Content-Encoding","value":"gzip"},{"key":"Expires","value":"0"},{"key":"X-XSS-Protection","value":"1; mode=block"},{"key":"X-Frame-Options","value":"DENY"},{"key":"X-Content-Type-Options","value":"nosniff"},{"key":"Strict-Transport-Security","value":"max-age=31536000 ; includeSubDomains"},{"key":"Referrer-Policy","value":"no-referrer"},{"key":"Date","value":"Tue, 03 Nov 2020 12:32:35 GMT"}],"cookie":[],"responseTime":null,"body":"{\n    \"id\": \"MjQ=\",\n    \"name\": \"DataSource Name\",\n    \"description\": \"Example DataSource with all field types\",\n    \"type\": \"CUSTOMER\",\n    \"icon\": \"SQLSERVER\",\n    \"attributes\": [\n        {\n            \"id\": \"Mjc0\",\n            \"name\": \"Datetime_formatted\",\n            \"displayName\": \"Datetime Formatted\",\n            \"createdDate\": \"2020-11-03 12:25:14\",\n            \"notNullCount\": null,\n            \"tag\": \"NONE\",\n            \"format\": \"yyyy.DD.mm hh:mm:ss\",\n            \"type\": \"DATETIME\"\n        },\n        {\n            \"id\": \"Mjcz\",\n            \"name\": \"Datetime\",\n            \"displayName\": \"Datetime\",\n            \"createdDate\": \"2020-11-03 12:25:14\",\n            \"notNullCount\": null,\n            \"tag\": \"NONE\",\n            \"format\": \"yyyy-MM-dd HH:mm:ss\",\n            \"type\": \"DATETIME\"\n        },\n        {\n            \"id\": \"Mjcy\",\n            \"name\": \"Date_formatted\",\n            \"displayName\": \"Date Formatted\",\n            \"createdDate\": \"2020-11-03 12:25:14\",\n            \"notNullCount\": null,\n            \"tag\": \"NONE\",\n            \"format\": \"yyyy.MM.dd\",\n            \"type\": \"DATE\"\n        },\n        {\n            \"id\": \"Mjcx\",\n            \"name\": \"Date\",\n            \"displayName\": \"Date\",\n            \"createdDate\": \"2020-11-03 12:25:14\",\n            \"notNullCount\": null,\n            \"tag\": \"NONE\",\n            \"format\": \"yyyy-MM-dd\",\n            \"type\": \"DATE\"\n        },\n        {\n            \"id\": \"Mjcw\",\n            \"name\": \"Decimal\",\n            \"displayName\": \"Decimal\",\n            \"createdDate\": \"2020-11-03 12:25:14\",\n            \"notNullCount\": null,\n            \"tag\": \"NONE\",\n            \"format\": null,\n            \"type\": \"DECIMAL\"\n        },\n        {\n            \"id\": \"MjY5\",\n            \"name\": \"integer\",\n            \"displayName\": \"Integer\",\n            \"createdDate\": \"2020-11-03 12:25:14\",\n            \"notNullCount\": null,\n            \"tag\": \"NONE\",\n            \"format\": null,\n            \"type\": \"INT\"\n        },\n        {\n            \"id\": \"MjY4\",\n            \"name\": \"boolean\",\n            \"displayName\": \"Boolean\",\n            \"createdDate\": \"2020-11-03 12:25:14\",\n            \"notNullCount\": null,\n            \"tag\": \"NONE\",\n            \"format\": null,\n            \"type\": \"BOOLEAN\"\n        },\n        {\n            \"id\": \"MjY3\",\n            \"name\": \"EMAIL\",\n            \"displayName\": \"Email\",\n            \"createdDate\": \"2020-11-03 12:25:14\",\n            \"notNullCount\": null,\n            \"tag\": \"CUSTOMER_EMAIL_ADDRESS\",\n            \"format\": null,\n            \"type\": \"STRING\"\n        },\n        {\n            \"id\": \"MjY2\",\n            \"name\": \"id\",\n            \"displayName\": \"Unique ID - mandatory\",\n            \"createdDate\": \"2020-11-03 12:25:14\",\n            \"notNullCount\": null,\n            \"tag\": \"CUSTOMER_EXTERNAL_ID\",\n            \"format\": null,\n            \"type\": \"STRING\"\n        }\n    ],\n    \"recordsCount\": null,\n    \"lastSyncDate\": null,\n    \"ingestEndpoint\": \"https://public-api.distil.ai/api/connection/MjQ=/data\"\n}"}],"_postman_id":"940ac8dd-6b92-4589-bb3e-d35d740d98ab"},{"name":"Edit Datasource","event":[{"listen":"test","script":{"id":"3ad02b0e-03b6-493a-adae-51d1a8ef3075","exec":[""],"type":"text/javascript"}}],"id":"d25449bd-8583-4b8d-95c2-b2279758eff7","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"auth":{"type":"noauth","isInherited":false},"method":"PUT","header":[{"key":"Authorization","type":"text","value":"{api_key}"}],"body":{"mode":"raw","raw":"{\n  \"name\": \"Example Datasource\",\n  \"description\": \"Example DataSource with all field types\",\n  \"type\": \"CUSTOMER\",\n  \"attributes\": [\n    {\n      \"name\": \"id\",\n      \"displayName\": \"Identity\",\n      \"type\": \"STRING\"\n    },\n    {\n      \"name\": \"NewAttribute1\",\n      \"type\": \"STRING\"\n    },\n    {\n      \"name\": \"NewAttribute2\",\n      \"type\": \"BOOLEAN\"\n    }\n    ]\n}\n\n","options":{"raw":{"language":"json"}}},"url":"https://public-api.distil.ai/api/connection/{datasource_id}","description":"<p>Updates the details of a specified Datasource or Datasource attribute, or inserts new attributes into a Datasource within a Distil API Integration.</p>\n<p>Please see <a href=\"#55b4b18e-9585-4968-abae-6ca3d4f21dea\">Create Datasource</a> for further details of the body payload.</p>\n","urlObject":{"protocol":"https","path":["api","connection","{datasource_id}"],"host":["public-api","distil","ai"],"query":[],"variable":[]}},"response":[{"id":"f560f17e-ce69-4eb1-b937-42072176aacd","name":"Edit Datasource","originalRequest":{"method":"PUT","header":[{"key":"Authorization","type":"text","value":"{api_key}"}],"body":{"mode":"raw","raw":"{\n  \"name\": \"Example Datasource\",\n  \"description\": \"Example DataSource with all field types\",\n  \"type\": \"CUSTOMER\",\n  \"attributes\": [\n    {\n      \"name\": \"id\",\n      \"displayName\": \"Identity\",\n      \"type\": \"STRING\"\n    },\n    {\n      \"name\": \"NewAttribute1\",\n      \"type\": \"STRING\"\n    },\n    {\n      \"name\": \"NewAttribute2\",\n      \"type\": \"BOOLEAN\"\n    }\n    ]\n}\n\n","options":{"raw":{"language":"json"}}},"url":"https://public-api.distil.ai/api/connection/{datasource_id}"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Cache-Control","value":"no-cache, no-store, max-age=0, must-revalidate"},{"key":"Pragma","value":"no-cache"},{"key":"Transfer-Encoding","value":"chunked"},{"key":"Content-Type","value":"application/json;charset=UTF-8"},{"key":"Content-Encoding","value":"gzip"},{"key":"Expires","value":"0"},{"key":"X-XSS-Protection","value":"1; mode=block"},{"key":"X-Frame-Options","value":"DENY"},{"key":"X-Content-Type-Options","value":"nosniff"},{"key":"Strict-Transport-Security","value":"max-age=31536000 ; includeSubDomains"},{"key":"Referrer-Policy","value":"no-referrer"},{"key":"Date","value":"Tue, 03 Nov 2020 12:45:07 GMT"}],"cookie":[],"responseTime":null,"body":"{\n    \"id\": \"MjQ=\",\n    \"name\": \"Example Datasource\",\n    \"description\": \"Example DataSource with all field types\",\n    \"type\": \"CUSTOMER\",\n    \"icon\": \"SQLSERVER\",\n    \"attributes\": [\n        {\n            \"id\": \"Mjc2\",\n            \"name\": \"NewAttribute2\",\n            \"displayName\": \"New Attribute 2\",\n            \"createdDate\": \"2020-11-03 12:45:07\",\n            \"notNullCount\": null,\n            \"tag\": \"NONE\",\n            \"format\": null,\n            \"type\": \"BOOLEAN\"\n        },\n        {\n            \"id\": \"Mjc1\",\n            \"name\": \"NewAttribute1\",\n            \"displayName\": \"New Attribute 1\",\n            \"createdDate\": \"2020-11-03 12:45:07\",\n            \"notNullCount\": null,\n            \"tag\": \"NONE\",\n            \"format\": null,\n            \"type\": \"STRING\"\n        },\n        {\n            \"id\": \"MjY2\",\n            \"name\": \"id\",\n            \"displayName\": \"Identity\",\n            \"createdDate\": \"2020-11-03 12:25:14\",\n            \"notNullCount\": null,\n            \"tag\": \"CUSTOMER_EXTERNAL_ID\",\n            \"format\": null,\n            \"type\": \"STRING\"\n        },\n        {\n            \"id\": \"Mjc0\",\n            \"name\": \"Datetime_formatted\",\n            \"displayName\": \"Datetime Formatted\",\n            \"createdDate\": \"2020-11-03 12:25:14\",\n            \"notNullCount\": null,\n            \"tag\": \"NONE\",\n            \"format\": \"yyyy.DD.mm hh:mm:ss\",\n            \"type\": \"DATETIME\"\n        },\n        {\n            \"id\": \"Mjcz\",\n            \"name\": \"Datetime\",\n            \"displayName\": \"Datetime\",\n            \"createdDate\": \"2020-11-03 12:25:14\",\n            \"notNullCount\": null,\n            \"tag\": \"NONE\",\n            \"format\": \"yyyy-MM-dd HH:mm:ss\",\n            \"type\": \"DATETIME\"\n        },\n        {\n            \"id\": \"Mjcy\",\n            \"name\": \"Date_formatted\",\n            \"displayName\": \"Date Formatted\",\n            \"createdDate\": \"2020-11-03 12:25:14\",\n            \"notNullCount\": null,\n            \"tag\": \"NONE\",\n            \"format\": \"yyyy.MM.dd\",\n            \"type\": \"DATE\"\n        },\n        {\n            \"id\": \"Mjcx\",\n            \"name\": \"Date\",\n            \"displayName\": \"Date\",\n            \"createdDate\": \"2020-11-03 12:25:14\",\n            \"notNullCount\": null,\n            \"tag\": \"NONE\",\n            \"format\": \"yyyy-MM-dd\",\n            \"type\": \"DATE\"\n        },\n        {\n            \"id\": \"Mjcw\",\n            \"name\": \"Decimal\",\n            \"displayName\": \"Decimal\",\n            \"createdDate\": \"2020-11-03 12:25:14\",\n            \"notNullCount\": null,\n            \"tag\": \"NONE\",\n            \"format\": null,\n            \"type\": \"DECIMAL\"\n        },\n        {\n            \"id\": \"MjY5\",\n            \"name\": \"integer\",\n            \"displayName\": \"Integer\",\n            \"createdDate\": \"2020-11-03 12:25:14\",\n            \"notNullCount\": null,\n            \"tag\": \"NONE\",\n            \"format\": null,\n            \"type\": \"INT\"\n        },\n        {\n            \"id\": \"MjY4\",\n            \"name\": \"boolean\",\n            \"displayName\": \"Boolean\",\n            \"createdDate\": \"2020-11-03 12:25:14\",\n            \"notNullCount\": null,\n            \"tag\": \"NONE\",\n            \"format\": null,\n            \"type\": \"BOOLEAN\"\n        },\n        {\n            \"id\": \"MjY3\",\n            \"name\": \"EMAIL\",\n            \"displayName\": \"Email\",\n            \"createdDate\": \"2020-11-03 12:25:14\",\n            \"notNullCount\": null,\n            \"tag\": \"CUSTOMER_EMAIL_ADDRESS\",\n            \"format\": null,\n            \"type\": \"STRING\"\n        }\n    ],\n    \"recordsCount\": null,\n    \"lastSyncDate\": null,\n    \"ingestEndpoint\": \"https://public-api.distil.ai/api/connection/MjQ=/data\"\n}"}],"_postman_id":"d25449bd-8583-4b8d-95c2-b2279758eff7"},{"name":"Create New Datasource Attribute","event":[{"listen":"test","script":{"id":"b98fa78b-8c0e-428e-a822-b886e222c87a","exec":[""],"type":"text/javascript"}}],"id":"57e80631-3f7e-49d4-803c-2d720213483e","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"auth":{"type":"noauth","isInherited":false},"method":"POST","header":[{"key":"Authorization","value":"{api_key}","type":"text"}],"body":{"mode":"raw","raw":"{\n    \"name\": \"NewAttribute3\",\n    \"displayName\": \"Third New Attribute\",\n    \"type\": \"DATE\",\n    \"format\": \"yyyy.MM.dd\"\n}","options":{"raw":{"language":"json"}}},"url":"https://public-api.distil.ai/api/connection/{datasource_id}/attribute","description":"<p>Creates new attribute(s) in a specified existing datasource within a Distil API Integration.</p>\n<p>Please see <a href=\"#55b4b18e-9585-4968-abae-6ca3d4f21dea\">Create Datasource</a> for further details of the body payload.</p>\n","urlObject":{"protocol":"https","path":["api","connection","{datasource_id}","attribute"],"host":["public-api","distil","ai"],"query":[],"variable":[]}},"response":[{"id":"7c132a1a-d968-4a8a-9a0c-1a51ee2e606e","name":"Create New Datasource Attribute","originalRequest":{"method":"POST","header":[{"key":"Authorization","value":"{api_key}","type":"text"}],"body":{"mode":"raw","raw":"{\n    \"name\": \"NewAttribute3\",\n    \"displayName\": \"Third New Attribute\",\n    \"type\": \"DATE\",\n    \"format\": \"yyyy.MM.dd\"\n}","options":{"raw":{"language":"json"}}},"url":"https://public-api.distil.ai/api/connection/{datasource_id}/attribute"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Cache-Control","value":"no-cache, no-store, max-age=0, must-revalidate"},{"key":"Pragma","value":"no-cache"},{"key":"Content-Length","value":"175"},{"key":"Content-Type","value":"application/json;charset=UTF-8"},{"key":"Expires","value":"0"},{"key":"X-XSS-Protection","value":"1; mode=block"},{"key":"X-Frame-Options","value":"DENY"},{"key":"X-Content-Type-Options","value":"nosniff"},{"key":"Strict-Transport-Security","value":"max-age=31536000 ; includeSubDomains"},{"key":"Referrer-Policy","value":"no-referrer"},{"key":"Date","value":"Tue, 03 Nov 2020 12:49:27 GMT"}],"cookie":[],"responseTime":null,"body":"{\n    \"id\": \"Mjc3\",\n    \"name\": \"NewAttribute3\",\n    \"displayName\": \"Third New Attribute\",\n    \"createdDate\": \"2020-11-03 12:49:27\",\n    \"notNullCount\": null,\n    \"tag\": null,\n    \"format\": \"yyyy.MM.dd\",\n    \"type\": \"DATE\"\n}"}],"_postman_id":"57e80631-3f7e-49d4-803c-2d720213483e"},{"name":"Edit Datasource Attribute","event":[{"listen":"test","script":{"id":"0ab917a2-d5d8-4e36-8c7b-8739e41f5bba","exec":[""],"type":"text/javascript"}}],"id":"467d52bf-38d3-4634-b976-33573cd7f977","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"auth":{"type":"noauth","isInherited":false},"method":"PUT","header":[{"key":"Authorization","value":"{api_key}","type":"text"}],"body":{"mode":"raw","raw":"{\n   \"name\": \"EMAIL\",\n   \"displayName\": \"Email Address\",\n   \"type\": \"STRING\",\n   \"format\": \"\"\n}\n","options":{"raw":{"language":"json"}}},"url":"https://public-api.distil.ai/api/connection/{datasource_id}/attribute/{attribute_id}","description":"<p>Updates a specified Attribute in an existing datasource within a Distil API Integration.</p>\n<p>Please see <a href=\"#55b4b18e-9585-4968-abae-6ca3d4f21dea\">Create Datasource</a> for further details of the body payload.</p>\n","urlObject":{"protocol":"https","path":["api","connection","{datasource_id}","attribute","{attribute_id}"],"host":["public-api","distil","ai"],"query":[],"variable":[]}},"response":[{"id":"c933a2b1-0240-4329-9792-d51cca2a20cc","name":"Edit Datasource Attribute","originalRequest":{"method":"PUT","header":[{"key":"Authorization","value":"{api_key}","type":"text"}],"body":{"mode":"raw","raw":"{\n   \"name\": \"EMAIL\",\n   \"displayName\": \"Email Address\",\n   \"type\": \"STRING\",\n   \"format\": \"\"\n}\n","options":{"raw":{"language":"json"}}},"url":"https://public-api.distil.ai/api/connection/{datasource_id}/attribute/{attribute_id}"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Cache-Control","value":"no-cache, no-store, max-age=0, must-revalidate"},{"key":"Pragma","value":"no-cache"},{"key":"Content-Length","value":"173"},{"key":"Content-Type","value":"application/json;charset=UTF-8"},{"key":"Expires","value":"0"},{"key":"X-XSS-Protection","value":"1; mode=block"},{"key":"X-Frame-Options","value":"DENY"},{"key":"X-Content-Type-Options","value":"nosniff"},{"key":"Strict-Transport-Security","value":"max-age=31536000 ; includeSubDomains"},{"key":"Referrer-Policy","value":"no-referrer"},{"key":"Date","value":"Tue, 03 Nov 2020 12:53:31 GMT"}],"cookie":[],"responseTime":null,"body":"{\n    \"id\": \"MjY3\",\n    \"name\": \"EMAIL\",\n    \"displayName\": \"Email Address\",\n    \"createdDate\": \"2020-11-03 12:25:14\",\n    \"notNullCount\": null,\n    \"tag\": \"CUSTOMER_EMAIL_ADDRESS\",\n    \"format\": \"\",\n    \"type\": \"STRING\"\n}"}],"_postman_id":"467d52bf-38d3-4634-b976-33573cd7f977"},{"name":"Delete Datasource Attribute","event":[{"listen":"test","script":{"id":"0923248a-e09e-4687-afd4-b38015c1c8ad","exec":[""],"type":"text/javascript","packages":{},"requests":{}}}],"id":"2197cd72-c462-4c59-be7a-2888dbedb751","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"DELETE","header":[{"key":"Authorization","value":"{api_key}","type":"text"}],"body":{"mode":"raw","raw":"","options":{"raw":{"language":"json"}}},"url":"https://public-api.distil.ai/api/connection/{datasource_id}/attribute/{attribute_id}","description":"<p>Deletes a specified Attribute from an existing datasource within a Distil API Integration.</p>\n<p>The Attribute ID can be found be calling the <a href=\"#940ac8dd-6b92-4589-bb3e-d35d740d98ab\">Get Datasource Details</a> endpoint.</p>\n","auth":{"type":"apikey","apikey":{"basicConfig":[{"key":"key","value":"Authorization"},{"key":"value","value":"<value>"}]},"isInherited":true,"source":{"_postman_id":"397aeed5-5850-41bd-be8a-10339a4f4f2e","id":"397aeed5-5850-41bd-be8a-10339a4f4f2e","name":"Distil.ai Public API Documentation","type":"collection"}},"urlObject":{"protocol":"https","path":["api","connection","{datasource_id}","attribute","{attribute_id}"],"host":["public-api","distil","ai"],"query":[],"variable":[]}},"response":[{"id":"6f5f0615-a6eb-4495-ae9c-2c1c9ceb699c","name":"Delete Datasource Attribute","originalRequest":{"method":"DELETE","header":[{"key":"Authorization","value":"{api_key}","type":"text"}],"body":{"mode":"raw","raw":"","options":{"raw":{"language":"json"}}},"url":"https://public-api.distil.ai/api/connection/{datasource_id}/attribute/{attribute_id}"},"status":"No Content","code":204,"_postman_previewlanguage":"plain","header":[{"key":"Cache-Control","value":"no-cache, no-store, max-age=0, must-revalidate"},{"key":"Pragma","value":"no-cache"},{"key":"Expires","value":"0"},{"key":"X-XSS-Protection","value":"1; mode=block"},{"key":"X-Frame-Options","value":"DENY"},{"key":"X-Content-Type-Options","value":"nosniff"},{"key":"Strict-Transport-Security","value":"max-age=31536000 ; includeSubDomains"},{"key":"Referrer-Policy","value":"no-referrer"},{"key":"Date","value":"Tue, 03 Nov 2020 12:56:49 GMT"}],"cookie":[],"responseTime":null,"body":null}],"_postman_id":"2197cd72-c462-4c59-be7a-2888dbedb751"},{"name":"Insert/Update Datasource Records","event":[{"listen":"test","script":{"id":"98ae443b-6807-43f4-a07e-0e30b93abb18","exec":[""],"type":"text/javascript"}}],"id":"b5ad7921-f5d4-490c-996f-507f6d4047d3","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"auth":{"type":"noauth","isInherited":false},"method":"POST","header":[{"key":"Authorization","type":"text","value":"{api_key}"}],"body":{"mode":"raw","raw":"[\n    {\n        \"id\": \"0\",\n        \"EMAIL\": \"0@email.com\",\n        \"boolean\": true,\n        \"integer\": 0,\n        \"Decimal\": 0.132,\n        \"Date\": \"2020-11-21\",\n        \"Date_formatted\": \"2020.21.11\",\n        \"Datetime\": \"2020-11-21 21:21:21\",\n        \"Datetime_formatted\": \"2020.21.11 21:21:21\",\n        \"NewAttribute1\": \"a\",\n        \"NewAttribute2\": true\n    },\n    {\n        \"id\": \"1\",\n        \"EMAIL\": \"1@email.com\",\n        \"boolean\": true,\n        \"integer\": 1,\n        \"Decimal\": 1.1320000000000001,\n        \"Date\": \"2020-11-21\",\n        \"Date_formatted\": \"2020.21.11\",\n        \"Datetime\": \"2020-11-21 21:21:21\",\n        \"Datetime_formatted\": \"2020.21.11 21:21:21\",\n        \"NewAttribute1\": \"b\",\n        \"NewAttribute2\": false\n    }\n]","options":{"raw":{"language":"json"}}},"url":"https://public-api.distil.ai/api/connection/{datasource_id}/data","description":"<p>Inserts or Updates records into an existing specified Datasource within a Distil API Integration.</p>\n<p>The body of the request is in JSON format and should include an array containing an object for each record to be updated. Each object in the array should contain the following elements:</p>\n<ul>\n<li><p>The <strong>id</strong> of the Record. The ID value should be of the correct type, as specified within the attribute properties.</p>\n</li>\n<li><p>Then, for every other attribute, the attribute name followed by the attribute value e.g. \"email\": \"<a href=\"mailto:info@distil.ai\">info@distil.ai</a>\". The attribute value should be of the correct type, as specified within the attribute properties.</p>\n</li>\n</ul>\n<p>If an attribute is omitted it will not be updated, however all mandatory attributes cannot be omitted and must be included for all new records.</p>\n<p>The response body for a successful request is likely to return a status of 'IN_PROGRESS\", with an ingestion ID. This ingestion ID can then be used in the <a href=\"#f30ad0e2-2d6a-45de-bd51-fdacba78d3b6\">Check Ingestion Status</a>  request to verify the progress of the update.</p>\n","urlObject":{"protocol":"https","path":["api","connection","{datasource_id}","data"],"host":["public-api","distil","ai"],"query":[],"variable":[]}},"response":[{"id":"0b9994f3-4afe-41cb-bf5e-07e5faad74bb","name":"Insert/Update Datasource Records","originalRequest":{"method":"POST","header":[{"key":"Authorization","type":"text","value":"{api_key}"}],"body":{"mode":"raw","raw":"[\n    {\n        \"id\": \"0\",\n        \"EMAIL\": \"0@email.com\",\n        \"boolean\": true,\n        \"integer\": 0,\n        \"Decimal\": 0.132,\n        \"Date\": \"2020-11-21\",\n        \"Date_formatted\": \"2020.21.11\",\n        \"Datetime\": \"2020-11-21 21:21:21\",\n        \"Datetime_formatted\": \"2020.21.11 21:21:21\",\n        \"NewAttribute1\": \"a\",\n        \"NewAttribute2\": true\n    },\n    {\n        \"id\": \"1\",\n        \"EMAIL\": \"1@email.com\",\n        \"boolean\": true,\n        \"integer\": 1,\n        \"Decimal\": 1.1320000000000001,\n        \"Date\": \"2020-11-21\",\n        \"Date_formatted\": \"2020.21.11\",\n        \"Datetime\": \"2020-11-21 21:21:21\",\n        \"Datetime_formatted\": \"2020.21.11 21:21:21\",\n        \"NewAttribute1\": \"b\",\n        \"NewAttribute2\": false\n    }\n]","options":{"raw":{"language":"json"}}},"url":"https://public-api.distil.ai/api/connection/{datasource_id}/data"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Cache-Control","value":"no-cache, no-store, max-age=0, must-revalidate"},{"key":"Pragma","value":"no-cache"},{"key":"Content-Length","value":"90"},{"key":"Content-Type","value":"application/json;charset=UTF-8"},{"key":"Expires","value":"0"},{"key":"X-Content-Type-Options","value":"nosniff"},{"key":"X-Frame-Options","value":"DENY"},{"key":"X-XSS-Protection","value":"1 ; mode=block"},{"key":"Referrer-Policy","value":"no-referrer"},{"key":"Date","value":"Wed, 04 Nov 2020 09:43:39 GMT"}],"cookie":[],"responseTime":null,"body":"{\n    \"id\": \"2619aa10-1e82-11eb-a74b-93b30e41195b\",\n    \"status\": \"IN_PROGRESS\",\n    \"ingestionResults\": []\n}"}],"_postman_id":"b5ad7921-f5d4-490c-996f-507f6d4047d3"},{"name":"Check ingestion status","event":[{"listen":"test","script":{"id":"95e3bb1a-bc66-431c-bd0a-02645e696825","exec":["pm.test(\"Status is OK\", function () {","    pm.response.to.have.status(200);","});","","var jsonData = pm.response.json();","","pm.test(\"FINISHED status returned\", function () {","    pm.expect(jsonData.id).to.be.an('string').that.is.not.empty;","    pm.expect(jsonData.status).to.be.an('string').that.is.eql('FINISHED');","","});","","pm.test(\"Results Array as expected\", function () {","","    pm.expect(jsonData.ingestionResults).to.be.an('array').that.is.not.empty;","","    let res1 = jsonData.ingestionResults[0];","","    pm.expect(res1.idx).to.be.an('number').that.is.eql(0);","    pm.expect(res1.result).to.be.an('string').that.is.eql('NOT_CHANGED');","    pm.expect(res1.details).to.be.null;","","    let res2 = jsonData.ingestionResults[1];","","    pm.expect(res2.idx).to.be.an('number').that.is.eql(1);","    pm.expect(res2.result).to.be.an('string').that.is.eql('CREATED');","    pm.expect(res2.details).to.be.null;","});"],"type":"text/javascript"}}],"id":"f30ad0e2-2d6a-45de-bd51-fdacba78d3b6","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"auth":{"type":"noauth","isInherited":false},"method":"GET","header":[{"key":"Authorization","type":"text","value":"{api_key}"}],"body":{"mode":"raw","raw":"","options":{"raw":{"language":"json"}}},"url":"https://public-api.distil.ai/api/connection/{datasource_id}/data/{ingestion_id}","description":"<p>Checks the ingestion status of a request to insert, update or delete records into a datasource.</p>\n<p>The Ingestion ID is returned in the response of the <a href=\"#b5ad7921-f5d4-490c-996f-507f6d4047d3\">Insert/Update Datasource Records</a> or <a href=\"#3d859e90-433e-4f35-b6d3-69388180fb8a\">Delete Records by ID</a> requests.</p>\n<p>If the response status is still \"WAITING\" then the request can be refreshed until a final status is returned.</p>\n","urlObject":{"protocol":"https","path":["api","connection","{datasource_id}","data","{ingestion_id}"],"host":["public-api","distil","ai"],"query":[],"variable":[]}},"response":[{"id":"36e48ab6-bacf-47a9-8942-888c0980f169","name":"Check ingestion status","originalRequest":{"method":"GET","header":[{"key":"Authorization","value":"{api_key}","type":"text"}],"body":{"mode":"raw","raw":"","options":{"raw":{"language":"json"}}},"url":"https://public-api.distil.ai/api/connection/{datasource_id}/data/{ingestion_id}"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Cache-Control","value":"no-cache, no-store, max-age=0, must-revalidate"},{"key":"Pragma","value":"no-cache"},{"key":"Content-Length","value":"174"},{"key":"Content-Type","value":"application/json;charset=UTF-8"},{"key":"Expires","value":"0"},{"key":"X-Content-Type-Options","value":"nosniff"},{"key":"X-Frame-Options","value":"DENY"},{"key":"X-XSS-Protection","value":"1 ; mode=block"},{"key":"Referrer-Policy","value":"no-referrer"},{"key":"Date","value":"Wed, 04 Nov 2020 09:47:29 GMT"}],"cookie":[],"responseTime":null,"body":"{\n    \"id\": \"2619aa10-1e82-11eb-a74b-93b30e41195b\",\n    \"status\": \"FINISHED\",\n    \"ingestionResults\": [\n        {\n            \"idx\": 0,\n            \"result\": \"CREATED\",\n            \"details\": null\n        },\n        {\n            \"idx\": 1,\n            \"result\": \"CREATED\",\n            \"details\": null\n        }\n    ]\n}"}],"_postman_id":"f30ad0e2-2d6a-45de-bd51-fdacba78d3b6"},{"name":"Retrieve Datasource Records","event":[{"listen":"test","script":{"id":"de701314-a51a-427d-8630-950cd0468a5e","exec":[""],"type":"text/javascript"}}],"id":"73a89d16-56ca-4020-8104-72ad0f86ec39","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"auth":{"type":"noauth","isInherited":false},"method":"GET","header":[{"key":"Authorization","value":"{api_key}","type":"text"}],"url":"https://public-api.distil.ai/api/connection/{datasource_id}/data","description":"<p>Retreives all records from a specified datasource within a Distil API Integration</p>\n","urlObject":{"protocol":"https","path":["api","connection","{datasource_id}","data"],"host":["public-api","distil","ai"],"query":[],"variable":[]}},"response":[{"id":"692b0b18-b8da-4888-a4bd-b511389c8529","name":"Retrieve Datasource Records","originalRequest":{"method":"GET","header":[{"key":"Authorization","value":"{api_key}","type":"text"}],"url":"https://staging-public-api.distil.ai/api/connection/{datasource_id}/data"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Cache-Control","value":"no-cache, no-store, max-age=0, must-revalidate"},{"key":"Pragma","value":"no-cache"},{"key":"Content-Length","value":"633"},{"key":"Content-Type","value":"application/json;charset=UTF-8"},{"key":"Expires","value":"0"},{"key":"X-Content-Type-Options","value":"nosniff"},{"key":"X-Frame-Options","value":"DENY"},{"key":"X-XSS-Protection","value":"1 ; mode=block"},{"key":"Referrer-Policy","value":"no-referrer"},{"key":"Date","value":"Wed, 04 Nov 2020 09:47:39 GMT"}],"cookie":[],"responseTime":null,"body":"{\n    \"data\": [\n        {\n            \"boolean\": true,\n            \"Decimal\": 0.132,\n            \"NewAttribute1\": \"a\",\n            \"Datetime_formatted\": \"2020-01-21T21:21:21.000+0000\",\n            \"NewAttribute2\": true,\n            \"id\": \"0\",\n            \"integer\": 0,\n            \"EMAIL\": \"0@email.com\",\n            \"Date\": \"2020-11-21T00:00:00.000+0000\",\n            \"Date_formatted\": \"2021-09-11T00:00:00.000+0000\",\n            \"Datetime\": \"2020-11-21T21:21:21.000+0000\"\n        },\n        {\n            \"boolean\": true,\n            \"Decimal\": 1.1320000000000001,\n            \"NewAttribute1\": \"b\",\n            \"Datetime_formatted\": \"2020-01-21T21:21:21.000+0000\",\n            \"NewAttribute2\": false,\n            \"id\": \"1\",\n            \"integer\": 1,\n            \"EMAIL\": \"1@email.com\",\n            \"Date\": \"2020-11-21T00:00:00.000+0000\",\n            \"Date_formatted\": \"2021-09-11T00:00:00.000+0000\",\n            \"Datetime\": \"2020-11-21T21:21:21.000+0000\"\n        }\n    ],\n    \"nextUrl\": null\n}"}],"_postman_id":"73a89d16-56ca-4020-8104-72ad0f86ec39"},{"name":"Get Datasource Record by External ID","event":[{"listen":"test","script":{"id":"7369001c-baea-42c8-b192-33de11e2c79b","exec":[""],"type":"text/javascript"}}],"id":"5866af2a-fb7e-41cb-8947-488b88d24230","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"auth":{"type":"noauth","isInherited":false},"method":"GET","header":[{"key":"Authorization","value":"{api_key}","type":"text"}],"body":{"mode":"raw","raw":""},"url":"https://public-api.distil.ai/api/customer?id={external_id}","description":"<p>Retreives a single record, identified using the external ID, from a specified datasource within a Distil API Integration</p>\n","urlObject":{"protocol":"https","path":["api","customer"],"host":["public-api","distil","ai"],"query":[{"key":"id","value":"{external_id}"}],"variable":[]}},"response":[{"id":"b72a9c61-ec9c-4e95-8248-f2728f2c7012","name":"Get Datasource Record by External ID","originalRequest":{"method":"GET","header":[{"key":"Authorization","value":"{api_key}","type":"text"}],"body":{"mode":"raw","raw":""},"url":{"raw":"https://public-api.distil.ai/api/customer?id={external_id}","protocol":"https","host":["public-api","distil","ai"],"path":["api","customer"],"query":[{"key":"id","value":"{external_id}"}]}},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Cache-Control","value":"no-cache, no-store, max-age=0, must-revalidate"},{"key":"Pragma","value":"no-cache"},{"key":"Content-Length","value":"64"},{"key":"Content-Type","value":"application/json;charset=UTF-8"},{"key":"Expires","value":"0"},{"key":"X-XSS-Protection","value":"1; mode=block"},{"key":"X-Frame-Options","value":"DENY"},{"key":"X-Content-Type-Options","value":"nosniff"},{"key":"Strict-Transport-Security","value":"max-age=31536000 ; includeSubDomains"},{"key":"Referrer-Policy","value":"no-referrer"},{"key":"Date","value":"Wed, 04 Nov 2020 11:32:19 GMT"}],"cookie":[],"responseTime":null,"body":"[\n    {\n        \"id\": \"0bf984c7-a0b7-4459-baea-9ea17a37f074\",\n        \"dataSources\": []\n    }\n]"}],"_postman_id":"5866af2a-fb7e-41cb-8947-488b88d24230"},{"name":"Delete Records By ID","event":[{"listen":"test","script":{"id":"de32b2bf-1685-4f18-a9fa-1fdbfdca524c","exec":[""],"type":"text/javascript"}}],"id":"3d859e90-433e-4f35-b6d3-69388180fb8a","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"auth":{"type":"noauth","isInherited":false},"method":"DELETE","header":[{"key":"Authorization","type":"text","value":"{api_key}"}],"body":{"mode":"raw","raw":"[\n    \"0\",\n    \"1\"\n]","options":{"raw":{"language":"json"}}},"url":"https://public-api.distil.ai/api/connection/{datasource_id}/data","description":"<p>Deletes one or more records, by passing external IDs as an array within the message Body, from a specified datasource within a Distil API Integration.</p>\n<p>The body of the request is in JSON format and should contain an array of external IDs of those records that are to be deleted.</p>\n<p>The response body for a successful request is likely to return a status of 'WAITING\", with an ingestion ID. This ingestion ID can then be used in the <a href=\"#f30ad0e2-2d6a-45de-bd51-fdacba78d3b6\">Check Ingestion Status</a> request to verify the progress of the update.</p>\n","urlObject":{"protocol":"https","path":["api","connection","{datasource_id}","data"],"host":["public-api","distil","ai"],"query":[],"variable":[]}},"response":[{"id":"604ccbe7-5b12-466e-90e4-124fc46ecb72","name":"Delete Records By ID","originalRequest":{"method":"DELETE","header":[{"key":"Authorization","type":"text","value":"{api_key}"}],"body":{"mode":"raw","raw":"[\n    \"0\",\n    \"1\"\n]","options":{"raw":{"language":"json"}}},"url":"https://public-api.distil.ai/api/connection/{datasource_id}/data"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Cache-Control","value":"no-cache, no-store, max-age=0, must-revalidate"},{"key":"Pragma","value":"no-cache"},{"key":"Content-Length","value":"86"},{"key":"Content-Type","value":"application/json;charset=UTF-8"},{"key":"Expires","value":"0"},{"key":"X-Content-Type-Options","value":"nosniff"},{"key":"X-Frame-Options","value":"DENY"},{"key":"X-XSS-Protection","value":"1 ; mode=block"},{"key":"Referrer-Policy","value":"no-referrer"},{"key":"Date","value":"Wed, 04 Nov 2020 10:10:39 GMT"}],"cookie":[],"responseTime":null,"body":"{\n    \"id\": \"eb5d3550-1e85-11eb-a74b-93b30e41195b\",\n    \"status\": \"WAITING\",\n    \"ingestionResults\": []\n}"}],"_postman_id":"3d859e90-433e-4f35-b6d3-69388180fb8a"},{"name":"Delete Records by ID","event":[{"listen":"test","script":{"id":"7b6e6af5-0051-449f-be8e-f20c6cb8decd","exec":[""],"type":"text/javascript"}}],"id":"cb133db2-3bc0-44b2-b7fd-91b3ac5ba34a","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"auth":{"type":"noauth","isInherited":false},"method":"POST","header":[{"key":"Authorization","type":"text","value":"{api_key}"}],"body":{"mode":"raw","raw":"[\n    \"0\",\n    \"1\"\n]","options":{"raw":{"language":"json"}}},"url":"https://public-api.distil.ai/api/connection/{datasource_id}/data/delete","description":"<p>Deletes one or more records, by passing external IDs as an array within the message Body, from a specified datasource within a Distil API Integration.</p>\n<p>The body of the request is in JSON format and should contain an array of external IDs of those records that are to be deleted.</p>\n<p>This request exists for instances where certain environments may not enable values to be entered into the body of a delete request.</p>\n<p>The response body for a successful request is likely to return a status of 'WAITING\", with an ingestion ID. This ingestion ID can then be used in the <a href=\"#f30ad0e2-2d6a-45de-bd51-fdacba78d3b6\">Check Ingestion Status</a> request to verify the progress of the update.</p>\n","urlObject":{"protocol":"https","path":["api","connection","{datasource_id}","data","delete"],"host":["public-api","distil","ai"],"query":[],"variable":[]}},"response":[{"id":"51122d8e-8d85-47e0-9729-b46523957fae","name":"Delete Records by ID","originalRequest":{"method":"POST","header":[{"key":"Authorization","type":"text","value":"{api_key}"}],"body":{"mode":"raw","raw":"[\n    \"0\",\n    \"1\"\n]","options":{"raw":{"language":"json"}}},"url":"https://public-api.distil.ai/api/connection/{datasource_id}/data/delete"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Cache-Control","value":"no-cache, no-store, max-age=0, must-revalidate"},{"key":"Pragma","value":"no-cache"},{"key":"Content-Length","value":"86"},{"key":"Content-Type","value":"application/json;charset=UTF-8"},{"key":"Expires","value":"0"},{"key":"X-Content-Type-Options","value":"nosniff"},{"key":"X-Frame-Options","value":"DENY"},{"key":"X-XSS-Protection","value":"1 ; mode=block"},{"key":"Referrer-Policy","value":"no-referrer"},{"key":"Date","value":"Wed, 04 Nov 2020 11:39:57 GMT"}],"cookie":[],"responseTime":null,"body":"{\n    \"id\": \"656071d0-1e92-11eb-a74b-93b30e41195b\",\n    \"status\": \"WAITING\",\n    \"ingestionResults\": []\n}"}],"_postman_id":"cb133db2-3bc0-44b2-b7fd-91b3ac5ba34a"},{"name":"Delete Datasource","event":[{"listen":"test","script":{"id":"16fef23c-58a2-45f1-81e0-bb5969bd7054","exec":[""],"type":"text/javascript"}}],"id":"058eb002-7f2f-4c3d-adf0-e354bb9a9cc5","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"auth":{"type":"noauth","isInherited":false},"method":"DELETE","header":[{"key":"Authorization","value":"{api_key}","type":"text"}],"body":{"mode":"raw","raw":"","options":{"raw":{"language":"json"}}},"url":"https://public-api.distil.ai/api/connection/{datasource_id}","description":"<p>Deletes a specified datasource within a Distil API Integration</p>\n","urlObject":{"protocol":"https","path":["api","connection","{datasource_id}"],"host":["public-api","distil","ai"],"query":[],"variable":[]}},"response":[],"_postman_id":"058eb002-7f2f-4c3d-adf0-e354bb9a9cc5"},{"name":"https://api.bitbucket.org/2.0/repositories/bigplatform?page=3","id":"ec1e1549-8b76-4e58-a61d-608e04e5a070","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"auth":{"type":"basic","basic":{"basicConfig":[{"key":"username","value":"<username>"},{"key":"password","value":"<password>"}]},"isInherited":false},"method":"GET","header":[],"url":"https://api.bitbucket.org/2.0/repositories/bigplatform?page=3","description":"<p>Generated from cURL: curl -u <a href=\"mailto:neil@distil.ai\">neil@distil.ai</a>:ATATT3xFfGF0jBr5m-5bf39Ed6o7HJpCKhvhPuHaJgvLu48WagsUBSBvMo427frG-ddqYBBV-2h8lpjBxOTw5s7GcpAdCKfi4hw0jr8eoxykKHTW0o_bwLWwXW7V32PFSALlWFAOPBi-HZ22qT76MSIPWymxEcn7lxVVUf4oLHNjozSwKqrr6zQ=4A215EC5 <br /><a href=\"https://api.bitbucket.org/2.0/repositories/bigplatform?page=3\">https://api.bitbucket.org/2.0/repositories/bigplatform?page=3</a></p>\n","urlObject":{"protocol":"https","path":["2.0","repositories","bigplatform"],"host":["api","bitbucket","org"],"query":[{"key":"page","value":"3"}],"variable":[]}},"response":[],"_postman_id":"ec1e1549-8b76-4e58-a61d-608e04e5a070"}],"auth":{"type":"apikey","apikey":{"basicConfig":[{"key":"key","value":"Authorization"},{"key":"value","value":"<value>"}]}},"event":[{"listen":"prerequest","script":{"id":"dd2e1869-91c6-4333-ad74-f2947e603502","type":"text/javascript","requests":{},"exec":[""]}},{"listen":"test","script":{"id":"94351f71-c203-41fe-9195-4ddacad8099e","type":"text/javascript","requests":{},"exec":[""]}}],"variable":[{"key":"api_key","value":"{api_key}"},{"key":"datasource_id","value":"{datasource_id}"},{"key":"attribute_id","value":"{attribute_id}"},{"key":"external_id","value":"{external_id}"},{"key":"ingestion_id","value":"{ingestion_id}"}]}