Difference between API and Webhook.trigger
Hello Experts,Can you help me to understand the difference between APIs and webhook triggers.What kind of security cab be added if we use API and webhook as trigger.
Forum Posts
Resolved! How to reference a list item in a data pill expression
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...
Resolved! Best Practice for Large Recordsets
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...
How to do performance testing in Workato?
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...
dynamic creation of JIRA issues - limitation with custom fields
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...
Resolved! Transform query result to nested list / nested json with multiple levels
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...
Resolved! Pass through JSON "string" from Database query
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...
Resolved! How do I enter values into Workato's OpenAI Custom Action?
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 ...
Search projects action in Workato for Wrike
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...
Resolved! Sorting / ordering a list input to a repeat for each action
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...
