API Forum

This forum is in read-only mode.
Please refer to our API support in case you have any questions.
We can be reached at api@e-conomic.com
e-conomic API developer forum

Get total for account, for period

0
I'm using the API to pull data form e-conomic into an Excel sheet.
One row for each account number, one column for each month.
I currently use the ".GetEntriesByDate" function to get all entries for a date, the iterate these in order to get the total for the period.

This however can take quite a bit of time to get through, more that half an hour getting a full years data.

My question is this: Is there an other function I can use, to get the total for a given account number, for a given time period?

- So that I can avoid iterating all entries for the period, and hopefully save time.
created Feb 26, 2014 by Cstahnke
0% Accept Rate
Q 4 A 0 C 7

1 Answer

0
Hi,

AccountUtil.GetEntryTotalsByDate should be helpful here:

http://e-conomic.github.io/eco-api-sdk-ref-docs/Documentation/M_Economic_Api_IAccountUtil_GetEntryTotalsByDate.html

You supply an array of accounts, plus a date interval - and it'll return entry totals for that date interval for the specified accounts.

This method is VERY fast - plus, it'll reduce your number of round-trips to as many as the number of periods you need.

 

BR,
answered Mar 2, 2014 by Christian Estrup
Could you please supply an example of this?
I keep getting errors.
Have done this:
 Dim MyEconomicAccountutilInterface As Economic.Api.IAccountUtil
 Dim accounts() = MyEconomicSession.Account.GetAll()
 Dim AllePeriodebalancer = MyEconomicAccountutilInterface.GetEntryTotalsByDate(accounts, StartDate, SlutDate)
What error - perhaps even stack trace - are you getting?
I was doing it all wrong, and have it figured out now.
The correct call is:
Dim accounts() = MyEconomicSession.Account.GetAll()   
Dim AllePeriodebalancer = MyEconomicSession.Account.GetEntryTotalsByDate(Accounts, StartDate, SlutDate)
OK - glad you were able to get it to work :-)
Visma e-conomic A/S
...