Skip to main content
Your investigations are what a doctor orders or advises: laboratory tests, scans, panels and packages. Each row is one orderable item, identified by your own id. Use type=lab_investigation with the API, or pick Investigations in the console. An investigation is not the value that comes back. The values a lab reports, such as hemoglobin, are lab results. A named group of results that a doctor fills in, such as CBC, is a lab panel. Complete Blood Count can exist as an investigation (ordered) and as a panel (filled in). These are separate records with their own ids.
Mandatory columns: investigation_id and name. Every other column is optional; leave the cell empty if you don’t have the value.

Columns

Example file

lab-investigations.csv
Put quotes around any value that contains a comma, like "C-Reactive Protein (CRP), Serum (Qualitative)". Spreadsheet programs do this for you when they save as CSV.
The smallest valid file has just the two mandatory columns:
minimal.csv

Example JSON

The same records sent to Create or update records. In JSON, multi-value fields are lists.

Common mistakes

  • Putting result values here. Hemoglobin, with its unit, belongs in lab results. Add an investigation only for what is ordered.
  • Expecting a panel to be filled in from here. Setting type to panel is only a label. To give doctors a CBC to fill in, upload a lab panel.
  • A wrong ekaid. Eka stores the id you send without checking it. A wrong id can attach your investigation to the wrong Eka item, so check each mapping against Eka’s reference list.
  • Reusing an id for a different investigation. An existing investigation_id updates that record; it never creates a second one.