The Lookup From Table Component can be used to convert from different tables that parsed as a CSV.
CSV Table
: The CSV is entered on the Credentials page as a list of separated
items. Any delimiter is supported. The CSV will be parsed using the first row as
a header for each column below it. The CSV must be able to be interpreted as a
rectangle, i.e. it cannot be missing values.
For example,
English,Abbreviated,German
male,M,männlich
female,F,weiblich
other,O,divers
unknown,U,unbekannt
Will parse as
English | Abbreviated | German |
---|---|---|
male | M | männlich |
female | F | weiblich |
other | O | divers |
unknown | U | unbekannt |
and
English,Abbreviated,German
male,M,männlich
,F,weiblich
other,,
unknown,U,unbekannt
Will parse correctly as
English | Abbreviated | German |
---|---|---|
male | M | männlich |
F | weiblich | |
other | ||
unknown | U | unbekannt |
(though this may not be useful), but
English,Abbreviated,German
male,M,männlich
F,weiblich
other
unknown,U,unbekannt
will provide a failed result.
The CSV can only be a maximum of 5kB, and if it contains any duplicate values in a given column, it will fail validation.
To utilize the Lookup Table component, you need to provide a valid CSV table in the component’s credentials. It’s important to note that the CSV file should not exceed 5kB in size, and if it contains any duplicate values within a specific column, it will fail the validation process.
The Lookup Table component supports the Lookup From Table action exclusively. It enables you to establish relationships between your configured values based on the columns present in the CSV table. To ensure proper configuration, each column in the CSV table should have a corresponding header name, which you can pass into the Lookup Table component’s Configuration.
The technical notes page gives some technical details about Lookup Table component like changelog.
This component has no trigger functions. This means it will not be accessible to select as a first component during the integration flow design.
The Lookup From Table action allows you to establish relationships between the values in different columns of your CSV table. To configure this action, you need to select two columns from your CSV table: column X and column Y.
Once the columns are chosen, you can specify the input value from column X. The Lookup Table component will then search for a corresponding match in column X and return the value from column Y that is present in the same row.
In summary, the result of the Lookup From Table action will be the value from column Y, which corresponds to the selected input value from column X in the Mapping process. This enables you to retrieve and utilize specific values from the CSV table based on your configured mappings.
To gain a better understanding of how the Lookup Table component functions, we highly recommend reviewing a brief example. This example will provide you with practical insights into the component’s operation and usage.
Emit empty object on unsuccessful lookup
- is a checkbox. If selected, an empty object {} will be emitted given an unsuccessful lookup where nothing is found. If not selected, an error will be thrown on an unsuccessful lookup.From this column
: the column to translate fromTo this column
: the column to translate toDuplicates behavior
: How to handle cases when found several records in selected From this column
in provided table, options:
Emit all mach individually
- Will emit each record as separate messageEmit all mach as Array
- Will emit all founded records as array of stringsEmit first found
- Will emit first founded recordThrow an error (Default)
- By default error will be thrownAs input in Mapping, you must choose any value from column X that you put in From this table field.
{"result": "value"}
will be emitted{}
will be emitted"double quotes"
. Any elements of the CSV that contain the delimiter and also quotations should have the quotes backspaced.
e.g.Full Name,First,Last
"Bond,James",James,Bond
"Johnson, Dwayne \"The Rock\"",Dwayne,Johnson
"
, not '
, because '
is considered as an additional character. So in this case:
2 is the same as “2”, but ‘2’ would be equal to “‘2’”.Example: