Поиск по этому блогу

среда, 10 июля 2019 г.

Pentaho BI Server and timestamp(datepicker) field in report

I was fighting with this problem entire week(with switching to different projects/tasks) and I didn't find solutions in internet/docs.

The Problem

  1. Report created in Pentaho Report Designer
  2. Parameters - timestamp fields(date picker view)
  3. Use API for downloading reports


API call(using curl)

 curl "https://pentaho.server.internal.org/pentaho/api/repos/blablabla/prpt.report?date_from=2019-07-08T00:00:00.000-0700&date_till=2019-07-08T00:59:59.999-0700&output-target=table/csv;page-mode=stream" -o output.csv


So correct format is: 2019-07-08T00:00:00.000-0700. May be this information will help to save some time to the person who finds this article.

Комментариев нет:

Отправить комментарий