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

Forum Posts

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
  • 1328 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
  • 758 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
  • 773 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
  • 4066 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
  • 1314 Views
  • 2 replies
  • 3 kudos

Resolved! SFDc Lost connection

I've been working on a recipe in sandbox/pilot between Epicor and SFDC.When i first started my API account in SFDC was missing some permissions so i just switched to my account in sandbox while I worked on it. now that I am getting ready to migrate, ...

johnw by Executive Chef I
  • 1975 Views
  • 2 replies
  • 0 kudos