Skip to content

Instantly share code, notes, and snippets.

@atomotic
Created October 15, 2013 12:26
Show Gist options
  • Save atomotic/6990809 to your computer and use it in GitHub Desktop.
Save atomotic/6990809 to your computer and use it in GitHub Desktop.
openrefine json history: get the DOI resolution url. doi value is in the column 2 of the table
[
{
"op": "core/column-addition",
"description": "Create column url at index 2 based on column Column 2 using expression jython:import httplib\nconn = httplib.HTTPConnection(\"dx.doi.org\")\ndoi = \"/\"+value\nconn.request(\"HEAD\", doi)\nres = conn.getresponse()\nreturn res.getheader('location')",
"engineConfig": {
"facets": [],
"mode": "row-based"
},
"newColumnName": "url",
"columnInsertIndex": 2,
"baseColumnName": "Column 2",
"expression": "jython:import httplib\nconn = httplib.HTTPConnection(\"dx.doi.org\")\ndoi = \"/\"+value\nconn.request(\"HEAD\", doi)\nres = conn.getresponse()\nreturn res.getheader('location')",
"onError": "set-to-blank"
}
]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment