Does anyone have some information on how to use the Reference Data in integration.io ?
I can see there are join conditions but i can’t see how they work.

Hi Jon,

Reference data in webMethods.io Integration allows you to store static data centrally, enabling reuse across multiple flow services without hardcoding. This approach ensures consistency, reduces redundancy, and simplifies updates by referencing centrally stored data like configuration details or lookup tables.

To use reference data, it must first be loaded into the pipeline. If you want to load all data, call the service without specific criteria. However, if you need data based on certain conditions, you can apply match criteria with joins.

Let’s illustrate this with a sample dataset:

https://higherlogicdownload.s3.amazonaws.com/IMWUC/webMethods/Files3/64191493036a1203c995d3fd8b1bd5c21d4900e8_2_775x297.png 1.5x, https://higherlogicdownload.s3.amazonaws.com/IMWUC/webMethods/Files3/64191493036a1203c995d3fd8b1bd5c21d4900e8_2_1034x396.png 2x" data-dominant-color="FCFCFC">

image1191×457 10.1 KB

Suppose the reference has two columns, and we only want to load data with “Code” ranging between 2 and 5 then set values for path and joins as below:

https://higherlogicdownload.s3.amazonaws.com/IMWUC/webMethods/Files3/bb1f08139a9a407d3d07c25ebcc67619d6716dcd_2_775x274.png 1.5x, https://higherlogicdownload.s3.amazonaws.com/IMWUC/webMethods/Files/bb1f08139a9a407d3d07c25ebcc67619d6716dcd.png 2x" data-dominant-color="FBFBFC">

image1022×362 12.7 KB

https://higherlogicdownload.s3.amazonaws.com/IMWUC/webMethods/Files3/65fd118d4295b4dd1afcdcb874956537f05c19a5_2_757x750.png 1.5x, https://higherlogicdownload.s3.amazonaws.com/IMWUC/webMethods/Files/65fd118d4295b4dd1afcdcb874956537f05c19a5.png 2x" data-dominant-color="FBFBFB">

image805×797 26.6 KB

https://higherlogicdownload.s3.amazonaws.com/IMWUC/webMethods/Files/9b4076437aee1c53dad5e4872c42feb4a607a0d6.png 1.5x, https://higherlogicdownload.s3.amazonaws.com/IMWUC/webMethods/Files/9b4076437aee1c53dad5e4872c42feb4a607a0d6.png 2x" data-dominant-color="FBFCFB">

image607×622 24.4 KB

I hope this helps. You can read more about it using the link belows:
Flow services - webMethods.io Integration

Thanks for the reply - now I understand that join.
is there a way to use multiple columns for the key to make the query more flexible and complex ?

Yes, it can be achieved.
matchCriteria is an array and can be used for more complex queries.

Thanks Sourabh,

If you are able, then a screenshot of the inputs would really help in explaining what to do - this is missing from the current documentation.