Forum Discussion

timrodman's avatar
timrodman
Helper I
8 years ago
Solved

Quickbooks Online - Report function - urlFragment parameter

When using the Quickbooks Online data source in Power BI Desktop     There is a function called Report     When I try to use the Report function, it asks for a parameter called urlFragm...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    timrodman,

    Here are some samples of urlFragment parameter values that should work.

    /reports/AgedReceivableDetail?date_macro=All

    /reports/AgedReceivableDetail?report_date=2015-06-30&start_duedate=2015-01-01&end_duedate=2015-06-30&columns=due_date,cust_name

    /reports/CustomerSales?customer=1&start_date=2015-08-01&end_date=2015-09-30

    Reference:
    https://developer.intuit.com/docs/api/accounting/sales%20by%20customer

    Regards,
    Lydia

timrodman's avatar
timrodman
Helper I
8 years ago
Thanks Anonymous
Anonymous's avatar
Anonymous
Not applicable
8 years ago

timrodman,

Here are some samples of urlFragment parameter values that should work.

/reports/AgedReceivableDetail?date_macro=All

/reports/AgedReceivableDetail?report_date=2015-06-30&start_duedate=2015-01-01&end_duedate=2015-06-30&columns=due_date,cust_name

/reports/CustomerSales?customer=1&start_date=2015-08-01&end_date=2015-09-30

Reference:
https://developer.intuit.com/docs/api/accounting/sales%20by%20customer

Regards,
Lydia

  • mbuhary's avatar
    mbuhary
    Helper I
    7 years ago

    Lydia,

     

    Could you please provide what url fragments to use to retrieve reports of:

    - Profit and Loss; and

    - Balance Sheet 

    • ZSCPA's avatar
      ZSCPA
      New Member
      2 years ago

      Were you ever able to find an answer to this question? 

  • abatahir's avatar
    abatahir
    Helper I
    4 years ago

    /\I am not expert to use developer page of QB, is there any way get all list if URLs

  • timrodman's avatar
    timrodman
    Helper I
    8 years ago

    Thank you. That worked!

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      timrodman,

      Glad to hear the issue is solved. Could you please mark my reply as solution to close this thread?

      Regards,
      Lydia

      • tbarron2's avatar
        tbarron2
        Regular Visitor
        7 years ago

        I'm using this function and am having issues with credentials.  When I use Power BI Desktop, it asks for my Quickbooks Online credentials which then results in the scheduled refreshes to fail due to invalid credentials.   If I then validate the QBO credentials by signing in via Power BI Online, then Power BI desktop fails to authenticate when refreshing.   Any ideas on how to alleviate this?