Forum Discussion
Get data using REST API Ringover - POST method
Hello PhilipTreacy
Finaly my colleague Data Architect found the solution.
The LasIdReturned in GetPage row 24 "LastIdReturned = try List.Last(Json[#"call_list"])[cdr_id] otherwise 0," was in conflict with all the "LastIdReturned" before.
So he have rename all the "LastIdReturned before" by "LastId" and now it's works very well.
Thank to yo again for youur time.
BR
Julien
Hi PhilipTreacy
For example if I set the StartDate parameter to "2020-10-27", the query will generate a number of lists, precisely 42 which is normal because each list contains 100 records (rows) and I know the database has generated 4200 rows since that date (42 * 100).
But in reality I have the same unique list 42 times, so when I remove the duplicate I only have 100 rows (my first list).
I didn't find how to share a photo or screenshot, so, I hope I was clear.
Thanks again for your time.
Hello PhilipTreacy
Finaly my colleague Data Architect found the solution.
The LasIdReturned in GetPage row 24 "LastIdReturned = try List.Last(Json[#"call_list"])[cdr_id] otherwise 0," was in conflict with all the "LastIdReturned" before.
So he have rename all the "LastIdReturned before" by "LastId" and now it's works very well.
Thank to yo again for youur time.
BR
Julien
Hi Julien,
I've been trying to do the same thing as you. Not really a pro with PowerQuery.
Tried your solution but all I receive is duplicated entities. If I choose 100 entities per page, it fetch 100 entities and then duplicates them.
I tried the solution you published afterward but it changes nothing, maybe I didn't understand you. Can you copy&paste the new code or something?
My aim is to gather all the calls from Ringover from a selected startdate and then update new data everyday acumulatively.
I hope I can still reach you!
best regards!
Arturo
