leonardoamorim
New Contributor
Joined 5 years ago
User Profile
User Widgets
Contributions
Scheduled Task End DateTime
Hi, I have a pipeline that is supposed to run on a daily basis and I’m struggling in writing the logic for a timeframe. Basically, I have a API picking up data from Workday and we have two parameters (“to” and “from”) as following: The problem is when I was reading the documentation, it says the the task.end result is an arbitrary date far in the future if I initiate the Task in designer. What I want to do is: First run this pipeline with the ‘to’ date being today and ‘from’ date being yesterday (so, -1 day From this, schedule the task to run daily and now instead of passing the ‘from’ date of -1 day I want it to get the end time of the first execution. Example: I run today manually at 31/05/2022 at 18:00pm The task ends at 31/05/2022 at 18:30pm Create the schedule task to run day to day, so starting at 01/06/2022 to run FROM 18:30 (task end of point 2) TO todays date (01/06/2022 18:00pm) Can someone help me with this? Thank you so much! 🙂2.9KViews0likes2CommentsREST Get Pagination
Hi everybody, I’ve been thinking about a solution to my problem the past few weeks and still couldn’t find a proper solution. The problem is: I have an REST Output which gives me the following. The total of outputs I have for ONE day and the data with a limit of 100. It doesn’t have the offset or number of pages in the output. I want to fetch all the data for a day (in this case, 10811) so I created a MAPPER with the following values before asking for the REST GET with PAGINATION Then, I do a REST GET with the following values for: from to type limit (always a 100) The problem is when I try to do the pagination that does not work. For the HasNext field: $entity.data.length > 1 (this is always true until it reaches the last offset value and it returns me an array with 0 data) For the NextUrl fiel i have : “URL” + + “?from=” + $from + “&to=”+ $to + “&type=”+ $type + “&limit=”+ $limit + “&offset=” + (snap.out.totalCount+100).toString() I need to increment the OFFSET in the REST GET by 100 every iteration, with a LIMIT of 100 outputs every time, until I have all the TOTAL outputs (in this case, 10811). I don’t know what I am doing wrong, but i’m getting an error: “error”:“not found: unable to find valid operation for: null”,“code”:“S21”}" Can someone help me? Thanks =)5KViews0likes4Comments