Google Refine script Github 4people

refine_github_geeks.json

// More than https://github.com/about
// Uses https://api.github.com/orgs/github/members as data source and fetches user data from the url field
[
  {
    "op": "core/column-addition-by-fetching-urls",
    "description": "Create column userData at index 1 by fetching URLs based on column url using expression grel:value",
    "engineConfig": {
      "facets": [],
      "mode": "row-based"
    },
    "newColumnName": "userData",
    "columnInsertIndex": 1,
    "baseColumnName": "url",
    "urlExpression": "grel:value",
    "onError": "store-error",
    "delay": 50
  },
  {
    "op": "core/column-addition",
    "description": "Create column login at index 2 based on column userData using expression grel:parseJson(value).login",
    "engineConfig": {
      "facets": [],
      "mode": "row-based"
    },
    "newColumnName": "login",
    "columnInsertIndex": 2,
    "baseColumnName": "userData",
    "expression": "grel:parseJson(value).login",
    "onError": "set-to-blank"
  },
  {
    "op": "core/column-addition",
    "description": "Create column name at index 2 based on column userData using expression grel:parseJson(value).name",
    "engineConfig": {
      "facets": [],
      "mode": "row-based"
    },
    "newColumnName": "name",
    "columnInsertIndex": 2,
    "baseColumnName": "userData",
    "expression": "grel:parseJson(value).name",
    "onError": "set-to-blank"
  },
  {
    "op": "core/column-addition",
    "description": "Create column public_repos at index 2 based on column userData using expression grel:parseJson(value).public_repos",
    "engineConfig": {
      "facets": [],
      "mode": "row-based"
    },
    "newColumnName": "public_repos",
    "columnInsertIndex": 2,
    "baseColumnName": "userData",
    "expression": "grel:parseJson(value).public_repos",
    "onError": "set-to-blank"
  },
  {
    "op": "core/column-addition",
    "description": "Create column followers at index 2 based on column userData using expression grel:parseJson(value).followers",
    "engineConfig": {
      "facets": [],
      "mode": "row-based"
    },
    "newColumnName": "followers",
    "columnInsertIndex": 2,
    "baseColumnName": "userData",
    "expression": "grel:parseJson(value).followers",
    "onError": "set-to-blank"
  },
  {
    "op": "core/column-addition",
    "description": "Create column public_gists at index 2 based on column userData using expression grel:parseJson(value).public_gists",
    "engineConfig": {
      "facets": [],
      "mode": "row-based"
    },
    "newColumnName": "public_gists",
    "columnInsertIndex": 2,
    "baseColumnName": "userData",
    "expression": "grel:parseJson(value).public_gists",
    "onError": "set-to-blank"
  },
  {
    "op": "core/column-addition",
    "description": "Create column github_profile at index 2 based on column userData using expression grel:parseJson(value).html_url",
    "engineConfig": {
      "facets": [],
      "mode": "row-based"
    },
    "newColumnName": "github_profile",
    "columnInsertIndex": 2,
    "baseColumnName": "userData",
    "expression": "grel:parseJson(value).html_url",
    "onError": "set-to-blank"
  },
  {
    "op": "core/column-addition",
    "description": "Create column blog at index 2 based on column userData using expression grel:parseJson(value).blog",
    "engineConfig": {
      "facets": [],
      "mode": "row-based"
    },
    "newColumnName": "blog",
    "columnInsertIndex": 2,
    "baseColumnName": "userData",
    "expression": "grel:parseJson(value).blog",
    "onError": "set-to-blank"
  },
  {
    "op": "core/column-addition",
    "description": "Create column location at index 2 based on column userData using expression grel:parseJson(value).location",
    "engineConfig": {
      "facets": [],
      "mode": "row-based"
    },
    "newColumnName": "location",
    "columnInsertIndex": 2,
    "baseColumnName": "userData",
    "expression": "grel:parseJson(value).location",
    "onError": "set-to-blank"
  }
]