1. Babelway
  2. Babelway User Guide
  3. Chapter 4. Manage & Build

4.2.4.10. Lookup table Gateway In

 

This gateway allows you to create a message from the content of a lookup table. The message created is a XML document. It uses the same format as the XML CSV representation used internally by Babelway.

 Lookup Table Id 

 The technical id of the lookup table. 

 Include headers 

 Check this to add the column names as headers of the messages created. 

 Filter 1 column 

 Column used to filter the extract of the lookup tables entries. 

 Filter 1 value 

 Value used to filter the extract of the lookup tables entries. 

 Filter 2 column 

 Column used to filter the extract of the lookup tables entries. 

 Filter 2 value 

 Value used to filter the extract of the lookup tables entries. 

 Filter 3 column 

 Column used to filter the extract of the lookup tables entries. 

 Filter 3 value 

 Value used to filter the extract of the lookup tables entries. 

 Post extract operation 

 Optional operation to perform on selected entries (NONE, DELETE and UPDATE) after extraction. Default is DELETE 

 Column to update 

 Column to update after the extract of the lookup tables entries, Only used with 'Update' in 'Post extract operation'. 

 Column to update 

 Column to update after the extract of the lookup tables entries, Only used with 'Update' in 'Post extract operation'. 

 Update value 

 Value to use when updating the column to update. 

 Limit 

 Maximum number of entries to extract in 1 execution of this gateway. 

 Entries per message 

 Maximum number of entries per message. If the overall limit is bigger, several messages will be created for each execution of this gateway. 

 Cron expression 

 Cron expression. Allows you to define complex time expressions like every weekday night at 23:00 (0 0 23 ? * MON-FRI *) and the time zone for the polling. If left empty, the system will check at least once every 15 minutes. For easy creation of your cron expression, you can use the online cron maker tool available at: http://www.cronmaker.com/. 

Note: 

  • In the "General" page for this Gateway In you can see the "Poll now" button. When clicking on this button this will poll all of the messages immediately (and will not wait for the next defined moment).
  • If there is a file name provided in the "Message In" or "Message Out" which contain ~ tilde character, All browser based on Chromium will replace the ~ tilde character by the _ underscore character when you try to download the file from the Babelway interface, For more details you can check this link https://bugs.chromium.org/p/chromium/issues/detail?id=479419
  • The maximum file size accepted by this gateway is 100 MB.