{"info":{"_postman_id":"44ab3050-4e34-4b40-87f8-6f3eb220b8c1","name":"KBC Samples","description":"Sample Requests for [KBC APIs](https://developers.keboola.com/overview/api/)","schema":"https://schema.getpostman.com/json/collection/v2.0.0/collection.json"},"item":[{"name":"Jobs","item":[{"name":"Get Components in Project","id":"11da3fbe-4880-48ff-a299-0536acfe6153","request":{"method":"GET","header":[{"key":"X-StorageApi-Token","value":"{{token}}"}],"url":"https://connection.keboola.com/v2/storage/components","description":"[List Components](https://keboola.docs.apiary.io/#reference/component-configurations/list-components/get-components) which have an existing configuration in the given project."},"response":[{"id":"d2dcb4da-267a-4cb2-94c5-b92b4cc4d1e8","name":"Get Component List","originalRequest":{"method":"GET","header":[{"key":"X-StorageApi-Token","value":"{{token}}"}],"url":"https://connection.keboola.com/v2/storage/components"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Access-Control-Allow-Origin","value":"*","name":"Access-Control-Allow-Origin","description":""},{"key":"Cache-Control","value":"private, no-cache, no-store, must-revalidate","name":"Cache-Control","description":""},{"key":"Connection","value":"keep-alive","name":"Connection","description":""},{"key":"Content-Encoding","value":"gzip","name":"Content-Encoding","description":""},{"key":"Content-Length","value":"850","name":"Content-Length","description":""},{"key":"Content-Security-Policy","value":"default-src none; script-src 'self' 'unsafe-inline' 'unsafe-eval' assets-cdn.keboola.com d38qy9k7n8xp7k.cloudfront.net assets.zendesk.com www.google-analytics.com ajax.googleapis.com apis.google.com www.googletagmanager.com www.gstatic.com js-agent.newrelic.com bam.nr-data.net kbc-uis.s3.amazonaws.com www.google.com www.dropbox.com; style-src 'self' 'unsafe-inline' assets-cdn.keboola.com cloud.typography.com d38qy9k7n8xp7k.cloudfront.net kbc-uis.s3.amazonaws.com www.google.com ajax.googleapis.com; img-src * data:; media-src assets-cdn.keboola.com; font-src data: assets-cdn.keboola.com cloud.typography.com; worker-src 'self' blob:; child-src blob:; connect-src * 'self'; frame-src docs.google.com accounts.google.com content-sheets.googleapis.com content.googleapis.com www.youtube.com www.google.com; object-src d38qy9k7n8xp7k.cloudfront.net kbc-uis.s3.amazonaws.com; report-uri https://sentry.io/api/90575/csp-report/?sentry_key=718dc19aef5e4a77b8a7bf06cda52f75","name":"Content-Security-Policy","description":""},{"key":"Content-Type","value":"application/json","name":"Content-Type","description":""},{"key":"Date","value":"Mon, 06 Nov 2017 12:30:37 GMT","name":"Date","description":""},{"key":"Server","value":"Apache","name":"Server","description":""},{"key":"Strict-Transport-Security","value":"max-age=31536000","name":"Strict-Transport-Security","description":""},{"key":"Vary","value":"Accept-Encoding","name":"Vary","description":""},{"key":"X-Content-Type-Options","value":"nosniff","name":"X-Content-Type-Options","description":""},{"key":"X-Frame-Options","value":"DENY","name":"X-Frame-Options","description":""},{"key":"X-Powered-By","value":"PHP/7.1.5","name":"X-Powered-By","description":""},{"key":"X-XSS-Protection","value":"1; mode=block","name":"X-XSS-Protection","description":""}],"cookie":[],"responseTime":null,"body":"[{\"id\":\"keboola.ex-db-snowflake\",\"type\":\"extractor\",\"name\":\"Snowflake\",\"description\":\"Cloud-Native Elastic Data Warehouse Service\",\"longDescription\":null,\"hasUI\":false,\"hasRun\":false,\"ico32\":\"https:\\/\\/assets-cdn.keboola.com\\/developer-portal\\/icons\\/keboola.ex-db-snowflake\\/32\\/2.png\",\"ico64\":\"https:\\/\\/assets-cdn.keboola.com\\/developer-portal\\/icons\\/keboola.ex-db-snowflake\\/64\\/2.png\",\"data\":{\"definition\":{\"type\":\"aws-ecr\",\"uri\":\"147946154733.dkr.ecr.us-east-1.amazonaws.com\\/developer-portal-v2\\/keboola.ex-db-snowflake\",\"tag\":\"1.2.5\"},\"vendor\":{\"contact\":[\"Keboola\",\"K\\u0159i\\u017e\\u00edkova 488\\/115, Praha, CZ\",\"support@keboola.com\"],\"licenseUrl\":\"https:\\/\\/raw.githubusercontent.com\\/keboola\\/db-extractor-snowflake\\/master\\/LICENSE.md\"},\"configuration_format\":\"yaml\",\"network\":\"bridge\",\"cpu_shares\":1024,\"memory\":\"512m\",\"process_timeout\":21600,\"forward_token\":false,\"forward_token_details\":false,\"default_bucket\":false,\"default_bucket_stage\":\"in\",\"staging_storage\":{\"input\":\"local\"},\"synchronous_actions\":[\"testConnection\",\"getTables\"]},\"flags\":[\"genericDockerUI\",\"encrypt\"],\"configurationSchema\":{},\"emptyConfiguration\":{},\"uiOptions\":{},\"configurationDescription\":null,\"uri\":\"https:\\/\\/syrup.keboola.com\\/docker\\/keboola.ex-db-snowflake\",\"documentationUrl\":\"https:\\/\\/github.com\\/keboola\\/db-extractor-snowflake\\/blob\\/master\\/README.md\",\"configurations\":[{\"id\":\"328864809\",\"name\":\"Sample database\",\"description\":\"\",\"created\":\"2017-11-06T13:28:48+0100\",\"creatorToken\":{\"id\":27865,\"description\":\"ondrej.popelka@keboola.com\"},\"version\":3,\"changeDescription\":\"Create query account\",\"isDeleted\":false,\"currentVersion\":{\"created\":\"2017-11-06T13:30:12+0100\",\"creatorToken\":{\"id\":27865,\"description\":\"ondrej.popelka@keboola.com\"},\"changeDescription\":\"Create query account\"}}]}]"}],"_postman_id":"11da3fbe-4880-48ff-a299-0536acfe6153"},{"name":"Run Job","id":"3f9735d1-bdb7-4914-a923-3d3c3236e82c","request":{"method":"POST","header":[{"key":"X-StorageApi-Token","value":"{{token}}"},{"key":"Content-Type","value":"application/json"}],"body":{"mode":"raw","raw":"{\r\n    \"config\": \"{{configurationId}}\"\r\n}"},"url":"https://syrup.keboola.com/docker/{{componentId}}/run","description":"[Run a job API](https://kebooladocker.docs.apiary.io/#reference/run/create-a-job/run-job)"},"response":[{"id":"5a05bacf-1625-4633-a4c5-a64ee5092698","name":"Run Job","originalRequest":{"method":"POST","header":[{"key":"X-StorageApi-Token","value":"{{token}}"},{"key":"Content-Type","value":"application/json"}],"body":{"mode":"raw","raw":"{\r\n    \"config\": \"328864809\"\r\n}"},"url":"https://syrup.keboola.com/docker/keboola.ex-db-snowflake/run"},"status":"Accepted","code":202,"_postman_previewlanguage":"json","header":[{"key":"Access-Control-Allow-Headers","value":"*","name":"Access-Control-Allow-Headers","description":""},{"key":"Access-Control-Allow-Methods","value":"*","name":"Access-Control-Allow-Methods","description":""},{"key":"Access-Control-Allow-Origin","value":"*","name":"Access-Control-Allow-Origin","description":""},{"key":"Cache-Control","value":"must-revalidate, no-cache, no-store, private","name":"Cache-Control","description":""},{"key":"Connection","value":"keep-alive","name":"Connection","description":""},{"key":"Content-Encoding","value":"gzip","name":"Content-Encoding","description":""},{"key":"Content-Length","value":"103","name":"Content-Length","description":""},{"key":"Content-Type","value":"application/json","name":"Content-Type","description":""},{"key":"Date","value":"Mon, 06 Nov 2017 12:35:41 GMT","name":"Date","description":""},{"key":"Server","value":"Apache","name":"Server","description":""},{"key":"Vary","value":"Accept-Encoding","name":"Vary","description":""},{"key":"X-Powered-By","value":"PHP/5.6.31","name":"X-Powered-By","description":""}],"cookie":[],"responseTime":null,"body":"{\"id\":\"328865608\",\"url\":\"https:\\/\\/syrup.keboola.com\\/queue\\/job\\/328865608\",\"status\":\"waiting\"}"}],"_postman_id":"3f9735d1-bdb7-4914-a923-3d3c3236e82c"},{"name":"Get Job Status","id":"cca05456-200c-4a45-929b-b9e169ee4159","request":{"method":"GET","header":[{"key":"X-StorageApi-Token","value":"{{token}}"}],"url":"https://syrup.keboola.com/queue/job/{{jobId}}","description":"Returns [Job Status](https://syrupqueue.docs.apiary.io/#reference/jobs/job/view-job-detail). Run this request in a loop until the job is finished."},"response":[{"id":"ec9caa7d-b552-40a3-ae26-f6c57e63d45c","name":"Get Job Status","originalRequest":{"method":"GET","header":[{"key":"X-StorageApi-Token","value":"{{token}}"}],"url":"https://syrup.keboola.com/queue/job/328865608"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Access-Control-Allow-Headers","value":"*","name":"Access-Control-Allow-Headers","description":""},{"key":"Access-Control-Allow-Methods","value":"*","name":"Access-Control-Allow-Methods","description":""},{"key":"Access-Control-Allow-Origin","value":"*","name":"Access-Control-Allow-Origin","description":""},{"key":"Cache-Control","value":"must-revalidate, no-cache, no-store, private","name":"Cache-Control","description":""},{"key":"Connection","value":"keep-alive","name":"Connection","description":""},{"key":"Content-Encoding","value":"gzip","name":"Content-Encoding","description":""},{"key":"Content-Length","value":"590","name":"Content-Length","description":""},{"key":"Content-Type","value":"application/json","name":"Content-Type","description":""},{"key":"Date","value":"Mon, 06 Nov 2017 13:04:24 GMT","name":"Date","description":""},{"key":"Server","value":"Apache","name":"Server","description":""},{"key":"Vary","value":"Accept-Encoding","name":"Vary","description":""},{"key":"X-Powered-By","value":"PHP/5.6.31","name":"X-Powered-By","description":""}],"cookie":[],"responseTime":null,"body":"{\"id\":328865608,\"runId\":\"328865609\",\"lockName\":\"docker-572-keboola.ex-db-snowflake-328864809\",\"project\":{\"id\":572,\"name\":\"Testing\"},\"token\":{\"id\":\"27865\",\"description\":\"ondrej.popelka@keboola.com\"},\"component\":\"docker\",\"command\":\"run\",\"params\":{\"config\":328864809,\"component\":\"keboola.ex-db-snowflake\",\"mode\":\"run\"},\"result\":{\"message\":\"Component processing finished.\",\"images\":[[{\"id\":\"147946154733.dkr.ecr.us-east-1.amazonaws.com\\/developer-portal-v2\\/keboola.ex-db-snowflake:1.2.5\",\"digests\":[\"147946154733.dkr.ecr.us-east-1.amazonaws.com\\/developer-portal-v2\\/keboola.ex-db-snowflake@sha256:84aaf9ed2b233da38d47f6f53a386ae53f0d12dbb8c6046494923c0a173c25af\"]}]]},\"status\":\"success\",\"process\":{\"host\":\"kbc-us-east-1-syrup-docker-i-0a8853007e0a668e1\",\"pid\":69880},\"createdTime\":\"2017-11-06T13:35:41+01:00\",\"startTime\":\"2017-11-06T13:35:41+01:00\",\"endTime\":\"2017-11-06T13:36:23+01:00\",\"durationSeconds\":42,\"waitSeconds\":0,\"nestingLevel\":0,\"encrypted\":true,\"error\":null,\"errorNote\":null,\"terminatedBy\":{\"id\":null,\"description\":null},\"usage\":[],\"_index\":\"prod_syrup_docker_2017_3\",\"_type\":\"jobs\",\"isFinished\":true}"}],"_postman_id":"cca05456-200c-4a45-929b-b9e169ee4159"}],"id":"54b62008-25b2-4fc5-af6f-dfa57940c5eb","description":"Commonly used requests related to running Jobs in KBC.","_postman_id":"54b62008-25b2-4fc5-af6f-dfa57940c5eb"},{"name":"Configurations","item":[{"name":"Get Components","id":"f12bc0de-dd03-4995-a508-6b4a29691d5d","request":{"method":"GET","header":[],"url":"https://connection.keboola.com/v2/storage","description":"Return a list of all [available components](https://keboola.docs.apiary.io/#reference/miscellaneous/api-index/get-components)."},"response":[{"id":"a82f6001-4ab5-4e54-a8e5-19929ef4067f","name":"Get Components","originalRequest":{"method":"GET","header":[],"url":"https://connection.keboola.com/v2/storage"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Access-Control-Allow-Origin","value":"*","name":"Access-Control-Allow-Origin","description":""},{"key":"Cache-Control","value":"private, no-cache, no-store, must-revalidate","name":"Cache-Control","description":""},{"key":"Connection","value":"keep-alive","name":"Connection","description":""},{"key":"Content-Encoding","value":"gzip","name":"Content-Encoding","description":""},{"key":"Content-Security-Policy","value":"default-src none; script-src 'self' 'unsafe-inline' 'unsafe-eval' assets-cdn.keboola.com d38qy9k7n8xp7k.cloudfront.net assets.zendesk.com www.google-analytics.com ajax.googleapis.com apis.google.com www.googletagmanager.com www.gstatic.com js-agent.newrelic.com bam.nr-data.net kbc-uis.s3.amazonaws.com www.google.com www.dropbox.com; style-src 'self' 'unsafe-inline' assets-cdn.keboola.com cloud.typography.com d38qy9k7n8xp7k.cloudfront.net kbc-uis.s3.amazonaws.com www.google.com ajax.googleapis.com; img-src * data:; media-src assets-cdn.keboola.com; font-src data: assets-cdn.keboola.com cloud.typography.com; worker-src 'self' blob:; child-src blob:; connect-src * 'self'; frame-src docs.google.com accounts.google.com content-sheets.googleapis.com content.googleapis.com www.youtube.com www.google.com; object-src d38qy9k7n8xp7k.cloudfront.net kbc-uis.s3.amazonaws.com; report-uri https://sentry.io/api/90575/csp-report/?sentry_key=718dc19aef5e4a77b8a7bf06cda52f75","name":"Content-Security-Policy","description":""},{"key":"Content-Type","value":"application/json","name":"Content-Type","description":""},{"key":"Date","value":"Mon, 06 Nov 2017 13:19:26 GMT","name":"Date","description":""},{"key":"Server","value":"Apache","name":"Server","description":""},{"key":"Strict-Transport-Security","value":"max-age=31536000","name":"Strict-Transport-Security","description":""},{"key":"Transfer-Encoding","value":"chunked","name":"Transfer-Encoding","description":""},{"key":"Vary","value":"Accept-Encoding","name":"Vary","description":""},{"key":"X-Content-Type-Options","value":"nosniff","name":"X-Content-Type-Options","description":""},{"key":"X-Frame-Options","value":"DENY","name":"X-Frame-Options","description":""},{"key":"X-Powered-By","value":"PHP/7.1.5","name":"X-Powered-By","description":""},{"key":"X-XSS-Protection","value":"1; mode=block","name":"X-XSS-Protection","description":""}],"cookie":[],"responseTime":null,"body":"{\n    \"host\": \"6f151bc57e25\",\n    \"api\": \"storage\",\n    \"version\": \"v2\",\n    \"revision\": \"11dc5566bfe7d09ec93dfa7c252423904408891e\",\n    \"documentation\": \"http://docs.keboola.apiary.io/\",\n    \"components\": [\n        {\n            \"id\": \"keboola.ex-db-snowflake\",\n            \"type\": \"extractor\",\n            \"name\": \"Snowflake\",\n            \"description\": \"Cloud-Native Elastic Data Warehouse Service\",\n            \"longDescription\": null,\n            \"hasUI\": false,\n            \"hasRun\": false,\n            \"ico32\": \"https://assets-cdn.keboola.com/developer-portal/icons/keboola.ex-db-snowflake/32/2.png\",\n            \"ico64\": \"https://assets-cdn.keboola.com/developer-portal/icons/keboola.ex-db-snowflake/64/2.png\",\n            \"data\": {\n                \"definition\": {\n                    \"type\": \"aws-ecr\",\n                    \"uri\": \"147946154733.dkr.ecr.us-east-1.amazonaws.com/developer-portal-v2/keboola.ex-db-snowflake\",\n                    \"tag\": \"1.2.5\"\n                },\n                \"vendor\": {\n                    \"contact\": [\n                        \"Keboola\",\n                        \"Křižíkova 488/115, Praha, CZ\",\n                        \"support@keboola.com\"\n                    ],\n                    \"licenseUrl\": \"https://raw.githubusercontent.com/keboola/db-extractor-snowflake/master/LICENSE.md\"\n                },\n                \"configuration_format\": \"yaml\",\n                \"network\": \"bridge\",\n                \"cpu_shares\": 1024,\n                \"memory\": \"512m\",\n                \"process_timeout\": 21600,\n                \"forward_token\": false,\n                \"forward_token_details\": false,\n                \"default_bucket\": false,\n                \"default_bucket_stage\": \"in\",\n                \"staging_storage\": {\n                    \"input\": \"local\"\n                },\n                \"synchronous_actions\": [\n                    \"testConnection\",\n                    \"getTables\"\n                ]\n            },\n            \"flags\": [\n                \"genericDockerUI\",\n                \"encrypt\"\n            ],\n            \"configurationSchema\": {},\n            \"emptyConfiguration\": {},\n            \"uiOptions\": {},\n            \"configurationDescription\": null,\n            \"uri\": \"https://syrup.keboola.com/docker/keboola.ex-db-snowflake\",\n            \"documentationUrl\": \"https://github.com/keboola/db-extractor-snowflake/blob/master/README.md\"\n        }\n    ],\n    \"services\": [\n        {\n            \"id\": \"docker-runner\",\n            \"url\": \"https://docker-runner.keboola.com\"\n        },\n        {\n            \"id\": \"import\",\n            \"url\": \"https://import.keboola.com\"\n        },\n        {\n            \"id\": \"syrup\",\n            \"url\": \"https://syrup.keboola.com\"\n        }\n    ],\n    \"urlTemplates\": {\n        \"orchestrationJob\": \"/admin/projects/&&projectId&&/orchestrations/&&orchestrationId&&/jobs/&&jobId&&\"\n    }\n}"}],"_postman_id":"f12bc0de-dd03-4995-a508-6b4a29691d5d"},{"name":"List Component Configurations","id":"f54e56dd-8cf9-448d-babd-5de303088d57","request":{"method":"GET","header":[{"key":"X-StorageAPI-Token","value":"{{token}}"}],"url":"https://connection.keboola.com/v2/storage/components/{{componentId}}/configs","description":"[List existing configurations](http://docs.keboola.apiary.io/#reference/component-configurations/component-configs/list-configs) of a given component."},"response":[],"_postman_id":"f54e56dd-8cf9-448d-babd-5de303088d57"},{"name":"List Configuration Versions","id":"3be00536-67f5-4700-96a0-26ba14ad0e68","request":{"method":"GET","header":[{"key":"X-StorageAPI-Token","value":"{{token}}"}],"url":"https://connection.keboola.com/v2/storage/components/{{componentId}}/configs/{{configurationId}}/versions","description":"[List versions](http://docs.keboola.apiary.io/#reference/component-configurations/list-configs-versions/versions-list) of the given configuration."},"response":[{"id":"ce22b1d5-3ea3-47de-9227-0588d27bfbc1","name":"S3 Extractor configuration versions","originalRequest":{"method":"GET","header":[{"key":"X-StorageAPI-Token","value":"{{token}}"}],"url":"https://connection.keboola.com/v2/storage/components/keboola.ex-aws-s3/configs/364479526/versions"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Access-Control-Allow-Origin","value":"*","name":"Access-Control-Allow-Origin","description":"Specifies a URI that may access the resource. For requests without credentials, the server may specify '*' as a wildcard, thereby allowing any origin to access the resource."},{"key":"Cache-Control","value":"private, no-cache, no-store, must-revalidate","name":"Cache-Control","description":"Tells all caching mechanisms from server to client whether they may cache this object. It is measured in seconds"},{"key":"Connection","value":"keep-alive","name":"Connection","description":"Options that are desired for the connection"},{"key":"Content-Encoding","value":"gzip","name":"Content-Encoding","description":"The type of encoding used on the data."},{"key":"Content-Length","value":"241","name":"Content-Length","description":"The length of the response body in octets (8-bit bytes)"},{"key":"Content-Security-Policy","value":"default-src none; script-src 'self' 'unsafe-inline' 'unsafe-eval' assets-cdn.keboola.com d38qy9k7n8xp7k.cloudfront.net assets.zendesk.com www.google-analytics.com ajax.googleapis.com apis.google.com www.googletagmanager.com www.gstatic.com js-agent.newrelic.com bam.nr-data.net kbc-uis.s3.amazonaws.com www.google.com www.dropbox.com; style-src 'self' 'unsafe-inline' assets-cdn.keboola.com cloud.typography.com d38qy9k7n8xp7k.cloudfront.net kbc-uis.s3.amazonaws.com www.google.com ajax.googleapis.com; img-src * data:; media-src assets-cdn.keboola.com; font-src data: assets-cdn.keboola.com cloud.typography.com; worker-src 'self' blob:; child-src blob:; connect-src * 'self'; frame-src docs.google.com accounts.google.com content-sheets.googleapis.com content.googleapis.com www.youtube.com www.google.com; object-src d38qy9k7n8xp7k.cloudfront.net kbc-uis.s3.amazonaws.com; report-uri https://sentry.io/api/90575/csp-report/?sentry_key=718dc19aef5e4a77b8a7bf06cda52f75","name":"Content-Security-Policy","description":"Custom header"},{"key":"Content-Type","value":"application/json","name":"Content-Type","description":"The mime type of this content"},{"key":"Date","value":"Thu, 08 Mar 2018 14:46:08 GMT","name":"Date","description":"The date and time that the message was sent"},{"key":"Server","value":"Apache","name":"Server","description":"A name for the server"},{"key":"Strict-Transport-Security","value":"max-age=31536000","name":"Strict-Transport-Security","description":"A HSTS Policy informing the HTTP client how long to cache the HTTPS only policy and whether this applies to subdomains."},{"key":"Vary","value":"Accept-Encoding","name":"Vary","description":"Tells downstream proxies how to match future request headers to decide whether the cached response can be used rather than requesting a fresh one from the origin server."},{"key":"X-Content-Type-Options","value":"nosniff","name":"X-Content-Type-Options","description":"The only defined value, \"nosniff\", prevents Internet Explorer from MIME-sniffing a response away from the declared content-type"},{"key":"X-Frame-Options","value":"DENY","name":"X-Frame-Options","description":"Clickjacking protection: \"deny\" - no rendering within a frame, \"sameorigin\" - no rendering if origin mismatch"},{"key":"X-Powered-By","value":"PHP/7.1.11","name":"X-Powered-By","description":"Specifies the technology (ASP.NET, PHP, JBoss, e.g.) supporting the web application (version details are often in X-Runtime, X-Version, or X-AspNet-Version)"},{"key":"X-XSS-Protection","value":"1; mode=block","name":"X-XSS-Protection","description":"Cross-site scripting (XSS) filter"}],"cookie":[],"responseTime":null,"body":"[{\"version\":4,\"created\":\"2018-03-08T15:21:28+0100\",\"creatorToken\":{\"id\":27865,\"description\":\"ondrej.popelka@keboola.com\"},\"changeDescription\":\"Table first table edited\",\"isDeleted\":false,\"name\":\"test\",\"description\":\"\"},{\"version\":3,\"created\":\"2018-03-08T14:58:33+0100\",\"creatorToken\":{\"id\":27865,\"description\":\"ondrej.popelka@keboola.com\"},\"changeDescription\":\"Table first table added\",\"isDeleted\":false,\"name\":\"test\",\"description\":\"\"},{\"version\":2,\"created\":\"2018-03-08T14:55:50+0100\",\"creatorToken\":{\"id\":27865,\"description\":\"ondrej.popelka@keboola.com\"},\"changeDescription\":\"AWS Credentials edited\",\"isDeleted\":false,\"name\":\"test\",\"description\":\"\"},{\"version\":1,\"created\":\"2018-03-08T14:54:19+0100\",\"creatorToken\":{\"id\":27865,\"description\":\"ondrej.popelka@keboola.com\"},\"changeDescription\":\"\",\"isDeleted\":false,\"name\":\"test\",\"description\":\"\"}]"}],"_postman_id":"3be00536-67f5-4700-96a0-26ba14ad0e68"},{"name":"Create Copy","id":"0e8c0052-8740-41d6-af97-a6ad052f4063","request":{"method":"POST","header":[{"key":"X-StorageAPI-Token","value":"{{token}}"},{"key":"Content-Type","value":"application/x-www-form-urlencoded"}],"body":{"mode":"formdata","formdata":[{"key":"name","value":"{{name}}","type":"text"},{"key":"description","value":"Test Copy","type":"text"}]},"url":"https://connection.keboola.com/v2/storage/components/{{componentId}}/configs/{{configurationId}}/versions/{{versionId}}/create","description":"Create a [configuration copy](https://keboola.docs.apiary.io/#reference/component-configurations/copy-configurations/create-configuration-copy)."},"response":[],"_postman_id":"0e8c0052-8740-41d6-af97-a6ad052f4063"},{"name":"Rollback Configuration","id":"d43b25fa-1b2d-4aed-ad33-f1cef2c33a06","request":{"method":"POST","header":[{"key":"X-StorageAPI-Token","value":"{{token}}"},{"key":"Content-Type","value":"application/x-www-form-urlencoded"}],"url":"https://connection.keboola.com/v2/storage/components/{{componentId}}/configs/{{configurationId}}/versions/{{versionId}}/rollback","description":"[Rollback configuration](https://keboola.docs.apiary.io/#reference/component-configurations/rollback-configuration-version/rollback-version) to the given version."},"response":[{"id":"4e18b49f-fa57-4032-ac01-111e193e4ea8","name":"Rollback S3 Configuration","originalRequest":{"method":"POST","header":[{"key":"X-StorageAPI-Token","value":"{{token}}"},{"key":"Content-Type","value":"application/x-www-form-urlencoded"}],"url":"https://connection.keboola.com/v2/storage/components/keboola.ex-aws-s3/configs/364479526/versions/3/rollback"},"status":"Created","code":201,"_postman_previewlanguage":"json","header":[{"key":"Access-Control-Allow-Origin","value":"*","name":"Access-Control-Allow-Origin","description":"Specifies a URI that may access the resource. For requests without credentials, the server may specify '*' as a wildcard, thereby allowing any origin to access the resource."},{"key":"Cache-Control","value":"private, no-cache, no-store, must-revalidate","name":"Cache-Control","description":"Tells all caching mechanisms from server to client whether they may cache this object. It is measured in seconds"},{"key":"Connection","value":"keep-alive","name":"Connection","description":"Options that are desired for the connection"},{"key":"Content-Length","value":"16","name":"Content-Length","description":"The length of the response body in octets (8-bit bytes)"},{"key":"Content-Security-Policy","value":"default-src none; script-src 'self' 'unsafe-inline' 'unsafe-eval' assets-cdn.keboola.com d38qy9k7n8xp7k.cloudfront.net assets.zendesk.com www.google-analytics.com ajax.googleapis.com apis.google.com www.googletagmanager.com www.gstatic.com js-agent.newrelic.com bam.nr-data.net kbc-uis.s3.amazonaws.com www.google.com www.dropbox.com; style-src 'self' 'unsafe-inline' assets-cdn.keboola.com cloud.typography.com d38qy9k7n8xp7k.cloudfront.net kbc-uis.s3.amazonaws.com www.google.com ajax.googleapis.com; img-src * data:; media-src assets-cdn.keboola.com; font-src data: assets-cdn.keboola.com cloud.typography.com; worker-src 'self' blob:; child-src blob:; connect-src * 'self'; frame-src docs.google.com accounts.google.com content-sheets.googleapis.com content.googleapis.com www.youtube.com www.google.com; object-src d38qy9k7n8xp7k.cloudfront.net kbc-uis.s3.amazonaws.com; report-uri https://sentry.io/api/90575/csp-report/?sentry_key=718dc19aef5e4a77b8a7bf06cda52f75","name":"Content-Security-Policy","description":"Custom header"},{"key":"Content-Type","value":"application/json","name":"Content-Type","description":"The mime type of this content"},{"key":"Date","value":"Sun, 11 Mar 2018 23:01:39 GMT","name":"Date","description":"The date and time that the message was sent"},{"key":"Server","value":"Apache","name":"Server","description":"A name for the server"},{"key":"Strict-Transport-Security","value":"max-age=31536000","name":"Strict-Transport-Security","description":"A HSTS Policy informing the HTTP client how long to cache the HTTPS only policy and whether this applies to subdomains."},{"key":"X-Content-Type-Options","value":"nosniff","name":"X-Content-Type-Options","description":"The only defined value, \"nosniff\", prevents Internet Explorer from MIME-sniffing a response away from the declared content-type"},{"key":"X-Frame-Options","value":"DENY","name":"X-Frame-Options","description":"Clickjacking protection: \"deny\" - no rendering within a frame, \"sameorigin\" - no rendering if origin mismatch"},{"key":"X-Powered-By","value":"PHP/7.1.11","name":"X-Powered-By","description":"Specifies the technology (ASP.NET, PHP, JBoss, e.g.) supporting the web application (version details are often in X-Runtime, X-Version, or X-AspNet-Version)"},{"key":"X-XSS-Protection","value":"1; mode=block","name":"X-XSS-Protection","description":"Cross-site scripting (XSS) filter"}],"cookie":[],"responseTime":null,"body":"{\"version\":\"26\"}"}],"_postman_id":"d43b25fa-1b2d-4aed-ad33-f1cef2c33a06"},{"name":"Component Configuration Detail","id":"1c9905d5-eca2-4416-bc05-4cb7b8f685aa","request":{"method":"GET","header":[{"key":"X-StorageAPI-Token","value":"{{token}}"}],"url":"https://connection.keboola.com/v2/storage/components/{{componentId}}/configs/{{configurationId}}","description":"[Show details](https://keboola.docs.apiary.io/#reference/component-configurations/component-configurations/configuration-detail) of a given component configuration."},"response":[{"id":"0f4d4f2e-05e6-4b54-a0ad-b4a369eadcff","name":"S3 Extractor Configuration Detail","originalRequest":{"method":"GET","header":[{"key":"X-StorageAPI-Token","value":"{{token}}"}],"url":"https://connection.keboola.com/v2/storage/components/{{componentId}}/configs/{{configurationId}}"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Access-Control-Allow-Origin","value":"*","name":"Access-Control-Allow-Origin","description":"Specifies a URI that may access the resource. For requests without credentials, the server may specify '*' as a wildcard, thereby allowing any origin to access the resource."},{"key":"Cache-Control","value":"private, no-cache, no-store, must-revalidate","name":"Cache-Control","description":"Tells all caching mechanisms from server to client whether they may cache this object. It is measured in seconds"},{"key":"Connection","value":"keep-alive","name":"Connection","description":"Options that are desired for the connection"},{"key":"Content-Encoding","value":"gzip","name":"Content-Encoding","description":"The type of encoding used on the data."},{"key":"Content-Length","value":"754","name":"Content-Length","description":"The length of the response body in octets (8-bit bytes)"},{"key":"Content-Security-Policy","value":"default-src none; script-src 'self' 'unsafe-inline' 'unsafe-eval' assets-cdn.keboola.com d38qy9k7n8xp7k.cloudfront.net assets.zendesk.com www.google-analytics.com ajax.googleapis.com apis.google.com www.googletagmanager.com www.gstatic.com js-agent.newrelic.com bam.nr-data.net kbc-uis.s3.amazonaws.com www.google.com www.dropbox.com; style-src 'self' 'unsafe-inline' assets-cdn.keboola.com cloud.typography.com d38qy9k7n8xp7k.cloudfront.net kbc-uis.s3.amazonaws.com www.google.com ajax.googleapis.com; img-src * data:; media-src assets-cdn.keboola.com; font-src data: assets-cdn.keboola.com cloud.typography.com; worker-src 'self' blob:; child-src blob:; connect-src * 'self'; frame-src docs.google.com accounts.google.com content-sheets.googleapis.com content.googleapis.com www.youtube.com www.google.com; object-src d38qy9k7n8xp7k.cloudfront.net kbc-uis.s3.amazonaws.com; report-uri https://sentry.io/api/90575/csp-report/?sentry_key=718dc19aef5e4a77b8a7bf06cda52f75","name":"Content-Security-Policy","description":"Custom header"},{"key":"Content-Type","value":"application/json","name":"Content-Type","description":"The mime type of this content"},{"key":"Date","value":"Thu, 08 Mar 2018 16:44:14 GMT","name":"Date","description":"The date and time that the message was sent"},{"key":"Server","value":"Apache","name":"Server","description":"A name for the server"},{"key":"Strict-Transport-Security","value":"max-age=31536000","name":"Strict-Transport-Security","description":"A HSTS Policy informing the HTTP client how long to cache the HTTPS only policy and whether this applies to subdomains."},{"key":"Vary","value":"Accept-Encoding","name":"Vary","description":"Tells downstream proxies how to match future request headers to decide whether the cached response can be used rather than requesting a fresh one from the origin server."},{"key":"X-Content-Type-Options","value":"nosniff","name":"X-Content-Type-Options","description":"The only defined value, \"nosniff\", prevents Internet Explorer from MIME-sniffing a response away from the declared content-type"},{"key":"X-Frame-Options","value":"DENY","name":"X-Frame-Options","description":"Clickjacking protection: \"deny\" - no rendering within a frame, \"sameorigin\" - no rendering if origin mismatch"},{"key":"X-Powered-By","value":"PHP/7.1.11","name":"X-Powered-By","description":"Specifies the technology (ASP.NET, PHP, JBoss, e.g.) supporting the web application (version details are often in X-Runtime, X-Version, or X-AspNet-Version)"},{"key":"X-XSS-Protection","value":"1; mode=block","name":"X-XSS-Protection","description":"Cross-site scripting (XSS) filter"}],"cookie":[],"responseTime":null,"body":"{\"id\":\"364479526\",\"name\":\"test\",\"description\":\"\",\"created\":\"2018-03-08T14:54:19+0100\",\"creatorToken\":{\"id\":27865,\"description\":\"ondrej.popelka@keboola.com\"},\"version\":4,\"changeDescription\":\"Table first table edited\",\"isDeleted\":false,\"configuration\":{\"parameters\":{\"accessKeyId\":\"AKIAIBZYEEXQILP46FCA\",\"#secretAccessKey\":\"KBC::ComponentProjectEncrypted==p5gvUw4RSGiVJjT2ayVORpqS7yiKhExi7NnQECntVm8haHaHtFNVDMT8X8b+htnixpXhPIQ9yV+ETrvr+hNeYfh+Ex+UpC\\/\\/QPWnLcEOC8XOLgmQN8BNgRGSERWUziK0\"}},\"rowsSortOrder\":[],\"rows\":[{\"id\":\"364481153\",\"name\":\"first table\",\"description\":\"\",\"configuration\":{\"parameters\":{\"bucket\":\"travis-php-db-import-tests-s3filesbucket-vm9zhtm5jd7s\",\"key\":\"tw_accounts.csv\",\"saveAs\":\"first-table\",\"includeSubfolders\":false,\"newFilesOnly\":false},\"processors\":{\"after\":[{\"definition\":{\"component\":\"keboola.processor-move-files\"},\"parameters\":{\"direction\":\"tables\",\"addCsvSuffix\":true}},{\"definition\":{\"component\":\"keboola.processor-create-manifest\"},\"parameters\":{\"delimiter\":\",\",\"enclosure\":\"\\\"\",\"incremental\":false,\"primary_key\":[],\"columns\":[],\"columns_from\":\"header\"}},{\"definition\":{\"component\":\"keboola.processor-skip-lines\"},\"parameters\":{\"lines\":1}}]}},\"isDisabled\":false,\"version\":2,\"created\":\"2018-03-08T14:58:33+0100\",\"creatorToken\":{\"id\":27865,\"description\":\"ondrej.popelka@keboola.com\"},\"changeDescription\":\"Table first table edited\",\"state\":{}}],\"state\":{},\"currentVersion\":{\"created\":\"2018-03-08T15:21:28+0100\",\"creatorToken\":{\"id\":27865,\"description\":\"ondrej.popelka@keboola.com\"},\"changeDescription\":\"Table first table edited\"}}"},{"id":"de828d2a-88fb-42b5-bbba-8da6e95155ee","name":"Email Attachments Extractor Configuration Detail","originalRequest":{"method":"GET","header":[{"key":"X-StorageAPI-Token","value":"{{token}}"}],"url":"https://connection.keboola.com/v2/storage/components/keboola.ex-email-attachments/configs/365111648"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Access-Control-Allow-Origin","value":"*","name":"Access-Control-Allow-Origin","description":"Specifies a URI that may access the resource. For requests without credentials, the server may specify '*' as a wildcard, thereby allowing any origin to access the resource."},{"key":"Cache-Control","value":"private, no-cache, no-store, must-revalidate","name":"Cache-Control","description":"Tells all caching mechanisms from server to client whether they may cache this object. It is measured in seconds"},{"key":"Connection","value":"keep-alive","name":"Connection","description":"Options that are desired for the connection"},{"key":"Content-Encoding","value":"gzip","name":"Content-Encoding","description":"The type of encoding used on the data."},{"key":"Content-Length","value":"354","name":"Content-Length","description":"The length of the response body in octets (8-bit bytes)"},{"key":"Content-Security-Policy","value":"default-src none; script-src 'self' 'unsafe-inline' 'unsafe-eval' assets-cdn.keboola.com d38qy9k7n8xp7k.cloudfront.net assets.zendesk.com www.google-analytics.com ajax.googleapis.com apis.google.com www.googletagmanager.com www.gstatic.com js-agent.newrelic.com bam.nr-data.net kbc-uis.s3.amazonaws.com www.google.com www.dropbox.com; style-src 'self' 'unsafe-inline' assets-cdn.keboola.com cloud.typography.com d38qy9k7n8xp7k.cloudfront.net kbc-uis.s3.amazonaws.com www.google.com ajax.googleapis.com; img-src * data:; media-src assets-cdn.keboola.com; font-src data: assets-cdn.keboola.com cloud.typography.com; worker-src 'self' blob:; child-src blob:; connect-src * 'self'; frame-src docs.google.com accounts.google.com content-sheets.googleapis.com content.googleapis.com www.youtube.com www.google.com; object-src d38qy9k7n8xp7k.cloudfront.net kbc-uis.s3.amazonaws.com; report-uri https://sentry.io/api/90575/csp-report/?sentry_key=718dc19aef5e4a77b8a7bf06cda52f75","name":"Content-Security-Policy","description":"Custom header"},{"key":"Content-Type","value":"application/json","name":"Content-Type","description":"The mime type of this content"},{"key":"Date","value":"Sat, 10 Mar 2018 07:20:05 GMT","name":"Date","description":"The date and time that the message was sent"},{"key":"Server","value":"Apache","name":"Server","description":"A name for the server"},{"key":"Strict-Transport-Security","value":"max-age=31536000","name":"Strict-Transport-Security","description":"A HSTS Policy informing the HTTP client how long to cache the HTTPS only policy and whether this applies to subdomains."},{"key":"Vary","value":"Accept-Encoding","name":"Vary","description":"Tells downstream proxies how to match future request headers to decide whether the cached response can be used rather than requesting a fresh one from the origin server."},{"key":"X-Content-Type-Options","value":"nosniff","name":"X-Content-Type-Options","description":"The only defined value, \"nosniff\", prevents Internet Explorer from MIME-sniffing a response away from the declared content-type"},{"key":"X-Frame-Options","value":"DENY","name":"X-Frame-Options","description":"Clickjacking protection: \"deny\" - no rendering within a frame, \"sameorigin\" - no rendering if origin mismatch"},{"key":"X-Powered-By","value":"PHP/7.1.11","name":"X-Powered-By","description":"Specifies the technology (ASP.NET, PHP, JBoss, e.g.) supporting the web application (version details are often in X-Runtime, X-Version, or X-AspNet-Version)"},{"key":"X-XSS-Protection","value":"1; mode=block","name":"X-XSS-Protection","description":"Cross-site scripting (XSS) filter"}],"cookie":[],"responseTime":null,"body":"{\"id\":\"365111648\",\"name\":\"Processor test\",\"description\":\"\",\"created\":\"2018-03-10T08:13:08+0100\",\"creatorToken\":{\"id\":27865,\"description\":\"ondrej.popelka@keboola.com\"},\"version\":3,\"changeDescription\":\"Update name\",\"isDeleted\":false,\"configuration\":{\"parameters\":{\"email\":\"572-365111648-5aa3858e91ed1@import.keboola.com\",\"delimiter\":\",\",\"enclosure\":\"\\\"\",\"primaryKey\":[],\"incremental\":false}},\"rowsSortOrder\":[],\"rows\":[],\"state\":{\"lastDownloadedFileTimestamp\":\"1520666119\"},\"currentVersion\":{\"created\":\"2018-03-10T08:16:54+0100\",\"creatorToken\":{\"id\":27865,\"description\":\"ondrej.popelka@keboola.com\"},\"changeDescription\":\"Update name\"}}"}],"_postman_id":"1c9905d5-eca2-4416-bc05-4cb7b8f685aa"},{"name":"Update configuration","id":"de43e274-4733-49ec-b691-7f4d5946e663","request":{"method":"PUT","header":[{"key":"Content-Type","value":"application/x-www-form-urlencoded"},{"key":"X-StorageAPI-Token","value":"{{token}}"}],"body":{"mode":"urlencoded","urlencoded":[{"key":"configuration","value":"{{configurationJson}}","type":"text"}]},"url":"https://connection.keboola.com/v2/storage/components/{{componentId}}/configs/{{configurationId}}","description":"[Update an existing configuration](https://keboola.docs.apiary.io/#reference/component-configurations/manage-configurations/update-configuration). Note that the configuration must be sent as an encoded JSON in the form field."},"response":[{"id":"268a217d-0bbe-4aaa-a7e3-8a79bbbfd779","name":"Add processor to Email Attachments Extractor Configuration","originalRequest":{"method":"PUT","header":[{"key":"Content-Type","value":"application/x-www-form-urlencoded"},{"key":"X-StorageAPI-Token","value":"{{token}}"}],"body":{"mode":"urlencoded","urlencoded":[{"key":"configuration","value":"{\n    \"parameters\": {\n        \"email\": \"572-365111648-5aa3858e91ed1@import.keboola.com\",\n        \"delimiter\": \",\",\n        \"enclosure\": \"\\\"\",\n        \"primaryKey\": [],\n        \"incremental\": false\n    },\n    \"processors\": {\n        \"after\": [\n            {\n                \"definition\": {\n                    \"component\": \"keboola.processor-skip-lines\"\n                },\n                \"parameters\": {\n                    \"lines\": 1,\n                    \"direction_from\": \"top\"\n                }\n            }\n        ]\n    }\n}","type":"text"}]},"url":"https://connection.keboola.com/v2/storage/components/keboola.ex-email-attachments/configs/365111648"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Access-Control-Allow-Origin","value":"*","name":"Access-Control-Allow-Origin","description":"Specifies a URI that may access the resource. For requests without credentials, the server may specify '*' as a wildcard, thereby allowing any origin to access the resource."},{"key":"Cache-Control","value":"private, no-cache, no-store, must-revalidate","name":"Cache-Control","description":"Tells all caching mechanisms from server to client whether they may cache this object. It is measured in seconds"},{"key":"Connection","value":"keep-alive","name":"Connection","description":"Options that are desired for the connection"},{"key":"Content-Encoding","value":"gzip","name":"Content-Encoding","description":"The type of encoding used on the data."},{"key":"Content-Length","value":"406","name":"Content-Length","description":"The length of the response body in octets (8-bit bytes)"},{"key":"Content-Security-Policy","value":"default-src none; script-src 'self' 'unsafe-inline' 'unsafe-eval' assets-cdn.keboola.com d38qy9k7n8xp7k.cloudfront.net assets.zendesk.com www.google-analytics.com ajax.googleapis.com apis.google.com www.googletagmanager.com www.gstatic.com js-agent.newrelic.com bam.nr-data.net kbc-uis.s3.amazonaws.com www.google.com www.dropbox.com; style-src 'self' 'unsafe-inline' assets-cdn.keboola.com cloud.typography.com d38qy9k7n8xp7k.cloudfront.net kbc-uis.s3.amazonaws.com www.google.com ajax.googleapis.com; img-src * data:; media-src assets-cdn.keboola.com; font-src data: assets-cdn.keboola.com cloud.typography.com; worker-src 'self' blob:; child-src blob:; connect-src * 'self'; frame-src docs.google.com accounts.google.com content-sheets.googleapis.com content.googleapis.com www.youtube.com www.google.com; object-src d38qy9k7n8xp7k.cloudfront.net kbc-uis.s3.amazonaws.com; report-uri https://sentry.io/api/90575/csp-report/?sentry_key=718dc19aef5e4a77b8a7bf06cda52f75","name":"Content-Security-Policy","description":"Custom header"},{"key":"Content-Type","value":"application/json","name":"Content-Type","description":"The mime type of this content"},{"key":"Date","value":"Sat, 10 Mar 2018 07:32:08 GMT","name":"Date","description":"The date and time that the message was sent"},{"key":"Server","value":"Apache","name":"Server","description":"A name for the server"},{"key":"Strict-Transport-Security","value":"max-age=31536000","name":"Strict-Transport-Security","description":"A HSTS Policy informing the HTTP client how long to cache the HTTPS only policy and whether this applies to subdomains."},{"key":"Vary","value":"Accept-Encoding","name":"Vary","description":"Tells downstream proxies how to match future request headers to decide whether the cached response can be used rather than requesting a fresh one from the origin server."},{"key":"X-Content-Type-Options","value":"nosniff","name":"X-Content-Type-Options","description":"The only defined value, \"nosniff\", prevents Internet Explorer from MIME-sniffing a response away from the declared content-type"},{"key":"X-Frame-Options","value":"DENY","name":"X-Frame-Options","description":"Clickjacking protection: \"deny\" - no rendering within a frame, \"sameorigin\" - no rendering if origin mismatch"},{"key":"X-Powered-By","value":"PHP/7.1.11","name":"X-Powered-By","description":"Specifies the technology (ASP.NET, PHP, JBoss, e.g.) supporting the web application (version details are often in X-Runtime, X-Version, or X-AspNet-Version)"},{"key":"X-XSS-Protection","value":"1; mode=block","name":"X-XSS-Protection","description":"Cross-site scripting (XSS) filter"}],"cookie":[],"responseTime":null,"body":"{\"id\":\"365111648\",\"name\":\"Processor test\",\"description\":\"\",\"created\":\"2018-03-10T08:13:08+0100\",\"creatorToken\":{\"id\":27865,\"description\":\"ondrej.popelka@keboola.com\"},\"version\":4,\"changeDescription\":\"\",\"isDeleted\":false,\"configuration\":{\"parameters\":{\"email\":\"572-365111648-5aa3858e91ed1@import.keboola.com\",\"delimiter\":\",\",\"enclosure\":\"\\\"\",\"primaryKey\":[],\"incremental\":false},\"processors\":{\"after\":[{\"definition\":{\"component\":\"keboola.processor-skip-lines\"},\"parameters\":{\"lines\":1,\"direction_from\":\"top\"}}]}},\"rowsSortOrder\":[],\"rows\":[],\"state\":{\"lastDownloadedFileTimestamp\":\"1520666119\"},\"currentVersion\":{\"created\":\"2018-03-10T08:32:08+0100\",\"creatorToken\":{\"id\":27865,\"description\":\"ondrej.popelka@keboola.com\"},\"changeDescription\":\"\"}}"},{"id":"3bffe16f-517d-4cc1-b87c-b7dfcad2aaf4","name":"Update AWS S3 configuration to set new credentials","originalRequest":{"method":"PUT","header":[{"key":"Content-Type","type":"text","name":"Content-Type","value":"application/x-www-form-urlencoded"},{"key":"X-StorageAPI-Token","value":"{{token}}"}],"body":{"mode":"urlencoded","urlencoded":[{"key":"configuration","value":"{\n\t\"parameters\": {\n\t\t\"accessKeyId\": \"a\",\n\t\t\"#secretAccessKey\": \"b\"\n\t}\n}","type":"text"}]},"url":"https://connection.keboola.com/v2/storage/components/keboola.ex-aws-s3/configs/364479526"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Access-Control-Allow-Origin","value":"*","name":"Access-Control-Allow-Origin","description":"Specifies a URI that may access the resource. For requests without credentials, the server may specify '*' as a wildcard, thereby allowing any origin to access the resource."},{"key":"Cache-Control","value":"private, no-cache, no-store, must-revalidate","name":"Cache-Control","description":"Tells all caching mechanisms from server to client whether they may cache this object. It is measured in seconds"},{"key":"Connection","value":"keep-alive","name":"Connection","description":"Options that are desired for the connection"},{"key":"Content-Encoding","value":"gzip","name":"Content-Encoding","description":"The type of encoding used on the data."},{"key":"Content-Length","value":"643","name":"Content-Length","description":"The length of the response body in octets (8-bit bytes)"},{"key":"Content-Security-Policy","value":"default-src none; script-src 'self' 'unsafe-inline' 'unsafe-eval' assets-cdn.keboola.com d38qy9k7n8xp7k.cloudfront.net assets.zendesk.com www.google-analytics.com ajax.googleapis.com apis.google.com www.googletagmanager.com www.gstatic.com js-agent.newrelic.com bam.nr-data.net kbc-uis.s3.amazonaws.com www.google.com www.dropbox.com; style-src 'self' 'unsafe-inline' assets-cdn.keboola.com cloud.typography.com d38qy9k7n8xp7k.cloudfront.net kbc-uis.s3.amazonaws.com www.google.com ajax.googleapis.com; img-src * data:; media-src assets-cdn.keboola.com; font-src data: assets-cdn.keboola.com cloud.typography.com; worker-src 'self' blob:; child-src blob:; connect-src * 'self'; frame-src docs.google.com accounts.google.com content-sheets.googleapis.com content.googleapis.com www.youtube.com www.google.com; object-src d38qy9k7n8xp7k.cloudfront.net kbc-uis.s3.amazonaws.com; report-uri https://sentry.io/api/90575/csp-report/?sentry_key=718dc19aef5e4a77b8a7bf06cda52f75","name":"Content-Security-Policy","description":"Custom header"},{"key":"Content-Type","value":"application/json","name":"Content-Type","description":"The mime type of this content"},{"key":"Date","value":"Fri, 09 Mar 2018 14:56:11 GMT","name":"Date","description":"The date and time that the message was sent"},{"key":"Server","value":"Apache","name":"Server","description":"A name for the server"},{"key":"Strict-Transport-Security","value":"max-age=31536000","name":"Strict-Transport-Security","description":"A HSTS Policy informing the HTTP client how long to cache the HTTPS only policy and whether this applies to subdomains."},{"key":"Vary","value":"Accept-Encoding","name":"Vary","description":"Tells downstream proxies how to match future request headers to decide whether the cached response can be used rather than requesting a fresh one from the origin server."},{"key":"X-Content-Type-Options","value":"nosniff","name":"X-Content-Type-Options","description":"The only defined value, \"nosniff\", prevents Internet Explorer from MIME-sniffing a response away from the declared content-type"},{"key":"X-Frame-Options","value":"DENY","name":"X-Frame-Options","description":"Clickjacking protection: \"deny\" - no rendering within a frame, \"sameorigin\" - no rendering if origin mismatch"},{"key":"X-Powered-By","value":"PHP/7.1.11","name":"X-Powered-By","description":"Specifies the technology (ASP.NET, PHP, JBoss, e.g.) supporting the web application (version details are often in X-Runtime, X-Version, or X-AspNet-Version)"},{"key":"X-XSS-Protection","value":"1; mode=block","name":"X-XSS-Protection","description":"Cross-site scripting (XSS) filter"}],"cookie":[],"responseTime":null,"body":"{\"id\":\"364479526\",\"name\":\"test\",\"description\":\"\",\"created\":\"2018-03-08T14:54:19+0100\",\"creatorToken\":{\"id\":27865,\"description\":\"ondrej.popelka@keboola.com\"},\"version\":10,\"changeDescription\":\"\",\"isDeleted\":false,\"configuration\":{\"parameters\":{\"accessKeyId\":\"a\",\"#secretAccessKey\":\"b\"}},\"rowsSortOrder\":[],\"rows\":[{\"id\":\"364481153\",\"name\":\"first table\",\"description\":\"\",\"configuration\":{\"parameters\":{\"bucket\":\"travis-php-db-import-tests-s3filesbucket-vm9zhtm5jd7s\",\"key\":\"tw_accounts.csv\",\"saveAs\":\"first-table\",\"includeSubfolders\":false,\"newFilesOnly\":true},\"processors\":{\"after\":[{\"definition\":{\"component\":\"keboola.processor-move-files\"},\"parameters\":{\"direction\":\"tables\",\"addCsvSuffix\":true}},{\"definition\":{\"component\":\"keboola.processor-create-manifest\"},\"parameters\":{\"delimiter\":\",\",\"enclosure\":\"\\\"\",\"incremental\":false,\"primary_key\":[],\"columns\":[],\"columns_from\":\"header\"}},{\"definition\":{\"component\":\"keboola.processor-skip-lines\"},\"parameters\":{\"lines\":1}}]}},\"isDisabled\":false,\"version\":3,\"created\":\"2018-03-08T14:58:33+0100\",\"creatorToken\":{\"id\":27865,\"description\":\"ondrej.popelka@keboola.com\"},\"changeDescription\":\"Table first table edited\",\"state\":{\"lastDownloadedFileTimestamp\":\"1511176959\",\"processedFilesInLastTimestampSecond\":[\"tw_accounts.csv\"]}}],\"state\":{},\"currentVersion\":{\"created\":\"2018-03-09T15:56:11+0100\",\"creatorToken\":{\"id\":27865,\"description\":\"ondrej.popelka@keboola.com\"},\"changeDescription\":\"\"}}"},{"id":"4db36bc7-986b-40c7-a5ea-f84654cab138","name":"Set Row order of S3 Extractor","originalRequest":{"method":"PUT","header":[{"key":"Content-Type","value":"application/x-www-form-urlencoded"},{"key":"X-StorageAPI-Token","value":"{{token}}"}],"body":{"mode":"urlencoded","urlencoded":[{"key":"rowsSortOrder[0]","value":"364481153","type":"text"},{"key":"rowsSortOrder[1]","value":"364949834","type":"text"}]},"url":"https://connection.keboola.com/v2/storage/components/keboola.ex-aws-s3/configs/364479526"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Access-Control-Allow-Origin","value":"*","name":"Access-Control-Allow-Origin","description":"Specifies a URI that may access the resource. For requests without credentials, the server may specify '*' as a wildcard, thereby allowing any origin to access the resource."},{"key":"Cache-Control","value":"private, no-cache, no-store, must-revalidate","name":"Cache-Control","description":"Tells all caching mechanisms from server to client whether they may cache this object. It is measured in seconds"},{"key":"Connection","value":"keep-alive","name":"Connection","description":"Options that are desired for the connection"},{"key":"Content-Encoding","value":"gzip","name":"Content-Encoding","description":"The type of encoding used on the data."},{"key":"Content-Length","value":"689","name":"Content-Length","description":"The length of the response body in octets (8-bit bytes)"},{"key":"Content-Security-Policy","value":"default-src none; script-src 'self' 'unsafe-inline' 'unsafe-eval' assets-cdn.keboola.com d38qy9k7n8xp7k.cloudfront.net assets.zendesk.com www.google-analytics.com ajax.googleapis.com apis.google.com www.googletagmanager.com www.gstatic.com js-agent.newrelic.com bam.nr-data.net kbc-uis.s3.amazonaws.com www.google.com www.dropbox.com; style-src 'self' 'unsafe-inline' assets-cdn.keboola.com cloud.typography.com d38qy9k7n8xp7k.cloudfront.net kbc-uis.s3.amazonaws.com www.google.com ajax.googleapis.com; img-src * data:; media-src assets-cdn.keboola.com; font-src data: assets-cdn.keboola.com cloud.typography.com; worker-src 'self' blob:; child-src blob:; connect-src * 'self'; frame-src docs.google.com accounts.google.com content-sheets.googleapis.com content.googleapis.com www.youtube.com www.google.com; object-src d38qy9k7n8xp7k.cloudfront.net kbc-uis.s3.amazonaws.com; report-uri https://sentry.io/api/90575/csp-report/?sentry_key=718dc19aef5e4a77b8a7bf06cda52f75","name":"Content-Security-Policy","description":"Custom header"},{"key":"Content-Type","value":"application/json","name":"Content-Type","description":"The mime type of this content"},{"key":"Date","value":"Fri, 09 Mar 2018 20:30:06 GMT","name":"Date","description":"The date and time that the message was sent"},{"key":"Server","value":"Apache","name":"Server","description":"A name for the server"},{"key":"Strict-Transport-Security","value":"max-age=31536000","name":"Strict-Transport-Security","description":"A HSTS Policy informing the HTTP client how long to cache the HTTPS only policy and whether this applies to subdomains."},{"key":"Vary","value":"Accept-Encoding","name":"Vary","description":"Tells downstream proxies how to match future request headers to decide whether the cached response can be used rather than requesting a fresh one from the origin server."},{"key":"X-Content-Type-Options","value":"nosniff","name":"X-Content-Type-Options","description":"The only defined value, \"nosniff\", prevents Internet Explorer from MIME-sniffing a response away from the declared content-type"},{"key":"X-Frame-Options","value":"DENY","name":"X-Frame-Options","description":"Clickjacking protection: \"deny\" - no rendering within a frame, \"sameorigin\" - no rendering if origin mismatch"},{"key":"X-Powered-By","value":"PHP/7.1.11","name":"X-Powered-By","description":"Specifies the technology (ASP.NET, PHP, JBoss, e.g.) supporting the web application (version details are often in X-Runtime, X-Version, or X-AspNet-Version)"},{"key":"X-XSS-Protection","value":"1; mode=block","name":"X-XSS-Protection","description":"Cross-site scripting (XSS) filter"}],"cookie":[],"responseTime":null,"body":"{\"id\":\"364479526\",\"name\":\"test\",\"description\":\"\",\"created\":\"2018-03-08T14:54:19+0100\",\"creatorToken\":{\"id\":27865,\"description\":\"ondrej.popelka@keboola.com\"},\"version\":24,\"changeDescription\":\"\",\"isDeleted\":false,\"configuration\":{\"parameters\":{\"accessKeyId\":\"a\",\"#secretAccessKey\":\"b\"}},\"rowsSortOrder\":[\"364481153\",\"364949834\"],\"rows\":[{\"id\":\"364481153\",\"name\":\"first table\",\"description\":\"\",\"configuration\":{\"parameters\":{\"bucket\":\"travis-php-db-import-tests-s3filesbucket-vm9zhtm5jd7s\",\"key\":\"tw_accounts.csv\",\"saveAs\":\"first-table\",\"includeSubfolders\":false,\"newFilesOnly\":true},\"processors\":{\"after\":[{\"definition\":{\"component\":\"keboola.processor-move-files\"},\"parameters\":{\"direction\":\"tables\",\"addCsvSuffix\":true}},{\"definition\":{\"component\":\"keboola.processor-create-manifest\"},\"parameters\":{\"delimiter\":\",\",\"enclosure\":\"\\\"\",\"incremental\":false,\"primary_key\":[],\"columns\":[],\"columns_from\":\"header\"}},{\"definition\":{\"component\":\"keboola.processor-skip-lines\"},\"parameters\":{\"lines\":1}}]}},\"isDisabled\":false,\"version\":9,\"created\":\"\",\"creatorToken\":{\"id\":0,\"description\":null},\"changeDescription\":null,\"state\":{}},{\"id\":\"364949834\",\"name\":\"second table\",\"description\":\"\",\"configuration\":{\"parameters\":{\"bucket\":\"abc\",\"key\":\"cdef\",\"includeSubfolders\":false,\"newFilesOnly\":false},\"processors\":{\"after\":[{\"definition\":{\"component\":\"keboola.processor-move-files\"},\"parameters\":{\"direction\":\"tables\",\"addCsvSuffix\":true,\"folder\":\"second-table\"}},{\"definition\":{\"component\":\"keboola.processor-create-manifest\"},\"parameters\":{\"delimiter\":\",\",\"enclosure\":\"\\\"\",\"incremental\":false,\"primary_key\":[],\"columns\":[]}}]}},\"isDisabled\":false,\"version\":2,\"created\":\"2018-03-09T21:24:30+0100\",\"creatorToken\":{\"id\":27865,\"description\":\"ondrej.popelka@keboola.com\"},\"changeDescription\":\"Table second table edited\",\"state\":{}}],\"state\":{},\"currentVersion\":{\"created\":\"2018-03-09T21:30:06+0100\",\"creatorToken\":{\"id\":27865,\"description\":\"ondrej.popelka@keboola.com\"},\"changeDescription\":\"\"}}"}],"_postman_id":"de43e274-4733-49ec-b691-7f4d5946e663"},{"name":"Update configuration Row","id":"9200fb4e-1a9c-4f94-8ee9-3205ebad49c7","request":{"method":"PUT","header":[{"key":"Content-Type","value":"application/x-www-form-urlencoded"},{"key":"X-StorageAPI-Token","value":"{{token}}"}],"body":{"mode":"urlencoded","urlencoded":[{"key":"configuration","value":"{{configurationJson}}","type":"text"}]},"url":"https://connection.keboola.com/v2/storage/components/{{componentId}}/configs/{{configurationId}}/rows/{{rowId}}","description":"[Update an existing configuration row](https://keboola.docs.apiary.io/#reference/component-configurations/manage-configuration-rows/update-row). Note that the configuration must be sent as an encoded JSON in the form field."},"response":[{"id":"455b471b-727a-4a9e-983f-b57128671dfc","name":"Add processor to S3 Extractor configuration Row","originalRequest":{"method":"PUT","header":[{"key":"Content-Type","value":"application/x-www-form-urlencoded"},{"key":"X-StorageAPI-Token","value":"{{token}}"}],"body":{"mode":"urlencoded","urlencoded":[{"key":"configuration","value":"{{configurationJson}}","type":"text"}]},"url":"https://connection.keboola.com/v2/storage/components/keboola.ex-aws-s3/configs/364479526/rows/364481153"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Access-Control-Allow-Origin","value":"*","name":"Access-Control-Allow-Origin","description":"Specifies a URI that may access the resource. For requests without credentials, the server may specify '*' as a wildcard, thereby allowing any origin to access the resource."},{"key":"Cache-Control","value":"private, no-cache, no-store, must-revalidate","name":"Cache-Control","description":"Tells all caching mechanisms from server to client whether they may cache this object. It is measured in seconds"},{"key":"Connection","value":"keep-alive","name":"Connection","description":"Options that are desired for the connection"},{"key":"Content-Encoding","value":"gzip","name":"Content-Encoding","description":"The type of encoding used on the data."},{"key":"Content-Length","value":"317","name":"Content-Length","description":"The length of the response body in octets (8-bit bytes)"},{"key":"Content-Security-Policy","value":"default-src none; script-src 'self' 'unsafe-inline' 'unsafe-eval' assets-cdn.keboola.com d38qy9k7n8xp7k.cloudfront.net assets.zendesk.com www.google-analytics.com ajax.googleapis.com apis.google.com www.googletagmanager.com www.gstatic.com js-agent.newrelic.com bam.nr-data.net kbc-uis.s3.amazonaws.com www.google.com www.dropbox.com; style-src 'self' 'unsafe-inline' assets-cdn.keboola.com cloud.typography.com d38qy9k7n8xp7k.cloudfront.net kbc-uis.s3.amazonaws.com www.google.com ajax.googleapis.com; img-src * data:; media-src assets-cdn.keboola.com; font-src data: assets-cdn.keboola.com cloud.typography.com; worker-src 'self' blob:; child-src blob:; connect-src * 'self'; frame-src docs.google.com accounts.google.com content-sheets.googleapis.com content.googleapis.com www.youtube.com www.google.com; object-src d38qy9k7n8xp7k.cloudfront.net kbc-uis.s3.amazonaws.com; report-uri https://sentry.io/api/90575/csp-report/?sentry_key=718dc19aef5e4a77b8a7bf06cda52f75","name":"Content-Security-Policy","description":"Custom header"},{"key":"Content-Type","value":"application/json","name":"Content-Type","description":"The mime type of this content"},{"key":"Date","value":"Sat, 10 Mar 2018 08:09:47 GMT","name":"Date","description":"The date and time that the message was sent"},{"key":"Server","value":"Apache","name":"Server","description":"A name for the server"},{"key":"Strict-Transport-Security","value":"max-age=31536000","name":"Strict-Transport-Security","description":"A HSTS Policy informing the HTTP client how long to cache the HTTPS only policy and whether this applies to subdomains."},{"key":"Vary","value":"Accept-Encoding","name":"Vary","description":"Tells downstream proxies how to match future request headers to decide whether the cached response can be used rather than requesting a fresh one from the origin server."},{"key":"X-Content-Type-Options","value":"nosniff","name":"X-Content-Type-Options","description":"The only defined value, \"nosniff\", prevents Internet Explorer from MIME-sniffing a response away from the declared content-type"},{"key":"X-Frame-Options","value":"DENY","name":"X-Frame-Options","description":"Clickjacking protection: \"deny\" - no rendering within a frame, \"sameorigin\" - no rendering if origin mismatch"},{"key":"X-Powered-By","value":"PHP/7.1.11","name":"X-Powered-By","description":"Specifies the technology (ASP.NET, PHP, JBoss, e.g.) supporting the web application (version details are often in X-Runtime, X-Version, or X-AspNet-Version)"},{"key":"X-XSS-Protection","value":"1; mode=block","name":"X-XSS-Protection","description":"Cross-site scripting (XSS) filter"}],"cookie":[],"responseTime":null,"body":"{\"id\":\"364481153\",\"name\":\"first table\",\"description\":\"\",\"configuration\":{\"parameters\":{\"bucket\":\"travis-php-db-import-tests-s3filesbucket-vm9zhtm5jd7s\",\"key\":\"tw_accounts.csv\",\"saveAs\":\"first-table\",\"includeSubfolders\":false,\"newFilesOnly\":true},\"processors\":{\"after\":[{\"definition\":{\"component\":\"keboola.processor-skip-lines\"},\"parameters\":{\"lines\":1}}]}},\"isDisabled\":false,\"version\":10,\"created\":\"\",\"creatorToken\":{\"id\":0,\"description\":null},\"changeDescription\":null,\"state\":{}}"},{"id":"8b716e1f-5247-44ef-a91e-ae15eee3dd15","name":"Update S3 Extractor configuration Row","originalRequest":{"method":"PUT","header":[{"key":"Content-Type","value":"application/x-www-form-urlencoded"},{"key":"X-StorageAPI-Token","value":"{{token}}"}],"body":{"mode":"urlencoded","urlencoded":[{"key":"configuration","value":"{\n    \"parameters\": {\n        \"bucket\": \"some-bucket\",\n        \"key\": \"sample.csv\",\n        \"includeSubfolders\": false,\n        \"newFilesOnly\": true\n    }\n}","type":"text"}]},"url":"https://connection.keboola.com/v2/storage/components/keboola.ex-aws-s3/configs/364479526/rows/364481153"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Access-Control-Allow-Origin","value":"*","name":"Access-Control-Allow-Origin","description":"Specifies a URI that may access the resource. For requests without credentials, the server may specify '*' as a wildcard, thereby allowing any origin to access the resource."},{"key":"Cache-Control","value":"private, no-cache, no-store, must-revalidate","name":"Cache-Control","description":"Tells all caching mechanisms from server to client whether they may cache this object. It is measured in seconds"},{"key":"Connection","value":"keep-alive","name":"Connection","description":"Options that are desired for the connection"},{"key":"Content-Encoding","value":"gzip","name":"Content-Encoding","description":"The type of encoding used on the data."},{"key":"Content-Length","value":"278","name":"Content-Length","description":"The length of the response body in octets (8-bit bytes)"},{"key":"Content-Security-Policy","value":"default-src none; script-src 'self' 'unsafe-inline' 'unsafe-eval' assets-cdn.keboola.com d38qy9k7n8xp7k.cloudfront.net assets.zendesk.com www.google-analytics.com ajax.googleapis.com apis.google.com www.googletagmanager.com www.gstatic.com js-agent.newrelic.com bam.nr-data.net kbc-uis.s3.amazonaws.com www.google.com www.dropbox.com; style-src 'self' 'unsafe-inline' assets-cdn.keboola.com cloud.typography.com d38qy9k7n8xp7k.cloudfront.net kbc-uis.s3.amazonaws.com www.google.com ajax.googleapis.com; img-src * data:; media-src assets-cdn.keboola.com; font-src data: assets-cdn.keboola.com cloud.typography.com; worker-src 'self' blob:; child-src blob:; connect-src * 'self'; frame-src docs.google.com accounts.google.com content-sheets.googleapis.com content.googleapis.com www.youtube.com www.google.com; object-src d38qy9k7n8xp7k.cloudfront.net kbc-uis.s3.amazonaws.com; report-uri https://sentry.io/api/90575/csp-report/?sentry_key=718dc19aef5e4a77b8a7bf06cda52f75","name":"Content-Security-Policy","description":"Custom header"},{"key":"Content-Type","value":"application/json","name":"Content-Type","description":"The mime type of this content"},{"key":"Date","value":"Fri, 09 Mar 2018 20:10:19 GMT","name":"Date","description":"The date and time that the message was sent"},{"key":"Server","value":"Apache","name":"Server","description":"A name for the server"},{"key":"Strict-Transport-Security","value":"max-age=31536000","name":"Strict-Transport-Security","description":"A HSTS Policy informing the HTTP client how long to cache the HTTPS only policy and whether this applies to subdomains."},{"key":"Vary","value":"Accept-Encoding","name":"Vary","description":"Tells downstream proxies how to match future request headers to decide whether the cached response can be used rather than requesting a fresh one from the origin server."},{"key":"X-Content-Type-Options","value":"nosniff","name":"X-Content-Type-Options","description":"The only defined value, \"nosniff\", prevents Internet Explorer from MIME-sniffing a response away from the declared content-type"},{"key":"X-Frame-Options","value":"DENY","name":"X-Frame-Options","description":"Clickjacking protection: \"deny\" - no rendering within a frame, \"sameorigin\" - no rendering if origin mismatch"},{"key":"X-Powered-By","value":"PHP/7.1.11","name":"X-Powered-By","description":"Specifies the technology (ASP.NET, PHP, JBoss, e.g.) supporting the web application (version details are often in X-Runtime, X-Version, or X-AspNet-Version)"},{"key":"X-XSS-Protection","value":"1; mode=block","name":"X-XSS-Protection","description":"Cross-site scripting (XSS) filter"}],"cookie":[],"responseTime":null,"body":"{\"id\":\"364481153\",\"name\":\"first table\",\"description\":\"\",\"configuration\":{\"parameters\":{\"bucket\":\"some-bucket\",\"key\":\"sample.csv\",\"includeSubfolders\":false,\"newFilesOnly\":true}},\"isDisabled\":false,\"version\":8,\"created\":\"\",\"creatorToken\":{\"id\":0,\"description\":null},\"changeDescription\":null,\"state\":{\"lastDownloadedFileTimestamp\":\"1511176959\",\"processedFilesInLastTimestampSecond\":[\"tw_accounts.csv\"]}}"},{"id":"dce78d92-f67d-4c8a-959e-f9c0d0e76c3f","name":"Reset S3 Extractor Row State","originalRequest":{"method":"PUT","header":[{"key":"Content-Type","value":"application/x-www-form-urlencoded"},{"key":"X-StorageAPI-Token","value":"{{token}}"}],"body":{"mode":"urlencoded","urlencoded":[{"key":"state","value":"{}","type":"text"}]},"url":"https://connection.keboola.com/v2/storage/components/keboola.ex-aws-s3/configs/364479526/rows/364481153"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Access-Control-Allow-Origin","value":"*","name":"Access-Control-Allow-Origin","description":"Specifies a URI that may access the resource. For requests without credentials, the server may specify '*' as a wildcard, thereby allowing any origin to access the resource."},{"key":"Cache-Control","value":"private, no-cache, no-store, must-revalidate","name":"Cache-Control","description":"Tells all caching mechanisms from server to client whether they may cache this object. It is measured in seconds"},{"key":"Connection","value":"keep-alive","name":"Connection","description":"Options that are desired for the connection"},{"key":"Content-Encoding","value":"gzip","name":"Content-Encoding","description":"The type of encoding used on the data."},{"key":"Content-Length","value":"216","name":"Content-Length","description":"The length of the response body in octets (8-bit bytes)"},{"key":"Content-Security-Policy","value":"default-src none; script-src 'self' 'unsafe-inline' 'unsafe-eval' assets-cdn.keboola.com d38qy9k7n8xp7k.cloudfront.net assets.zendesk.com www.google-analytics.com ajax.googleapis.com apis.google.com www.googletagmanager.com www.gstatic.com js-agent.newrelic.com bam.nr-data.net kbc-uis.s3.amazonaws.com www.google.com www.dropbox.com; style-src 'self' 'unsafe-inline' assets-cdn.keboola.com cloud.typography.com d38qy9k7n8xp7k.cloudfront.net kbc-uis.s3.amazonaws.com www.google.com ajax.googleapis.com; img-src * data:; media-src assets-cdn.keboola.com; font-src data: assets-cdn.keboola.com cloud.typography.com; worker-src 'self' blob:; child-src blob:; connect-src * 'self'; frame-src docs.google.com accounts.google.com content-sheets.googleapis.com content.googleapis.com www.youtube.com www.google.com; object-src d38qy9k7n8xp7k.cloudfront.net kbc-uis.s3.amazonaws.com; report-uri https://sentry.io/api/90575/csp-report/?sentry_key=718dc19aef5e4a77b8a7bf06cda52f75","name":"Content-Security-Policy","description":"Custom header"},{"key":"Content-Type","value":"application/json","name":"Content-Type","description":"The mime type of this content"},{"key":"Date","value":"Fri, 09 Mar 2018 20:20:10 GMT","name":"Date","description":"The date and time that the message was sent"},{"key":"Server","value":"Apache","name":"Server","description":"A name for the server"},{"key":"Strict-Transport-Security","value":"max-age=31536000","name":"Strict-Transport-Security","description":"A HSTS Policy informing the HTTP client how long to cache the HTTPS only policy and whether this applies to subdomains."},{"key":"Vary","value":"Accept-Encoding","name":"Vary","description":"Tells downstream proxies how to match future request headers to decide whether the cached response can be used rather than requesting a fresh one from the origin server."},{"key":"X-Content-Type-Options","value":"nosniff","name":"X-Content-Type-Options","description":"The only defined value, \"nosniff\", prevents Internet Explorer from MIME-sniffing a response away from the declared content-type"},{"key":"X-Frame-Options","value":"DENY","name":"X-Frame-Options","description":"Clickjacking protection: \"deny\" - no rendering within a frame, \"sameorigin\" - no rendering if origin mismatch"},{"key":"X-Powered-By","value":"PHP/7.1.11","name":"X-Powered-By","description":"Specifies the technology (ASP.NET, PHP, JBoss, e.g.) supporting the web application (version details are often in X-Runtime, X-Version, or X-AspNet-Version)"},{"key":"X-XSS-Protection","value":"1; mode=block","name":"X-XSS-Protection","description":"Cross-site scripting (XSS) filter"}],"cookie":[],"responseTime":null,"body":"{\"id\":\"364481153\",\"name\":\"first table\",\"description\":\"\",\"configuration\":{\"parameters\":{\"bucket\":\"some-bucket\",\"key\":\"sample.csv\",\"includeSubfolders\":false,\"newFilesOnly\":true}},\"isDisabled\":false,\"version\":8,\"created\":\"\",\"creatorToken\":{\"id\":0,\"description\":null},\"changeDescription\":null,\"state\":{}}"}],"_postman_id":"9200fb4e-1a9c-4f94-8ee9-3205ebad49c7"}],"id":"49cb0efe-3a04-4588-bc60-80005187de97","description":"Requests for working with [Configurations](https://keboola.docs.apiary.io/#reference/component-configurations/list-components/get-components) of components.","_postman_id":"49cb0efe-3a04-4588-bc60-80005187de97"},{"name":"Table Importer","item":[{"name":"Import Table","id":"9b8117d9-7e7d-46ab-9fd7-041714d5a31d","request":{"method":"POST","header":[{"key":"X-StorageApi-Token","value":"{{token}}"}],"body":{"mode":"formdata","formdata":[{"key":"tableId","value":"{{tableId}}","type":"text"},{"key":"data","type":"file","src":{},"value":null}]},"url":"https://import.keboola.com/write-table","description":"Import data into an existing table"},"response":[{"id":"374c9376-c849-4f04-89c6-97e0496d684c","name":"Import Table","originalRequest":{"method":"POST","header":[{"key":"X-StorageApi-Token","value":"{{token}}"}],"body":{"mode":"formdata","formdata":[{"key":"tableId","value":"in.c-main.my-table","type":"text"},{"key":"data","type":"file","src":{"0":{}}}]},"url":"https://import.keboola.com/write-table"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Access-Control-Allow-Origin","value":"*","name":"Access-Control-Allow-Origin","description":""},{"key":"Cache-Control","value":"no-cache","name":"Cache-Control","description":""},{"key":"Connection","value":"keep-alive","name":"Connection","description":""},{"key":"Content-Encoding","value":"gzip","name":"Content-Encoding","description":""},{"key":"Content-Length","value":"129","name":"Content-Length","description":""},{"key":"Content-Type","value":"application/json","name":"Content-Type","description":""},{"key":"Date","value":"Mon, 06 Nov 2017 14:37:08 GMT","name":"Date","description":""},{"key":"Server","value":"Apache","name":"Server","description":""},{"key":"Strict-Transport-Security","value":"max-age=31536000","name":"Strict-Transport-Security","description":""},{"key":"Vary","value":"Accept-Encoding","name":"Vary","description":""}],"cookie":[],"responseTime":null,"body":"{\"transaction\":null,\"warnings\":[],\"importedColumns\":[\"number\",\"someText\"],\"totalRowsCount\":5,\"totalDataSizeBytes\":12582912}"}],"_postman_id":"9b8117d9-7e7d-46ab-9fd7-041714d5a31d"}],"id":"dbbfa6fc-d67f-46af-be2e-601c0a732571","description":"Use [Storage API importer](https://developers.keboola.com/integrate/storage/api/importer/) to import data to KBC.","_postman_id":"dbbfa6fc-d67f-46af-be2e-601c0a732571"},{"name":"Encryption","id":"f3ae6d39-cea1-4eb3-b6de-04b868b728e3","request":{"method":"POST","header":[{"key":"Content-Type","value":"text/plain"}],"body":{"mode":"raw","raw":"secret"},"url":"https://syrup.keboola.com/docker/encrypt","description":"[Encrypts](https://kebooladocker.docs.apiary.io/#reference/encrypt/encryption/encrypt-data) plain text and JSON data."},"response":[{"id":"7279f057-95c5-4e74-91cf-a77309d697f9","name":"Encrypt JSON","originalRequest":{"method":"POST","header":[{"key":"Content-Type","value":"application/json"}],"url":"https://syrup.keboola.com/docker/encrypt"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Access-Control-Allow-Headers","value":"*","name":"Access-Control-Allow-Headers","description":""},{"key":"Access-Control-Allow-Methods","value":"*","name":"Access-Control-Allow-Methods","description":""},{"key":"Access-Control-Allow-Origin","value":"*","name":"Access-Control-Allow-Origin","description":""},{"key":"Cache-Control","value":"must-revalidate, no-cache, no-store, private","name":"Cache-Control","description":""},{"key":"Connection","value":"keep-alive","name":"Connection","description":""},{"key":"Content-Encoding","value":"gzip","name":"Content-Encoding","description":""},{"key":"Content-Length","value":"184","name":"Content-Length","description":""},{"key":"Content-Type","value":"application/json","name":"Content-Type","description":""},{"key":"Date","value":"Mon, 06 Nov 2017 07:26:44 GMT","name":"Date","description":""},{"key":"Server","value":"Apache","name":"Server","description":""},{"key":"Vary","value":"Accept-Encoding","name":"Vary","description":""},{"key":"X-Powered-By","value":"PHP/5.6.31","name":"X-Powered-By","description":""}],"cookie":[],"responseTime":null,"body":"{\"plain\":\"this will not be encrypted\",\"#secret\":\"KBC::Encrypted==zTc6dHE25rewduSLIkGOcn3BIWcJxRp\\/NzAutMy9HVJDQlUt\\/X9gMXEYjBAK+HB0NGUjtG6pivptQq+fpKrk6FOIrRgyV533WnaZHoiscAo=\"}"},{"id":"7f006a49-5cb5-4bee-be24-9e5361892aaf","name":"Encryption Plain text","originalRequest":{"method":"POST","header":[{"key":"Content-Type","type":"text","name":"Content-Type","value":"text/plain"}],"body":{"mode":"raw","raw":"this is secret"},"url":"https://syrup.keboola.com/docker/encrypt"},"status":"OK","code":200,"_postman_previewlanguage":"plain","header":[{"key":"Access-Control-Allow-Headers","value":"*","name":"Access-Control-Allow-Headers","description":""},{"key":"Access-Control-Allow-Methods","value":"*","name":"Access-Control-Allow-Methods","description":""},{"key":"Access-Control-Allow-Origin","value":"*","name":"Access-Control-Allow-Origin","description":""},{"key":"Cache-Control","value":"must-revalidate, no-cache, no-store, private","name":"Cache-Control","description":""},{"key":"Connection","value":"keep-alive","name":"Connection","description":""},{"key":"Content-Encoding","value":"gzip","name":"Content-Encoding","description":""},{"key":"Content-Length","value":"124","name":"Content-Length","description":""},{"key":"Content-Type","value":"text/plain; charset=UTF-8","name":"Content-Type","description":""},{"key":"Date","value":"Mon, 06 Nov 2017 07:28:49 GMT","name":"Date","description":""},{"key":"Server","value":"Apache","name":"Server","description":""},{"key":"Vary","value":"Accept-Encoding","name":"Vary","description":""},{"key":"X-Powered-By","value":"PHP/5.6.31","name":"X-Powered-By","description":""}],"cookie":[],"responseTime":null,"body":"KBC::Encrypted==UkAwaHCWtrz9ETTRDkkXjgvUvjnAFiZcDz2MOz3Y3ehYVMdhBgYD4RPbDtmupYmiRaeWtIJ677praligVqBMIQ=="},{"id":"a0852383-be43-4727-a723-22446abbeacd","name":"Project Encryption","originalRequest":{"method":"POST","header":[{"key":"Content-Type","type":"text","name":"Content-Type","value":"text/plain"}],"body":{"mode":"raw","raw":"this is secret"},"url":{"raw":"https://syrup.keboola.com/docker/encrypt?projectId=572","protocol":"https","host":["syrup","keboola","com"],"path":["docker","encrypt"],"query":[{"key":"projectId","value":"572"}]}},"status":"OK","code":200,"_postman_previewlanguage":"plain","header":[{"key":"Access-Control-Allow-Headers","value":"*","name":"Access-Control-Allow-Headers","description":""},{"key":"Access-Control-Allow-Methods","value":"*","name":"Access-Control-Allow-Methods","description":""},{"key":"Access-Control-Allow-Origin","value":"*","name":"Access-Control-Allow-Origin","description":""},{"key":"Cache-Control","value":"must-revalidate, no-cache, no-store, private","name":"Cache-Control","description":""},{"key":"Connection","value":"keep-alive","name":"Connection","description":""},{"key":"Content-Encoding","value":"gzip","name":"Content-Encoding","description":""},{"key":"Content-Length","value":"124","name":"Content-Length","description":""},{"key":"Content-Type","value":"text/plain; charset=UTF-8","name":"Content-Type","description":""},{"key":"Date","value":"Mon, 06 Nov 2017 07:32:14 GMT","name":"Date","description":""},{"key":"Server","value":"Apache","name":"Server","description":""},{"key":"Vary","value":"Accept-Encoding","name":"Vary","description":""},{"key":"X-Powered-By","value":"PHP/5.6.31","name":"X-Powered-By","description":""}],"cookie":[],"responseTime":null,"body":"KBC::Encrypted==NTc6awasHoiMTGmjR4T8nX9Ho6qzQ9o1ZQ58iJkAMi5TLYuEkS5dDAdchGqEoA4SoqWQ0ce/uCMQhDH5kQdGQw=="},{"id":"fc7fb4d8-88b1-4a28-af6d-c98f36bf74e1","name":"Component Project Encryption","originalRequest":{"method":"POST","header":[{"key":"Content-Type","type":"text","name":"Content-Type","value":"application/json"}],"body":{"mode":"raw","raw":"{\n    \"plain\": \"this will not be encrypted\",\n    \"#secret\": \"this will be encrypted\"\n}"},"url":{"raw":"https://syrup.keboola.com/docker/encrypt?projectId=572&componentId=keboola.ex-db-snowflake","protocol":"https","host":["syrup","keboola","com"],"path":["docker","encrypt"],"query":[{"key":"projectId","value":"572"},{"key":"componentId","value":"keboola.ex-db-snowflake"}]}},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Access-Control-Allow-Headers","value":"*","name":"Access-Control-Allow-Headers","description":""},{"key":"Access-Control-Allow-Methods","value":"*","name":"Access-Control-Allow-Methods","description":""},{"key":"Access-Control-Allow-Origin","value":"*","name":"Access-Control-Allow-Origin","description":""},{"key":"Cache-Control","value":"must-revalidate, no-cache, no-store, private","name":"Cache-Control","description":""},{"key":"Connection","value":"keep-alive","name":"Connection","description":""},{"key":"Content-Encoding","value":"gzip","name":"Content-Encoding","description":""},{"key":"Content-Length","value":"190","name":"Content-Length","description":""},{"key":"Content-Type","value":"application/json","name":"Content-Type","description":""},{"key":"Date","value":"Mon, 06 Nov 2017 07:36:41 GMT","name":"Date","description":""},{"key":"Server","value":"Apache","name":"Server","description":""},{"key":"Vary","value":"Accept-Encoding","name":"Vary","description":""},{"key":"X-Powered-By","value":"PHP/5.6.31","name":"X-Powered-By","description":""}],"cookie":[],"responseTime":null,"body":"{\"plain\":\"this will not be encrypted\",\"#secret\":\"KBC::ComponentProjectEncrypted==F1e3rGS4tWRpBFbz3L7IfxUhbUfGXR5IitebMOhtSYUXc0bUERRm4tzg9dnKMQsA0f0tt+Id8ChcdMAHIyn+SPlllpdNSHQeSBxobIpkCeo=\"}"}],"_postman_id":"f3ae6d39-cea1-4eb3-b6de-04b868b728e3"},{"name":"Debug","id":"880d27ba-5af1-4d18-b8d5-1cce87c3ba58","request":{"method":"POST","header":[{"key":"X-StorageApi-Token","value":"{{token}}"},{"key":"Content-Type","value":"application/json"}],"body":{"mode":"raw","raw":"{\r\n\t\"config\": {{configurationId}}\r\n}"},"url":"https://syrup.keboola.com/docker/{{componentId}}/debug","description":"[Debug](https://kebooladocker.docs.apiary.io/#reference/debug) API call creates an archive with the data directory. This allows you to run a component locally with a copy of the production envrionment."},"response":[{"id":"119ae89a-d2ae-4d33-8357-5240b9d56bb4","name":"Running without configuration","originalRequest":{"method":"POST","header":[{"key":"X-StorageApi-Token","value":"{{token}}"},{"key":"Content-Type","value":"application/json"}],"body":{"mode":"raw","raw":"{\r\n\t\"config\": \"dummy\",\r\n\t\"configData\": {\r\n\t\t\"storage\": {\r\n\t\t\t\"input\": {\r\n\t\t\t\t\"tables\": [\r\n\t\t\t\t\t{\r\n\t\t\t\t\t\t\"source\": \"in.c-main.sample\",\r\n\t\t\t\t\t\t\"destination\": \"source.csv\"\r\n\t\t\t\t\t}\r\n\t\t\t\t]\r\n\t\t\t}\r\n\t\t},\r\n\t\t\"parameters\": {\r\n\t\t\t\"sound\": \"Moo\",\r\n\t\t\t\"repeat\": 2\r\n\t\t}\r\n\t}\r\n}"},"url":"https://syrup.keboola.com/docker/keboola-test.ex-docs-tutorial/debug"},"status":"Accepted","code":202,"_postman_previewlanguage":"json","header":[{"key":"Access-Control-Allow-Headers","value":"*","name":"Access-Control-Allow-Headers","description":"Used in response to a preflight request to indicate which HTTP headers can be used when making the actual request."},{"key":"Access-Control-Allow-Methods","value":"*","name":"Access-Control-Allow-Methods","description":"Specifies the method or methods allowed when accessing the resource. This is used in response to a preflight request."},{"key":"Access-Control-Allow-Origin","value":"*","name":"Access-Control-Allow-Origin","description":"Specifies a URI that may access the resource. For requests without credentials, the server may specify '*' as a wildcard, thereby allowing any origin to access the resource."},{"key":"Cache-Control","value":"must-revalidate, no-cache, no-store, private","name":"Cache-Control","description":"Tells all caching mechanisms from server to client whether they may cache this object. It is measured in seconds"},{"key":"Connection","value":"keep-alive","name":"Connection","description":"Options that are desired for the connection"},{"key":"Content-Encoding","value":"gzip","name":"Content-Encoding","description":"The type of encoding used on the data."},{"key":"Content-Length","value":"103","name":"Content-Length","description":"The length of the response body in octets (8-bit bytes)"},{"key":"Content-Type","value":"application/json","name":"Content-Type","description":"The mime type of this content"},{"key":"Date","value":"Mon, 06 Nov 2017 11:07:34 GMT","name":"Date","description":"The date and time that the message was sent"},{"key":"Server","value":"Apache","name":"Server","description":"A name for the server"},{"key":"Vary","value":"Accept-Encoding","name":"Vary","description":"Tells downstream proxies how to match future request headers to decide whether the cached response can be used rather than requesting a fresh one from the origin server."},{"key":"X-Powered-By","value":"PHP/5.6.31","name":"X-Powered-By","description":"Specifies the technology (ASP.NET, PHP, JBoss, e.g.) supporting the web application (version details are often in X-Runtime, X-Version, or X-AspNet-Version)"}],"cookie":[],"responseTime":null,"body":"{\"id\":\"328855088\",\"url\":\"https:\\/\\/syrup.keboola.com\\/queue\\/job\\/328855088\",\"status\":\"waiting\"}"},{"id":"367f61a0-7bd7-4f10-866a-f99cae7ed065","name":"Run with Configuration","originalRequest":{"method":"POST","header":[{"key":"X-StorageApi-Token","value":"{{token}}"},{"key":"Content-Type","value":"application/json"}],"body":{"mode":"raw","raw":"{\r\n\t\"config\": \"328831433\"\r\n}"},"url":"https://syrup.keboola.com/docker/keboola.ex-currency/debug"},"status":"Accepted","code":202,"_postman_previewlanguage":"json","header":[{"key":"Access-Control-Allow-Headers","value":"*","name":"Access-Control-Allow-Headers","description":"Used in response to a preflight request to indicate which HTTP headers can be used when making the actual request."},{"key":"Access-Control-Allow-Methods","value":"*","name":"Access-Control-Allow-Methods","description":"Specifies the method or methods allowed when accessing the resource. This is used in response to a preflight request."},{"key":"Access-Control-Allow-Origin","value":"*","name":"Access-Control-Allow-Origin","description":"Specifies a URI that may access the resource. For requests without credentials, the server may specify '*' as a wildcard, thereby allowing any origin to access the resource."},{"key":"Cache-Control","value":"must-revalidate, no-cache, no-store, private","name":"Cache-Control","description":"Tells all caching mechanisms from server to client whether they may cache this object. It is measured in seconds"},{"key":"Connection","value":"keep-alive","name":"Connection","description":"Options that are desired for the connection"},{"key":"Content-Encoding","value":"gzip","name":"Content-Encoding","description":"The type of encoding used on the data."},{"key":"Content-Length","value":"103","name":"Content-Length","description":"The length of the response body in octets (8-bit bytes)"},{"key":"Content-Type","value":"application/json","name":"Content-Type","description":"The mime type of this content"},{"key":"Date","value":"Mon, 06 Nov 2017 09:29:08 GMT","name":"Date","description":"The date and time that the message was sent"},{"key":"Server","value":"Apache","name":"Server","description":"A name for the server"},{"key":"Vary","value":"Accept-Encoding","name":"Vary","description":"Tells downstream proxies how to match future request headers to decide whether the cached response can be used rather than requesting a fresh one from the origin server."},{"key":"X-Powered-By","value":"PHP/5.6.31","name":"X-Powered-By","description":"Specifies the technology (ASP.NET, PHP, JBoss, e.g.) supporting the web application (version details are often in X-Runtime, X-Version, or X-AspNet-Version)"}],"cookie":[],"responseTime":null,"body":"{\"id\":\"328841962\",\"url\":\"https:\\/\\/syrup.keboola.com\\/queue\\/job\\/328841962\",\"status\":\"waiting\"}"},{"id":"747b770c-80c0-41dd-bffd-543a5b8c0b2c","name":"Run Config Row","originalRequest":{"method":"POST","header":[{"key":"X-StorageApi-Token","value":"{{token}}"},{"key":"Content-Type","value":"application/json"}],"body":{"mode":"raw","raw":"{\r\n\t\"config\": \"377900104\",\r\n\t\"row\": \"377900403\"\r\n}"},"url":"https://syrup.keboola.com/docker/keboola.ex-http/debug"},"status":"Accepted","code":202,"_postman_previewlanguage":"json","header":[{"key":"Access-Control-Allow-Headers","value":"*","name":"Access-Control-Allow-Headers","description":"Used in response to a preflight request to indicate which HTTP headers can be used when making the actual request."},{"key":"Access-Control-Allow-Methods","value":"*","name":"Access-Control-Allow-Methods","description":"Specifies the method or methods allowed when accessing the resource. This is used in response to a preflight request."},{"key":"Access-Control-Allow-Origin","value":"*","name":"Access-Control-Allow-Origin","description":"Specifies a URI that may access the resource. For requests without credentials, the server may specify '*' as a wildcard, thereby allowing any origin to access the resource."},{"key":"Cache-Control","value":"must-revalidate, no-cache, no-store, private","name":"Cache-Control","description":"Tells all caching mechanisms from server to client whether they may cache this object. It is measured in seconds"},{"key":"Connection","value":"keep-alive","name":"Connection","description":"Options that are desired for the connection"},{"key":"Content-Encoding","value":"gzip","name":"Content-Encoding","description":"The type of encoding used on the data."},{"key":"Content-Length","value":"104","name":"Content-Length","description":"The length of the response body in octets (8-bit bytes)"},{"key":"Content-Type","value":"application/json","name":"Content-Type","description":"The mime type of this content"},{"key":"Date","value":"Tue, 10 Apr 2018 08:02:51 GMT","name":"Date","description":"The date and time that the message was sent"},{"key":"Server","value":"Apache","name":"Server","description":"A name for the server"},{"key":"Vary","value":"Accept-Encoding","name":"Vary","description":"Tells downstream proxies how to match future request headers to decide whether the cached response can be used rather than requesting a fresh one from the origin server."},{"key":"X-Powered-By","value":"PHP/5.6.32","name":"X-Powered-By","description":"Specifies the technology (ASP.NET, PHP, JBoss, e.g.) supporting the web application (version details are often in X-Runtime, X-Version, or X-AspNet-Version)"}],"cookie":[],"responseTime":null,"body":"{\"id\":\"377919902\",\"url\":\"https:\\/\\/syrup.keboola.com\\/queue\\/job\\/377919902\",\"status\":\"waiting\"}"},{"id":"a63bfeb1-4312-4e37-a356-d98fce328004","name":"R Transformation","originalRequest":{"method":"POST","header":[{"key":"X-StorageApi-Token","value":"{{token}}"},{"key":"Content-Type","value":"application/json"}],"body":{"mode":"raw","raw":"{\r\n\t\"configData\": {\r\n\t\t\"storage\": {\r\n\t\t\t\"input\": {\r\n\t\t\t\t\"tables\": [\r\n\t\t\t\t\t{\r\n\t\t\t\t\t\t\"source\": \"in.c-main.sample\",\r\n\t\t\t\t\t\t\"destination\": \"source.csv\"\r\n\t\t\t\t\t}\r\n\t\t\t\t]\r\n\t\t\t}\r\n\t\t},\r\n\t\t\"parameters\": {\r\n\t\t\t\"script\": [\r\n\t\t\t\t\"data <- read.csv(file = 'in/tables/source.csv');\",\r\n\t\t\t\t\"df <- data.frame(\",\r\n\t\t\t\t\"  col1 = paste0(data$someText, 'ping'),\",\r\n\t\t\t\t\"  col2 = data$number * 42\",\r\n\t\t\t\t\")\",\r\n\t\t\t\t\"write.csv(df, file = 'out/tables/result.csv', row.names = FALSE)\"\r\n\t\t\t]\r\n\t\t}\r\n\t}\r\n}"},"url":"https://syrup.keboola.com/docker/keboola.r-transformation/debug"},"status":"Accepted","code":202,"_postman_previewlanguage":"json","header":[{"key":"Access-Control-Allow-Headers","value":"*","name":"Access-Control-Allow-Headers","description":"Used in response to a preflight request to indicate which HTTP headers can be used when making the actual request."},{"key":"Access-Control-Allow-Methods","value":"*","name":"Access-Control-Allow-Methods","description":"Specifies the method or methods allowed when accessing the resource. This is used in response to a preflight request."},{"key":"Access-Control-Allow-Origin","value":"*","name":"Access-Control-Allow-Origin","description":"Specifies a URI that may access the resource. For requests without credentials, the server may specify '*' as a wildcard, thereby allowing any origin to access the resource."},{"key":"Cache-Control","value":"must-revalidate, no-cache, no-store, private","name":"Cache-Control","description":"Tells all caching mechanisms from server to client whether they may cache this object. It is measured in seconds"},{"key":"Connection","value":"keep-alive","name":"Connection","description":"Options that are desired for the connection"},{"key":"Content-Encoding","value":"gzip","name":"Content-Encoding","description":"The type of encoding used on the data."},{"key":"Content-Length","value":"103","name":"Content-Length","description":"The length of the response body in octets (8-bit bytes)"},{"key":"Content-Type","value":"application/json","name":"Content-Type","description":"The mime type of this content"},{"key":"Date","value":"Mon, 06 Nov 2017 11:28:35 GMT","name":"Date","description":"The date and time that the message was sent"},{"key":"Server","value":"Apache","name":"Server","description":"A name for the server"},{"key":"Vary","value":"Accept-Encoding","name":"Vary","description":"Tells downstream proxies how to match future request headers to decide whether the cached response can be used rather than requesting a fresh one from the origin server."},{"key":"X-Powered-By","value":"PHP/5.6.31","name":"X-Powered-By","description":"Specifies the technology (ASP.NET, PHP, JBoss, e.g.) supporting the web application (version details are often in X-Runtime, X-Version, or X-AspNet-Version)"}],"cookie":[],"responseTime":null,"body":"{\"id\":\"328857190\",\"url\":\"https:\\/\\/syrup.keboola.com\\/queue\\/job\\/328857190\",\"status\":\"waiting\"}"},{"id":"aa99c068-1352-421a-90f9-c50409881f87","name":"Python Transformation","originalRequest":{"method":"POST","header":[{"key":"X-StorageApi-Token","value":"{{token}}"},{"key":"Content-Type","value":"application/json"}],"body":{"mode":"raw","raw":"{\r\n\t\"configData\": {\r\n\t\t\"storage\": {\r\n\t\t\t\"input\": {\r\n\t\t\t\t\"tables\": [\r\n\t\t\t\t\t{\r\n\t\t\t\t\t\t\"source\": \"in.c-main.sample\",\r\n\t\t\t\t\t\t\"destination\": \"source.csv\"\r\n\t\t\t\t\t}\r\n\t\t\t\t]\r\n\t\t\t}\r\n\t\t},\r\n\t\t\"parameters\": {\r\n\t\t\t\"script\": [\r\n\t\t\t\t\"import csv\",\r\n\t\t\t\t\"csvlt = '\\\\n'\",\r\n\t\t\t\t\"csvdel = ','\",\r\n\t\t\t\t\"csvquo = '\\\"'\",\r\n\t\t\t\t\"with open('in/tables/source.csv', mode='rt', encoding='utf-8') as in_file, open('out/tables/destination.csv', mode='wt', encoding='utf-8') as out_file:\",\r\n    \t\t\t\"    writer = csv.DictWriter(out_file, fieldnames=['col1', 'col2'], lineterminator=csvlt, delimiter=csvdel, quotechar=csvquo)\",\r\n    \t\t\t\"    writer.writeheader()\",\r\n\t\t\t\t\"    lazy_lines = (line.replace('\\\\0', '') for line in in_file)\",\r\n\t\t\t\t\"    reader = csv.DictReader(lazy_lines, lineterminator=csvlt, delimiter=csvdel, quotechar=csvquo)\",\r\n\t\t\t\t\"    for row in reader:\",\r\n\t\t\t\t\"        # do something and write row\",\r\n\t\t\t\t\"        writer.writerow({'col1': row['someText'] + 'ping', 'col2': int(row['number']) * 42})\"\r\n\t\t\t]\r\n\t\t}\r\n\t}\r\n}"},"url":"https://syrup.keboola.com/docker/keboola.python-transformation/debug"},"status":"Accepted","code":202,"_postman_previewlanguage":"json","header":[{"key":"Access-Control-Allow-Headers","value":"*","name":"Access-Control-Allow-Headers","description":"Used in response to a preflight request to indicate which HTTP headers can be used when making the actual request."},{"key":"Access-Control-Allow-Methods","value":"*","name":"Access-Control-Allow-Methods","description":"Specifies the method or methods allowed when accessing the resource. This is used in response to a preflight request."},{"key":"Access-Control-Allow-Origin","value":"*","name":"Access-Control-Allow-Origin","description":"Specifies a URI that may access the resource. For requests without credentials, the server may specify '*' as a wildcard, thereby allowing any origin to access the resource."},{"key":"Cache-Control","value":"must-revalidate, no-cache, no-store, private","name":"Cache-Control","description":"Tells all caching mechanisms from server to client whether they may cache this object. It is measured in seconds"},{"key":"Connection","value":"keep-alive","name":"Connection","description":"Options that are desired for the connection"},{"key":"Content-Encoding","value":"gzip","name":"Content-Encoding","description":"The type of encoding used on the data."},{"key":"Content-Length","value":"103","name":"Content-Length","description":"The length of the response body in octets (8-bit bytes)"},{"key":"Content-Type","value":"application/json","name":"Content-Type","description":"The mime type of this content"},{"key":"Date","value":"Mon, 06 Nov 2017 11:41:00 GMT","name":"Date","description":"The date and time that the message was sent"},{"key":"Server","value":"Apache","name":"Server","description":"A name for the server"},{"key":"Vary","value":"Accept-Encoding","name":"Vary","description":"Tells downstream proxies how to match future request headers to decide whether the cached response can be used rather than requesting a fresh one from the origin server."},{"key":"X-Powered-By","value":"PHP/5.6.31","name":"X-Powered-By","description":"Specifies the technology (ASP.NET, PHP, JBoss, e.g.) supporting the web application (version details are often in X-Runtime, X-Version, or X-AspNet-Version)"}],"cookie":[],"responseTime":null,"body":"{\"id\":\"328858482\",\"url\":\"https:\\/\\/syrup.keboola.com\\/queue\\/job\\/328858482\",\"status\":\"waiting\"}"}],"_postman_id":"880d27ba-5af1-4d18-b8d5-1cce87c3ba58"},{"name":"Run Tag","id":"3ebb4c26-7508-426d-a124-739f15079538","request":{"method":"POST","header":[{"key":"X-StorageApi-Token","value":"{{token}}"},{"key":"Content-Type","value":"application/json"}],"body":{"mode":"raw","raw":"{\r\n    \"config\": \"{{configurationId}}\"\r\n}"},"url":"https://syrup.keboola.com/docker/{{componentId}}/run/{{tag}}","description":"[Run a job with specific image tag](https://kebooladocker.docs.apiary.io/#reference/run/create-a-job-with-image/run-job). Creates a job running a specified version of the component."},"response":[],"_postman_id":"3ebb4c26-7508-426d-a124-739f15079538"}]}