Look up, ignoring case
Finds "Alice" in the header row and returns row 2 of that column.
Input
{
"data": [
{
"Alice": 1,
"Bob": 2,
"Charly": 3,
"Dave": 4
},
{
"Alice": "Germany",
"Bob": "USA",
"Charly": "Austria",
"Dave": "Switzerland"
},
{
"Alice": 11,
"Bob": 12,
"Charly": 13,
"Dave": 14
},
{
"Alice": "Apple",
"Bob": "Banana",
"Charly": "Cherry",
"Dave": "Dragonfruit"
}
],
"lookUpValue": "Alice",
"row": 2,
"ignoreCase": true
}Output · HTTP 200
{
"result": "Germany"
}Show curl command
curl -X POST 'https://api.1001fx.com/spreadsheet/hlookup' \
-H 'X-API-KEY: YOURSECRETAPIKEY' \
-H 'Content-Type: application/json' \
-d '{"data":[{"Alice":1,"Bob":2,"Charly":3,"Dave":4},{"Alice":"Germany","Bob":"USA","Charly":"Austria","Dave":"Switzerland"},{"Alice":11,"Bob":12,"Charly":13,"Dave":14},{"Alice":"Apple","Bob":"Banana","Charly":"Cherry","Dave":"Dragonfruit"}],"lookUpValue":"Alice","row":2,"ignoreCase":true}'