Workato | Systematic Community

How to omit empty key-value pairs from Payload

Hi all, My process is that I have a list of data, I extract the relevant data from the list, add the data to the payload, and then POST that data to a particular endpoint. The key consideration is that when a key-value pair has a null value, that key...

How to avoid sending fields to API or other plarform endpoints

I have noticed weird behavior recently. I was building a recipe and when I add "blank" word under the formula fields, that field will not sending to the endpoints.But with the latest updates, when I send the same content to different endpoints, it i...

What’s trending at Workato?

What's new?Workflow Apps - Public Form Submission with secure file uploadsPublic form submission for Workflow apps is now live and available to all customers. This is a critical feature to expand use cases beyond just internal ones and allow initiati...

XSLT does not honor the output element

Hi,I am using XML tools by workato and the Transform using XSLT action.I am converting an XML input to a text output. I do this using the following XSLT element:<xsl:output method="text" encoding="UTF-8"/>But workato always seems to add the XML prolo...

Reporting Saved searches from Netsuite to PowerBi (Large Data sets & Multiple Saved Searches)

Hello,I'm trying to Automate reporting with Netsuite Data to PowerBi.Not sure what the best way is to do this and maybe somebody could point me in the correct direction.We have Multiple Saved Searches from Netsuite that we save as CSV and what to aut...

Tips and Tricks to Handle Large Datasets and Files

Workato's robust architecture is designed to effortlessly handle the complex needs of enterprises, making it ideal for processing and managing large datasets and files. Whether you're managing customer data, updating inventory, or preparing financia...

Is it possible to bulk upload records to Creatio using a custom action? If so what's the JSON Layout

So I am experimenting with bulk uploading to Creatio using a HTTP POST under Custom Action. I take a bunch of records and split them into batches and can succesfully loop through them. Through some editing I am able to get a variable resembling the b...

How to Convert Stream Data Back to Raw (text) Data for Processing?

I'm using Workflow Apps to store a PDF or DOC file in a Data Table. When I retrieve the file, its contents appear in a stream format. I need to convert this stream back into raw data (text) so I can process it further. Is there any approach to achiev...

Updated Course Materials

Hi there, I'm doing the training lesson On-Prem Agent Installation > Extensions, but I'm not able to have the custom connector to reach out to the on-prem agent.I'm getting the error "Connection failed: 301 Moved Permanently" (see image): The source ...

Unable to Install workato-connector-sdk Gem

Hi everyone,I am trying to install the workato-connector-sdk gem by following the official Workato documentation (Connector SDK > CLI > Getting Started with the SDK Gem). However, I am encountering an error when running the following command:cmd -> ...