GET api/BusinessIntelligence/GetJournalOrderData?from={from}&to={to}

Get journal order data that was created between from and to, including both active and archived orders.

Request Information

URI Parameters

Name	Description	Type	Additional Information
from	Filter data from this date (inclusive), must be before or equal to .	date	Required
to	Filter data to this date (inclusive), must be after or equal to .	date	Required

Body Parameters

None.

Response Information

Resource Description

Collection of OrderStatisticsDataDto

Name	Description	Type	Additional Information
OrderId	The id of the order.	integer	None.
Law	The name of the law for this order.	string	None.
ValidFrom	Information about from when the order is valid.	date	None.
ValidTo	Information about to when the order is valid. A null value means no end date (still valid).	date	None.
Archived	Information about when the order was archived. A null value means that the order is not archived.	date	None.
ChangedDate	Information about when the order was changed the last time.	date	None.
CreatedDate	Information about when the order was created.	date	None.
GroupId	Which group (id) this order is connected to.	integer	None.
ClientId	Internal id of the client. Can be used to count or group data when the PNR is missing.	integer	None.
ClientPnr	Client personal number	string	None.
ClientPnrGender	Client gender according to the personal number	character	None.
ClientBirthDate	Client birth date	date	None.

Response Formats

application/json, text/json

Sample:

[
  {
    "OrderId": 1,
    "Law": "sample string 2",
    "ValidFrom": "2025-11-04T13:01:07.8757511+01:00",
    "ValidTo": "2025-11-04T13:01:07.8757511+01:00",
    "Archived": "2025-11-04T13:01:07.8757511+01:00",
    "ChangedDate": "2025-11-04T13:01:07.8757511+01:00",
    "CreatedDate": "2025-11-04T13:01:07.8757511+01:00",
    "GroupId": 4,
    "ClientId": 5,
    "ClientPnr": "sample string 6",
    "ClientPnrGender": "A",
    "ClientBirthDate": "2025-11-04T13:01:07.8757511+01:00"
  },
  {
    "OrderId": 1,
    "Law": "sample string 2",
    "ValidFrom": "2025-11-04T13:01:07.8757511+01:00",
    "ValidTo": "2025-11-04T13:01:07.8757511+01:00",
    "Archived": "2025-11-04T13:01:07.8757511+01:00",
    "ChangedDate": "2025-11-04T13:01:07.8757511+01:00",
    "CreatedDate": "2025-11-04T13:01:07.8757511+01:00",
    "GroupId": 4,
    "ClientId": 5,
    "ClientPnr": "sample string 6",
    "ClientPnrGender": "A",
    "ClientBirthDate": "2025-11-04T13:01:07.8757511+01:00"
  }
]

application/xml, text/xml

Sample:

<ArrayOfOrderStatisticsDataDto xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
  <OrderStatisticsDataDto>
    <OrderId>1</OrderId>
    <Law>sample string 2</Law>
    <ValidFrom>2025-11-04T13:01:07.8757511+01:00</ValidFrom>
    <ValidTo>2025-11-04T13:01:07.8757511+01:00</ValidTo>
    <Archived>2025-11-04T13:01:07.8757511+01:00</Archived>
    <ChangedDate>2025-11-04T13:01:07.8757511+01:00</ChangedDate>
    <CreatedDate>2025-11-04T13:01:07.8757511+01:00</CreatedDate>
    <GroupId>4</GroupId>
    <ClientId>5</ClientId>
    <ClientPnr>sample string 6</ClientPnr>
    <ClientPnrGender>65</ClientPnrGender>
    <ClientBirthDate>2025-11-04T13:01:07.8757511+01:00</ClientBirthDate>
  </OrderStatisticsDataDto>
  <OrderStatisticsDataDto>
    <OrderId>1</OrderId>
    <Law>sample string 2</Law>
    <ValidFrom>2025-11-04T13:01:07.8757511+01:00</ValidFrom>
    <ValidTo>2025-11-04T13:01:07.8757511+01:00</ValidTo>
    <Archived>2025-11-04T13:01:07.8757511+01:00</Archived>
    <ChangedDate>2025-11-04T13:01:07.8757511+01:00</ChangedDate>
    <CreatedDate>2025-11-04T13:01:07.8757511+01:00</CreatedDate>
    <GroupId>4</GroupId>
    <ClientId>5</ClientId>
    <ClientPnr>sample string 6</ClientPnr>
    <ClientPnrGender>65</ClientPnrGender>
    <ClientBirthDate>2025-11-04T13:01:07.8757511+01:00</ClientBirthDate>
  </OrderStatisticsDataDto>
</ArrayOfOrderStatisticsDataDto>