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:
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:
I hope this helps. You can read more about it using the link belows:
Flow services - webMethods.io Integration
2 Likes
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.
1 Like
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.