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?
Matt McKenna
Joins Between Apps?
Hello,
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?
Thank you!
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.
Gabriel Sim
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.
Matt McKenna
Thank you! This was helpful.