Workato | Systematic Community

Slack Workbot

Hi,We're creating automations with Workato for Slack. We're wondering, is it possible to open the Home tab of a Slack app via a direct message sent to an employee with Workato? Basically, we'd send a direct message to the employee and in the message ...

Not able to run the snowflake custom queries with flatten json columns

Hi In our project, we are loading data from snowflake tables into Reltio. We are receiving complex json data in some of the columns.We have flatten the json column and able to get the proper result in snowflake but when we use the same query in RIH(R...

Downloading a PDF from a URL

Hi, I'm facing an issue with downloading a PDF from a URL. I've created an action that currently returns a download link, allowing me to download a ZIP file. However, I have a new requirement: I want the process to directly unzip the file and create ...

Any ways to exempt multifactor authentication for Outlook?

Is it possible for Workato to exempt multifactor authentication when connecting Outlook to Workato? Our internal security procedures changed recently, and moving forward, all Outlook accounts require DUO authentication. We would like to avoid using D...

PowerBI Connector Unauthorized

I'm attempting to connect to a trial PowerBI account. There is a Community connector but I'm not seeing much documentation for it. I believe I have set things up properly but I can't get the connector to connect. I am attempting to use OAuth2 Clie...

Resolved! New column adding

I have a case where we should import data from Intacct to Anaplan via Workato. However to do so, firstly we need to create an Unique UID in exporting data of Intacct through Workato. I know that workato has two formulas to generate such UID (UUID and...

What’s trending at Workato?

What's New?Automation Quality & Security AcceleratorWorkato’s Automation Quality and Security (AQS) accelerator provides a framework to standardise recipe development best practices and report on the non-adherence of recipes/deployment packages conce...

Resolved! Chunk large amounts of data (including files)

(Chunk large amounts of data (including files) to make it easier to perform downstream operations. For example: breaking a batch of 5000 records into chunks of 500 to prevent an API timeout.)I tried above example by taking 5000 records and with 5 col...

Resolved! Custom connector - HMAC authentication

Hi everyone,I'm working on trying to integrate the Lexsynergy API with Workato, but I've hit a roadblock. It seems I can't use the standard HTTP connector due to their specific HMAC authentication requirements. I tried building a custom connector, bu...