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...
To make things even better, we're offering an additional 40% off when you use the link below. Secure your spot at this rate by Friday: https://www.workato.com/events/automate?utm_source=Workato+Pros&utm_medium=Community&utm_campaign=Automate2024&p...
Hi,I am unsure if this is the correct place for this but for lack of alternatives I'll try my luck.Currently the limit for data tables is 50 columns. This limit is reached quite easily as the current Workflow Apps architecture requires flat tables fo...
Hi, I'd like to test IF variable a is equal to something AND variable b is either equal to value 1 OR value 2.I've set up the IF condition similar to below, but can't seem to get the IF condition to evaluate true when variable b is equal to value 2. ...
Can someone share any resources other then the workato doc. for the test automation. Or if you can share test automation design references that would be helpful as well.
Hi,A service request on ServiceDesk Plus has fields such as status, priority etc. These are dropdown options, and possible options are customisable at ServiceDesk Plus configurations. The list of possible values can be fetched using a REST api call. ...
Our customers' input was instrumental in the updates made to several accelerators. Check out the changes below:Enterprise Data Hub V3.3.1Bug Fixes:Validation errors will be reported to the audit table in bulk in case of bulk upsert operation.String w...
Based on the feedback from the customers and pain points that we heard from the partners, we have released the below 2 new platform accelerators:Autonomous Operations Framework (AHQ): The Autonomous Operations Framework (AOF) Accelerator was built to...
Is there a way to use wildcards inside a search? I know I can use the .match? in a formula but not sure how to do it in this situationWhere the pricebook name in SFDC would be SP01 – List, or SP03 – Bobs Cable etcWhere in Epcior its just SP01 or SP03...
Hi,I have to schedule a recipe to run every 4 hours starting from 11 AM in Timezone America/New_York(-05:00).I am able to provide value to run every 4 hours but I am not able to provide starting time.Your suggestion would be greatful for me.Thanks
