Hello all,
I still new to PowerBi and I am trying to figure out how to apply an offset to my code that will allow my query to pull all the records instead just what the limit is.
Here is my code:
= (offset) =>
let
limit = 500,
Source = Json.Document(
Web.Contents("https://www.leaflink.com/api/v2/orders-received/?limit=500",
[
RelativePath="tables/orders-received?top=500&skip="
& Number.ToText(offset*limit) & "&select=number,short_id,external_id_seller,external_id_buyer,ext_acct_id,created_on,user,buyer,seller,customer,brand,status,manual,discount,discount_type,tax_amount,tax_type,final_tax,shipping_charge,total,payment_term,payment_methods,selected_payment_option,payment_due_date,paid,paid_date,ship_date,shipping_details,notes,internal_notes,delivery_preferences,sales_reps,classification,payment_balance,available_transitions,modified,has_special_requests,delivery_provider,order_taxes,delivery_info,is_combination,llf_payment_method,credits,facility_id,order_number,order_seller_number,order_buyer_number,order_short_number,distributor,external_ids,corporate_address,delivery_address",
Headers=[Authorization= "App API_KEY"]]))
in
Source
