Hi,We have a Parse EDI task, of which the output we put in a list.For a specific field, we need to pluck a value, based on a qualifier in an object.The list "MOA loop" contains multiple "MOA" objects, each with an object "MonetaryAmount", which in it...
I have an API that returns me certain items with corresponding dates.They come in this format : 2024-06-12T13:00:00.000+02:00When I turn them into a SQL collection, all is well.However I get an issue when I query the SQL collection, as it suddenly re...
Hi,I have a view in SQL that shows a schedule (production order) with its startdate and update date (the update date does not always mean that the production order has started, just that something has been updated).What I want to do is find a schedul...
I have an API which i call on a schedule, and it returns me all status updates since the last poll.Due to API limits etc... I do this on a 15 minute interval.However, if the item gets updated more than once within this interval, I get the same item r...
In my python snippet I have the following output schema defined, which is a nested list: the output of my python script (when just doing return output) also is in the same format But for the life of my I cannot figure out how to map the array I creat...
My query selects all schedules that have a DTSStart filled in, so I already filter out the NULL values in my query.The DTSStart date is the sort column I use.The first few times the recipe was triggered based on all items in the query that have a sta...
It worked.I tried the sql collection yesterday, but the output was weird.After querying it was OK though. i did a select * from bookings AS T0 WHERE index = (select max(index) from bookings where transport_number = T0.transport_number)i added an inde...
Thanks, I will be trying this!The only possible issue I'm seeing is that in my response there is a nested list, which I now flatten using .pluck('value')[0] and 1 and 2But this is a good starting point, I'm trying it tomorrow!
