{"info":{"_postman_id":"3ccaba26-c0a8-4109-93c1-381eefd9b14a","name":"Flexter Online","description":"<html><head></head><body><p>This document contains basic information about the available REST API endpoints for working with Flexter Online.</p>\n<h1 id=\"terminology\">Terminology</h1>\n<hr>\n<h2 id=\"source\">Source</h2>\n<p>It's a resource with connection details for the data source. This is a location where you store your XML / JSON data.</p>\n<p><em>Supported sources are:</em> </p>\n<ul>\n<li><a href=\"#ba00f6a1-6834-430b-b9b3-b88f8d6a4b11\">Uploaded file</a></li>\n<li><a href=\"#51ca65c3-4681-4ae2-9a18-b4e074e08bce\">AWS S3</a></li>\n</ul>\n<p>Once a source has been created, you can refer to it by its name when sending requests to other API endpoints.</p>\n<blockquote>\n<p>For example, if you create an S3 Source with name <code>source1</code>, you can refer to it by its name <code>source1</code> for creating a logical schema, or for data processing</p>\n</blockquote>\n<hr>\n<h2 id=\"sink\">Sink</h2>\n<p>It's a resource with connection details for a target data store. This is the location where the processed data will be saved. </p>\n<p><em>Supported sinks are:</em></p>\n<ul>\n<li><a href=\"#289f3410-8ebf-43cd-b7cd-a0a849814544\">MySQL</a></li>\n<li><a href=\"#3c04b627-3b96-4e76-b40a-c126cd2e4607\">PostgreSQL</a></li>\n<li><a href=\"#89e2fe3c-8a44-454b-837e-dedc4f3aa84c\">AWS S3</a></li>\n<li><a href=\"#98308559-057b-4b44-91c1-ab40bf0e37fb\">Snowflake</a></li>\n<li><a href=\"#43a0f413-208f-46ed-95b8-02b0dbc83fdb\">Redshift</a></li>\n</ul>\n<p>You need to create sink if you want to save the output of data processing in your own storage. </p>\n<blockquote>\n<p>For example if you want to save the output to S3 bucket, you need to create S3 Sink once, and then reuse it as many time as you want, data will be copied using paths and credentials of this Sink entry.</p>\n</blockquote>\n<p>You can refer to the sink by its name just as you do for Sources.</p>\n<hr>\n<h2 id=\"schema\">Schema</h2>\n<p>This is your target data model and the mappings from XML/JSON source elements to target table columns.</p>\n<p>Before you start processing the data, you need to create a target data model and mapping from source data to the target data model.\nWe generate this automatically, all you need to do is to <a href=\"#2d9568cb-32ec-4511-aa28-c0d2bfd4461f\">send a request with your created Source for analysis</a>.</p>\n<p>Once you have created the schema, you can begin data processing</p>\n<hr>\n<h2 id=\"data-processing\">Data Processing</h2>\n<p>It's a task of processing of XML / JSON files from a given Source, using a Schema, and saving the result of processing into a Sink</p>\n</body></html>","schema":"https://schema.getpostman.com/json/collection/v2.0.0/collection.json","toc":[{"content":"Terminology","slug":"terminology"}],"owner":"6807520","collectionId":"3ccaba26-c0a8-4109-93c1-381eefd9b14a","publishedId":"S11KQeSX","public":true,"customColor":{"top-bar":"FFFFFF","right-sidebar":"303030","highlight":"EF5B25"},"publishDate":"2019-03-01T05:27:11.000Z"},"item":[{"name":"Authentication","item":[{"name":"Getting access token","id":"f43dfec8-5d5d-48a6-a74a-89f3775f9436","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[{"key":"Content-Type","name":"Content-Type","value":"application/x-www-form-urlencoded","type":"text"}],"body":{"mode":"urlencoded","urlencoded":[{"key":"username","value":"XXXXXXXXX","description":"<p>Username provided by Sonra</p>\n","type":"text"},{"key":"password","value":"XXXXXXXXX","description":"<p>Password provided by Sonra</p>\n","type":"text"},{"key":"grant_type","value":"password","description":"<p>Authentication type - should equal \"password\"</p>\n","type":"text"}]},"url":"https://api.sonra.io/oauth/token","auth":{"type":"basic","basic":{"basicConfig":[{"key":"username","value":"<username>"},{"key":"password","value":"<password>"}]},"isInherited":true,"source":{"_postman_id":"05c02d78-7e46-4a32-9efa-2d620966d442","id":"05c02d78-7e46-4a32-9efa-2d620966d442","name":"Authentication","type":"folder"}},"urlObject":{"protocol":"https","path":["oauth","token"],"host":["api","sonra","io"],"query":[],"variable":[]}},"response":[{"id":"14114339-5b98-4f28-b1e8-2f8e710316e8","name":"Authenticated","originalRequest":{"method":"POST","header":[{"key":"Content-Type","name":"Content-Type","value":"application/x-www-form-urlencoded","type":"text"},{"key":"Authorization","value":"Basic NmdORDZ0MnRwMldmazVzSk5BWWZxdVdRZXRhdWtoYWI6ZzlROFdRYm5Ic3BWUVdCYzVtZ1ZHQ0JYWjhRS1c1dUg=","type":"text"}],"body":{"mode":"urlencoded","urlencoded":[{"key":"username","value":"XXXXXXXXX","type":"text"},{"key":"password","value":"XXXXXXXXX","type":"text"},{"key":"grant_type","value":"password","type":"text"}]},"url":"https://api.sonra.io/oauth/token"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Server","value":"nginx/1.12.2"},{"key":"Date","value":"Fri, 01 Mar 2019 05:17:51 GMT"},{"key":"Content-Type","value":"application/json;charset=UTF-8"},{"key":"Transfer-Encoding","value":"chunked"},{"key":"Connection","value":"keep-alive"},{"key":"Cache-Control","value":"no-store"},{"key":"Pragma","value":"no-cache"},{"key":"X-Content-Type-Options","value":"nosniff"},{"key":"X-XSS-Protection","value":"1; mode=block"},{"key":"X-Frame-Options","value":"DENY"},{"key":"Set-Cookie","value":"uid=CgEBR1x4wH+N8kCjAwMGAg==; expires=Sat, 29-Feb-20 05:17:51 GMT; domain=.sonra.io; path=/"}],"cookie":[],"responseTime":null,"body":"{\n    \"access_token\": \"eyJhbG........\",\n    \"token_type\": \"bearer\",\n    \"refresh_token\": \"..........\",\n    \"expires_in\": 43199,\n    \"scope\": \"read write\",\n    \"jti\": \"9f75f5ad-ba38-4baf-843a-849918427954\"\n}"},{"id":"8c9bd68d-13a5-4278-a57a-3ef3bb4a1353","name":"Bad credentials","originalRequest":{"method":"POST","header":[{"key":"Content-Type","name":"Content-Type","value":"application/x-www-form-urlencoded","type":"text"},{"key":"Authorization","value":"Basic NmdORDZ0MnRwMldmazVzSk5BWWZxdVdRZXRhdWtoYWI6ZzlROFdRYm5Ic3BWUVdCYzVtZ1ZHQ0JYWjhRS1c1dUg=","type":"text"}],"body":{"mode":"urlencoded","urlencoded":[{"key":"username","value":"XXXXXXXXX","type":"text"},{"key":"password","value":"XXXXXXXXX","type":"text"},{"key":"grant_type","value":"password","type":"text"}]},"url":"https://api.sonra.io/oauth/token"},"status":"Bad Request","code":400,"_postman_previewlanguage":"json","header":[{"key":"Server","value":"nginx/1.12.2"},{"key":"Date","value":"Fri, 01 Mar 2019 05:25:37 GMT"},{"key":"Content-Type","value":"application/json;charset=UTF-8"},{"key":"Transfer-Encoding","value":"chunked"},{"key":"Connection","value":"keep-alive"},{"key":"Cache-Control","value":"no-store"},{"key":"Pragma","value":"no-cache"},{"key":"X-Content-Type-Options","value":"nosniff"},{"key":"X-XSS-Protection","value":"1; mode=block"},{"key":"X-Frame-Options","value":"DENY"}],"cookie":[],"responseTime":null,"body":"{\n    \"error\": \"invalid_grant\",\n    \"error_description\": \"Bad credentials\"\n}"}],"_postman_id":"f43dfec8-5d5d-48a6-a74a-89f3775f9436"}],"id":"05c02d78-7e46-4a32-9efa-2d620966d442","description":"<p>Important to note, that for every call you make to RestAPI, you need to provide <strong>access_token</strong>.</p>\n<p><em>This is a beta version. It may change in the future.</em></p>\n<p>To get access_token you need to make a call to /oauth/token with Authorization header and 3 form parameters:</p>\n<ul>\n<li>username=YOUR_EMAIL</li>\n<li>password=YOUR_PASSWORD</li>\n<li>grant_type=password</li>\n</ul>\n","auth":{"type":"basic","basic":{"basicConfig":[{"key":"username","value":"<username>"},{"key":"password","value":"<password>"}]},"isInherited":false},"event":[{"listen":"prerequest","script":{"id":"d6eb547b-1a0b-4a22-bdce-136130812e3f","type":"text/javascript","exec":[""]}},{"listen":"test","script":{"id":"5ca467dd-54a4-495e-8e2c-a8563af8af12","type":"text/javascript","exec":[""]}}],"_postman_id":"05c02d78-7e46-4a32-9efa-2d620966d442"},{"name":"Source management","item":[{"name":"Creating File Source","id":"ba00f6a1-6834-430b-b9b3-b88f8d6a4b11","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[],"body":{"mode":"formdata","formdata":[{"key":"type","value":"xml | xsd | json","description":"<p>Type of Source, can be \"xml\" , \"xsd\", \"json\"</p>\n","type":"text"},{"key":"name","value":"my_first_file","description":"<p>Name of your source. You will use this name to put a reference to the Source</p>\n","type":"text"},{"key":"file","description":"<p>File to upload</p>\n","type":"file","value":null}]},"url":"https://api.sonra.io/source/create/file","description":"<p>Use this endpoint to create a Source by uploading an XML/XSD/JSON file.</p>\n<p>Uploaded files are stored in our cloud, and you can use them for further processing.\nYou can also upload a ZIP archive with multiple XML/XSD/JSON files in it.</p>\n<p><strong>Note that if you upload an archive with mixed types (XML/JSON/XSD in one archive), you can only select one \"type\" for this Source.</strong></p>\n<blockquote>\n<p>For example, if you select XML type, only XML files will be read and parsed from the archive.</p>\n</blockquote>\n","auth":{"type":"bearer","bearer":{"basicConfig":[{"key":"token","value":"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJhdWQiOlsiYmFzaWNfcmVzb3VyY2UiXSwidXNlcl9uYW1lIjoiWFhYWFhYWFhYIiwic2NvcGUiOlsicmVhZCIsIndyaXRlIl0sImV4cCI6MTU1MzI5ODgxMywiYXV0aG9yaXRpZXMiOlsiUk9MRV9VU0VSIl0sImp0aSI6Ijk0MzY4Y2I5LWJhNmYtNGQ5ZS1iMDMzLTNiYWZkN2QwYzQ3NSIsImNsaWVudF9pZCI6IjZnTkQ2dDJ0cDJXZms1c0pOQVlmcXVXUWV0YXVraGFiIn0.J7B4XtX9scXuITJfeg87av2lh3ZunYO1hkBjMs5_ku8"}]},"isInherited":true,"source":{"_postman_id":"48a2032f-6b2d-4f3c-b3a7-c9aa9fb4e31f","id":"48a2032f-6b2d-4f3c-b3a7-c9aa9fb4e31f","name":"Source management","type":"folder"}},"urlObject":{"protocol":"https","path":["source","create","file"],"host":["api","sonra","io"],"query":[],"variable":[]}},"response":[{"id":"1861efd2-ae7d-4a55-9624-67774a3c49bc","name":"Creating File Source","originalRequest":{"method":"POST","header":[{"key":"Authorization","value":"Bearer <access_token>","description":"Put access token here, which you get after successfull authentication","type":"text"}],"body":{"mode":"formdata","formdata":[{"key":"type","value":"xml","description":"Type of Source, can be \"xml\" , \"xsd\", \"json\"","type":"text"},{"key":"name","value":"my_first_file","description":"Name of your source. You will use this name to put a reference to the Source","type":"text"},{"key":"file","description":"File to upload.","type":"file"}]},"url":"https://api.sonra.io/source/create/file"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Server","value":"nginx/1.12.2"},{"key":"Date","value":"Fri, 01 Mar 2019 06:41:14 GMT"},{"key":"Content-Type","value":"application/json;charset=UTF-8"},{"key":"Transfer-Encoding","value":"chunked"},{"key":"Connection","value":"keep-alive"},{"key":"X-Content-Type-Options","value":"nosniff"},{"key":"X-XSS-Protection","value":"1; mode=block"},{"key":"Cache-Control","value":"no-cache, no-store, max-age=0, must-revalidate"},{"key":"Pragma","value":"no-cache"},{"key":"Expires","value":"0"},{"key":"X-Frame-Options","value":"DENY"}],"cookie":[],"responseTime":null,"body":"{\n    \"status\": \"ok\",\n    \"file\": \"my_first_file\",\n    \"type\": \"xml\"\n}"}],"_postman_id":"ba00f6a1-6834-430b-b9b3-b88f8d6a4b11"},{"name":"Creating S3 Source","id":"51ca65c3-4681-4ae2-9a18-b4e074e08bce","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[{"key":"Authorization","value":"Bearer <access_token>","description":"<p>Put access token here, which you get after successfull authentication</p>\n","type":"text"},{"key":"Content-Type","name":"Content-Type","value":"application/json","type":"text"}],"body":{"mode":"raw","raw":"{\n    \"name\": \"s3source\",\n    \"path\": \"s3://iebucketencpt/donut.zip\",\n    \"roleArn\": \"arn:aws:iam::111111111111:role/AssumeS3External1\",\n    \"type\": \"xml\"\n}"},"url":"https://api.sonra.io/source/create/s3","description":"<p>Use this endpoint to create an S3 Source.\nAn S3 Source is a good option if you have an S3 bucket with data to process.</p>\n<p>It requires 3 mandatory parameters name, type, path, and 1 optional parameter roleArn:</p>\n<ul>\n<li>The parameter <strong>name</strong> is a unique name of Source, which you will use in other calls as a reference to it.</li>\n<li>Parameter <strong>type</strong> represents a type of Source, it can be XML/XSD/JSON</li>\n<li>Parameter <strong>path</strong> is a full path to S3 Object, it can be bucket/folder/file</li>\n<li>(Optional) Parameter <strong>roleArn</strong> is a name of AWS Role with at least Read access to a provided path in your AWS Account, <a href=\"#1d5fd942-96eb-4541-a91f-e9331c918f94\">that you should create for Flexter AWS Account</a>.</li>\n</ul>\n","auth":{"type":"bearer","bearer":{"basicConfig":[{"key":"token","value":"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJhdWQiOlsiYmFzaWNfcmVzb3VyY2UiXSwidXNlcl9uYW1lIjoiWFhYWFhYWFhYIiwic2NvcGUiOlsicmVhZCIsIndyaXRlIl0sImV4cCI6MTU1MzI5ODgxMywiYXV0aG9yaXRpZXMiOlsiUk9MRV9VU0VSIl0sImp0aSI6Ijk0MzY4Y2I5LWJhNmYtNGQ5ZS1iMDMzLTNiYWZkN2QwYzQ3NSIsImNsaWVudF9pZCI6IjZnTkQ2dDJ0cDJXZms1c0pOQVlmcXVXUWV0YXVraGFiIn0.J7B4XtX9scXuITJfeg87av2lh3ZunYO1hkBjMs5_ku8"}]},"isInherited":true,"source":{"_postman_id":"48a2032f-6b2d-4f3c-b3a7-c9aa9fb4e31f","id":"48a2032f-6b2d-4f3c-b3a7-c9aa9fb4e31f","name":"Source management","type":"folder"}},"urlObject":{"protocol":"https","path":["source","create","s3"],"host":["api","sonra","io"],"query":[],"variable":[]}},"response":[{"id":"6886ebb4-5491-4aef-8b5e-a289d4ddbd69","name":"Invalid path","originalRequest":{"method":"POST","header":[{"key":"Authorization","value":"Bearer <access_token>","description":"Put access token here, which you get after successfull authentication","type":"text"},{"key":"Content-Type","name":"Content-Type","value":"application/json","type":"text"}],"body":{"mode":"raw","raw":"{\n    \"name\": \"bad_source\",\n    \"path\": \"s3://iebucketencpt/invalid_key/\",\n    \"roleArn\": \"arn:aws:iam::111111111111:policy/SomeS3PolicyWithAssumeRole\",\n    \"type\": \"xml\"\n}"},"url":"https://api.sonra.io/source/create/s3"},"status":"Conflict","code":409,"_postman_previewlanguage":"json","header":[{"key":"Server","value":"nginx/1.12.2"},{"key":"Date","value":"Fri, 01 Mar 2019 07:44:24 GMT"},{"key":"Content-Type","value":"application/json;charset=UTF-8"},{"key":"Transfer-Encoding","value":"chunked"},{"key":"Connection","value":"keep-alive"},{"key":"X-Content-Type-Options","value":"nosniff"},{"key":"X-XSS-Protection","value":"1; mode=block"},{"key":"Cache-Control","value":"no-cache, no-store, max-age=0, must-revalidate"},{"key":"Pragma","value":"no-cache"},{"key":"Expires","value":"0"},{"key":"X-Frame-Options","value":"DENY"}],"cookie":[],"responseTime":null,"body":"{\n    \"status\": \"Error\",\n    \"error_message\": \"Can't get access to the role\"\n}"},{"id":"c16fd3b2-464a-4c92-a385-f21839bb458b","name":"Creating S3 Source","originalRequest":{"method":"POST","header":[{"key":"Authorization","value":"Bearer <access_token>","description":"Put access token here, which you get after successfull authentication","type":"text"},{"key":"Content-Type","name":"Content-Type","value":"application/json","type":"text"}],"body":{"mode":"raw","raw":"{\n    \"name\": \"my_first_s3_source\",\n    \"path\": \"s3://iebucketencpt/donut.zip\",\n    \"roleArn\": \"arn:aws:iam::111111111111:role/SomeS3RoleForAssumeRole\",\n    \"type\": \"xml\"\n}"},"url":"https://api.sonra.io/source/create/s3"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Server","value":"nginx/1.12.2"},{"key":"Date","value":"Fri, 01 Mar 2019 07:39:12 GMT"},{"key":"Content-Type","value":"application/json;charset=UTF-8"},{"key":"Transfer-Encoding","value":"chunked"},{"key":"Connection","value":"keep-alive"},{"key":"X-Content-Type-Options","value":"nosniff"},{"key":"X-XSS-Protection","value":"1; mode=block"},{"key":"Cache-Control","value":"no-cache, no-store, max-age=0, must-revalidate"},{"key":"Pragma","value":"no-cache"},{"key":"Expires","value":"0"},{"key":"X-Frame-Options","value":"DENY"}],"cookie":[],"responseTime":null,"body":"{\n    \"status\": \"ok\",\n    \"file\": \"my_first_s3_source\",\n    \"type\": \"xml\"\n}"},{"id":"e8405036-a797-44a6-9a11-871f6d9fac35","name":"Invalid Role Example","originalRequest":{"method":"POST","header":[{"key":"Authorization","value":"Bearer <access_token>","description":"Put access token here, which you get after successfull authentication","type":"text"},{"key":"Content-Type","name":"Content-Type","value":"application/json","type":"text"}],"body":{"mode":"raw","raw":"{\n    \"name\": \"bad_source\",\n    \"path\": \"s3://iebucketencpt/donut.zip\",\n    \"roleArn\": \"arn:aws:iam::111111111111:role/AssumeS3External\",\n    \"type\": \"xml\"\n}"},"url":"https://api.sonra.io/source/create/s3"},"status":"Conflict","code":409,"_postman_previewlanguage":"json","header":[{"key":"Server","value":"nginx/1.12.2"},{"key":"Date","value":"Fri, 01 Mar 2019 07:42:41 GMT"},{"key":"Content-Type","value":"application/json;charset=UTF-8"},{"key":"Transfer-Encoding","value":"chunked"},{"key":"Connection","value":"keep-alive"},{"key":"X-Content-Type-Options","value":"nosniff"},{"key":"X-XSS-Protection","value":"1; mode=block"},{"key":"Cache-Control","value":"no-cache, no-store, max-age=0, must-revalidate"},{"key":"Pragma","value":"no-cache"},{"key":"Expires","value":"0"},{"key":"X-Frame-Options","value":"DENY"}],"cookie":[],"responseTime":null,"body":"{\n    \"status\": \"Error\",\n    \"error_message\": \"Can't get access to the role\"\n}"}],"_postman_id":"51ca65c3-4681-4ae2-9a18-b4e074e08bce"},{"name":"Getting Source","id":"53ce46d9-7c8a-455d-9360-02ed3aa7ee63","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[{"key":"Authorization","value":"Bearer <access_token>","description":"<p>Put access token here, which you get after successfull authentication</p>\n","type":"text"}],"url":"https://api.sonra.io/source/get/<source_name>","description":"<p>Use this endpoint to get a single Source entry information.</p>\n<p>It requires only 1 parameter name and returns information about Source with the provided name.</p>\n<p>If Source is not found, you will get an error response.</p>\n","auth":{"type":"bearer","bearer":{"basicConfig":[{"key":"token","value":"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJhdWQiOlsiYmFzaWNfcmVzb3VyY2UiXSwidXNlcl9uYW1lIjoiWFhYWFhYWFhYIiwic2NvcGUiOlsicmVhZCIsIndyaXRlIl0sImV4cCI6MTU1MzI5ODgxMywiYXV0aG9yaXRpZXMiOlsiUk9MRV9VU0VSIl0sImp0aSI6Ijk0MzY4Y2I5LWJhNmYtNGQ5ZS1iMDMzLTNiYWZkN2QwYzQ3NSIsImNsaWVudF9pZCI6IjZnTkQ2dDJ0cDJXZms1c0pOQVlmcXVXUWV0YXVraGFiIn0.J7B4XtX9scXuITJfeg87av2lh3ZunYO1hkBjMs5_ku8"}]},"isInherited":true,"source":{"_postman_id":"48a2032f-6b2d-4f3c-b3a7-c9aa9fb4e31f","id":"48a2032f-6b2d-4f3c-b3a7-c9aa9fb4e31f","name":"Source management","type":"folder"}},"urlObject":{"protocol":"https","path":["source","get","<source_name>"],"host":["api","sonra","io"],"query":[],"variable":[]}},"response":[{"id":"9f65bf8d-21a0-4540-8165-d9ed9073ce8d","name":"Getting Source","originalRequest":{"method":"GET","header":[{"key":"Authorization","value":"Bearer <access_token>","description":"Put access token here, which you get after successfull authorization","type":"text"}],"url":"https://api.sonra.io/source/get/myxmlfile"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Server","value":"nginx/1.12.2"},{"key":"Date","value":"Fri, 01 Mar 2019 06:11:08 GMT"},{"key":"Content-Type","value":"application/json;charset=UTF-8"},{"key":"Transfer-Encoding","value":"chunked"},{"key":"Connection","value":"keep-alive"},{"key":"X-Content-Type-Options","value":"nosniff"},{"key":"X-XSS-Protection","value":"1; mode=block"},{"key":"Cache-Control","value":"no-cache, no-store, max-age=0, must-revalidate"},{"key":"Pragma","value":"no-cache"},{"key":"Expires","value":"0"},{"key":"X-Frame-Options","value":"DENY"}],"cookie":[],"responseTime":null,"body":"{\n    \"status\": \"ok\",\n    \"format\": \"application/zip\",\n    \"storage_type\": \"Uploaded file\",\n    \"create_date\": \"2019-02-27T16:11:09.384+0000\",\n    \"name\": \"myxmlfile\",\n    \"type\": \"xml\",\n    \"size\": 6738989,\n    \"path\": \"1551283868715-daily.export_urls_rich.zip\"\n}"}],"_postman_id":"53ce46d9-7c8a-455d-9360-02ed3aa7ee63"},{"name":"Source listing","id":"c08f9f1a-efdc-41e1-be42-4aabe168a56b","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[{"key":"Authorization","value":"Bearer <access_token>","description":"<p>Put access token here, which you get after successfull authentication</p>\n","type":"text"}],"url":"https://api.sonra.io/source/list","description":"<p>Use this endpoint to get list of created Sources</p>\n","auth":{"type":"bearer","bearer":{"basicConfig":[{"key":"token","value":"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJhdWQiOlsiYmFzaWNfcmVzb3VyY2UiXSwidXNlcl9uYW1lIjoiWFhYWFhYWFhYIiwic2NvcGUiOlsicmVhZCIsIndyaXRlIl0sImV4cCI6MTU1MzI5ODgxMywiYXV0aG9yaXRpZXMiOlsiUk9MRV9VU0VSIl0sImp0aSI6Ijk0MzY4Y2I5LWJhNmYtNGQ5ZS1iMDMzLTNiYWZkN2QwYzQ3NSIsImNsaWVudF9pZCI6IjZnTkQ2dDJ0cDJXZms1c0pOQVlmcXVXUWV0YXVraGFiIn0.J7B4XtX9scXuITJfeg87av2lh3ZunYO1hkBjMs5_ku8"}]},"isInherited":true,"source":{"_postman_id":"48a2032f-6b2d-4f3c-b3a7-c9aa9fb4e31f","id":"48a2032f-6b2d-4f3c-b3a7-c9aa9fb4e31f","name":"Source management","type":"folder"}},"urlObject":{"protocol":"https","path":["source","list"],"host":["api","sonra","io"],"query":[],"variable":[]}},"response":[{"id":"b24a7c72-8f00-4297-94d7-0c790707f80d","name":"Source listing","originalRequest":{"method":"GET","header":[{"key":"Authorization","value":"Bearer <access_token>","description":"Put access token here, which you get after successfull authorization","type":"text"}],"url":"https://api.sonra.io/source/list"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Server","value":"nginx/1.12.2"},{"key":"Date","value":"Fri, 01 Mar 2019 06:10:19 GMT"},{"key":"Content-Type","value":"application/json;charset=UTF-8"},{"key":"Transfer-Encoding","value":"chunked"},{"key":"Connection","value":"keep-alive"},{"key":"X-Content-Type-Options","value":"nosniff"},{"key":"X-XSS-Protection","value":"1; mode=block"},{"key":"Cache-Control","value":"no-cache, no-store, max-age=0, must-revalidate"},{"key":"Pragma","value":"no-cache"},{"key":"Expires","value":"0"},{"key":"X-Frame-Options","value":"DENY"}],"cookie":[],"responseTime":null,"body":"{\n    \"status\": \"ok\",\n    \"sources\": [\n        {\n            \"format\": \"application/zip\",\n            \"storage_type\": \"Uploaded file\",\n            \"create_date\": \"2019-02-27T16:11:09.384+0000\",\n            \"name\": \"myxmlfile\",\n            \"type\": \"xml\",\n            \"size\": 6738989,\n            \"path\": \"1551283868715-daily.export_urls_rich.zip\"\n        },\n        {\n            \"format\": \"application/zip\",\n            \"storage_type\": \"Uploaded file\",\n            \"create_date\": \"2019-02-27T16:13:20.171+0000\",\n            \"name\": \"myxmlfile2\",\n            \"type\": \"xml\",\n            \"size\": 6738989,\n            \"path\": \"1551283999574-daily.export_urls_rich.zip\"\n        }\n    ]\n}"}],"_postman_id":"c08f9f1a-efdc-41e1-be42-4aabe168a56b"},{"name":"Deleting Source","id":"3753c48d-3cd1-44bf-9885-bceed1846cb7","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[{"description":"<p>Put access token here, which you get after successfull authentication</p>\n","key":"Authorization","type":"text","value":"Bearer <access_token>"}],"url":"https://api.sonra.io/source/delete/<source_name>","description":"<p>Use this endpoint to delete a single Source entry.</p>\n","auth":{"type":"bearer","bearer":{"basicConfig":[{"key":"token","value":"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJhdWQiOlsiYmFzaWNfcmVzb3VyY2UiXSwidXNlcl9uYW1lIjoiWFhYWFhYWFhYIiwic2NvcGUiOlsicmVhZCIsIndyaXRlIl0sImV4cCI6MTU1MzI5ODgxMywiYXV0aG9yaXRpZXMiOlsiUk9MRV9VU0VSIl0sImp0aSI6Ijk0MzY4Y2I5LWJhNmYtNGQ5ZS1iMDMzLTNiYWZkN2QwYzQ3NSIsImNsaWVudF9pZCI6IjZnTkQ2dDJ0cDJXZms1c0pOQVlmcXVXUWV0YXVraGFiIn0.J7B4XtX9scXuITJfeg87av2lh3ZunYO1hkBjMs5_ku8"}]},"isInherited":true,"source":{"_postman_id":"48a2032f-6b2d-4f3c-b3a7-c9aa9fb4e31f","id":"48a2032f-6b2d-4f3c-b3a7-c9aa9fb4e31f","name":"Source management","type":"folder"}},"urlObject":{"protocol":"https","path":["source","delete","<source_name>"],"host":["api","sonra","io"],"query":[],"variable":[]}},"response":[{"id":"df336ed5-2695-46b9-be58-2bae2e7c7f8c","name":"Deleting Source","originalRequest":{"method":"GET","header":[{"description":"Put access token here, which you get after successfull authentication","key":"Authorization","type":"text","value":"Bearer <access_token>"}],"url":"https://api.sonra.io/source/delete/testsource"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Server","value":"nginx/1.15.10"},{"key":"Date","value":"Tue, 09 Apr 2019 09:28:30 GMT"},{"key":"Content-Type","value":"application/json;charset=UTF-8"},{"key":"Transfer-Encoding","value":"chunked"},{"key":"Connection","value":"keep-alive"},{"key":"X-Content-Type-Options","value":"nosniff"},{"key":"X-XSS-Protection","value":"1; mode=block"},{"key":"Cache-Control","value":"no-cache, no-store, max-age=0, must-revalidate"},{"key":"Pragma","value":"no-cache"},{"key":"Expires","value":"0"},{"key":"X-Frame-Options","value":"DENY"}],"cookie":[],"responseTime":null,"body":"{\n    \"storage_type\": \"S3\",\n    \"create_date\": \"2019-03-18T12:45:00.315+0000\",\n    \"name\": \"testsource\",\n    \"type\": \"xml\",\n    \"path\": \"s3://testsource\"\n}"}],"_postman_id":"3753c48d-3cd1-44bf-9885-bceed1846cb7"}],"id":"48a2032f-6b2d-4f3c-b3a7-c9aa9fb4e31f","description":"<p>Source is a resource containing connection details for the data source.\nIt can be of three different types:</p>\n<ul>\n<li>XML</li>\n<li>XSD</li>\n<li>JSON</li>\n</ul>\n<p>The type of source determines by which algorithm it will be processed during Schema generation or data processing.</p>\n<p>Endpoints for Source management</p>\n","auth":{"type":"bearer","bearer":{"basicConfig":[{"key":"token","value":"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJhdWQiOlsiYmFzaWNfcmVzb3VyY2UiXSwidXNlcl9uYW1lIjoiWFhYWFhYWFhYIiwic2NvcGUiOlsicmVhZCIsIndyaXRlIl0sImV4cCI6MTU1MzI5ODgxMywiYXV0aG9yaXRpZXMiOlsiUk9MRV9VU0VSIl0sImp0aSI6Ijk0MzY4Y2I5LWJhNmYtNGQ5ZS1iMDMzLTNiYWZkN2QwYzQ3NSIsImNsaWVudF9pZCI6IjZnTkQ2dDJ0cDJXZms1c0pOQVlmcXVXUWV0YXVraGFiIn0.J7B4XtX9scXuITJfeg87av2lh3ZunYO1hkBjMs5_ku8"}]},"isInherited":false},"event":[{"listen":"prerequest","script":{"id":"ac92eb9b-04af-48b3-b51c-1f5755499060","type":"text/javascript","exec":[""]}},{"listen":"test","script":{"id":"69dfb9df-ce9c-4058-a876-f9e7472a40ec","type":"text/javascript","exec":[""]}}],"_postman_id":"48a2032f-6b2d-4f3c-b3a7-c9aa9fb4e31f"},{"name":"Sink management","item":[{"name":"Creating Mysql Sink","id":"289f3410-8ebf-43cd-b7cd-a0a849814544","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[{"description":"<p>Put access token here, which you get after successfull authentication</p>\n","key":"Authorization","type":"text","value":"Bearer <access_token>"},{"key":"Content-Type","type":"text","value":"application/json"}],"body":{"mode":"raw","raw":"{\n    \"name\": \"mysql_sink\",\n    \"path\": \"jdbc:mysql://hostname:port/database_name\",\n    \"username\": \"my_user\",\n    \"password\": \"my_password\"\n}"},"url":"https://api.sonra.io/sink/create/mysql","description":"<p>Use this endpoint to create a Mysql Sink, if you want to save the data processing output to Mysql database.</p>\n<p>To create a Mysql sink provide the following mandatory parameters:</p>\n<ul>\n<li><strong>name</strong> - is a unique name of Sink, which you will use in other calls as a reference to it.</li>\n<li><strong>path</strong> - a path to Mysql database (jdbc), should be in format <em>jdbc:mysql://hostname:port/database_name</em> (for example jdbc:mysql://myflextest.cqkbp4ipuueb.eu-west-1.rds.amazonaws.com/myflextest)</li>\n<li><strong>username</strong> - username (user must have WRITE access for selected database)</li>\n<li><strong>password</strong> - user's password</li>\n</ul>\n","auth":{"type":"bearer","bearer":{"basicConfig":[{"key":"token","value":"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJhdWQiOlsiYmFzaWNfcmVzb3VyY2UiXSwidXNlcl9uYW1lIjoiWFhYWFhYWFhYIiwic2NvcGUiOlsicmVhZCIsIndyaXRlIl0sImV4cCI6MTU1MzI5ODgxMywiYXV0aG9yaXRpZXMiOlsiUk9MRV9VU0VSIl0sImp0aSI6Ijk0MzY4Y2I5LWJhNmYtNGQ5ZS1iMDMzLTNiYWZkN2QwYzQ3NSIsImNsaWVudF9pZCI6IjZnTkQ2dDJ0cDJXZms1c0pOQVlmcXVXUWV0YXVraGFiIn0.J7B4XtX9scXuITJfeg87av2lh3ZunYO1hkBjMs5_ku8"}]},"isInherited":true,"source":{"_postman_id":"8cb70162-bf30-4ab0-8f80-0c12c8c9dd2e","id":"8cb70162-bf30-4ab0-8f80-0c12c8c9dd2e","name":"Sink management","type":"folder"}},"urlObject":{"protocol":"https","path":["sink","create","mysql"],"host":["api","sonra","io"],"query":[],"variable":[]}},"response":[{"id":"b5238fa6-4158-4e0c-881f-433e1eeae15f","name":"Creating Mysql Sink","originalRequest":{"method":"POST","header":[{"description":"Put access token here, which you get after successfull authentication","key":"Authorization","type":"text","value":"Bearer <access_token>"},{"key":"Content-Type","type":"text","value":"application/json"}],"body":{"mode":"raw","raw":"{\n    \"name\": \"mysql_sink\",\n    \"path\": \"jdbc:mysql://myflextest.cqkbp4ipuueb.eu-west-1.rds.amazonaws.com/myflextest\",\n    \"username\": \"my_user\",\n    \"password\": \"my_password\"\n}"},"url":"https://api.sonra.io/sink/create/mysql"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Server","value":"nginx/1.15.10"},{"key":"Date","value":"Thu, 04 Apr 2019 11:32:47 GMT"},{"key":"Content-Type","value":"application/json;charset=UTF-8"},{"key":"Transfer-Encoding","value":"chunked"},{"key":"Connection","value":"keep-alive"},{"key":"X-Content-Type-Options","value":"nosniff"},{"key":"X-XSS-Protection","value":"1; mode=block"},{"key":"Cache-Control","value":"no-cache, no-store, max-age=0, must-revalidate"},{"key":"Pragma","value":"no-cache"},{"key":"Expires","value":"0"},{"key":"X-Frame-Options","value":"DENY"}],"cookie":[],"responseTime":null,"body":"{\n    \"status\": \"ok\",\n    \"file\": \"mysql_sink\",\n    \"type\": \"MYSQL\"\n}"}],"_postman_id":"289f3410-8ebf-43cd-b7cd-a0a849814544"},{"name":"Creating Postgresql Sink","id":"3c04b627-3b96-4e76-b40a-c126cd2e4607","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[{"description":"<p>Put access token here, which you get after successfull authentication</p>\n","key":"Authorization","type":"text","value":"Bearer <access_token>"},{"key":"Content-Type","type":"text","value":"application/json"}],"body":{"mode":"raw","raw":"{\n    \"name\": \"pgsql_sink\",\n    \"path\": \"jdbc:postgresql://hostname:port/database_name\",\n    \"username\": \"pg_user\",\n    \"password\": \"pg_password\"\n}"},"url":"https://api.sonra.io/sink/create/postgresql","description":"<p>Use this endpoint to create a Postgresql Sink, if you want to save the data processing output to Postgresql database.</p>\n<p>To create a Postgresql sink provide the following mandatory parameters:</p>\n<ul>\n<li><strong>name</strong> - is a unique name of Sink, which you will use in other calls as a reference to it.</li>\n<li><strong>path</strong> - a path to Postgresql database (jdbc), should be in format <em>jdbc:postgresql://hostname:port/database_name</em> (for example jdbc:postgresql://flextest.cqkbp4ipuue1.eu-west-1.rds.amazonaws.com/flextestdb)</li>\n<li><strong>username</strong> - username (user must have WRITE access for selected database)</li>\n<li><strong>password</strong> - user's password</li>\n</ul>\n","auth":{"type":"bearer","bearer":{"basicConfig":[{"key":"token","value":"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJhdWQiOlsiYmFzaWNfcmVzb3VyY2UiXSwidXNlcl9uYW1lIjoiWFhYWFhYWFhYIiwic2NvcGUiOlsicmVhZCIsIndyaXRlIl0sImV4cCI6MTU1MzI5ODgxMywiYXV0aG9yaXRpZXMiOlsiUk9MRV9VU0VSIl0sImp0aSI6Ijk0MzY4Y2I5LWJhNmYtNGQ5ZS1iMDMzLTNiYWZkN2QwYzQ3NSIsImNsaWVudF9pZCI6IjZnTkQ2dDJ0cDJXZms1c0pOQVlmcXVXUWV0YXVraGFiIn0.J7B4XtX9scXuITJfeg87av2lh3ZunYO1hkBjMs5_ku8"}]},"isInherited":true,"source":{"_postman_id":"8cb70162-bf30-4ab0-8f80-0c12c8c9dd2e","id":"8cb70162-bf30-4ab0-8f80-0c12c8c9dd2e","name":"Sink management","type":"folder"}},"urlObject":{"protocol":"https","path":["sink","create","postgresql"],"host":["api","sonra","io"],"query":[],"variable":[]}},"response":[{"id":"94321db5-3f75-4f36-a998-7f75ea952db9","name":"Creating Postgresql Sink","originalRequest":{"method":"POST","header":[{"description":"Put access token here, which you get after successfull authentication","key":"Authorization","type":"text","value":"Bearer <access_token>"},{"key":"Content-Type","type":"text","value":"application/json"}],"body":{"mode":"raw","raw":"{\n    \"name\": \"pgsql_sink\",\n    \"path\": \"jdbc:postgresql://flextest.cqkbp4ipuue1.eu-west-1.rds.amazonaws.com/flextestdb\",\n    \"username\": \"pg_user\",\n    \"password\": \"pg_password\"\n}"},"url":"https://api.sonra.io/sink/create/postgresql"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Server","value":"nginx/1.15.10"},{"key":"Date","value":"Thu, 04 Apr 2019 11:32:47 GMT"},{"key":"Content-Type","value":"application/json;charset=UTF-8"},{"key":"Transfer-Encoding","value":"chunked"},{"key":"Connection","value":"keep-alive"},{"key":"X-Content-Type-Options","value":"nosniff"},{"key":"X-XSS-Protection","value":"1; mode=block"},{"key":"Cache-Control","value":"no-cache, no-store, max-age=0, must-revalidate"},{"key":"Pragma","value":"no-cache"},{"key":"Expires","value":"0"},{"key":"X-Frame-Options","value":"DENY"}],"cookie":[],"responseTime":null,"body":"{\n    \"status\": \"ok\",\n    \"file\": \"pgsql_sink\",\n    \"type\": \"POSTGRESQL\"\n}"}],"_postman_id":"3c04b627-3b96-4e76-b40a-c126cd2e4607"},{"name":"Creating S3 Sink","id":"89e2fe3c-8a44-454b-837e-dedc4f3aa84c","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[{"key":"Authorization","value":"Bearer <access_token>","description":"<p>Put access token here, which you get after successfull authentication</p>\n","type":"text"},{"key":"Content-Type","name":"Content-Type","value":"application/json","type":"text"}],"body":{"mode":"raw","raw":"{\n    \"name\": \"s3sink\",\n    \"path\": \"s3://iebucketencpt/donut.zip\",\n    \"roleArn\": \"arn:aws:iam::111111111111:role/AssumeS3External1\"\n}"},"url":"https://api.sonra.io/sink/create/s3","description":"<p>Use this endpoint to create an S3 Sink, if you want to save the data processing output to an S3 Bucket.</p>\n<p>It requires 2 mandatory parameters name, path, and 1 optional parameter roleArn:</p>\n<ul>\n<li>The parameter <strong>name</strong> is a unique name of Sink, which you will use in other calls as a reference to it.</li>\n<li>Parameter <strong>path</strong> is a full path to S3 Object, it can be bucket/folder</li>\n<li>(Optional) Parameter <strong>roleArn</strong> is a name of AWS Role with List/Read/Write to a provided path in your AWS Account, <a href=\"#1d5fd942-96eb-4541-a91f-e9331c918f94\">that you should create for Flexter AWS Account</a>.</li>\n</ul>\n","auth":{"type":"bearer","bearer":{"basicConfig":[{"key":"token","value":"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJhdWQiOlsiYmFzaWNfcmVzb3VyY2UiXSwidXNlcl9uYW1lIjoiWFhYWFhYWFhYIiwic2NvcGUiOlsicmVhZCIsIndyaXRlIl0sImV4cCI6MTU1MzI5ODgxMywiYXV0aG9yaXRpZXMiOlsiUk9MRV9VU0VSIl0sImp0aSI6Ijk0MzY4Y2I5LWJhNmYtNGQ5ZS1iMDMzLTNiYWZkN2QwYzQ3NSIsImNsaWVudF9pZCI6IjZnTkQ2dDJ0cDJXZms1c0pOQVlmcXVXUWV0YXVraGFiIn0.J7B4XtX9scXuITJfeg87av2lh3ZunYO1hkBjMs5_ku8"}]},"isInherited":true,"source":{"_postman_id":"8cb70162-bf30-4ab0-8f80-0c12c8c9dd2e","id":"8cb70162-bf30-4ab0-8f80-0c12c8c9dd2e","name":"Sink management","type":"folder"}},"urlObject":{"protocol":"https","path":["sink","create","s3"],"host":["api","sonra","io"],"query":[],"variable":[]}},"response":[{"id":"67e52b71-e555-4e78-b6c5-d5e84cee5eb2","name":"Creating S3 Sink","originalRequest":{"method":"POST","header":[{"key":"Authorization","value":"Bearer <access_token>","description":"Put access token here, which you get after successfull authentication","type":"text"},{"key":"Content-Type","name":"Content-Type","value":"application/json","type":"text"}],"body":{"mode":"raw","raw":"{\n    \"name\": \"s3sink\",\n    \"path\": \"s3://iebucketencpt/donut.zip\",\n    \"roleArn\": \"arn:aws:iam::111111111111:role/SomeS3RoleForAssumeRole\"\n}"},"url":"https://api.sonra.io/sink/create/s3"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Server","value":"nginx/1.12.2"},{"key":"Date","value":"Tue, 05 Mar 2019 20:04:20 GMT"},{"key":"Content-Type","value":"application/json;charset=UTF-8"},{"key":"Transfer-Encoding","value":"chunked"},{"key":"Connection","value":"keep-alive"},{"key":"X-Content-Type-Options","value":"nosniff"},{"key":"X-XSS-Protection","value":"1; mode=block"},{"key":"Cache-Control","value":"no-cache, no-store, max-age=0, must-revalidate"},{"key":"Pragma","value":"no-cache"},{"key":"Expires","value":"0"},{"key":"X-Frame-Options","value":"DENY"}],"cookie":[],"responseTime":null,"body":"{\n    \"status\": \"ok\",\n    \"file\": \"s3sink\",\n    \"type\": \"S3_EXTERNAL\"\n}"}],"_postman_id":"89e2fe3c-8a44-454b-837e-dedc4f3aa84c"},{"name":"Creating Snowflake Sink","id":"98308559-057b-4b44-91c1-ab40bf0e37fb","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[{"key":"Authorization","value":"Bearer <access_token>","description":"<p>Put access token here, which you get after successfull authentication</p>\n","type":"text"},{"key":"Content-Type","value":"application/json","type":"text"}],"body":{"mode":"raw","raw":"{\n    \"name\": \"snowflake\",\n    \"path\": \"snowflake://xxxxxx.eu-central-1.snowflakecomputing.com\",\n    \"username\": \"username\",\n    \"password\": \"password\",\n    \"db\": \"DEFAULT_DB\",\n    \"schema\": \"PUBLIC\",\n    \"warehouse\": \"DEFAULT_WH\"\n}"},"url":"https://api.sonra.io/sink/create/snowflake","description":"<p>Use this endpoint to create a Snowflake Sink, if you want to save the data processing output to Snowflake database.</p>\n<p>To create a Snowflake sink provide the following mandatory parameters:</p>\n<ul>\n<li><strong>name</strong> - is a unique name of Sink, which you will use in other calls as a reference to it.</li>\n<li><strong>path</strong> - a path to snowflake, should be in format <em>snowflake://account_name.region.snowflakecomputing.com</em> (for example snowflake://qwerty123.eu-central-1.snowflakecomputing.com)</li>\n<li><strong>username</strong> - username (user must have WRITE access for selected database/schema)</li>\n<li><strong>password</strong> - user's password</li>\n<li><strong>db</strong> - name of database</li>\n<li><strong>schema</strong>  - name of database's schema</li>\n<li><strong>warehouse</strong> - a name of a virtual warehouse (user must have OPERATE/USAGE privileges)</li>\n</ul>\n","auth":{"type":"bearer","bearer":{"basicConfig":[{"key":"token","value":"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJhdWQiOlsiYmFzaWNfcmVzb3VyY2UiXSwidXNlcl9uYW1lIjoiWFhYWFhYWFhYIiwic2NvcGUiOlsicmVhZCIsIndyaXRlIl0sImV4cCI6MTU1MzI5ODgxMywiYXV0aG9yaXRpZXMiOlsiUk9MRV9VU0VSIl0sImp0aSI6Ijk0MzY4Y2I5LWJhNmYtNGQ5ZS1iMDMzLTNiYWZkN2QwYzQ3NSIsImNsaWVudF9pZCI6IjZnTkQ2dDJ0cDJXZms1c0pOQVlmcXVXUWV0YXVraGFiIn0.J7B4XtX9scXuITJfeg87av2lh3ZunYO1hkBjMs5_ku8"}]},"isInherited":true,"source":{"_postman_id":"8cb70162-bf30-4ab0-8f80-0c12c8c9dd2e","id":"8cb70162-bf30-4ab0-8f80-0c12c8c9dd2e","name":"Sink management","type":"folder"}},"urlObject":{"protocol":"https","path":["sink","create","snowflake"],"host":["api","sonra","io"],"query":[],"variable":[]}},"response":[{"id":"b5712914-0a46-4f71-8ef6-a6d090e7a4db","name":"Creating Snowflake Sink","originalRequest":{"method":"POST","header":[{"key":"Authorization","value":"Bearer <access_token>","description":"Put access token here, which you get after successfull authentication","type":"text"},{"key":"Content-Type","value":"application/json","type":"text"}],"body":{"mode":"raw","raw":"{\n    \"name\": \"snowflake\",\n    \"path\": \"snowflake://xxxxxx.eu-central-1.snowflakecomputing.com\",\n    \"username\": \"username\",\n    \"password\": \"password\",\n    \"db\": \"DEFAULT_DB\",\n    \"schema\": \"PUBLIC\",\n    \"warehouse\": \"DEFAULT_WH\"\n}"},"url":"https://api.sonra.io/sink/create/snowflake"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Server","value":"nginx/1.12.2"},{"key":"Date","value":"Wed, 06 Mar 2019 08:16:05 GMT"},{"key":"Content-Type","value":"application/json;charset=UTF-8"},{"key":"Transfer-Encoding","value":"chunked"},{"key":"Connection","value":"keep-alive"},{"key":"X-Content-Type-Options","value":"nosniff"},{"key":"X-XSS-Protection","value":"1; mode=block"},{"key":"Cache-Control","value":"no-cache, no-store, max-age=0, must-revalidate"},{"key":"Pragma","value":"no-cache"},{"key":"Expires","value":"0"},{"key":"X-Frame-Options","value":"DENY"}],"cookie":[],"responseTime":null,"body":"{\n    \"status\": \"ok\",\n    \"file\": \"snowflake\",\n    \"type\": \"SNOWFLAKE\"\n}"}],"_postman_id":"98308559-057b-4b44-91c1-ab40bf0e37fb"},{"name":"Creating Redshift Sink","id":"43a0f413-208f-46ed-95b8-02b0dbc83fdb","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[{"description":"<p>Put access token here, which you get after successfull authentication</p>\n","key":"Authorization","type":"text","value":"Bearer <access_token>"},{"key":"Content-Type","type":"text","value":"application/json"}],"body":{"mode":"raw","raw":"{\n    \"name\": \"redshift_sink\",\n    \"path\": \"jdbc:redshift://sonra-test.xxx.eu-west-1.redshift.amazonaws.com:5439/testdb\",\n    \"username\": \"redshift_user\",\n    \"password\": \"redshift_password\"\n}"},"url":"https://api.sonra.io/sink/create/redshift","description":"<p>Use this endpoint to create a Redshift Sink, if you want to save the data processing output to Redshift database.</p>\n<p>To create a Redshift sink provide the following mandatory parameters:</p>\n<ul>\n<li><strong>name</strong> - is a unique name of Sink, which you will use in other calls as a reference to it.</li>\n<li><strong>path</strong> - a path to Redshift database (jdbc), should be in format <em>jdbc:redshift://cluster-name.xxx.region.redshift.amazonaws.com:5439/database_name</em> (for example jdbc:redshift://sonra-test.xxx.eu-west-1.redshift.amazonaws.com:5439/testdb)</li>\n<li><strong>username</strong> - username (user must have WRITE access for selected database)</li>\n<li><strong>password</strong> - user's password</li>\n</ul>\n","auth":{"type":"bearer","bearer":{"basicConfig":[{"key":"token","value":"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJhdWQiOlsiYmFzaWNfcmVzb3VyY2UiXSwidXNlcl9uYW1lIjoiWFhYWFhYWFhYIiwic2NvcGUiOlsicmVhZCIsIndyaXRlIl0sImV4cCI6MTU1MzI5ODgxMywiYXV0aG9yaXRpZXMiOlsiUk9MRV9VU0VSIl0sImp0aSI6Ijk0MzY4Y2I5LWJhNmYtNGQ5ZS1iMDMzLTNiYWZkN2QwYzQ3NSIsImNsaWVudF9pZCI6IjZnTkQ2dDJ0cDJXZms1c0pOQVlmcXVXUWV0YXVraGFiIn0.J7B4XtX9scXuITJfeg87av2lh3ZunYO1hkBjMs5_ku8"}]},"isInherited":true,"source":{"_postman_id":"8cb70162-bf30-4ab0-8f80-0c12c8c9dd2e","id":"8cb70162-bf30-4ab0-8f80-0c12c8c9dd2e","name":"Sink management","type":"folder"}},"urlObject":{"protocol":"https","path":["sink","create","redshift"],"host":["api","sonra","io"],"query":[],"variable":[]}},"response":[{"id":"217d2efd-6c43-46bd-99bd-fa9efd78c972","name":"Creating Redshift Sink","originalRequest":{"method":"POST","header":[{"description":"Put access token here, which you get after successfull authentication","key":"Authorization","type":"text","value":"Bearer <access_token>"},{"key":"Content-Type","type":"text","value":"application/json"}],"body":{"mode":"raw","raw":"{\n    \"name\": \"redshift_sink\",\n    \"path\": \"jdbc:redshift://sonra-test.xxxx.eu-west-1.redshift.amazonaws.com:5439/testdb\",\n    \"username\": \"testuser\",\n    \"password\": \"Testpass1\"\n}"},"url":"https://api.sonra.io/sink/create/redshift"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Server","value":"nginx/1.15.10"},{"key":"Date","value":"Thu, 04 Apr 2019 11:32:47 GMT"},{"key":"Content-Type","value":"application/json;charset=UTF-8"},{"key":"Transfer-Encoding","value":"chunked"},{"key":"Connection","value":"keep-alive"},{"key":"X-Content-Type-Options","value":"nosniff"},{"key":"X-XSS-Protection","value":"1; mode=block"},{"key":"Cache-Control","value":"no-cache, no-store, max-age=0, must-revalidate"},{"key":"Pragma","value":"no-cache"},{"key":"Expires","value":"0"},{"key":"X-Frame-Options","value":"DENY"}],"cookie":[],"responseTime":null,"body":"{\n    \"status\": \"ok\",\n    \"file\": \"redshift_sink\",\n    \"type\": \"REDSHIFT\"\n}"},{"id":"72b96438-646c-4f30-afc5-98d6f867747d","name":"Invalid username/password or database","originalRequest":{"method":"POST","header":[{"description":"Put access token here, which you get after successfull authentication","key":"Authorization","type":"text","value":"Bearer <access_token>"},{"key":"Content-Type","type":"text","value":"application/json"}],"body":{"mode":"raw","raw":"{\n    \"name\": \"redshift_sink\",\n    \"path\": \"jdbc:redshift://sonra-test.xxx.eu-west-1.redshift.amazonaws.com:5439/testdb\",\n    \"username\": \"redshift_user\",\n    \"password\": \"redshift_password\"\n}"},"url":"https://api.sonra.io/sink/create/redshift"},"status":"Conflict","code":409,"_postman_previewlanguage":"json","header":[{"key":"Server","value":"nginx/1.15.10"},{"key":"Date","value":"Thu, 04 Apr 2019 11:34:14 GMT"},{"key":"Content-Type","value":"application/json;charset=UTF-8"},{"key":"Transfer-Encoding","value":"chunked"},{"key":"Connection","value":"keep-alive"},{"key":"X-Content-Type-Options","value":"nosniff"},{"key":"X-XSS-Protection","value":"1; mode=block"},{"key":"Cache-Control","value":"no-cache, no-store, max-age=0, must-revalidate"},{"key":"Pragma","value":"no-cache"},{"key":"Expires","value":"0"},{"key":"X-Frame-Options","value":"DENY"}],"cookie":[],"responseTime":null,"body":"{\n    \"status\": \"Error\",\n    \"error_message\": \"[Amazon](500310) Invalid operation: password authentication failed for user \\\"redshift_user\\\";\"\n}"}],"_postman_id":"43a0f413-208f-46ed-95b8-02b0dbc83fdb"},{"name":"Getting Sink","id":"e1942fc0-6dcd-43d0-9e8e-7d9e2ada0796","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[{"description":"<p>Put access token here, which you get after successfull authentication</p>\n","key":"Authorization","type":"text","value":"Bearer <access_token>"}],"url":"https://api.sonra.io/sink/get/<sink_name>","description":"<p>Use this endpoint to get a single Sink entry information.</p>\n<p>It requires only 1 parameter name and returns information about Sink with the provided name.</p>\n<p>If Sink is not found, you will get an error response.</p>\n","auth":{"type":"bearer","bearer":{"basicConfig":[{"key":"token","value":"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJhdWQiOlsiYmFzaWNfcmVzb3VyY2UiXSwidXNlcl9uYW1lIjoiWFhYWFhYWFhYIiwic2NvcGUiOlsicmVhZCIsIndyaXRlIl0sImV4cCI6MTU1MzI5ODgxMywiYXV0aG9yaXRpZXMiOlsiUk9MRV9VU0VSIl0sImp0aSI6Ijk0MzY4Y2I5LWJhNmYtNGQ5ZS1iMDMzLTNiYWZkN2QwYzQ3NSIsImNsaWVudF9pZCI6IjZnTkQ2dDJ0cDJXZms1c0pOQVlmcXVXUWV0YXVraGFiIn0.J7B4XtX9scXuITJfeg87av2lh3ZunYO1hkBjMs5_ku8"}]},"isInherited":true,"source":{"_postman_id":"8cb70162-bf30-4ab0-8f80-0c12c8c9dd2e","id":"8cb70162-bf30-4ab0-8f80-0c12c8c9dd2e","name":"Sink management","type":"folder"}},"urlObject":{"protocol":"https","path":["sink","get","<sink_name>"],"host":["api","sonra","io"],"query":[],"variable":[]}},"response":[{"id":"ca790127-c1ee-4c41-adb8-eaf721c95ecd","name":"Getting Sink","originalRequest":{"method":"GET","header":[{"description":"Put access token here, which you get after successfull authentication","key":"Authorization","type":"text","value":"Bearer <access_token>"}],"url":"https://api.sonra.io/sink/get/s3sink"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Server","value":"nginx/1.12.2"},{"key":"Date","value":"Tue, 05 Mar 2019 20:06:39 GMT"},{"key":"Content-Type","value":"application/json;charset=UTF-8"},{"key":"Transfer-Encoding","value":"chunked"},{"key":"Connection","value":"keep-alive"},{"key":"X-Content-Type-Options","value":"nosniff"},{"key":"X-XSS-Protection","value":"1; mode=block"},{"key":"Cache-Control","value":"no-cache, no-store, max-age=0, must-revalidate"},{"key":"Pragma","value":"no-cache"},{"key":"Expires","value":"0"},{"key":"X-Frame-Options","value":"DENY"}],"cookie":[],"responseTime":null,"body":"{\n    \"status\": \"ok\",\n    \"create_date\": \"2019-03-05T20:04:19.956+0000\",\n    \"storage_type\": \"S3\",\n    \"name\": \"s3sink\",\n    \"type\": \"xml\",\n    \"path\": \"s3://iebucketencpt/donut.zip\"\n}"}],"_postman_id":"e1942fc0-6dcd-43d0-9e8e-7d9e2ada0796"},{"name":"Sink listing","id":"28ce83fb-c5db-4998-98e1-42fde75b9539","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[{"description":"<p>Put access token here, which you get after successfull authentication</p>\n","key":"Authorization","type":"text","value":"Bearer <access_token>"}],"url":"https://api.sonra.io/sink/list","description":"<p>Use this endpoint to get list of created Sinks</p>\n","auth":{"type":"bearer","bearer":{"basicConfig":[{"key":"token","value":"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJhdWQiOlsiYmFzaWNfcmVzb3VyY2UiXSwidXNlcl9uYW1lIjoiWFhYWFhYWFhYIiwic2NvcGUiOlsicmVhZCIsIndyaXRlIl0sImV4cCI6MTU1MzI5ODgxMywiYXV0aG9yaXRpZXMiOlsiUk9MRV9VU0VSIl0sImp0aSI6Ijk0MzY4Y2I5LWJhNmYtNGQ5ZS1iMDMzLTNiYWZkN2QwYzQ3NSIsImNsaWVudF9pZCI6IjZnTkQ2dDJ0cDJXZms1c0pOQVlmcXVXUWV0YXVraGFiIn0.J7B4XtX9scXuITJfeg87av2lh3ZunYO1hkBjMs5_ku8"}]},"isInherited":true,"source":{"_postman_id":"8cb70162-bf30-4ab0-8f80-0c12c8c9dd2e","id":"8cb70162-bf30-4ab0-8f80-0c12c8c9dd2e","name":"Sink management","type":"folder"}},"urlObject":{"protocol":"https","path":["sink","list"],"host":["api","sonra","io"],"query":[],"variable":[]}},"response":[{"id":"f8cbbefe-84e4-49c2-8a8d-b87ef0a69b07","name":"Sink listing","originalRequest":{"method":"GET","header":[{"description":"Put access token here, which you get after successfull authentication","key":"Authorization","type":"text","value":"Bearer <access_token>"}],"url":"https://api.sonra.io/sink/list"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Server","value":"nginx/1.12.2"},{"key":"Date","value":"Tue, 05 Mar 2019 20:09:14 GMT"},{"key":"Content-Type","value":"application/json;charset=UTF-8"},{"key":"Transfer-Encoding","value":"chunked"},{"key":"Connection","value":"keep-alive"},{"key":"X-Content-Type-Options","value":"nosniff"},{"key":"X-XSS-Protection","value":"1; mode=block"},{"key":"Cache-Control","value":"no-cache, no-store, max-age=0, must-revalidate"},{"key":"Pragma","value":"no-cache"},{"key":"Expires","value":"0"},{"key":"X-Frame-Options","value":"DENY"}],"cookie":[],"responseTime":null,"body":"{\n    \"status\": \"ok\",\n    \"files\": [\n        {\n            \"create_date\": \"2019-03-05T20:04:19.956+0000\",\n            \"storage_type\": \"S3\",\n            \"name\": \"s3sink\",\n            \"type\": \"xml\",\n            \"path\": \"s3://iebucketencpt/donut.zip\"\n        },\n        ...\n    ]\n}"}],"_postman_id":"28ce83fb-c5db-4998-98e1-42fde75b9539"},{"name":"Deleting Sink","id":"eed5f5bb-57cc-4f4e-885d-0dbbf4334865","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[{"description":"<p>Put access token here, which you get after successfull authentication</p>\n","key":"Authorization","type":"text","value":"Bearer <access_token>"}],"url":"https://api.sonra.io/sink/delete/<sink_name>","description":"<p>Use this endpoint to delete a single Sink entry.</p>\n","auth":{"type":"bearer","bearer":{"basicConfig":[{"key":"token","value":"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJhdWQiOlsiYmFzaWNfcmVzb3VyY2UiXSwidXNlcl9uYW1lIjoiWFhYWFhYWFhYIiwic2NvcGUiOlsicmVhZCIsIndyaXRlIl0sImV4cCI6MTU1MzI5ODgxMywiYXV0aG9yaXRpZXMiOlsiUk9MRV9VU0VSIl0sImp0aSI6Ijk0MzY4Y2I5LWJhNmYtNGQ5ZS1iMDMzLTNiYWZkN2QwYzQ3NSIsImNsaWVudF9pZCI6IjZnTkQ2dDJ0cDJXZms1c0pOQVlmcXVXUWV0YXVraGFiIn0.J7B4XtX9scXuITJfeg87av2lh3ZunYO1hkBjMs5_ku8"}]},"isInherited":true,"source":{"_postman_id":"8cb70162-bf30-4ab0-8f80-0c12c8c9dd2e","id":"8cb70162-bf30-4ab0-8f80-0c12c8c9dd2e","name":"Sink management","type":"folder"}},"urlObject":{"protocol":"https","path":["sink","delete","<sink_name>"],"host":["api","sonra","io"],"query":[],"variable":[]}},"response":[{"id":"aae00293-81b2-4f4c-bd1f-6661d8bb74cc","name":"Deleting Sink","originalRequest":{"method":"GET","header":[{"description":"Put access token here, which you get after successfull authentication","key":"Authorization","type":"text","value":"Bearer <access_token>"}],"url":"https://api.sonra.io/sink/delete/redshift_sink"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Server","value":"nginx/1.15.10"},{"key":"Date","value":"Tue, 09 Apr 2019 09:30:58 GMT"},{"key":"Content-Type","value":"application/json;charset=UTF-8"},{"key":"Transfer-Encoding","value":"chunked"},{"key":"Connection","value":"keep-alive"},{"key":"X-Content-Type-Options","value":"nosniff"},{"key":"X-XSS-Protection","value":"1; mode=block"},{"key":"Cache-Control","value":"no-cache, no-store, max-age=0, must-revalidate"},{"key":"Pragma","value":"no-cache"},{"key":"Expires","value":"0"},{"key":"X-Frame-Options","value":"DENY"}],"cookie":[],"responseTime":null,"body":"{\n    \"storage_type\": \"REDSHIFT\",\n    \"create_date\": \"2019-04-04T11:32:47.115+0000\",\n    \"name\": \"redshift_sink\",\n    \"type\": \"xml\",\n    \"path\": \"jdbc:redshift://xxxxxx.eu-west-1.redshift.amazonaws.com/testdb\"\n}"}],"_postman_id":"eed5f5bb-57cc-4f4e-885d-0dbbf4334865"}],"id":"8cb70162-bf30-4ab0-8f80-0c12c8c9dd2e","description":"<p>A sink is a resource containing connection details for the data storage, where you want to save the processed data.</p>\n<p><strong>Note, that Sink is an optional resource. If you don't create Sink, you still can process data, and the output will be saved in our cloud and available for download.</strong></p>\n<p>Endpoints for Sink management</p>\n","auth":{"type":"bearer","bearer":{"basicConfig":[{"key":"token","value":"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJhdWQiOlsiYmFzaWNfcmVzb3VyY2UiXSwidXNlcl9uYW1lIjoiWFhYWFhYWFhYIiwic2NvcGUiOlsicmVhZCIsIndyaXRlIl0sImV4cCI6MTU1MzI5ODgxMywiYXV0aG9yaXRpZXMiOlsiUk9MRV9VU0VSIl0sImp0aSI6Ijk0MzY4Y2I5LWJhNmYtNGQ5ZS1iMDMzLTNiYWZkN2QwYzQ3NSIsImNsaWVudF9pZCI6IjZnTkQ2dDJ0cDJXZms1c0pOQVlmcXVXUWV0YXVraGFiIn0.J7B4XtX9scXuITJfeg87av2lh3ZunYO1hkBjMs5_ku8"}]},"isInherited":false},"event":[{"listen":"prerequest","script":{"id":"ac92eb9b-04af-48b3-b51c-1f5755499060","type":"text/javascript","exec":[""]}},{"listen":"test","script":{"id":"69dfb9df-ce9c-4058-a876-f9e7472a40ec","type":"text/javascript","exec":[""]}}],"_postman_id":"8cb70162-bf30-4ab0-8f80-0c12c8c9dd2e"},{"name":"Schema management","item":[{"name":"Generating schema","id":"2d9568cb-32ec-4511-aa28-c0d2bfd4461f","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[{"key":"Authorization","value":"Bearer <access_token>","description":"<p>Put access token here, which you get after successfull authentication</p>\n","type":"text"},{"key":"Content-Type","name":"Content-Type","value":"application/json","type":"text"}],"body":{"mode":"raw","raw":"{\n    \"name\": \"sample_schema\",\n    \"xml\": \"xml_source\",\n    \"xsd\": \"xsd_source\",\n    \"json\": \"json_source\"\n}"},"url":"https://api.sonra.io/schema/create","description":"<p>You can generate Schema based on :</p>\n<ul>\n<li>XML Source entry ( Source with type <em>xml</em> )</li>\n<li>XML Source entry + XSD Source entry ( Sources with types <em>xml</em> and <em>xsd</em> accordingly )</li>\n<li>JSON Source files ( Source with type <em>json</em> )</li>\n</ul>\n<p>To generate Schema based on XML files, you can send the following request</p>\n<pre class=\"click-to-expand-wrapper is-snippet-wrapper\"><code>{\n    \"name\": \"name_of_your_schema\",\n    \"xml\": \"xml_source_name\"\n}\n</code></pre><p>To generate Schema based on XML and XSD files, you can send the following request</p>\n<pre class=\"click-to-expand-wrapper is-snippet-wrapper\"><code>{\n    \"name\": \"name_of_your_schema\",\n    \"xml\": \"xml_source_name\",\n    \"xsd\": \"xsd_source_name\"\n}\n</code></pre><p>To generate Schema based on JSON files, you can send the following request</p>\n<pre class=\"click-to-expand-wrapper is-snippet-wrapper\"><code>{\n    \"name\": \"name_of_your_schema\",\n    \"json\": \"json_source_name\"\n}\n</code></pre><p>If parameters are correct, you'll get a success response, which indicates that the schema generation process has started.</p>\n","auth":{"type":"bearer","bearer":{"basicConfig":[{"key":"token","value":"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJhdWQiOlsiYmFzaWNfcmVzb3VyY2UiXSwidXNlcl9uYW1lIjoiWFhYWFhYWFhYIiwic2NvcGUiOlsicmVhZCIsIndyaXRlIl0sImV4cCI6MTU1MzI5ODgxMywiYXV0aG9yaXRpZXMiOlsiUk9MRV9VU0VSIl0sImp0aSI6Ijk0MzY4Y2I5LWJhNmYtNGQ5ZS1iMDMzLTNiYWZkN2QwYzQ3NSIsImNsaWVudF9pZCI6IjZnTkQ2dDJ0cDJXZms1c0pOQVlmcXVXUWV0YXVraGFiIn0.J7B4XtX9scXuITJfeg87av2lh3ZunYO1hkBjMs5_ku8"}]},"isInherited":true,"source":{"_postman_id":"ebedea76-a9f1-4ef6-9277-38a418d28757","id":"ebedea76-a9f1-4ef6-9277-38a418d28757","name":"Schema management","type":"folder"}},"urlObject":{"protocol":"https","path":["schema","create"],"host":["api","sonra","io"],"query":[],"variable":[]}},"response":[{"id":"079be5ed-e046-440f-b2bf-c5a8b5babca4","name":"Creating schema invalid file","originalRequest":{"method":"POST","header":[{"key":"Authorization","value":"Bearer <access_token>","description":"Put access token here, which you get after successfull authentication","type":"text"},{"key":"Content-Type","name":"Content-Type","value":"application/json","type":"text"}],"body":{"mode":"raw","raw":"{\n    \"name\": \"sample_schema\",\n    \"xml\": \"my_first_file2\"\n}"},"url":"https://api.sonra.io/schema/create"},"status":"Conflict","code":409,"_postman_previewlanguage":"json","header":[{"key":"Server","value":"nginx/1.12.2"},{"key":"Date","value":"Tue, 05 Mar 2019 18:45:03 GMT"},{"key":"Content-Type","value":"application/json;charset=UTF-8"},{"key":"Transfer-Encoding","value":"chunked"},{"key":"Connection","value":"keep-alive"},{"key":"X-Content-Type-Options","value":"nosniff"},{"key":"X-XSS-Protection","value":"1; mode=block"},{"key":"Cache-Control","value":"no-cache, no-store, max-age=0, must-revalidate"},{"key":"Pragma","value":"no-cache"},{"key":"Expires","value":"0"},{"key":"X-Frame-Options","value":"DENY"}],"cookie":[],"responseTime":null,"body":"{\n    \"status\": \"Error\",\n    \"error_message\": \"Storage is not found\"\n}"},{"id":"94b5ba2d-7d84-4d72-8ce6-db1ef72f4532","name":"Creating XML based schema","originalRequest":{"method":"POST","header":[{"key":"Authorization","value":"Bearer <access_token>","description":"Put access token here, which you get after successfull authentication","type":"text"},{"key":"Content-Type","name":"Content-Type","value":"application/json","type":"text"}],"body":{"mode":"raw","raw":"{\n    \"name\": \"sample_schema\",\n    \"xml\": \"my_first_file\"\n}"},"url":"https://api.sonra.io/schema/create"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Server","value":"nginx/1.12.2"},{"key":"Date","value":"Tue, 05 Mar 2019 16:09:36 GMT"},{"key":"Content-Type","value":"application/json;charset=UTF-8"},{"key":"Transfer-Encoding","value":"chunked"},{"key":"Connection","value":"keep-alive"},{"key":"X-Content-Type-Options","value":"nosniff"},{"key":"X-XSS-Protection","value":"1; mode=block"},{"key":"Cache-Control","value":"no-cache, no-store, max-age=0, must-revalidate"},{"key":"Pragma","value":"no-cache"},{"key":"Expires","value":"0"},{"key":"X-Frame-Options","value":"DENY"}],"cookie":[],"responseTime":null,"body":"{\n    \"status\": \"ok\",\n    \"uuid\": \"sample_schema\"\n}"},{"id":"d1fb0656-57e9-4575-bb29-495cdb0ae34e","name":"Creating schema conflict","originalRequest":{"method":"POST","header":[{"key":"Authorization","value":"Bearer <access_token>","description":"Put access token here, which you get after successfull authentication","type":"text"},{"key":"Content-Type","name":"Content-Type","value":"application/json","type":"text"}],"body":{"mode":"raw","raw":"{\n    \"name\": \"sample_schema\",\n    \"xml\": \"my_first_file\"\n}"},"url":"https://api.sonra.io/schema/create"},"status":"Conflict","code":409,"_postman_previewlanguage":"json","header":[{"key":"Server","value":"nginx/1.12.2"},{"key":"Date","value":"Tue, 05 Mar 2019 18:43:20 GMT"},{"key":"Content-Type","value":"application/json;charset=UTF-8"},{"key":"Transfer-Encoding","value":"chunked"},{"key":"Connection","value":"keep-alive"},{"key":"X-Content-Type-Options","value":"nosniff"},{"key":"X-XSS-Protection","value":"1; mode=block"},{"key":"Cache-Control","value":"no-cache, no-store, max-age=0, must-revalidate"},{"key":"Pragma","value":"no-cache"},{"key":"Expires","value":"0"},{"key":"X-Frame-Options","value":"DENY"}],"cookie":[],"responseTime":null,"body":"{\n    \"status\": \"Error\",\n    \"error_message\": \"Schema already exists with name [sample_schema]\"\n}"}],"_postman_id":"2d9568cb-32ec-4511-aa28-c0d2bfd4461f"},{"name":"Getting schema","id":"d428c073-f982-45e7-b648-84840fd185ce","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[{"key":"Authorization","value":"Bearer <access_token>","description":"<p>Put access token here, which you get after successfull authentication</p>\n","type":"text"},{"key":"Content-Type","value":"application/json","type":"text"}],"url":"https://api.sonra.io/schema/get/<schema_name>","description":"<p>Use this endpoint to get a single Schema entry information.</p>\n<p>It requires only 1 parameter name and returns information about Schema with the provided name.</p>\n<p>If Schema is not found, you will get an error response.</p>\n","auth":{"type":"bearer","bearer":{"basicConfig":[{"key":"token","value":"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJhdWQiOlsiYmFzaWNfcmVzb3VyY2UiXSwidXNlcl9uYW1lIjoiWFhYWFhYWFhYIiwic2NvcGUiOlsicmVhZCIsIndyaXRlIl0sImV4cCI6MTU1MzI5ODgxMywiYXV0aG9yaXRpZXMiOlsiUk9MRV9VU0VSIl0sImp0aSI6Ijk0MzY4Y2I5LWJhNmYtNGQ5ZS1iMDMzLTNiYWZkN2QwYzQ3NSIsImNsaWVudF9pZCI6IjZnTkQ2dDJ0cDJXZms1c0pOQVlmcXVXUWV0YXVraGFiIn0.J7B4XtX9scXuITJfeg87av2lh3ZunYO1hkBjMs5_ku8"}]},"isInherited":true,"source":{"_postman_id":"ebedea76-a9f1-4ef6-9277-38a418d28757","id":"ebedea76-a9f1-4ef6-9277-38a418d28757","name":"Schema management","type":"folder"}},"urlObject":{"protocol":"https","path":["schema","get","<schema_name>"],"host":["api","sonra","io"],"query":[],"variable":[]}},"response":[{"id":"d16b5227-1cce-418a-842e-3e24f05d3116","name":"Getting schema","originalRequest":{"method":"GET","header":[{"key":"Authorization","value":"Bearer <access_token>","description":"Put access token here, which you get after successfull authentication","type":"text"},{"key":"Content-Type","value":"application/json","type":"text"}],"url":"https://api.sonra.io/schema/get/sample_schema"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Server","value":"nginx/1.12.2"},{"key":"Date","value":"Tue, 05 Mar 2019 19:13:17 GMT"},{"key":"Content-Type","value":"application/json;charset=UTF-8"},{"key":"Transfer-Encoding","value":"chunked"},{"key":"Connection","value":"keep-alive"},{"key":"X-Content-Type-Options","value":"nosniff"},{"key":"X-XSS-Protection","value":"1; mode=block"},{"key":"Cache-Control","value":"no-cache, no-store, max-age=0, must-revalidate"},{"key":"Pragma","value":"no-cache"},{"key":"Expires","value":"0"},{"key":"X-Frame-Options","value":"DENY"}],"cookie":[],"responseTime":null,"body":"{\n    \"status\": \"ok\",\n    \"schema\": {\n        \"updateDate\": null,\n        \"name\": \"sample_schema\",\n        \"id\": \"schema-5b018cdb-56ea-4de7-bdb9-bdf8ea6a41ac\",\n        \"createDate\": \"2019-03-05T16:09:35.411+0000\",\n        \"status\": \"C\"\n    }\n}"}],"_postman_id":"d428c073-f982-45e7-b648-84840fd185ce"},{"name":"Schema listing","id":"a61de2ca-31c6-436a-8201-d14bee8c6905","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[{"key":"Authorization","value":"Bearer <access_token>","description":"<p>Put access token here, which you get after successfull authentication</p>\n","type":"text"}],"url":"https://api.sonra.io/schema/list","description":"<p>Use this endpoint to get list of generated Schema</p>\n","auth":{"type":"bearer","bearer":{"basicConfig":[{"key":"token","value":"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJhdWQiOlsiYmFzaWNfcmVzb3VyY2UiXSwidXNlcl9uYW1lIjoiWFhYWFhYWFhYIiwic2NvcGUiOlsicmVhZCIsIndyaXRlIl0sImV4cCI6MTU1MzI5ODgxMywiYXV0aG9yaXRpZXMiOlsiUk9MRV9VU0VSIl0sImp0aSI6Ijk0MzY4Y2I5LWJhNmYtNGQ5ZS1iMDMzLTNiYWZkN2QwYzQ3NSIsImNsaWVudF9pZCI6IjZnTkQ2dDJ0cDJXZms1c0pOQVlmcXVXUWV0YXVraGFiIn0.J7B4XtX9scXuITJfeg87av2lh3ZunYO1hkBjMs5_ku8"}]},"isInherited":true,"source":{"_postman_id":"ebedea76-a9f1-4ef6-9277-38a418d28757","id":"ebedea76-a9f1-4ef6-9277-38a418d28757","name":"Schema management","type":"folder"}},"urlObject":{"protocol":"https","path":["schema","list"],"host":["api","sonra","io"],"query":[],"variable":[]}},"response":[{"id":"c63fe5ee-071b-4381-b61f-9b620fa35877","name":"Schema listing","originalRequest":{"method":"GET","header":[{"key":"Authorization","value":"Bearer <access_token>","description":"Put access token here, which you get after successfull authentication","type":"text"}],"url":"https://api.sonra.io/schema/list"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Server","value":"nginx/1.12.2"},{"key":"Date","value":"Tue, 05 Mar 2019 19:21:03 GMT"},{"key":"Content-Type","value":"application/json;charset=UTF-8"},{"key":"Transfer-Encoding","value":"chunked"},{"key":"Connection","value":"keep-alive"},{"key":"X-Content-Type-Options","value":"nosniff"},{"key":"X-XSS-Protection","value":"1; mode=block"},{"key":"Cache-Control","value":"no-cache, no-store, max-age=0, must-revalidate"},{"key":"Pragma","value":"no-cache"},{"key":"Expires","value":"0"},{"key":"X-Frame-Options","value":"DENY"}],"cookie":[],"responseTime":null,"body":"{\n    \"status\": \"ok\",\n    \"schemas\": [\n        {\n            \"name\": \"sample_schema\",\n            \"id\": \"schema-5b018cdb-56ea-4de7-bdb9-bdf8ea6a41ac\",\n            \"create_date\": \"2019-03-05T16:09:35.411+0000\",\n            \"status\": \"C\"\n        }\n    ]\n}"}],"_postman_id":"a61de2ca-31c6-436a-8201-d14bee8c6905"},{"name":"Deleting Schema","id":"26a07a11-84a2-49b3-b550-08d293f99a96","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[{"description":"<p>Put access token here, which you get after successfull authentication</p>\n","key":"Authorization","type":"text","value":"Bearer <access_token>"}],"url":"https://api.sonra.io/schema/delete/<schema_name>","description":"<p>Use this endpoint to delete a single Schema entry.</p>\n","auth":{"type":"bearer","bearer":{"basicConfig":[{"key":"token","value":"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJhdWQiOlsiYmFzaWNfcmVzb3VyY2UiXSwidXNlcl9uYW1lIjoiWFhYWFhYWFhYIiwic2NvcGUiOlsicmVhZCIsIndyaXRlIl0sImV4cCI6MTU1MzI5ODgxMywiYXV0aG9yaXRpZXMiOlsiUk9MRV9VU0VSIl0sImp0aSI6Ijk0MzY4Y2I5LWJhNmYtNGQ5ZS1iMDMzLTNiYWZkN2QwYzQ3NSIsImNsaWVudF9pZCI6IjZnTkQ2dDJ0cDJXZms1c0pOQVlmcXVXUWV0YXVraGFiIn0.J7B4XtX9scXuITJfeg87av2lh3ZunYO1hkBjMs5_ku8"}]},"isInherited":true,"source":{"_postman_id":"ebedea76-a9f1-4ef6-9277-38a418d28757","id":"ebedea76-a9f1-4ef6-9277-38a418d28757","name":"Schema management","type":"folder"}},"urlObject":{"protocol":"https","path":["schema","delete","<schema_name>"],"host":["api","sonra","io"],"query":[],"variable":[]}},"response":[{"id":"5b182562-8de7-49f6-9170-6343af88af88","name":"Deleting Schema","originalRequest":{"method":"GET","header":[{"description":"Put access token here, which you get after successfull authentication","key":"Authorization","type":"text","value":"Bearer <access_token>"}],"url":"https://api.sonra.io/schema/delete/test1-failed-XttuT"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Server","value":"nginx/1.15.10"},{"key":"Date","value":"Tue, 09 Apr 2019 09:32:37 GMT"},{"key":"Content-Type","value":"application/json;charset=UTF-8"},{"key":"Transfer-Encoding","value":"chunked"},{"key":"Connection","value":"keep-alive"},{"key":"X-Content-Type-Options","value":"nosniff"},{"key":"X-XSS-Protection","value":"1; mode=block"},{"key":"Cache-Control","value":"no-cache, no-store, max-age=0, must-revalidate"},{"key":"Pragma","value":"no-cache"},{"key":"Expires","value":"0"},{"key":"X-Frame-Options","value":"DENY"}],"cookie":[],"responseTime":null,"body":"{\n    \"name\": \"test1-failed-XttuT\"\n}"}],"_postman_id":"26a07a11-84a2-49b3-b550-08d293f99a96"}],"id":"ebedea76-a9f1-4ef6-9277-38a418d28757","description":"<p>This is your target data model and the mappings from XML/JSON source elements to target table columns.</p>\n","auth":{"type":"bearer","bearer":{"basicConfig":[{"key":"token","value":"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJhdWQiOlsiYmFzaWNfcmVzb3VyY2UiXSwidXNlcl9uYW1lIjoiWFhYWFhYWFhYIiwic2NvcGUiOlsicmVhZCIsIndyaXRlIl0sImV4cCI6MTU1MzI5ODgxMywiYXV0aG9yaXRpZXMiOlsiUk9MRV9VU0VSIl0sImp0aSI6Ijk0MzY4Y2I5LWJhNmYtNGQ5ZS1iMDMzLTNiYWZkN2QwYzQ3NSIsImNsaWVudF9pZCI6IjZnTkQ2dDJ0cDJXZms1c0pOQVlmcXVXUWV0YXVraGFiIn0.J7B4XtX9scXuITJfeg87av2lh3ZunYO1hkBjMs5_ku8"}]},"isInherited":false},"event":[{"listen":"prerequest","script":{"id":"85f7051a-ea90-4d75-a596-3e36b368f992","type":"text/javascript","exec":[""]}},{"listen":"test","script":{"id":"0d20b7f7-3d7b-4eb1-be03-84e00514f8a2","type":"text/javascript","exec":[""]}}],"_postman_id":"ebedea76-a9f1-4ef6-9277-38a418d28757"},{"name":"Data processing","item":[{"name":"Data processing","id":"c6ecf14f-ece4-4791-8fcf-073bddda3d04","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[{"key":"Authorization","value":"Bearer <access_token>","description":"<p>Put access token here, which you get after successfull authentication</p>\n","type":"text"},{"key":"Content-Type","value":"application/json","type":"text"}],"body":{"mode":"raw","raw":"{\n\t\"schema\": \"sample_schema\",\n\t\"source\": \"my_first_file\",\n\t\"sink\": \"s3sink\"\n}"},"url":"https://api.sonra.io/data/process","description":"<p>This endpoint is used to create a Data Processing entry.\nIt requires 2 mandatory parameters and 1 optional parameter:</p>\n<ul>\n<li>Parameter schema is a reference to a Schema entry</li>\n<li>Parameter source is a reference to a XML Source</li>\n<li>(Optional) Parameter sink is a reference to a Sink, if you want the output of processing to be saved somewhere, you should specify a Sink reference, otherwise the output will be saved in our cloud.</li>\n</ul>","auth":{"type":"bearer","bearer":{"basicConfig":[{"key":"token","value":"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJhdWQiOlsiYmFzaWNfcmVzb3VyY2UiXSwidXNlcl9uYW1lIjoiWFhYWFhYWFhYIiwic2NvcGUiOlsicmVhZCIsIndyaXRlIl0sImV4cCI6MTU1MzI5ODgxMywiYXV0aG9yaXRpZXMiOlsiUk9MRV9VU0VSIl0sImp0aSI6Ijk0MzY4Y2I5LWJhNmYtNGQ5ZS1iMDMzLTNiYWZkN2QwYzQ3NSIsImNsaWVudF9pZCI6IjZnTkQ2dDJ0cDJXZms1c0pOQVlmcXVXUWV0YXVraGFiIn0.J7B4XtX9scXuITJfeg87av2lh3ZunYO1hkBjMs5_ku8"}]},"isInherited":true,"source":{"_postman_id":"4c0a64b5-a90f-4b0a-bfaf-1bbf05d7f9b8","id":"4c0a64b5-a90f-4b0a-bfaf-1bbf05d7f9b8","name":"Data processing","type":"folder"}},"urlObject":{"protocol":"https","path":["data","process"],"host":["api","sonra","io"],"query":[],"variable":[]}},"response":[{"id":"de585034-86d9-439d-ad87-0fd9df8c3b74","name":"Data processing","originalRequest":{"method":"POST","header":[{"key":"Authorization","value":"Bearer <access_token>","description":"Put access token here, which you get after successfull authentication","type":"text"},{"key":"Content-Type","value":"application/json","type":"text"}],"body":{"mode":"raw","raw":"{\n\t\"schema\": \"sample_schema\",\n\t\"source\": \"my_first_file\",\n\t\"sink\": \"s3sink\"\n}"},"url":"https://api.sonra.io/data/process"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Server","value":"nginx/1.12.2"},{"key":"Date","value":"Tue, 05 Mar 2019 20:33:22 GMT"},{"key":"Content-Type","value":"application/json;charset=UTF-8"},{"key":"Transfer-Encoding","value":"chunked"},{"key":"Connection","value":"keep-alive"},{"key":"X-Content-Type-Options","value":"nosniff"},{"key":"X-XSS-Protection","value":"1; mode=block"},{"key":"Cache-Control","value":"no-cache, no-store, max-age=0, must-revalidate"},{"key":"Pragma","value":"no-cache"},{"key":"Expires","value":"0"},{"key":"X-Frame-Options","value":"DENY"}],"cookie":[],"responseTime":null,"body":"{\n    \"status\": \"OK\",\n    \"uuid\": \"data-2400eb32-0a80-496d-a203-7fad46eca4d3\"\n}"}],"_postman_id":"c6ecf14f-ece4-4791-8fcf-073bddda3d04"},{"name":"Get data processing","id":"df931a40-9ed1-43c2-8744-111b28b3756d","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[{"key":"Authorization","value":"Bearer <access_token>","description":"<p>Put access token here, which you get after successfull authentication</p>\n","type":"text"},{"key":"Content-Type","value":"application/json","type":"text"}],"body":{"mode":"raw","raw":"{\n\t\"id\": \"data-2400eb32-0a80-496d-a203-7fad46eca4d3\"\n}"},"url":"https://api.sonra.io/data/get/","auth":{"type":"bearer","bearer":{"basicConfig":[{"key":"token","value":"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJhdWQiOlsiYmFzaWNfcmVzb3VyY2UiXSwidXNlcl9uYW1lIjoiWFhYWFhYWFhYIiwic2NvcGUiOlsicmVhZCIsIndyaXRlIl0sImV4cCI6MTU1MzI5ODgxMywiYXV0aG9yaXRpZXMiOlsiUk9MRV9VU0VSIl0sImp0aSI6Ijk0MzY4Y2I5LWJhNmYtNGQ5ZS1iMDMzLTNiYWZkN2QwYzQ3NSIsImNsaWVudF9pZCI6IjZnTkQ2dDJ0cDJXZms1c0pOQVlmcXVXUWV0YXVraGFiIn0.J7B4XtX9scXuITJfeg87av2lh3ZunYO1hkBjMs5_ku8"}]},"isInherited":true,"source":{"_postman_id":"4c0a64b5-a90f-4b0a-bfaf-1bbf05d7f9b8","id":"4c0a64b5-a90f-4b0a-bfaf-1bbf05d7f9b8","name":"Data processing","type":"folder"}},"urlObject":{"protocol":"https","path":["data","get",""],"host":["api","sonra","io"],"query":[],"variable":[]}},"response":[{"id":"5a00c6d6-5a89-4fa5-89ff-72c7205bf4cc","name":"Get data processing","originalRequest":{"method":"POST","header":[{"key":"Authorization","value":"Bearer <access_token>","description":"Put access token here, which you get after successfull authentication","type":"text"},{"key":"Content-Type","value":"application/json","type":"text"}],"body":{"mode":"raw","raw":"{\n\t\"id\": \"data-2400eb32-0a80-496d-a203-7fad46eca4d3\"\n}"},"url":"https://api.sonra.io/data/get/"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Server","value":"nginx/1.12.2"},{"key":"Date","value":"Tue, 05 Mar 2019 20:37:57 GMT"},{"key":"Content-Type","value":"application/json;charset=UTF-8"},{"key":"Transfer-Encoding","value":"chunked"},{"key":"Connection","value":"keep-alive"},{"key":"X-Content-Type-Options","value":"nosniff"},{"key":"X-XSS-Protection","value":"1; mode=block"},{"key":"Cache-Control","value":"no-cache, no-store, max-age=0, must-revalidate"},{"key":"Pragma","value":"no-cache"},{"key":"Expires","value":"0"},{"key":"X-Frame-Options","value":"DENY"}],"cookie":[],"responseTime":null,"body":"{\n    \"status\": \"ok\",\n    \"workflow\": {\n        \"updateDate\": null,\n        \"name\": \"sample_schema-56153705-634b-4bb7-a867-029440595ee9\",\n        \"id\": \"data-2400eb32-0a80-496d-a203-7fad46eca4d3\",\n        \"createDate\": \"2019-03-05T20:33:21.478+0000\",\n        \"status\": \"C\"\n    }\n}"}],"_postman_id":"df931a40-9ed1-43c2-8744-111b28b3756d"},{"name":"Data processing listing","id":"93686b66-e33d-4378-839a-6eb29d92a2ee","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[{"key":"Authorization","value":"Bearer <access_token>","description":"<p>Put access token here, which you get after successfull authentication</p>\n","type":"text"},{"key":"Content-Type","value":"application/json","type":"text"}],"url":"https://api.sonra.io/data/list","auth":{"type":"bearer","bearer":{"basicConfig":[{"key":"token","value":"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJhdWQiOlsiYmFzaWNfcmVzb3VyY2UiXSwidXNlcl9uYW1lIjoiWFhYWFhYWFhYIiwic2NvcGUiOlsicmVhZCIsIndyaXRlIl0sImV4cCI6MTU1MzI5ODgxMywiYXV0aG9yaXRpZXMiOlsiUk9MRV9VU0VSIl0sImp0aSI6Ijk0MzY4Y2I5LWJhNmYtNGQ5ZS1iMDMzLTNiYWZkN2QwYzQ3NSIsImNsaWVudF9pZCI6IjZnTkQ2dDJ0cDJXZms1c0pOQVlmcXVXUWV0YXVraGFiIn0.J7B4XtX9scXuITJfeg87av2lh3ZunYO1hkBjMs5_ku8"}]},"isInherited":true,"source":{"_postman_id":"4c0a64b5-a90f-4b0a-bfaf-1bbf05d7f9b8","id":"4c0a64b5-a90f-4b0a-bfaf-1bbf05d7f9b8","name":"Data processing","type":"folder"}},"urlObject":{"protocol":"https","path":["data","list"],"host":["api","sonra","io"],"query":[],"variable":[]}},"response":[{"id":"7e0b4aa1-d682-4ad1-9012-74bfa6157e38","name":"Data processing listing","originalRequest":{"method":"GET","header":[{"key":"Authorization","value":"Bearer <access_token>","description":"Put access token here, which you get after successfull authentication","type":"text"},{"key":"Content-Type","value":"application/json","type":"text"}],"url":"https://api.sonra.io/data/list"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Server","value":"nginx/1.12.2"},{"key":"Date","value":"Tue, 05 Mar 2019 20:39:17 GMT"},{"key":"Content-Type","value":"application/json;charset=UTF-8"},{"key":"Transfer-Encoding","value":"chunked"},{"key":"Connection","value":"keep-alive"},{"key":"X-Content-Type-Options","value":"nosniff"},{"key":"X-XSS-Protection","value":"1; mode=block"},{"key":"Cache-Control","value":"no-cache, no-store, max-age=0, must-revalidate"},{"key":"Pragma","value":"no-cache"},{"key":"Expires","value":"0"},{"key":"X-Frame-Options","value":"DENY"}],"cookie":[],"responseTime":null,"body":"{\n    \"status\": \"ok\",\n    \"workflows\": [\n        {\n            \"name\": \"sample_schema-56153705-634b-4bb7-a867-029440595ee9\",\n            \"id\": \"data-2400eb32-0a80-496d-a203-7fad46eca4d3\",\n            \"create_date\": \"2019-03-05T20:33:21.478+0000\",\n            \"status\": \"C\"\n        }\n    ]\n}"}],"_postman_id":"93686b66-e33d-4378-839a-6eb29d92a2ee"},{"name":"Download data","id":"220ae134-01b7-4a11-9e65-20b02112c0c0","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[{"key":"Authorization","value":"Bearer <access_token>","description":"<p>Put access token here, which you get after successfull authentication</p>\n","type":"text"},{"key":"Content-Type","value":"application/json","type":"text"}],"body":{"mode":"raw","raw":"{\n\t\"id\": \"data-processing-uuid\"\n}"},"url":"https://api.sonra.io/data/download","auth":{"type":"bearer","bearer":{"basicConfig":[{"key":"token","value":"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJhdWQiOlsiYmFzaWNfcmVzb3VyY2UiXSwidXNlcl9uYW1lIjoiWFhYWFhYWFhYIiwic2NvcGUiOlsicmVhZCIsIndyaXRlIl0sImV4cCI6MTU1MzI5ODgxMywiYXV0aG9yaXRpZXMiOlsiUk9MRV9VU0VSIl0sImp0aSI6Ijk0MzY4Y2I5LWJhNmYtNGQ5ZS1iMDMzLTNiYWZkN2QwYzQ3NSIsImNsaWVudF9pZCI6IjZnTkQ2dDJ0cDJXZms1c0pOQVlmcXVXUWV0YXVraGFiIn0.J7B4XtX9scXuITJfeg87av2lh3ZunYO1hkBjMs5_ku8"}]},"isInherited":true,"source":{"_postman_id":"4c0a64b5-a90f-4b0a-bfaf-1bbf05d7f9b8","id":"4c0a64b5-a90f-4b0a-bfaf-1bbf05d7f9b8","name":"Data processing","type":"folder"}},"urlObject":{"protocol":"https","path":["data","download"],"host":["api","sonra","io"],"query":[],"variable":[]}},"response":[],"_postman_id":"220ae134-01b7-4a11-9e65-20b02112c0c0"}],"id":"4c0a64b5-a90f-4b0a-bfaf-1bbf05d7f9b8","description":"<p>TBD</p>\n","auth":{"type":"bearer","bearer":{"basicConfig":[{"key":"token","value":"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJhdWQiOlsiYmFzaWNfcmVzb3VyY2UiXSwidXNlcl9uYW1lIjoiWFhYWFhYWFhYIiwic2NvcGUiOlsicmVhZCIsIndyaXRlIl0sImV4cCI6MTU1MzI5ODgxMywiYXV0aG9yaXRpZXMiOlsiUk9MRV9VU0VSIl0sImp0aSI6Ijk0MzY4Y2I5LWJhNmYtNGQ5ZS1iMDMzLTNiYWZkN2QwYzQ3NSIsImNsaWVudF9pZCI6IjZnTkQ2dDJ0cDJXZms1c0pOQVlmcXVXUWV0YXVraGFiIn0.J7B4XtX9scXuITJfeg87av2lh3ZunYO1hkBjMs5_ku8"}]},"isInherited":false},"event":[{"listen":"prerequest","script":{"id":"3c031d9b-7ae3-4dd5-b704-3694a7b2f158","type":"text/javascript","exec":[""]}},{"listen":"test","script":{"id":"87216255-447f-4629-b885-b24db2c4ead4","type":"text/javascript","exec":[""]}}],"_postman_id":"4c0a64b5-a90f-4b0a-bfaf-1bbf05d7f9b8"},{"name":"Instruction to create S3 Role for Sources and Sinks","item":[],"id":"1d5fd942-96eb-4541-a91f-e9331c918f94","description":"<hr />\n<h2 id=\"creating-policy-for-a-bucket\">Creating Policy for a Bucket</h2>\n<ol>\n<li><p>Open the Amazon <a href=\"https://console.aws.amazon.com/iam/home\">IAM console</a></p>\n</li>\n<li><p>Click <strong>\"Policies\"</strong>, then <strong>\"Create policy\"</strong>\n<img src=\"https://lh5.googleusercontent.com/1eaTRGpgmNDAlBPBaI8Z8mRA565YlGt4VQeyfkUZGsKxT0aUdxW-yZKfBiRSpiUIwCPyGfIPQO0zVyufYa9an9TNcc6NR8J2lh2B0_JaeacJvU1dI6M6TLuVrIhseqasQaxeGAw4\" alt=\"Policies\" />\n<img src=\"https://lh6.googleusercontent.com/g3bFJvbgNUGzNAQQpp9fgnTKRBFIFnwZYOF3cpQLRmW2i92PA1dqv-xKSIwrRB9UhfoB94D0NOfskBZxYgNOQ4Q5oPO9yJYxvzzoT0EpVbj0gq1QS0fF8wDTIAODVlZtXJqL592D\" alt=\"Create policy\" /></p>\n</li>\n<li><p>Create a policy with a restricted access to S3 service and to a certain bucket / objects. \nFor example, create a policy with full permissions to a specific bucket <code>someofmybuckets123</code>.\n<img src=\"https://lh5.googleusercontent.com/4blrCfc4woy2M-zOJ0R-utEtdUontQsdBuINlZkNx2vh9Hh7-8Yk7ccbm-0UqOQhFvKw0L0mYbApIZnJTuX8zp0dzAaBVPc5WUGab5Lr34sBnXobWBG0mnsTIAXHnWbcOgZxSn4A\" alt=\"Example of policy permissions\" /></p>\n</li>\n<li><p>Click <strong>\"Review Policy\"</strong>, name it and click <strong>\"Create Policy\"</strong>.</p>\n</li>\n</ol>\n<hr />\n<h2 id=\"creating-role\">Creating Role</h2>\n<ol>\n<li>Open the Amazon <a href=\"https://console.aws.amazon.com/iam/home\">IAM console</a>.</li>\n<li>Click <strong>\"Roles\"</strong>, then <strong>\"Create role\"</strong></li>\n<li>Select \"Another AWS Role\" as a trusted entity, and use <strong>383414648305</strong> as Account ID (Sonra AWS Account)\n<img src=\"https://lh3.googleusercontent.com/cP_INnuWDgZlgQ_oqf3xh8yw_c-dmkowMLRqcSexxPB8sqoih6PoT5vqDfpNPGkZ4eVap8PeFF9jqecKVgulOQ93YsK2HcbiYI-iOjOhSf9C5a8bXlgab7bNeSZ8bnuk5ewhp4Ek\" alt=\"Sonra AWS Account Role\" /></li>\n<li>Click - <strong>\"Next: permissions\"</strong> and select the Policy we created before with access to S3.\n<img src=\"https://lh3.googleusercontent.com/U3W1zRbNRSk72Ypf6u9mnC9jl3j-ObtkSyKTr9X7a7XBQ7uQIAjbLCIaKFKg16hU3E3UW6F1Re3kVIAEr1M-BnMZjW-ynqKhV0SrepxU4gpcBq8gjI16sn4l8vH0U_E5pW6cXYSa\" alt=\"Attaching policy\" /></li>\n<li>Click <strong>\"Next - tags\"</strong> - <strong>\"Review\"</strong>, name Role and click <strong>\"Create role\"</strong></li>\n</ol>\n<hr />\n<h2 id=\"using-role\">Using role</h2>\n<p>Once role is created, select it in a list and open</p>\n<p><img src=\"https://lh6.googleusercontent.com/vzbDLfHEotJ_SQwmkWiGK3oxu3J6TiOZZtmOFnRDTHvw6XzdVhftlQeaixXula7u90dtVwR8R8RdWvx5mOimW2i4XJxt9VoydppcOWHkJ6h7QqTjeH0VD2EjbscLd_ElVeqmGtEM\" alt=\"Use role\" /></p>\n<p>Copy Role ARN and use it for creating S3 Sources and Sinks</p>\n","event":[{"listen":"prerequest","script":{"id":"fc65422c-6ea4-46f0-a62c-26b975e9efac","type":"text/javascript","exec":[""]}},{"listen":"test","script":{"id":"cdca3169-c8a9-4b6b-b855-fe7ec4594919","type":"text/javascript","exec":[""]}}],"_postman_id":"1d5fd942-96eb-4541-a91f-e9331c918f94"},{"name":"Get Data Source Copy","id":"69bdecdd-84c4-4eaf-b970-300f05f5ae41","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[{"description":"<p>Put access token here, which you get after successfull authentication</p>\n","key":"Authorization","type":"text","value":"Bearer <access_token>"}],"url":"https://api.sonra.io/data_sources/name","description":"<p>Retreive Data Source information</p>\n","urlObject":{"protocol":"https","path":["data_sources","name"],"host":["api","sonra","io"],"query":[],"variable":[]}},"response":[{"id":"18affac8-8f1a-414f-9dd7-b03ee66b27bf","name":"Get Data Source","originalRequest":{"method":"GET","header":[{"description":"Put access token here, which you get after successfull authentication","key":"Authorization","type":"text","value":"Bearer <access_token>"}],"url":"https://api.sonra.io/data_sources/2zzz"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Server","value":"nginx/1.15.10"},{"key":"Date","value":"Wed, 24 Jul 2019 07:07:59 GMT"},{"key":"Content-Type","value":"application/json;charset=UTF-8"},{"key":"Transfer-Encoding","value":"chunked"},{"key":"Connection","value":"keep-alive"},{"key":"Access-Control-Allow-Origin","value":"*"},{"key":"Access-Control-Allow-Methods","value":"POST, GET, OPTIONS, DELETE"},{"key":"Access-Control-Allow-Credentials","value":"true"},{"key":"Access-Control-Max-Age","value":"3600"},{"key":"Access-Control-Allow-Headers","value":"x-requested-with, authorization, Content-Type, Authorization, credential, X-XSRF-TOKEN"},{"key":"X-Content-Type-Options","value":"nosniff"},{"key":"X-XSS-Protection","value":"1; mode=block"},{"key":"Cache-Control","value":"no-cache, no-store, max-age=0, must-revalidate"},{"key":"Pragma","value":"no-cache"},{"key":"Expires","value":"0"},{"key":"X-Frame-Options","value":"DENY"}],"cookie":[],"responseTime":null,"body":"{\n    \"name\": \"2zzz\",\n    \"type\": \"xml\",\n    \"source_type\": \"uploaded_file\",\n    \"path\": \"xxx\",\n    \"size\": 6844,\n    \"create_date\": \"2019-05-06T09:19:09.471+0000\"\n}"}],"_postman_id":"69bdecdd-84c4-4eaf-b970-300f05f5ae41"}],"event":[{"listen":"prerequest","script":{"id":"e6f518f9-d511-4b80-9c72-b802402f1ba4","type":"text/javascript","exec":[""]}},{"listen":"test","script":{"id":"2f910f68-0389-42aa-b3bb-fea712df9844","type":"text/javascript","exec":[""]}}],"variable":[{"key":"access_token","value":"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJhdWQiOlsiYmFzaWNfcmVzb3VyY2UiXSwidXNlcl9uYW1lIjoiWFhYWFhYWFhYIiwic2NvcGUiOlsicmVhZCIsIndyaXRlIl0sImV4cCI6MTU1MzI5ODgxMywiYXV0aG9yaXRpZXMiOlsiUk9MRV9VU0VSIl0sImp0aSI6Ijk0MzY4Y2I5LWJhNmYtNGQ5ZS1iMDMzLTNiYWZkN2QwYzQ3NSIsImNsaWVudF9pZCI6IjZnTkQ2dDJ0cDJXZms1c0pOQVlmcXVXUWV0YXVraGFiIn0.J7B4XtX9scXuITJfeg87av2lh3ZunYO1hkBjMs5_ku8"}]}