Starting from the 2019 version of FDM it is possible to work directly with header records. This allows you to create lookup queries from objects within scripts, as well as storing information about devices directly in the header record rather than in object attributes.

This is useful for easily keeping values updated during your data import process (no API required to update device properties) and also to create a lookup from one table to another. As an example, if you store a code (e.g. GBP) in your header record you could look up the description of the acronym from another table to show it in a widget or report.

Copy to Clipboard