Skip to main content

Summary

Sum of Relevant Records

Written by Lenka Haringerová

If you need to retrieve basic summations for a given record type, use the summation:

/c/<identifikátor firmy>/<evidence>/$sum

It is also possible to combine filtering and summation:

/c/<identifikátor firmy>/<evidence>/(<filtr>)/$sum

Summations can be exported in the following formats:

  • XML: /c/<identifikátor firmy>/<evidence>/$sum.xml

  • JSON: /c/<identifikátor firmy>/<evidence>/$sum.json

Note:

Summations can only be performed on documents (invoices, orders, inquiries, cash movements, warehouse movements, …).

Summations can include advanced parameters (currently applicable only to account turnovers) that must be used with certain agendas.

Examples include:

  1. period: (rokMesic,2020-01-01,2020-12-31) – the time period to cover

  2. fields: obrDal,obrMd – which fields to summarize

  3. group-by: rokMesic, quarter(rokMesic) – how to group the results

The resulting URL might look like this, for example:

$sum.xml?period=(rokMesic,2020-01-01,2020-12-31)&fields=obrDal,obrMd&group-by=rokMesic

Did this answer your question?