Compare one field
Rows count as duplicates when Column2 is equal; returns 2 rows.
Input
{
"data": [
{
"Column1": "Germany",
"Column2": "Apple",
"Column3": "Dragonfruit"
},
{
"Column1": "Germany",
"Column2": "apple",
"Column3": "Dragonfruit"
},
{
"Column1": "US",
"Column2": "Apple",
"Column3": "Dragonfruit"
}
],
"fields": [
"Column2"
],
"ignoreCase": false
}Output · HTTP 200
{
"result": [
{
"Column1": "Germany",
"Column2": "Apple",
"Column3": "Dragonfruit"
},
{
"Column1": "Germany",
"Column2": "apple",
"Column3": "Dragonfruit"
}
]
}Show curl command
curl -X POST 'https://api.1001fx.com/array/removeduplicates' \
-H 'X-API-KEY: YOURSECRETAPIKEY' \
-H 'Content-Type: application/json' \
-d '{"data":[{"Column1":"Germany","Column2":"Apple","Column3":"Dragonfruit"},{"Column1":"Germany","Column2":"apple","Column3":"Dragonfruit"},{"Column1":"US","Column2":"Apple","Column3":"Dragonfruit"}],"fields":["Column2"],"ignoreCase":false}'