How to monitor the status of large API queries with the Accounting.BI real-time Log

May 23, 2023

Before you start this process:

  • Access the Accounting.BI Platform: Start by accessing the Accounting.BI platform. This involves typically logging in to your account or signing up if you're a new user.

This will allow you to locate the API Log interface and be able to view the log activity in real-time.

You can also watch the video (below) - it gives a deeper insight into the process:

To monitor the status of large API queries with the Accounting.BI real-time API Log, you can follow these step-by-step details:

  1. After accessing your Accounting.BI platform and navigating to the API Log, you can start making API queries/calls.

When you make small queries and click "Refresh Now," you receive a successful response instantly or within seconds.

  • However when making large API queries say a seven-month duration, the request becomes reasonably large. As a result, the loading page at the bottom initiates the loading process.

  • Navigate to the API Log Interface: Once you've accessed the API Log interface, you will be able to view the log activity in real-time.

When you start making more API queries, the log will display a list of API queries along with their status, timestamps, and any relevant error messages. You can observe the progress of each query and identify any issues that require attention at any time.

In our case, we currently have two queries, the smaller query's status is successful while the larger query is still in progress.

  • Identify large API queries: Since we specifically mentioned monitoring large API queries, you will need to identify them within the log. You identify them by looking at their status they have longer processing times and involve larger datasets
  • You can go ahead and call other API queries, press refresh now and monitor their status on the API log interface

  • Monitor query status: Keep an eye on the status of your large API queries in the log. The status can indicate whether a query is running, completed successfully, or encountered an error. By monitoring the status, you can track the progress of your large queries and promptly address any issues that arise.

By following these steps, you can effectively monitor the status of large API queries using the Accounting.BI real-time API Log. It allows you to stay informed about the progress of your queries, address any issues that arise, and ensure the smooth execution of your data analysis and reporting tasks.

Have questions or need further assistance? Contact us for personalised support.

learn more

Why is PowerBI important for Accountants?

As an accountant, you may find yourself referring to multiple sources to track the performance of your client’s cash flow, profitability, business trends and even bookkeeping cycle. What if you could access those results and comparisons automatically refreshed, on-demand, from your tablet, smartphone, PC, or even wearable device? Business intelligence and data visualisation systems can provide accountants with – the critical data and organisation summary in a custom format in one (or more) visuals or a dashboard. One of these powerful business intelligence tools is PowerBI.
READ MORE

Power BI: What is DAX?

DAX (Data Analysis Expressions) is a formula expression language developed by Microsoft to interact with data in different analysis services and visualisation tools platforms like Power BI, PowerPivot and SSAS tabular models. DAX can seem familiar to competent excel users as the language uses similar formulas and expressions.
READ MORE

How to connect your Xero account(s) to AccountingBi

This guide will walk you through two methods for connecting your Xero accounting software to AccountingBi
READ MORE

How to call your profit and loss account reports from Xero to AccountingBi

We have outlined a step-by-step process of calling your profit and loss report data from your Xero account to AccountingBi - article and video.
READ MORE

How to call the balance sheet reports from Xero to AccountingBi

We have outlined the steps of calling balance sheet reports from Xero to AccountingBi in a video (watch below) and an article.
READ MORE

How to connect Microsoft excel to Xero through AccountingBi

This video and article provide steps for connecting Xero to PowerBi through AccountingBi. It assumes that you've already pulled the Xero API from accounting BI for your various reports.
READ MORE
1 2 3 5
READ MORE
Accounting.bi - Business Intelligence Software
Copyright © 2023 Accounting.bi is a brand owned and operated by Accounting SQL Limited, incorporated in the United Kingdom. ​
Terms & Conditions - GDPR