Forum Discussion
I have a GET API call as source but table is limited to 200 rows - data is 216 rows
Resolver IIMost public APIs limit the amount of data returned per request. I don't know what API you're making your requests to, but most likely you'll need to paginate through multiple pages to bring back all 216 rows. I'm fond of using the `List.Generate()` Power Query function for API pagination.
Can you provide the Power Query M script you're using to make this request to the API? Also, can you provide the URL to the API documentation?
It is, been struggling with scripts to try and get this to work. New to this, but this is script now
let
Source = Web.Contents("https://api.mavenlink.com/api/v1/time_entries?from_archived_workspaces=true&per_page=5000" & "from_archived_workspaces=true", [Headers=[Authorization="bearer keyishere12345"]]),
convertToJson = Json.Document(Source),
time_entries = convertToJson[time_entries],
#"Converted to Table" = Record.ToTable(time_entries),
#"Expanded Value" = Table.ExpandRecordColumn(#"Converted to Table", "Value", {"created_at", "updated_at", "date_performed", "time_in_minutes", "billable", "notes", "rate_in_cents", "cost_rate_in_cents", "currency", "currency_symbol", "currency_base_unit", "user_can_edit", "approved", "taxable", "is_invoiced", "story_id", "workspace_id", "user_id", "active_submission_id", "id"}, {"Value.created_at", "Value.updated_at", "Value.date_performed", "Value.time_in_minutes", "Value.billable", "Value.notes", "Value.rate_in_cents", "Value.cost_rate_in_cents", "Value.currency", "Value.currency_symbol", "Value.currency_base_unit", "Value.user_can_edit", "Value.approved", "Value.taxable", "Value.is_invoiced", "Value.story_id", "Value.workspace_id", "Value.user_id", "Value.active_submission_id", "Value.id"})
in
#"Expanded Value"GET of all time entries
