Workato Pros Discussion Board

Resolved! Jobs Table - hyperlink column

Is it possible to use a Ruby formula to generate a column that is a clickable hyperlink? I can build a string and encode it just fine but it would be great if the value could be clicked.

Resolved! Dealing with null hash/nested objects eg Link['webView']['href']

I have a api call that returns similar to the following json structure: { "data": [ { "itemId": "001", "links": { "self": { "href": "http://website.com/api" }, ...

SAP Business one connector best practices

HiCan someone recommend what are the best practices of using SAP B1 connector? SAP B1 Rest (Odata) API has limitations on its authentication method: in the initial call a unique authentication "token" (cookie) is created with TTL of 30 minutes (per ...

unable to add a user to the Workspace role in Workato

While adding a user to the Workato Workspace Analyst role, the invitation is not being sent, and after some time, the invitation is no longer visible in Workato.Can anyone help me on this

How to use except formula in the nested object ?

I have an array which look like this below. I can manage to remove the 1st level of fields using except formula.users[0].except(:two_factor_auth_enabled,:signature).I am trying to remove the nested object field using the below formula.users[0].except...

414 error from calling a workato API

I created a workato API. I need to send quite a bit of data through the api (say up to 32K) but Im getting a 414 error. It isnt calling the underlying API so workato is rejecting the call outright. I can make the call with the same size data to other...

SQL Server Connection - Host name

Does anyone have experience 'generating' the URL host name for an on-prem SQL Server instance?I've downloaded/installed the service as well as the config/keys, but I don't understand how to get the Host name. In Workatos examples, it looks like they ...

Resolved! 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...

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 ...

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...

Systematic Community

Forum Posts

Resolved! Jobs Table - hyperlink column

Resolved! Dealing with null hash/nested objects eg Link['webView']['href']

SAP Business one connector best practices

unable to add a user to the Workspace role in Workato

How to use except formula in the nested object ?

414 error from calling a workato API

SQL Server Connection - Host name

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

Slack Workbot

Resolved! New column adding

Is there an easy way to continue the next item in ...

Workato Connector SDK - Refresh_On and Retry_On

Trigger Retries

Formatting Request Payload as an Array rather than...

Convert string to json and then iterate through th...

Escaped quotes turning into not-escaped quotes and...

Microsoft Dynamics missing a custom field as a dat...

"Help with Parsing JSON String into Python List – ...

Unable to get Twilio recording file via Workato HT...

Need to get additional trigger data returned from ...