Community Chat
cancel
Showing results for 
Search instead for 
Did you mean: 

Forum Posts

Epicor Object condition with multiple values

Hi Community,For a while Im designing recipe and have a quick question. With epicor connector, once i want to filter a table with multiple values , It does not bring any result. My values ABC,DEF, GHI. Once I put these values in condition section wit...

AC by Deputy Chef I
  • 3537 Views
  • 4 replies
  • 0 kudos

Filtering a search to 10 customers

I have a recipe where I am pulling invoices from the past 2 years. I want to add a condition where it will only pull records for 10 customers. I have not been very successful in setting up a formula using customer ID's. I have attached a copy of the ...

recipeImage.png
Nesh by Deputy Chef II
  • 2667 Views
  • 3 replies
  • 1 kudos

Unable to gain access to account

We are unable to gain access to our Workato account. We have a workato automation connecting Paylocity to Unanet and neither the Finance Director or the HR Director are able to log in to Workato. When they try to reset their passwords they are inform...

lmessal by Deputy Chef I
  • 2656 Views
  • 1 replies
  • 1 kudos

How to Optimize Workato Tasks and Reduce Costs

Hello Community Members,As many of you are aware, Workato's billing model is based on the number of tasks we utilize. This can sometimes lead to unexpectedly high costs, especially if tasks are not optimized efficiently. To help our community better ...

SQL Collector - alias and UNION queries

Hi all, as I could successfully run SQL queries (using Collection App) concerning SELECT of joined tables (managed as lists), I struggle when I want to refer to other elements I've already created inside the query. For example I can't make it concate...

efiumano by Deputy Chef I
  • 1797 Views
  • 1 replies
  • 2 kudos

Daylight Saving Time Bug in Recipe Job Schedule

If a recipe is scheduled for 2:00 am, after spring DST time jumps forward to 3:00 am,  Workato reschedules the job for 3:00 am. This could be a problem if there are jobs scheduled  between 2 am - 3 am that are dependent on the first job running at 2 ...

dunncrew by Deputy Chef III
  • 1601 Views
  • 1 replies
  • 3 kudos

Resolved! create a list of invoices per customer

Hello,I have a recipe in which I am pulling a list of customers with outstanding invoices. I am able to pull a list of all customers using Lists by workato. I want to create a table/list of invoices for customers who have more than one outstanding in...

Nesh by Deputy Chef II
  • 7449 Views
  • 7 replies
  • 6 kudos

How to convert array of strings into multible data sources

Hi, I would believe my questions is pretty simple. But I just can't figure out how to do this. In my payload schema, I retrieve an array of strings. I call it mail_of_signers. So I have an array that contains a lot of email adresses.I want to add the...

MaxLaks by Deputy Chef I
  • 2536 Views
  • 2 replies
  • 3 kudos
Announcements

Have you heard about The New Automation Mindset? Click here to learn more.


Experience Survey
Help us build a space that truly works for you by taking this survey!

🆕 Highlights Hub 🆕
Connect, share insights, and stay updated with the latest spotlights here.

This month’s spotlight: Amazon S3 Connector
Introduction to Workato Data Orchestration