3 weeks ago
Our goal is to establish Integration A, which serves as a data repository. The data stored in Integration A is then utilized in another recipe, Integration B, to ascertain the appropriate endpoint for data transmission. What is the most effective method to accomplish this within Workato? The current proposal involves storing data in a lookup table. Are there any superior alternatives or recommendations
3 weeks ago
Just be aware of the limitations of lookup tables:
3 weeks ago
@bkramer makes a good point about Lookup tables. If you need more scalability, some other options could be publishing the data as Topics to a Pub/Sub integration pattern (which Workato has natively). You could also create a CSV to store in Workato FileStorage that Integration B reads (perhaps the file path is stored in your lookup table). There's also Workato Table Storage though I haven't looked at that yet, and I want to say it might be connected to Workflow Apps.