[ { "op": "core/column-split", "description": "Split column Especie by separator", "engineConfig": { "facets": [], "mode": "row-based" }, "columnName": "Especie", "guessCellType": true, "removeOriginalColumn": false, "mode": "separator", "separator": " ", "regex": false, "maxColumns": 0 }, { "op": "core/column-addition-by-fetching-urls", "description": "Create column json data at index 3 by fetching URLs based on column Especie 2 using expression grel:\"http://api.gbif.org/v1/species/search?q=\"+cells[\"Especie 1\"].value+\" \"+value+\"&rank=SPECIES\"", "engineConfig": { "facets": [], "mode": "row-based" }, "newColumnName": "json data", "columnInsertIndex": 3, "baseColumnName": "Especie 2", "urlExpression": "grel:\"http://api.gbif.org/v1/species/search?q=\"+cells[\"Especie 1\"].value+\" \"+value+\"&rank=SPECIES\"", "onError": "set-to-blank", "delay": 200 }, { "op": "core/column-addition", "description": "Create column key at index 4 based on column json data using expression grel:with(value.parseJson().results[0], item, item.key)", "engineConfig": { "facets": [], "mode": "row-based" }, "newColumnName": "key", "columnInsertIndex": 4, "baseColumnName": "json data", "expression": "grel:with(value.parseJson().results[0], item, item.key)", "onError": "set-to-blank" }, { "op": "core/column-addition-by-fetching-urls", "description": "Create column count_PT at index 5 by fetching URLs based on column key using expression grel:\"http://api.gbif.org/v1/occurrence/count?country=PT&taxonKey=\"+value", "engineConfig": { "facets": [], "mode": "row-based" }, "newColumnName": "count_PT", "columnInsertIndex": 5, "baseColumnName": "key", "urlExpression": "grel:\"http://api.gbif.org/v1/occurrence/count?country=PT&taxonKey=\"+value", "onError": "set-to-blank", "delay": 200 }, { "op": "core/column-addition-by-fetching-urls", "description": "Create column count_ES at index 5 by fetching URLs based on column key using expression grel:\"http://api.gbif.org/v1/occurrence/count?country=ES&taxonKey=\"+value", "engineConfig": { "facets": [], "mode": "row-based" }, "newColumnName": "count_ES", "columnInsertIndex": 5, "baseColumnName": "key", "urlExpression": "grel:\"http://api.gbif.org/v1/occurrence/count?country=ES&taxonKey=\"+value", "onError": "set-to-blank", "delay": 200 }, { "op": "core/column-removal", "description": "Remove column json data", "columnName": "json data" } ]