Workato | Systematic Community

How to fetch all matching records using data_table_lookup?

Hello Team,Has anyone worked with the data_table_lookup formula in Workato?I'm trying to fetch multiple records from a data table based on a condition, but it seems to only return the first matching record, not all.Here’s an example of my data table...

Resolved! Filtering a list before iterating over it

Hey all,I have used the Python action to output a list, I've provided the schema and I can iterate over it without issue. However, what I would like to do is filter the list before iterating over it. So for example, the list contains an ID field, I c...

Connect Azure Service bus using service principals

Hi all,Is there a way to connect to Azure Service Bus using service principals instead of SAS keys?I tried doing this through the config.yaml file, but it didn't work. I even attempted to build my own JAR file and replace the original ones, but no lu...

WORKATO on OKTA-SSO using SAML

Hi, Hi all,I'm looking to set up Workato as an application tile in Okta using SAML SSO. I've reviewed some basics but would appreciate precise documentation or a step-by-step guide — ideally including:How to configure SAML settings on both Okta and W...

accessing json contents without a schema

Hi, I'm retreiving sign in logs from MS graph via HTTP. The schema is complex and seems to change a lot so I've had issues trying to define a proper schema for data pills. I would really just like to access one of the high level json objects and be a...

Workato If formula

Hi everyone. I had a query with regards to a formula. I have a scenario where on a Wrike form, I have 4 fields that I get as a user input. Below are the fields:1. Goal2. Campaign Purpose3. Target Audience 4. Value Proposition I would like to concaten...

Payload Not Received in JSON Format in Workato Flow App

Hello,I’m currently working with the Workato Flow App, and I’ve noticed that the incoming payload is not received in proper JSON format as expected.Interestingly, when I use Python code within a regular recipe, the output is displayed correctly as a ...

Azure connectors for Workato (like Excel) are shown as "univerified" in Azure and triggers security

Hi, when connecting with OAuth2.0 to Apps like Excel connector the app is shown as univerified in Azure, which is problematic as is always triggers security review (even if it was approved before multiple times). This make them much harder than neces...

Resolved! Need Trial account for Workato

I am writing to request access to a trial account for Workato. I am eager to explore the platform's features and evaluate its suitability for our needs. Kindly let me know if there are any specific steps or information required from my end to expedit...

Dynamic Hash Key

Has anyone had success using a dynamic hash key? Use case is I have a lookup table that has 2 columns that are just Keys and I have 2 objects (one from JIRA one from Salesforce) and I want to loop through each lookup table and do a comparison to dete...