If I have two different applications that I want to pull data from and combine the datasets via a foreign key, is there a way to do that in Workato?
For example, if I have rows in a Postgres/Redshift DB with a column called "MyExternalId" and objects in SalesForce with a field called "MyExternalId__c" that contain the same number, can I do independent SELECTs from Postgres/Redshift and Salesforce, do a join between the two datasets in Workato, and then run an action with the combined data?
Yes, that's possible with Collections.
In fact, there's a similar recipe here https://www.workato.com/recipes/683100-merge-lists-using-collections
You'll need to tweak the final Query action to join based on the columns you need. It uses standard SQL syntax.
Thank you! This was helpful.
Send us a ticket, we will try our best to assist you with your problem