Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I've been pulling my hair out all day trying to work this out. I've been using the Trading212 API to pull info from a demo account, but when trying to pull whole order history I'm facing an issue due to pagination.
I've had it working with varying degrees of success - but every time I get close, something seems to go wrong.
I'm currently working with the below Power Query code, if anyone could help.
let
baseUrl = "https://demo.trading212.com",
relativePath = "/api/v0/equity/history/orders?limit=4",
url = baseUrl & relativePath,
headers = [#"Authorization" = "000000000000000000"],
response = Web.Contents(
url,
[Headers = headers]
),
jsonResponse = Json.Document(response),
#"Converted to Table" = Record.ToTable(jsonResponse)
in
#"Converted to Table"
the output of that looks like the below.
I need to expand the list, and merge the nextPagePath with the baseUrl to get the next page of results.
If anyone could nudge me in the right direction, that would be great.
thank you
NameValue
items [List]
nextPagePath /api/v0/equity/history/orders?cursor=1728059206000&limit=4&instrumentCode
Please follow the documentation. Use RelativePath and Query parameters. https://learn.microsoft.com/en-us/powerquery-m/web-contents#example-1
Here is a ready-made convenience function: Handling paging for Power Query connectors - Power Query | Microsoft Learn
User | Count |
---|---|
7 | |
5 | |
5 | |
5 | |
4 |
User | Count |
---|---|
11 | |
11 | |
9 | |
7 | |
6 |