{"info":{"_postman_id":"30a8024b-29d1-07bf-22b8-c5210fa21180","name":"KBC Samples","description":"<html><head></head><body><p>Sample Requests for <a href=\"https://developers.keboola.com/overview/api/\">KBC APIs</a></p>\n</body></html>","schema":"https://schema.getpostman.com/json/collection/v2.0.0/collection.json","toc":[],"owner":"3086797","collectionId":"30a8024b-29d1-07bf-22b8-c5210fa21180","publishedId":"77h845D","public":true,"customColor":{"top-bar":"1D293D","right-sidebar":"1D293D","highlight":"00a8ff"},"publishDate":"2017-11-05T16:02:46.000Z"},"item":[{"name":"Jobs","item":[{"name":"Get Components in Project","id":"5dca0c54-a974-1601-47f4-14c2ba9b56fc","request":{"method":"GET","header":[{"key":"X-StorageApi-Token","value":"{{token}}"}],"body":{"mode":"formdata","formdata":[]},"url":"https://connection.keboola.com/v2/storage/components","description":"<p><a href=\"https://keboola.docs.apiary.io/#reference/component-configurations/list-components/get-components\">List Components</a> which have an existing configuration in the given project.</p>\n","urlObject":{"protocol":"https","path":["v2","storage","components"],"host":["connection","keboola","com"],"query":[],"variable":[]}},"response":[{"id":"179645df-c3e1-eaba-e247-889c29e38566","name":"Get Component List","originalRequest":{"method":"GET","header":[{"key":"X-StorageApi-Token","value":"{{token}}","disabled":false}],"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":"166","body":"[\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        \"configurations\": [\n            {\n                \"id\": \"328864809\",\n                \"name\": \"Sample database\",\n                \"description\": \"\",\n                \"created\": \"2017-11-06T13:28:48+0100\",\n                \"creatorToken\": {\n                    \"id\": 27865,\n                    \"description\": \"ondrej.popelka@keboola.com\"\n                },\n                \"version\": 3,\n                \"changeDescription\": \"Create query account\",\n                \"isDeleted\": false,\n                \"currentVersion\": {\n                    \"created\": \"2017-11-06T13:30:12+0100\",\n                    \"creatorToken\": {\n                        \"id\": 27865,\n                        \"description\": \"ondrej.popelka@keboola.com\"\n                    },\n                    \"changeDescription\": \"Create query account\"\n                }\n            }\n        ]\n    }\n]"}],"_postman_id":"5dca0c54-a974-1601-47f4-14c2ba9b56fc"},{"name":"Run Job","id":"8a7302c6-cb27-f39d-656c-b0f1d99bb421","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[{"key":"X-StorageApi-Token","value":"{{token}}"},{"key":"Content-Type","value":"application/json"}],"body":{"mode":"raw","raw":"{\r\n    \"component\": \"{{componentId}}\",\r\n    \"config\": \"{{configurationId}}\",\r\n    \"mode\": \"run\"\r\n}"},"url":"https://queue.keboola.com/jobs","description":"<p><a href=\"https://kebooladocker.docs.apiary.io/#reference/run/create-a-job/run-job\">Run a job API</a></p>\n","urlObject":{"protocol":"https","path":["jobs"],"host":["queue","keboola","com"],"query":[],"variable":[]}},"response":[{"id":"98a16527-2f98-e379-23cb-43417cb43f2f","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    \"component\": \"keboola.ex-db-snowflake\",\r\n    \"config\": \"554424643\",\r\n    \"mode\": \"run\"\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":"737","body":"{\r\n    \"id\": \"807932655\",\r\n    \"runId\": \"807932655\",\r\n    \"parentRunId\": \"\",\r\n    \"project\": {\r\n        \"id\": \"7150\",\r\n        \"name\": \"7150\"\r\n    },\r\n    \"token\": {\r\n        \"id\": \"199182\",\r\n        \"description\": \"ondrej.popelka@keboola.com\"\r\n    },\r\n    \"status\": \"created\",\r\n    \"desiredStatus\": \"processing\",\r\n    \"mode\": \"run\",\r\n    \"component\": \"keboola.ex-db-snowflake\",\r\n    \"config\": \"554424643\",\r\n    \"configData\": [],\r\n    \"configRowIds\": [],\r\n    \"tag\": \"5.5.0\",\r\n    \"createdTime\": \"2022-01-25T16:34:40+00:00\",\r\n    \"startTime\": null,\r\n    \"endTime\": null,\r\n    \"durationSeconds\": 0,\r\n    \"result\": [],\r\n    \"usageData\": [],\r\n    \"isFinished\": false,\r\n    \"url\": \"https://queue.keboola.com/jobs/807932655\",\r\n    \"branchId\": null,\r\n    \"variableValuesId\": null,\r\n    \"variableValuesData\": {\r\n        \"values\": []\r\n    },\r\n    \"backend\": [],\r\n    \"metrics\": [],\r\n    \"behavior\": {\r\n        \"onError\": null\r\n    },\r\n    \"parallelism\": null,\r\n    \"type\": \"standard\"\r\n}"}],"_postman_id":"8a7302c6-cb27-f39d-656c-b0f1d99bb421"},{"name":"Run Debug Job","id":"4170e5ea-5729-4287-b549-2b757a860eb0","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[{"key":"X-StorageApi-Token","value":"{{token}}"},{"key":"Content-Type","value":"application/json"}],"body":{"mode":"raw","raw":"{\r\n    \"component\": \"{{componentId}}\",\r\n    \"config\": \"{{configurationId}}\",\r\n    \"mode\": \"debug\",\r\n    \"tag\": \"5.5.0\"\r\n}"},"url":"https://queue.keboola.com/jobs","description":"<p><a href=\"https://kebooladocker.docs.apiary.io/#reference/run/create-a-job/run-job\">Run a job API</a></p>\n","urlObject":{"protocol":"https","path":["jobs"],"host":["queue","keboola","com"],"query":[],"variable":[]}},"response":[{"id":"f4f5a215-5c34-41ec-a513-164bd892611d","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    \"component\": \"keboola.ex-db-snowflake\",\r\n    \"config\": \"554424643\",\r\n    \"mode\": \"debug\",\r\n    \"tag\": \"5.5.0\"\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":"{\r\n    \"id\": \"807938657\",\r\n    \"runId\": \"807938657\",\r\n    \"parentRunId\": \"\",\r\n    \"project\": {\r\n        \"id\": \"7150\",\r\n        \"name\": \"7150\"\r\n    },\r\n    \"token\": {\r\n        \"id\": \"199182\",\r\n        \"description\": \"ondrej.popelka@keboola.com\"\r\n    },\r\n    \"status\": \"created\",\r\n    \"desiredStatus\": \"processing\",\r\n    \"mode\": \"debug\",\r\n    \"component\": \"keboola.ex-db-snowflake\",\r\n    \"config\": \"554424643\",\r\n    \"configData\": [],\r\n    \"configRowIds\": [],\r\n    \"tag\": \"5.5.0\",\r\n    \"createdTime\": \"2022-01-25T16:58:37+00:00\",\r\n    \"startTime\": null,\r\n    \"endTime\": null,\r\n    \"durationSeconds\": 0,\r\n    \"result\": [],\r\n    \"usageData\": [],\r\n    \"isFinished\": false,\r\n    \"url\": \"https://queue.keboola.com/jobs/807938657\",\r\n    \"branchId\": null,\r\n    \"variableValuesId\": null,\r\n    \"variableValuesData\": {\r\n        \"values\": []\r\n    },\r\n    \"backend\": [],\r\n    \"metrics\": [],\r\n    \"behavior\": {\r\n        \"onError\": null\r\n    },\r\n    \"parallelism\": null,\r\n    \"type\": \"standard\"\r\n}"}],"_postman_id":"4170e5ea-5729-4287-b549-2b757a860eb0"},{"name":"Get Job Status","id":"00d466ec-a65e-ae88-1785-67efcafd6f8d","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[{"key":"X-StorageApi-Token","value":"{{token}}"}],"url":"https://queue.keboola.com/jobs/{{jobId}}","description":"<p>Returns <a href=\"https://syrupqueue.docs.apiary.io/#reference/jobs/job/view-job-detail\">Job Status</a>. Run this request in a loop until the job is finished.</p>\n","urlObject":{"protocol":"https","path":["jobs","{{jobId}}"],"host":["queue","keboola","com"],"query":[],"variable":[]}},"response":[{"id":"ed1abf9a-2d40-1e3b-1462-e9bf83abf6a0","name":"Get Job Status","originalRequest":{"method":"GET","header":[{"key":"X-StorageApi-Token","value":"{{token}}","disabled":false}],"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":"209","body":"{\r\n    \"id\": \"807932655\",\r\n    \"runId\": \"807932655\",\r\n    \"parentRunId\": \"\",\r\n    \"project\": {\r\n        \"id\": \"7150\",\r\n        \"name\": \"7150\"\r\n    },\r\n    \"token\": {\r\n        \"id\": \"199182\",\r\n        \"description\": \"ondrej.popelka@keboola.com\"\r\n    },\r\n    \"status\": \"success\",\r\n    \"desiredStatus\": \"processing\",\r\n    \"mode\": \"run\",\r\n    \"component\": \"keboola.ex-db-snowflake\",\r\n    \"config\": \"554424643\",\r\n    \"configData\": [],\r\n    \"configRowIds\": [],\r\n    \"tag\": \"5.5.0\",\r\n    \"createdTime\": \"2022-01-25T16:34:40+00:00\",\r\n    \"startTime\": \"2022-01-25T16:34:51+00:00\",\r\n    \"endTime\": \"2022-01-25T16:35:49+00:00\",\r\n    \"durationSeconds\": 58,\r\n    \"result\": {\r\n        \"input\": {\r\n            \"tables\": []\r\n        },\r\n        \"images\": [\r\n            [\r\n                {\r\n                    \"id\": \"developer-portal-v2/keboola.ex-db-snowflake:5.5.0\",\r\n                    \"digests\": [\r\n                        \"developer-portal-v2/keboola.ex-db-snowflake@sha256:0f9428c52afea457ec3865cab7cfe457f4f875f3cf45d36f1876c709211da9cf\"\r\n                    ]\r\n                }\r\n            ],\r\n            [\r\n                {\r\n                    \"id\": \"developer-portal-v2/keboola.ex-db-snowflake:5.5.0\",\r\n                    \"digests\": [\r\n                        \"developer-portal-v2/keboola.ex-db-snowflake@sha256:0f9428c52afea457ec3865cab7cfe457f4f875f3cf45d36f1876c709211da9cf\"\r\n                    ]\r\n                }\r\n            ]\r\n        ],\r\n        \"output\": {\r\n            \"tables\": [\r\n                {\r\n                    \"id\": \"in.c-keboola-ex-db-snowflake-554424643.account\",\r\n                    \"name\": \"account\",\r\n                    \"columns\": [\r\n                        {\r\n                            \"name\": \"Id\"\r\n                        },\r\n                        {\r\n                            \"name\": \"Name\"\r\n                        },\r\n                        {\r\n                            \"name\": \"Region\"\r\n                        },\r\n                        {\r\n                            \"name\": \"Status\"\r\n                        },\r\n                        {\r\n                            \"name\": \"First_Order\"\r\n                        }\r\n                    ],\r\n                    \"displayName\": \"account\"\r\n                },\r\n                {\r\n                    \"id\": \"in.c-keboola-ex-db-snowflake-554424643.user\",\r\n                    \"name\": \"user\",\r\n                    \"columns\": [\r\n                        {\r\n                            \"name\": \"Id\"\r\n                        },\r\n                        {\r\n                            \"name\": \"Name\"\r\n                        },\r\n                        {\r\n                            \"name\": \"Sales_Market\"\r\n                        },\r\n                        {\r\n                            \"name\": \"Global_Market\"\r\n                        }\r\n                    ],\r\n                    \"displayName\": \"user\"\r\n                }\r\n            ]\r\n        },\r\n        \"message\": \"Component processing finished.\",\r\n        \"configVersion\": \"6\"\r\n    },\r\n    \"usageData\": [],\r\n    \"isFinished\": true,\r\n    \"url\": \"https://queue.keboola.com/jobs/807932655\",\r\n    \"branchId\": null,\r\n    \"variableValuesId\": null,\r\n    \"variableValuesData\": {\r\n        \"values\": []\r\n    },\r\n    \"backend\": [],\r\n    \"metrics\": {\r\n        \"backend\": {\r\n            \"size\": null\r\n        },\r\n        \"storage\": {\r\n            \"inputTablesBytesSum\": 0\r\n        }\r\n    },\r\n    \"behavior\": {\r\n        \"onError\": null\r\n    },\r\n    \"parallelism\": null,\r\n    \"type\": \"standard\"\r\n}"}],"_postman_id":"00d466ec-a65e-ae88-1785-67efcafd6f8d"}],"id":"1ce06047-c696-bb6e-06e9-b6c0c0035af2","description":"<p>Commonly used requests related to running Jobs in KBC.</p>\n","_postman_id":"1ce06047-c696-bb6e-06e9-b6c0c0035af2"},{"name":"Configurations","item":[{"name":"Variables","item":[{"name":"Create Variables Configuration","id":"16a5d721-b6a4-4daa-9196-8e90250ed16b","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[{"key":"X-StorageApi-Token","value":"{{token}}","type":"text"},{"warning":"This is a duplicate header and will be overridden by the Content-Type header generated by Postman.","key":"Content-Type","value":"application/json","type":"text"}],"body":{"mode":"raw","raw":"{\n    \"name\": \"My new configuration\",\n    \"configuration\": {\n        \"variables\": [\n            {\n                \"name\": \"alias\",\n                \"type\": \"string\"\n            },\n            {\n                \"name\": \"size\",\n                \"type\": \"string\"\n            }\n        ]\n    }\n}"},"url":"https://connection.keboola.com/v2/storage/components/keboola.variables/configs","description":"<p>Step 2 - Create Main Configuration containing variables.</p>\n","urlObject":{"protocol":"https","path":["v2","storage","components","keboola.variables","configs"],"host":["connection","keboola","com"],"query":[],"variable":[]}},"response":[],"_postman_id":"16a5d721-b6a4-4daa-9196-8e90250ed16b"},{"name":"Create Values Configuration","id":"72de2851-1853-4fe3-bec3-856fcc9e2270","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[{"key":"X-StorageApi-Token","value":"{{token}}","type":"text"},{"key":"Content-Type","value":"application/json","type":"text"}],"body":{"mode":"raw","raw":"{\n    \"name\": \"Default values\",\n    \"configuration\": {\n        \"values\": [\n            {\n                \"name\": \"alias\",\n                \"value\": \"batman\"\n            },\n            {\n                \"name\": \"size\",\n                \"value\": \"42\"\n            }\n        ]\n    }\n}"},"url":"https://connection.keboola.com/v2/storage/components/keboola.variables/configs/{{variables_id}}/rows","description":"<p>Step 2 - (optional) Create default values for variables.</p>\n","urlObject":{"protocol":"https","path":["v2","storage","components","keboola.variables","configs","{{variables_id}}","rows"],"host":["connection","keboola","com"],"query":[],"variable":[]}},"response":[],"_postman_id":"72de2851-1853-4fe3-bec3-856fcc9e2270"},{"name":"Create Main Configuration","event":[{"listen":"prerequest","script":{"id":"2aab09c6-11fd-41f6-9341-47b0545ba9c0","exec":[""],"type":"text/javascript"}}],"id":"732e4b66-4f2d-46ab-80ba-7a7d07ddb94b","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[{"key":"X-StorageApi-Token","type":"text","value":"{{token}}"},{"warning":"This is a duplicate header and will be overridden by the Content-Type header generated by Postman.","key":"Content-Type","value":"application/json","type":"text"}],"body":{"mode":"raw","raw":"{\n    \"name\": \"Example Python Transformation\",\n    \"configuration\": {\n            \"storage\": {\n                \"input\": {\n                    \"tables\": [\n                        {\n                            \"source\": \"in.c-variable-testing.batman\",\n                            \"destination\": \"batman.csv\",\n                            \"columns\": [],\n                            \"where_values\": [],\n                            \"where_operator\": \"eq\"\n                        }\n                    ],\n                    \"files\": []\n                },\n                \"output\": {\n                    \"tables\": [\n                        {\n                            \"source\": \"new-table.csv\",\n                            \"destination\": \"out.c-variable-testing.cars\",\n                            \"incremental\": false,\n                            \"primary_key\": [],\n                            \"columns\": [],\n                            \"delete_where_values\": [],\n                            \"delete_where_operator\": \"eq\",\n                            \"delimiter\": \",\",\n                            \"enclosure\": \"\\\"\",\n                            \"metadata\": [],\n                            \"column_metadata\": []\n                        }\n                    ],\n                    \"files\": []\n                }\n            },\n            \"parameters\": {\n                \"blocks\": [\n                    {\n                        \"name\": \"First Block\",\n                        \"codes\": [\n                            {\n                                \"name\": \"First Code\",\n                                \"script\": [\n                                    \"import csv\\ncsvlt = '\\\\n'\\ncsvdel = ','\\ncsvquo = '\\\"'\\nwith open('in/tables/{{alias}}.csv', mode='rt', encoding='utf-8') as in_file, open('out/tables/new-table.csv', mode='wt', encoding='utf-8') as out_file:\\n    writer = csv.DictWriter(out_file, fieldnames=['COUNTRY', 'CARS'], lineterminator=csvlt, delimiter=csvdel, quotechar=csvquo)\\n    writer.writeheader()\\n\\n    lazy_lines = (line.replace('\\\\0', '') for line in in_file)\\n    reader = csv.DictReader(lazy_lines, lineterminator=csvlt, delimiter=csvdel, quotechar=csvquo)\\n    for row in reader:\\n        writer.writerow({'COUNTRY': row['COUNTRY'] + '{{ alias }}', 'CARS': row['CARS'] + '{{ size }}'})\\nfrom pathlib import Path\\nimport sys\\ncontents = Path('/data/config.json').read_text()\\nprint(contents, file=sys.stdout)\"\n                                ]\n                            }\n                        ]\n                    }\n                ]\n            },\n            \"variables_id\": \"807943784\",\n            \"variables_values_id\": \"807952812\",\n            \"image_parameters\": {},\n            \"action\": \"run\",\n            \"authorization\": {}\n    }\n}"},"url":"https://connection.keboola.com/v2/storage/components/keboola.python-transformation-v2/configs","description":"<p>Step 3 - Create Main Configuration containing variables.</p>\n","urlObject":{"protocol":"https","path":["v2","storage","components","keboola.python-transformation-v2","configs"],"host":["connection","keboola","com"],"query":[],"variable":[]}},"response":[],"_postman_id":"732e4b66-4f2d-46ab-80ba-7a7d07ddb94b"},{"name":"Run Job with default values","id":"31486ac2-ea52-4f19-a039-2ee1b1ae5863","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[{"key":"X-StorageApi-Token","type":"text","value":"{{token}}"}],"body":{"mode":"raw","raw":"{\n    \"component\": \"keboola.python-transformation\",\n\t\"config\": \"{{main_config_id}}\",\n    \"mode\": \"run\"\n}","options":{"raw":{"language":"json"}}},"url":"https://queue.keboola.com/jobs","description":"<p>Step 4 - Run Job with default values</p>\n","urlObject":{"protocol":"https","path":["jobs"],"host":["queue","keboola","com"],"query":[],"variable":[]}},"response":[],"_postman_id":"31486ac2-ea52-4f19-a039-2ee1b1ae5863"},{"name":"Add Values Configuration","id":"fbe487b5-cd68-4318-8219-7c067ebef795","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[{"key":"X-StorageApi-Token","value":"{{token}}","type":"text"},{"warning":"This is a duplicate header and will be overridden by the Content-Type header generated by Postman.","key":"Content-Type","value":"application/json","type":"text"}],"body":{"mode":"raw","raw":"{\n    \"name\": \"New values\",\n    \"configuration\": {\n        \"values\": [\n            {\n                \"name\": \"alias\",\n                \"value\": \"WATMAN\"\n            },\n            {\n                \"name\": \"size\",\n                \"value\": \"4200\"\n            }\n        ]\n    }\n}"},"url":"https://connection.keboola.com/v2/storage/components/keboola.variables/configs/{{variables_id}}/rows","description":"<p>Step 4 - Create another set of values for variables.</p>\n","urlObject":{"protocol":"https","path":["v2","storage","components","keboola.variables","configs","{{variables_id}}","rows"],"host":["connection","keboola","com"],"query":[],"variable":[]}},"response":[],"_postman_id":"fbe487b5-cd68-4318-8219-7c067ebef795"},{"name":"Run Job with set values","id":"f883eb13-3f20-4e03-bf1b-36e9c889f773","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[{"key":"X-StorageApi-Token","type":"text","value":"{{token}}"}],"body":{"mode":"raw","raw":"{\n    \"component\": \"keboola.python-transformation\",\n    \"config\": \"{{main_config_id}}\",\n    \"mode\": \"run\",\n    \"variableValuesId\": \"{{new_values_id}}\"\n}","options":{"raw":{"language":"json"}}},"url":"https://queue.keboola.com/jobs","description":"<p>Step 4 - Run job with set values</p>\n","urlObject":{"protocol":"https","path":["jobs"],"host":["queue","keboola","com"],"query":[],"variable":[]}},"response":[],"_postman_id":"f883eb13-3f20-4e03-bf1b-36e9c889f773"},{"name":"Run Job with inline values","id":"2c38d6ca-2eda-4c7e-9888-071fad3d31d8","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[{"key":"X-StorageApi-Token","type":"text","value":"{{token}}"}],"body":{"mode":"raw","raw":"{\r\n    \"component\": \"keboola.python-transformation\",\r\n    \"config\": \"{{main_config_id}}\",\r\n    \"mode\": \"run\",\r\n    \"variableValuesData\": {\r\n        \"values\": [\r\n            {\r\n                \"name\": \"alias\",\r\n                \"value\": \"batman\"\r\n            },\r\n            {\r\n                \"name\": \"size\",\r\n                \"value\": \"scatman\"\r\n            }\r\n        ]\r\n\t}\r\n}","options":{"raw":{"language":"json"}}},"url":"https://queue.keboola.com/jobs","description":"<p>Step 4 - Run job with inline values</p>\n","urlObject":{"protocol":"https","path":["jobs"],"host":["queue","keboola","com"],"query":[],"variable":[]}},"response":[],"_postman_id":"2c38d6ca-2eda-4c7e-9888-071fad3d31d8"},{"name":"Create Orchestration","id":"9f2f9da0-59eb-4f33-a206-e5add24725d1","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[{"key":"X-StorageApi-Token","type":"text","value":"{{token}}"},{"warning":"This is a duplicate header and will be overridden by the Content-Type header generated by Postman.","key":"Content-Type","value":"application/json","type":"text"}],"body":{"mode":"raw","raw":"{\n    \"name\": \"Example Orchestration\",\n    \"configuration\": {\n        \"phases\": [\n            {\n                \"id\": 2468,\n                \"name\": \"Extractors\",\n                \"dependsOn\": []\n            }\n        ],\n        \"tasks\": [\n            {\n                \"id\": 13579,\n                \"name\": \"Example\",\n                \"phase\": 2468,\n                \"task\": {\n                    \"componentId\": \"keboola.python-transformation-v2\",\n                    \"configId\": \"807968875\",\n                    \"mode\": \"run\",\n                    \"variableValuesId\": \"807957572\"\n                },\n                \"continueOnFailure\": false,\n                \"enabled\": true\n            }\n        ]\n    }\n}"},"url":"https://connection.keboola.com/v2/storage/components/keboola.orchestrator/configs","description":"<p>Step 6 - Run Orchestration</p>\n","urlObject":{"protocol":"https","path":["v2","storage","components","keboola.orchestrator","configs"],"host":["connection","keboola","com"],"query":[],"variable":[]}},"response":[],"_postman_id":"9f2f9da0-59eb-4f33-a206-e5add24725d1"},{"name":"Run Orchestration","id":"3ebdc3f5-a940-4f0d-860b-ec311f704a7e","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[{"key":"X-StorageApi-Token","type":"text","value":"{{token}}"}],"body":{"mode":"raw","raw":"{\r\n    \"component\": \"keboola.orchestrator\",\r\n    \"config\": \"{{orchestration_id}}\",\r\n    \"mode\": \"run\"\r\n}","options":{"raw":{"language":"json"}}},"url":"https://queue.keboola.com/jobs","description":"<p>Step 6 - Run orchestration with defined values</p>\n","urlObject":{"protocol":"https","path":["jobs"],"host":["queue","keboola","com"],"query":[],"variable":[]}},"response":[],"_postman_id":"3ebdc3f5-a940-4f0d-860b-ec311f704a7e"},{"name":"Run Orchestration with Override","id":"f4fcf7af-afbe-4c29-999e-0f4c50aa477b","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[{"key":"X-StorageApi-Token","type":"text","value":"{{token}}"}],"body":{"mode":"raw","raw":"{\r\n    \"component\": \"keboola.orchestrator\",\r\n    \"config\": \"{{orchestration_id}}\",\r\n    \"mode\": \"run\",\r\n    \"variableValuesData\": {\r\n        \"values\": [\r\n            {\r\n                \"name\": \"alias\",\r\n                \"value\": \"batman\"\r\n            },\r\n            {\r\n                \"name\": \"size\",\r\n                \"value\": \"scatman\"\r\n            }\r\n        ]\r\n    }\r\n}","options":{"raw":{"language":"json"}}},"url":"https://queue.keboola.com/jobs","description":"<p>Step 6 - Run Orchestration and override defined values</p>\n","urlObject":{"protocol":"https","path":["jobs"],"host":["queue","keboola","com"],"query":[],"variable":[]}},"response":[],"_postman_id":"f4fcf7af-afbe-4c29-999e-0f4c50aa477b"}],"id":"a608b039-c608-46f2-b8e1-98728277c152","description":"<p>See the <a href=\"https://developers.keboola.com/integrate/variables/\">Documentation</a> for a more detailed description.</p>\n","event":[{"listen":"prerequest","script":{"id":"8b7c1d69-2c93-4088-84db-f34004acabfa","type":"text/javascript","exec":[""]}},{"listen":"test","script":{"id":"42dd5980-f3a0-4ed1-9a79-1af8a6d2515a","type":"text/javascript","exec":[""]}}],"_postman_id":"a608b039-c608-46f2-b8e1-98728277c152"},{"name":"Get Components","id":"f0e321e0-6533-0074-662d-fe4ab85a15d5","request":{"method":"GET","header":[],"body":{"mode":"formdata","formdata":[]},"url":"https://connection.keboola.com/v2/storage","description":"<p>Return a list of all <a href=\"https://keboola.docs.apiary.io/#reference/miscellaneous/api-index/get-components\">available components</a>.</p>\n","urlObject":{"protocol":"https","path":["v2","storage"],"host":["connection","keboola","com"],"query":[],"variable":[]}},"response":[{"id":"63c5d62b-fc04-e659-b637-52a4cc4f2a77","name":"Get Components","originalRequest":{"method":"GET","header":[],"body":{"mode":"formdata","formdata":[]},"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":"858","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":"f0e321e0-6533-0074-662d-fe4ab85a15d5"},{"name":"List Component Configurations","id":"9b84ef26-51aa-b281-e219-cc90c867fd9d","request":{"method":"GET","header":[{"key":"X-StorageAPI-Token","value":"{{token}}"}],"body":{"mode":"formdata","formdata":[]},"url":"https://connection.keboola.com/v2/storage/components/{{componentId}}/configs","description":"<p><a href=\"http://docs.keboola.apiary.io/#reference/component-configurations/component-configs/list-configs\">List existing configurations</a> of a given component.</p>\n","urlObject":{"protocol":"https","path":["v2","storage","components","{{componentId}}","configs"],"host":["connection","keboola","com"],"query":[],"variable":[]}},"response":[],"_postman_id":"9b84ef26-51aa-b281-e219-cc90c867fd9d"},{"name":"List Configuration Versions","id":"3e962568-9c38-207a-58bb-a92144adbe41","request":{"method":"GET","header":[{"key":"X-StorageAPI-Token","value":"{{token}}"}],"body":{"mode":"formdata","formdata":[]},"url":"https://connection.keboola.com/v2/storage/components/{{componentId}}/configs/{{configurationId}}/versions","description":"<p><a href=\"http://docs.keboola.apiary.io/#reference/component-configurations/list-configs-versions/versions-list\">List versions</a> of the given configuration.</p>\n","urlObject":{"protocol":"https","path":["v2","storage","components","{{componentId}}","configs","{{configurationId}}","versions"],"host":["connection","keboola","com"],"query":[],"variable":[]}},"response":[{"id":"d07bae9f-11b1-4427-82d6-dec82e88b445","name":"S3 Extractor configuration versions","originalRequest":{"method":"GET","header":[{"key":"X-StorageAPI-Token","value":"{{token}}","disabled":false}],"body":{"mode":"formdata","formdata":[]},"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":"3e962568-9c38-207a-58bb-a92144adbe41"},{"name":"Create Copy","id":"1591dcb4-2084-e5fe-2f3f-cd7f546f7315","request":{"method":"POST","header":[{"key":"X-StorageAPI-Token","value":"{{token}}"},{"warning":"This is a duplicate header and will be overridden by the Content-Type header generated by Postman.","key":"Content-Type","value":"application/json"}],"body":{"mode":"raw","raw":"{\n    \"name\": \"{{name}}\",\n    \"description\": \"Test Copy\"\n}"},"url":"https://connection.keboola.com/v2/storage/components/{{componentId}}/configs/{{configurationId}}/versions/{{versionId}}/create","description":"<p>Create a <a href=\"https://keboola.docs.apiary.io/#reference/component-configurations/copy-configurations/create-configuration-copy\">configuration copy</a>.</p>\n","urlObject":{"protocol":"https","path":["v2","storage","components","{{componentId}}","configs","{{configurationId}}","versions","{{versionId}}","create"],"host":["connection","keboola","com"],"query":[],"variable":[]}},"response":[],"_postman_id":"1591dcb4-2084-e5fe-2f3f-cd7f546f7315"},{"name":"Rollback Configuration","id":"2050856a-66b3-4120-9552-d1278a96621e","request":{"method":"POST","header":[{"key":"X-StorageAPI-Token","value":"{{token}}"},{"key":"Content-Type","value":"application/json"}],"body":{"mode":"formdata","formdata":[]},"url":"https://connection.keboola.com/v2/storage/components/{{componentId}}/configs/{{configurationId}}/versions/{{versionId}}/rollback","description":"<p><a href=\"https://keboola.docs.apiary.io/#reference/component-configurations/rollback-configuration-version/rollback-version\">Rollback configuration</a> to the given version.</p>\n","urlObject":{"protocol":"https","path":["v2","storage","components","{{componentId}}","configs","{{configurationId}}","versions","{{versionId}}","rollback"],"host":["connection","keboola","com"],"query":[],"variable":[]}},"response":[{"id":"4410c6cb-41d1-4f6b-8ded-f1f5c1381dc8","name":"Rollback S3 Configuration","originalRequest":{"method":"POST","header":[{"key":"X-StorageAPI-Token","value":"{{token}}"},{"key":"Content-Type","value":"application/json"}],"body":{"mode":"formdata","formdata":[]},"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":"2050856a-66b3-4120-9552-d1278a96621e"},{"name":"Component Configuration Detail","id":"9b9f3e7b-de3b-4c90-bad6-a8760e3852eb","request":{"method":"GET","header":[{"key":"X-StorageAPI-Token","value":"{{token}}"}],"body":{"mode":"formdata","formdata":[]},"url":"https://connection.keboola.com/v2/storage/components/{{componentId}}/configs/{{configurationId}}","description":"<p><a href=\"https://keboola.docs.apiary.io/#reference/component-configurations/component-configurations/configuration-detail\">Show details</a> of a given component configuration.</p>\n","urlObject":{"protocol":"https","path":["v2","storage","components","{{componentId}}","configs","{{configurationId}}"],"host":["connection","keboola","com"],"query":[],"variable":[]}},"response":[{"id":"2372a5c9-0f50-4d4e-9e9a-eee12395f457","name":"Email Attachments Extractor Configuration Detail","originalRequest":{"method":"GET","header":[{"key":"X-StorageAPI-Token","value":"{{token}}","disabled":false}],"body":{"mode":"formdata","formdata":[]},"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\"}}"},{"id":"95190780-daaa-4e29-a33c-a3fbdb10bd7d","name":"S3 Extractor Configuration Detail","originalRequest":{"method":"GET","header":[{"key":"X-StorageAPI-Token","value":"{{token}}","disabled":false}],"body":{"mode":"formdata","formdata":[]},"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\"}}"}],"_postman_id":"9b9f3e7b-de3b-4c90-bad6-a8760e3852eb"},{"name":"Update configuration","id":"91e2060c-0c14-7a09-0cc3-537eb6057ada","request":{"method":"PUT","header":[{"key":"Content-Type","value":"application/json"},{"key":"X-StorageAPI-Token","value":"{{token}}"}],"body":{"mode":"raw","raw":"{\n    \"configuration\": \"{{configurationJson}}\"\n}"},"url":"https://connection.keboola.com/v2/storage/components/{{componentId}}/configs/{{configurationId}}","description":"<p><a href=\"https://keboola.docs.apiary.io/#reference/component-configurations/manage-configurations/update-configuration\">Update an existing configuration</a>. Note that the configuration must be sent as an encoded JSON in the form field.</p>\n","urlObject":{"protocol":"https","path":["v2","storage","components","{{componentId}}","configs","{{configurationId}}"],"host":["connection","keboola","com"],"query":[],"variable":[]}},"response":[{"id":"0e35bdf4-5741-4a9c-9264-88d027d86bdb","name":"Set Row order of S3 Extractor","originalRequest":{"method":"PUT","header":[{"key":"Content-Type","name":"Content-Type","value":"application/json","type":"text"},{"key":"X-StorageAPI-Token","value":"{{token}}","disabled":false}],"body":{"mode":"raw","raw":"{\n    \"rowsSortOrder\": \n        [\n            \"364481153\",\n            \"364949834\"\n        ]\n}","options":{"raw":{"language":"json"}}},"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\":\"\"}}"},{"id":"0fdfe266-342f-46fe-bdf0-61d8135d85c9","name":"Update AWS S3 configuration to set new credentials","originalRequest":{"method":"PUT","header":[{"key":"Content-Type","name":"Content-Type","value":"application/json","type":"text"},{"key":"X-StorageAPI-Token","value":"{{token}}","disabled":false}],"body":{"mode":"raw","raw":"{\n    \"configuration\": {\n        \"parameters\": {\n            \"accessKeyId\": \"a\",\n            \"#secretAccessKey\": \"b\"\n        }\n    }\n}","options":{"raw":{"language":"json"}}},"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":"283cbe43-d674-46ee-b910-6569955833d9","name":"Add processor to Email Attachments Extractor Configuration","originalRequest":{"method":"PUT","header":[{"key":"Content-Type","name":"Content-Type","value":"application/json","type":"text"},{"key":"X-StorageAPI-Token","value":"{{token}}","disabled":false}],"body":{"mode":"raw","raw":"{\n    \"configuration\": {\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    }\n}","options":{"raw":{"language":"json"}}},"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\":\"\"}}"}],"_postman_id":"91e2060c-0c14-7a09-0cc3-537eb6057ada"},{"name":"Update configuration Row","id":"1e7fd94e-f22c-4a77-82c1-babc8602f9cd","request":{"method":"PUT","header":[{"key":"Content-Type","value":"application/json"},{"key":"X-StorageAPI-Token","value":"{{token}}"}],"body":{"mode":"raw","raw":"{\n    \"configuration\": \"{{configurationJson}}\"\n}"},"url":"https://connection.keboola.com/v2/storage/components/{{componentId}}/configs/{{configurationId}}/rows/{{rowId}}","description":"<p><a href=\"https://keboola.docs.apiary.io/#reference/component-configurations/manage-configuration-rows/update-row\">Update an existing configuration row</a>. Note that the configuration must be sent as an encoded JSON in the form field.</p>\n","urlObject":{"protocol":"https","path":["v2","storage","components","{{componentId}}","configs","{{configurationId}}","rows","{{rowId}}"],"host":["connection","keboola","com"],"query":[],"variable":[]}},"response":[{"id":"c41ec476-0a13-40ee-8c14-efc4a4bbc91c","name":"Reset S3 Extractor Row State","originalRequest":{"method":"PUT","header":[{"key":"Content-Type","name":"Content-Type","value":"application/json","type":"text"},{"key":"X-StorageAPI-Token","value":"{{token}}"}],"body":{"mode":"raw","raw":"{\n    \"state\": {}\n}","options":{"raw":{"language":"json"}}},"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\":{}}"},{"id":"e4e62f3a-bf20-4d58-85d0-e2e3037fa667","name":"Update S3 Extractor configuration Row","originalRequest":{"method":"PUT","header":[{"key":"Content-Type","name":"Content-Type","value":"application/json","type":"text"},{"key":"X-StorageAPI-Token","value":"{{token}}","disabled":false}],"body":{"mode":"raw","raw":"{\n    \"configuration\": {\n        \"parameters\": {\n            \"bucket\": \"some-bucket\",\n            \"key\": \"sample.csv\",\n            \"includeSubfolders\": false,\n            \"newFilesOnly\": true\n        }\n    }\n}","options":{"raw":{"language":"json"}}},"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":"fb993e0f-8dfa-46c0-97aa-c673cb714393","name":"Add processor to S3 Extractor configuration Row","originalRequest":{"method":"PUT","header":[{"key":"Content-Type","name":"Content-Type","value":"application/json","type":"text"},{"key":"X-StorageAPI-Token","value":"{{token}}","disabled":false}],"body":{"mode":"raw","raw":"{\n    \"configuration\": {{configurationJson}}\n}","options":{"raw":{"language":"json"}}},"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\":{}}"}],"_postman_id":"1e7fd94e-f22c-4a77-82c1-babc8602f9cd"}],"id":"0e4f6c71-89af-ca3f-ee04-fabc1a4529ad","description":"<p>Requests for working with <a href=\"https://keboola.docs.apiary.io/#reference/component-configurations/list-components/get-components\">Configurations</a> of components.</p>\n","_postman_id":"0e4f6c71-89af-ca3f-ee04-fabc1a4529ad"},{"name":"Table Importer","item":[{"name":"Import Table","id":"a56550a2-1d3b-0207-4f8d-850e5bd3781b","request":{"method":"POST","header":[{"key":"X-StorageApi-Token","value":"{{token}}"}],"body":{"mode":"formdata","formdata":[{"key":"tableId","value":"{{tableId}}","type":"text"},{"key":"data","value":null,"type":"file"}]},"url":"https://import.keboola.com/write-table","description":"<p>Import data into an existing table</p>\n","urlObject":{"protocol":"https","path":["write-table"],"host":["import","keboola","com"],"query":[],"variable":[]}},"response":[{"id":"8202edfb-c53a-44d6-7c65-df603dfa4e67","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":null}]},"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":"14811","body":"{\"transaction\":null,\"warnings\":[],\"importedColumns\":[\"number\",\"someText\"],\"totalRowsCount\":5,\"totalDataSizeBytes\":12582912}"}],"_postman_id":"a56550a2-1d3b-0207-4f8d-850e5bd3781b"}],"id":"2f4468c1-08c0-4743-4800-41cd974aae7a","description":"<p>Use <a href=\"https://developers.keboola.com/integrate/storage/api/importer/\">Storage API importer</a> to import data to KBC.</p>\n","_postman_id":"2f4468c1-08c0-4743-4800-41cd974aae7a"},{"name":"Common Tasks","item":[{"name":"Run Job","id":"fd60aa15-485c-4922-8536-c2ba2f27e8ea","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[{"key":"X-StorageApi-Token","value":"{{token}}","type":"text"}],"body":{"mode":"raw","raw":"{\r\n    \"mode\": \"run\",\r\n    \"component\": \"keboola.ex-db-snowflake\",\r\n    \"config\": \"493493\"\r\n}","options":{"raw":{"language":"json"}}},"url":"https://queue.keboola.com/jobs","urlObject":{"protocol":"https","path":["jobs"],"host":["queue","keboola","com"],"query":[],"variable":[]}},"response":[{"id":"5d6f11f8-41a0-4735-9776-689df9f998e1","name":"Run Job","originalRequest":{"method":"POST","header":[{"key":"X-StorageApi-Token","value":"{{token}}","type":"text"}],"body":{"mode":"raw","raw":"{\r\n    \"mode\": \"run\",\r\n    \"component\": \"keboola.ex-db-snowflake\",\r\n    \"config\": \"493493\"\r\n}","options":{"raw":{"language":"json"}}},"url":"https://queue.keboola.com/jobs"},"_postman_previewlanguage":null,"header":null,"cookie":[],"responseTime":null,"body":null}],"_postman_id":"fd60aa15-485c-4922-8536-c2ba2f27e8ea"},{"name":"Run Orchestration","id":"3e71b131-afd4-44be-9831-6534e581f2e0","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[{"key":"X-StorageApi-Token","value":"{{token}}","type":"text"}],"body":{"mode":"raw","raw":"{\r\n    \"mode\": \"run\",\r\n    \"component\": \"keboola.orchestrator\",\r\n    \"config\": \"1496488\"\r\n}","options":{"raw":{"language":"json"}}},"url":"https://queue.keboola.com/jobs","urlObject":{"protocol":"https","path":["jobs"],"host":["queue","keboola","com"],"query":[],"variable":[]}},"response":[{"id":"7a956957-0775-4799-9353-46031e074748","name":"Run Orchestration","originalRequest":{"method":"POST","header":[{"key":"X-StorageApi-Token","value":"{{token}}","type":"text"}],"body":{"mode":"raw","raw":"{\r\n    \"mode\": \"run\",\r\n    \"component\": \"keboola.ex-db-snowflake\",\r\n    \"config\": \"493493\"\r\n}","options":{"raw":{"language":"json"}}},"url":"https://queue.keboola.com/jobs"},"_postman_previewlanguage":null,"header":null,"cookie":[],"responseTime":null,"body":null}],"_postman_id":"3e71b131-afd4-44be-9831-6534e581f2e0"},{"name":"Create Scheduler configuration","id":"b721ecd8-159c-4895-9d0b-8b735880b714","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[{"key":"X-StorageApi-Token","value":"{{token}}","type":"text"},{"key":"Content-Type","value":"application/json","type":"text"}],"body":{"mode":"raw","raw":"{\n    \"name\": \"Example Schedule\",\n    \"configuration\": {\n        \"schedule\": {\n            \"cronTab\": \"0 * * * *\",\n            \"timezone\": \"UTC\",\n            \"state\": \"enabled\"\n        },\n        \"target\": {\n            \"componentId\": \"keboola.ex-db-snowflake\",\n            \"configurationId\": \"493493\",\n            \"mode\": \"run\"\n        }\n    }\n}","options":{"raw":{"language":"json"}}},"url":"https://connection.keboola.com/v2/storage/components/keboola.scheduler/configs/","urlObject":{"protocol":"https","path":["v2","storage","components","keboola.scheduler","configs",""],"host":["connection","keboola","com"],"query":[],"variable":[]}},"response":[{"id":"818a8419-592e-40ea-8cce-4d538beb6d88","name":"Create Scheduler configuration","originalRequest":{"method":"POST","header":[{"key":"X-StorageApi-Token","value":"{{token}}","type":"text"},{"key":"Content-Type","name":"Content-Type","value":"application/json","type":"text"}],"body":{"mode":"raw","raw":"{\n    \"name\": \"Example Schedule\",\n    \"configuration\": {\n        \"schedule\": {\n            \"cronTab\": \"0 * * * *\",\n            \"timezone\": \"UTC\",\n            \"state\": \"enabled\"\n        },\n        \"target\": {\n            \"componentId\": \"keboola.ex-db-snowflake\",\n            \"configurationId\": \"493493\",\n            \"mode\": \"run\"\n        }\n    }\n}","options":{"raw":{"language":"json"}}},"url":"https://connection.keboola.com/v2/storage/components/keboola.scheduler/configs/"},"_postman_previewlanguage":null,"header":null,"cookie":[],"responseTime":null,"body":null}],"_postman_id":"b721ecd8-159c-4895-9d0b-8b735880b714"},{"name":"Activate Schedule","id":"130cbfc4-4dd5-4f6d-99c0-2444c48ee551","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[{"key":"X-StorageApi-Token","value":"{{token}}","type":"text"}],"body":{"mode":"raw","raw":"{\r\n    \"configurationId\": \"10852379\"\r\n}\r\n","options":{"raw":{"language":"json"}}},"url":"https://scheduler.keboola.com/schedules","urlObject":{"protocol":"https","path":["schedules"],"host":["scheduler","keboola","com"],"query":[],"variable":[]}},"response":[{"id":"8fbb0c2a-08d6-402c-8a21-6abe3ffe07db","name":"Activate Schedule","originalRequest":{"method":"POST","header":[{"key":"X-StorageApi-Token","value":"{{token}}","type":"text"}],"body":{"mode":"raw","raw":"{\r\n    \"configurationId\": \"10850624\"\r\n}\r\n","options":{"raw":{"language":"json"}}},"url":"https://scheduler.keboola.com/schedules"},"_postman_previewlanguage":null,"header":null,"cookie":[],"responseTime":null,"body":null}],"_postman_id":"130cbfc4-4dd5-4f6d-99c0-2444c48ee551"},{"name":"Create Scheduler configuration for Row","id":"0fadefb7-9352-45b0-8c4e-6f3742feea2a","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[{"key":"X-StorageApi-Token","value":"{{token}}","type":"text"},{"key":"Content-Type","value":"application/json","type":"text"}],"body":{"mode":"raw","raw":"{\n    \"name\": \"Example Row Schedule\",\n    \"configuration\": {\n        \"schedule\": {\n            \"cronTab\": \"10,20,30,40,50 * * * *\",\n            \"timezone\": \"UTC\",\n            \"state\": \"enabled\"\n        },\n        \"target\": {\n            \"componentId\": \"keboola.ex-db-snowflake\",\n            \"configurationId\": \"493493\",\n            \"configurationRowIds\": [\"48094\"],\n            \"mode\": \"run\"\n        }\n    }\n}","options":{"raw":{"language":"json"}}},"url":"https://connection.keboola.com/v2/storage/components/keboola.scheduler/configs/","urlObject":{"protocol":"https","path":["v2","storage","components","keboola.scheduler","configs",""],"host":["connection","keboola","com"],"query":[],"variable":[]}},"response":[{"id":"895a8a6f-46cc-4eff-879f-cc0b5fcec7ae","name":"Create Scheduler configuration for Row","originalRequest":{"method":"POST","header":[{"key":"X-StorageApi-Token","value":"{{token}}","type":"text"},{"key":"Content-Type","name":"Content-Type","value":"application/json","type":"text"}],"body":{"mode":"raw","raw":"{\n    \"name\": \"Example Row Schedule\",\n    \"configuration\": {\n        \"schedule\": {\n            \"cronTab\": \"10,20,30,40,50 * * * *\",\n            \"timezone\": \"UTC\",\n            \"state\": \"enabled\"\n        },\n        \"target\": {\n            \"componentId\": \"keboola.ex-db-snowflake\",\n            \"configurationId\": \"493493\",\n            \"configurationRowIds\": [\"48094\"],\n            \"mode\": \"run\"\n        }\n    }\n}","options":{"raw":{"language":"json"}}},"url":"https://connection.keboola.com/v2/storage/components/keboola.scheduler/configs/"},"_postman_previewlanguage":null,"header":null,"cookie":[],"responseTime":null,"body":null}],"_postman_id":"0fadefb7-9352-45b0-8c4e-6f3742feea2a"},{"name":"List schedules","id":"6e0f31b1-9d50-4b51-9570-5334936d569c","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[{"key":"X-StorageApi-Token","value":"{{token}}","type":"text"}],"url":"https://scheduler.keboola.com/schedules?configurationId=10852379","urlObject":{"protocol":"https","path":["schedules"],"host":["scheduler","keboola","com"],"query":[{"key":"configurationId","value":"10852379"}],"variable":[]}},"response":[],"_postman_id":"6e0f31b1-9d50-4b51-9570-5334936d569c"}],"id":"6010ad96-1ef6-41ab-8974-2daaea4f94e6","_postman_id":"6010ad96-1ef6-41ab-8974-2daaea4f94e6","description":""},{"name":"Encryption","id":"1e6a668b-adf4-d76d-42d4-4395d2be59a3","request":{"method":"POST","header":[{"key":"Content-Type","value":"text/plain"}],"body":{"mode":"raw","raw":"secret"},"url":"https://syrup.keboola.com/docker/encrypt","description":"<p><a href=\"https://kebooladocker.docs.apiary.io/#reference/encrypt/encryption/encrypt-data\">Encrypts</a> plain text and JSON data.</p>\n","urlObject":{"protocol":"https","path":["docker","encrypt"],"host":["syrup","keboola","com"],"query":[],"variable":[]}},"response":[{"id":"437f58d3-2f2d-e349-c9d7-e87f6f65d1f9","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":"161","body":"KBC::Encrypted==UkAwaHCWtrz9ETTRDkkXjgvUvjnAFiZcDz2MOz3Y3ehYVMdhBgYD4RPbDtmupYmiRaeWtIJ677praligVqBMIQ=="},{"id":"44eadec5-1aa9-3c61-be44-58f746053b00","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":"247","body":"{\"plain\":\"this will not be encrypted\",\"#secret\":\"KBC::ComponentProjectEncrypted==F1e3rGS4tWRpBFbz3L7IfxUhbUfGXR5IitebMOhtSYUXc0bUERRm4tzg9dnKMQsA0f0tt+Id8ChcdMAHIyn+SPlllpdNSHQeSBxobIpkCeo=\"}"},{"id":"8b5fed79-3a8c-5744-87c8-c11167c62e79","name":"Project Encryption","originalRequest":{"method":"POST","header":[{"key":"Content-Type","type":"text","name":"Content-Type","value":"text/plain","disabled":false}],"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":"155","body":"KBC::Encrypted==NTc6awasHoiMTGmjR4T8nX9Ho6qzQ9o1ZQ58iJkAMi5TLYuEkS5dDAdchGqEoA4SoqWQ0ce/uCMQhDH5kQdGQw=="},{"id":"8e043da9-0048-3fc1-67bc-b19777896eac","name":"Encrypt JSON","originalRequest":{"method":"POST","header":[{"key":"Content-Type","value":"application/json"}],"body":{"mode":"formdata","formdata":[]},"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":"142","body":"{\"plain\":\"this will not be encrypted\",\"#secret\":\"KBC::Encrypted==zTc6dHE25rewduSLIkGOcn3BIWcJxRp\\/NzAutMy9HVJDQlUt\\/X9gMXEYjBAK+HB0NGUjtG6pivptQq+fpKrk6FOIrRgyV533WnaZHoiscAo=\"}"}],"_postman_id":"1e6a668b-adf4-d76d-42d4-4395d2be59a3"},{"name":"Debug","id":"4c9c7c9f-6cd6-58e7-27e3-aef62538e0ba","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":"<p><a href=\"https://kebooladocker.docs.apiary.io/#reference/debug\">Debug</a> API call creates an archive with the data directory. This allows you to run a component locally with a copy of the production envrionment.</p>\n","urlObject":{"protocol":"https","path":["docker","{{componentId}}","debug"],"host":["syrup","keboola","com"],"query":[],"variable":[]}},"response":[{"id":"49ce83e2-e65e-f1b9-8167-3492e4d2eff1","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":"774","body":"{\"id\":\"328857190\",\"url\":\"https:\\/\\/syrup.keboola.com\\/queue\\/job\\/328857190\",\"status\":\"waiting\"}"},{"id":"4eec5bf2-a612-4c55-80e9-3121fd751ca8","name":"Run Config Row","originalRequest":{"method":"POST","header":[{"key":"X-StorageApi-Token","value":"{{token}}","disabled":false},{"key":"Content-Type","value":"application/json","disabled":false}],"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":"64da53b5-24b9-ac73-c448-7bf55e6c20ff","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":"977","body":"{\"id\":\"328855088\",\"url\":\"https:\\/\\/syrup.keboola.com\\/queue\\/job\\/328855088\",\"status\":\"waiting\"}"},{"id":"7ef9decb-fbbd-b8f4-cad9-fffdfa4745cd","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":"756","body":"{\"id\":\"328841962\",\"url\":\"https:\\/\\/syrup.keboola.com\\/queue\\/job\\/328841962\",\"status\":\"waiting\"}"},{"id":"e445da8a-f963-291d-3b82-008ab2575a32","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":"819","body":"{\"id\":\"328858482\",\"url\":\"https:\\/\\/syrup.keboola.com\\/queue\\/job\\/328858482\",\"status\":\"waiting\"}"}],"_postman_id":"4c9c7c9f-6cd6-58e7-27e3-aef62538e0ba"},{"name":"Run Tag","id":"e8adcb14-951c-6199-2484-367ad6620c08","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":"<p><a href=\"https://kebooladocker.docs.apiary.io/#reference/run/create-a-job-with-image/run-job\">Run a job with specific image tag</a>. Creates a job running a specified version of the component.</p>\n","urlObject":{"protocol":"https","path":["docker","{{componentId}}","run","{{tag}}"],"host":["syrup","keboola","com"],"query":[],"variable":[]}},"response":[],"_postman_id":"e8adcb14-951c-6199-2484-367ad6620c08"}]}