• Documentation
  • Workato Blog
  • Product Blog
  • Return to Workato
  • Login
  • Automation Institute
  • Documentation
  • Community Forums
New Topic
Discussions Recipe Building Recipe Building Questions
M

Matt McKenna

started a topic over 4 years ago
Answered

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! 


Best Answer
G
Gabriel Sim said over 4 years ago

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.

Answer
G

Gabriel Sim

said over 4 years ago

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.

M

Matt McKenna

said over 4 years ago

Thank you! This was helpful.

Login to post a comment

Still can't find your solution?

Send us a ticket, we will try our best to assist you with your problem

Documentation
Developer's Library
Tutorials
eBooks
Product Hour
Product Blog
Workato Blog
Product updates
Customer Stories
© Workato 2022   Privacy   Terms   +1 (844) 469-6752
  • Documentation
  • Workato Blog
  • Product Blog
  • Solutions
  • Forums
  • Tickets
  • Log in
  • Return to Workato
Topic views count