How to rescue jobs older than one month
Hello,I need to retrieve a job that occurred over a month ago. I can locate it, but I need to see the tasks and because it was a long time ago, it doesn't show me what happened in that job.Is this possible?
Forum Posts
Resolved! Error Handling Questions
What does the job status say "Successful" when there was an error thrown and captured by the "Monitor" actionI'm processing large recordsets and as I loop through them I feel it's not ideal for the end user to get an email for every error. Has anyon...
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.
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 ...
