curl --request POST \
  --url https://cloudlab.scispot.io/labsheets/fetch-list-rows \
  --header 'Authorization: Bearer <token>' \
  --header 'Content-Type: application/json' \
  --data '
{
  "query": {
    "mandatoryFilters": [
      {
        "column": "Sample Type",
        "value": "DNA",
        "operator": "equals"
      }
    ],
    "optionalFilters": [
      {
        "column": "Sample Status",
        "value": "Pending",
        "operator": "equals"
      }
    ]
  }
}
'

const options = {
  method: 'POST',
  headers: {Authorization: 'Bearer <token>', 'Content-Type': 'application/json'},
  body: JSON.stringify({
    query: {
      mandatoryFilters: [{column: 'Sample Type', value: 'DNA', operator: 'equals'}],
      optionalFilters: [{column: 'Sample Status', value: 'Pending', operator: 'equals'}]
    }
  })
};

fetch('https://cloudlab.scispot.io/labsheets/fetch-list-rows', options)
  .then(res => res.json())
  .then(res => console.log(res))
  .catch(err => console.error(err));

import requests

url = "https://cloudlab.scispot.io/labsheets/fetch-list-rows"

payload = { "query": {
        "mandatoryFilters": [
            {
                "column": "Sample Type",
                "value": "DNA",
                "operator": "equals"
            }
        ],
        "optionalFilters": [
            {
                "column": "Sample Status",
                "value": "Pending",
                "operator": "equals"
            }
        ]
    } }
headers = {
    "Authorization": "Bearer <token>",
    "Content-Type": "application/json"
}

response = requests.post(url, json=payload, headers=headers)

print(response.text)

{
  "headers": [
    "uuid",
    "ID"
  ],
  "rows": [
    [
      "<uuid>",
      "SAMPLE-1"
    ]
  ],
  "total": 1,
  "success": "true"
}

{
  "success": false,
  "message": "Bad request"
}

{
  "success": false,
  "message": "Invalid Authentication Token"
}

{
  "success": false,
  "message": "Missing Authentication Token"
}

{
  "success": false,
  "message": "Not found"
}

{
  "success": false,
  "message": "Validation error"
}

{
  "success": false,
  "message": "Operation failed"
}