[
  {
    "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"
  }
]