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
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
typetopanelis 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_idupdates that record; it never creates a second one.

