iMIS Custom Table icon

iMIS Custom Table

Read and write records in any iMIS user-defined table via the GenEntity API

Actions3

Get

AI-generated

Summary

Fetch records from an iMIS user-defined table either by a composite key to get a single record or by applying query string filters to search multiple records.

Inputs

  • Table Name (required) — The name of the iMIS business object or user-defined table to query, e.g. Demographics, Relationship, UD_Communications.
  • Get By (required) — Selects the method to retrieve records: 'Composite Key' to fetch a single record by its composite key, or 'Query Filters' to search via query parameters.
  • Record Key (required) — (Required if Get By is 'Composite Key') The composite key identifying the single record, e.g. '12345' or '12345~1'.
  • Query Filters — (Required if Get By is 'Query Filters') One or multiple query string parameter name/value pairs to filter records during search.

Output shape

a list of JSON objects representing the fetched record(s) from the specified table, with properties flattened and annotated. If Get By is 'Composite Key', returns one record; if 'Query Filters', returns zero or more records matching the filters.

If no records match query filters, outputs a single JSON object with 'found': false and a message. If a single record is returned by filters, it is also marked with 'found': true. Each output item is paired with its input item.

Links

Discussion