Hello Workato Pros! We’re on a mission to make our community forum the best place for you to connect, share, and grow. Your experience matters and we want to hear from you! Take our quick Community Experience Survey below (embedded right in this post...
I'm trying to reference the ID property of a list item in a data pill expression. I could do a for each and loop through to get the relevant item, but I guess there must be a way to do this via the expression.This expression gives me an error when I...
First off, this is my first recipe and I'm teaching myself from the docs.workato.com plus looking at recipies created by people who preceeded me on this jobI have a recipie that is delivered a payload via JSON over a webhook trigger. It has a lot of...
Hi Experts,We’re planning to conduct performance testing on our Workato platform and wanted to check if there’s any in-house documentation or guidance available. Specifically, we’re looking for information related to performance metrics, CPU usage, r...
Hi,I am able to dynamically create JIRA issues using "Project issue type" as shown in the image below, but using that method, I cannot add data to custom fields. The "Sample project issue type" is supposed to allow me to retrieve custom fields, howev...
Hi,I need to create a nested json based on a SQL query.Sample dataset:Transportorder TO_param1 TO_param2 Ordernumber Order_param1 Order_param2 Orderitem Orderitem_param1OR-444450xyCO-12345xyCO-12345-1xOR-444450xyCO-12345xyCO-12345-2xOR-444450xyCO-123...
I'm querying a database from an API-Endpoint trigger and want to return the result as JSON.So far nothing out of the ordinary, and it works for other usecases.The data i do get back from the database though already contains a JSON string in one colum...
Hi,I used the "guided setup" but I cannot figure out how to add datapills to the "Request body parameters" it created. Below is how I configured using the Guided Setup:Setup OpenAI custom action from sample request Request type = JSON request body ...
Hi, In Wrike for Workato, Search projects action, how do you specify Metadata needed to limit the search? I am trying to limit the search by keyword in the Title. I get the following error if I specify 'Title' for Key and 'EOD' for value400 Bad Requ...
Hi there,I have a recipe that creates sales orders (header and lines) in Dynamics 365 F&O (ERP).I use a repeat for each action to create the sales order lines. The step input list is a list of the relevant line item data which includes a sequence num...
In Tibco Scribe we have a connector for Sage Intacct. To integrate invoices from CRM we use SOTransaction and SOTransactionItems objects. In the Workato-Sage Intacct connector, what are the corresponding APIs for SoTransaction and SoTransactionItem i...
