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...
Hi,I need to create a nested json based on a SQL query.Sample dataset:Transportorder TO_param1 TO_param2 Ordernumber Order_param1 Order_param2 Orderitem Orderitem_param1OR-444450xyCO-12345xyCO-12345-1xOR-444450xyCO-12345xyCO-12345-2xOR-444450xyCO-123...
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!
