Forum Discussion

jshirley's avatar
jshirley
Frequent Visitor
3 years ago

Need help adjusting some code to equate for the limits set on by the website api I am using

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

3 Replies

  • jshirley's avatar
    jshirley
    Frequent Visitor

    ppm1 That solution doesn't work for me. I had to connect to my api via a blank querry which won't let me add a custom function in like he suggests. 

    • ppm1's avatar
      ppm1
      Icon for Solution Sage rankSolution Sage

      Not sure what you mean about your API needing a blank query. Why aren't you able to make a list of numbers and then concatenate that into a web call on each row?

       

      Pat