Luckily I have autonomy to choose a database (AWS RDS based) - which connector has most wide connection+action capabilities (particularly for bulk ops) I am inclined towards Aurora (so choice betwee...
(Chunk large amounts of data (including files) to make it easier to perform downstream operations. For example: breaking a batch of 5000 records into chunks of 500 to prevent an API timeout.) I trie...
i have created a custom action in the SF connector to read a salesforce report the report data is contained in an array called datacells inside an array called rows i have put the response body vie...
I have an Epicor BAQ report I use in Workato that gives me a list of all SKUs in an order and their shipping information 99.9% of the time all the SKUs in an order will be on the same pricebook but ...
Just curious why there seem to be a continual stream of spam messages in the community. I can understand if one users's computer was compromised and a bot send out posts on the community under ...
I am sending an HTTP POST request, getting the response body as datapills and passing them in future actions in the same recipe. When testing that the datapills actually contain data using Logger, n...
Hello Everyone, I was wondering if anyone has ever attempted to pass variables from a recipe into a PowerShell script. What I'm trying to accomplish is sending an email address that is gathered as t...
Is there way to add entry to lookup table only if doesn't already exist (based on a specific column value?) Came across a recipe which seems to be inefficient - it's looking a search for the v...
Hi All, I am trying to insert rows in the Oracle table and was unable to see the input column names 1.I haven't selected the table from the drop down list instead I have passed the Table Na...
I have a BAQ report in Epcior which will list all the records of a Sales order and in certain conditions will create a SFDC opportunity and set to closed won etc. this works fine but today OM had a ...