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 ...
I am reading 1 text field from a SQL Server select rows and want to send them in an email. Currently, it puts all the records on one line, but I want each record on a new line. Any suggestions ? I tried to force a "New line" break, but no luck.See Sc...
Hi, When writing records to SQL, I see an option to insert a "Batch of Rows", but I don't see that "batch" option in Airtable, so I am guessing I have to write 1 row at a time somehow ? Probably just 10 - 20 records when it runs.Any suggestions?
Hi, is there a way to replace characters using a wildcard with a blank ?There are always 6 zeroes, and random 3 digits and a period before the 6 zeroes2023-10-09 17:38:36.243000000 More text here ...
Hi, In my recipe, I am selecting 2 columns from a SQL table, and want to put the results in the body of an email. I get results, but they look like this:{"rows"=>[{"datetimeoftxn_b5896cc8"=>"2023-10-09 13:59:23.797000000", "listoutput_0ec6e5e5"=>"Te...
AirTable has a restriction on how many INSERTS can occur in a time-frame. So I decided to insert 1 at a time in a loop, and include a WAIT delay to insert slowly.
Thanks. I think the output is correct when I do this:But after the next step to send the emailI get this error.Also, It looks like I can "trick" it into making a 2 dimensional array by PLUCKing a blank instead of a 2nd field, but it puts a comma off ...
