Import from REST API (2024)

{ "application_type": "rest_api", "application_params": { "source_params": { "url": "https://api.github.com/repos/rails/rails/issues?per_page=100&state=closed", "pagination": "page", "page_parameter": "page", "authentication_type": "oauth2", "oauth2_authorize_url": "https://github.com/login/oauth/authorize", "oauth2_token_url": "https://github.com/login/oauth/access_token", "oauth2_client_id": "<placeholder>", "content_type": "json", "incremental": true, "incremental_additional_url_parameters": "since={{ 3 days ago | %Y-%m-%d }}" }, "columns_options": { "hide_unmapped": true } }, "source_cube_name": "GitHub issues", "columns": [ { "name": "url", "data_type": "string" }, { "name": "labels_url", "data_type": "string" }, { "name": "comments_url", "data_type": "string" }, { "name": "events_url", "data_type": "string" }, { "name": "html_url", "data_type": "string" }, { "name": "id", "data_type": "integer", "dimension": "Issue", "id_column": true, "source_id_column": true }, { "name": "number", "data_type": "integer", "dimension": "Issue", "key_column": true }, { "name": "title", "data_type": "string", "dimension": "Issue", "property": "Title" }, { "name": "user\nlogin", "data_type": "string", "dimension": "Reporter", "key_column": true }, { "name": "user\nid", "data_type": "integer", "dimension": "Reporter", "id_column": true }, { "name": "user\navatar_url", "data_type": "string" }, { "name": "user\ngravatar_id", "data_type": "string" }, { "name": "user\nurl", "data_type": "string" }, { "name": "user\nhtml_url", "data_type": "string" }, { "name": "user\nfollowers_url", "data_type": "string" }, { "name": "user\nfollowing_url", "data_type": "string" }, { "name": "user\ngists_url", "data_type": "string" }, { "name": "user\nstarred_url", "data_type": "string" }, { "name": "user\nsubscriptions_url", "data_type": "string" }, { "name": "user\norganizations_url", "data_type": "string" }, { "name": "user\nrepos_url", "data_type": "string" }, { "name": "user\nevents_url", "data_type": "string" }, { "name": "user\nreceived_events_url", "data_type": "string" }, { "name": "user\ntype", "data_type": "string" }, { "name": "user\nsite_admin", "data_type": "string" }, { "name": "labels", "data_type": "string" }, { "name": "state", "data_type": "string", "dimension": "Status" }, { "name": "comments", "data_type": "integer" }, { "name": "created_at", "data_type": "datetime", "dimension": "Issue", "property": "Created at", "date_count_measure": "Issues created", "date_count_dimension": "Time" }, { "name": "updated_at", "data_type": "datetime", "dimension": "Issue", "property": "Updated at" }, { "name": "closed_at", "data_type": "datetime", "dimension": "Issue", "property": "Closed at", "date_count_measure": "Issues closed", "date_count_dimension": "Time" }, { "name": "pull_request\nhtml_url", "data_type": "string" }, { "name": "pull_request\ndiff_url", "data_type": "string" }, { "name": "pull_request\npatch_url", "data_type": "string" }, { "name": "body", "data_type": "string" }, { "name": "milestone\nurl", "data_type": "string" }, { "name": "milestone\nlabels_url", "data_type": "string" }, { "name": "milestone\nid", "data_type": "integer", "dimension": "Milestone", "id_column": true }, { "name": "milestone\nnumber", "data_type": "integer", "dimension": "Milestone", "key_column": true }, { "name": "milestone\ntitle", "data_type": "string", "scale": 1, "dimension": "Milestone", "name_column": true }, { "name": "milestone\ndescription", "data_type": "string" }, { "name": "milestone\ncreator\nlogin", "data_type": "string" }, { "name": "milestone\ncreator\nid", "data_type": "integer" }, { "name": "milestone\ncreator\navatar_url", "data_type": "string" }, { "name": "milestone\ncreator\ngravatar_id", "data_type": "string" }, { "name": "milestone\ncreator\nurl", "data_type": "string" }, { "name": "milestone\ncreator\nhtml_url", "data_type": "string" }, { "name": "milestone\ncreator\nfollowers_url", "data_type": "string" }, { "name": "milestone\ncreator\nfollowing_url", "data_type": "string" }, { "name": "milestone\ncreator\ngists_url", "data_type": "string" }, { "name": "milestone\ncreator\nstarred_url", "data_type": "string" }, { "name": "milestone\ncreator\nsubscriptions_url", "data_type": "string" }, { "name": "milestone\ncreator\norganizations_url", "data_type": "string" }, { "name": "milestone\ncreator\nrepos_url", "data_type": "string" }, { "name": "milestone\ncreator\nevents_url", "data_type": "string" }, { "name": "milestone\ncreator\nreceived_events_url", "data_type": "string" }, { "name": "milestone\ncreator\ntype", "data_type": "string" }, { "name": "milestone\ncreator\nsite_admin", "data_type": "string" }, { "name": "milestone\nopen_issues", "data_type": "integer" }, { "name": "milestone\nclosed_issues", "data_type": "integer" }, { "name": "milestone\nstate", "data_type": "string" }, { "name": "milestone\ncreated_at", "data_type": "datetime" }, { "name": "milestone\nupdated_at", "data_type": "datetime" }, { "name": "milestone\ndue_on", "data_type": "string" }, { "name": "assignee\nlogin", "data_type": "string", "dimension": "Assignee", "key_column": true }, { "name": "assignee\nid", "data_type": "integer", "dimension": "Assignee", "id_column": true }, { "name": "assignee\navatar_url", "data_type": "string" }, { "name": "assignee\ngravatar_id", "data_type": "string" }, { "name": "assignee\nurl", "data_type": "string" }, { "name": "assignee\nhtml_url", "data_type": "string" }, { "name": "assignee\nfollowers_url", "data_type": "string" }, { "name": "assignee\nfollowing_url", "data_type": "string" }, { "name": "assignee\ngists_url", "data_type": "string" }, { "name": "assignee\nstarred_url", "data_type": "string" }, { "name": "assignee\nsubscriptions_url", "data_type": "string" }, { "name": "assignee\norganizations_url", "data_type": "string" }, { "name": "assignee\nrepos_url", "data_type": "string" }, { "name": "assignee\nevents_url", "data_type": "string" }, { "name": "assignee\nreceived_events_url", "data_type": "string" }, { "name": "assignee\ntype", "data_type": "string" }, { "name": "assignee\nsite_admin", "data_type": "string" } ]}