Hi, I have a power query that is extracting the data using the rest API.
My requirement is to run the query first to extract all the records using the below query:
let
Pagination = List.Skip(List.Generate( () => [WebCall=[result = {0}], Page = 0, Counter=0], // Start Value
each List.Count([WebCall][result])>0 or [Counter] =0, // Condition under which the next execution will happen
[Query=[sysparm_offset =Text.From([Counter])]])),
Page = [Page]+1,
Counter = [Counter]+1000// internal counter
]
) ,1),
this will extract all the records from the table. Now I want to run the same query but only want to extract records updated in the last 7 days. What changes I need to make in the query so it should check if there are already records in the table(power query) and
1.if not it will extract the entire dataset
2. if there are records in the table then it should only extract the updated dataset. Something like this
https://<host>/api/now/table/incident?sysparm_query=sys_created_onONToday%40javascript%3Ags.beginningOfToday()%40javascript%3Ags.endOfToday()%5EORsys_updated_onBETWEENjavascript%3Ags.beginningOfToday()%40javascript%3Ags.beginningOfLast7Days()
