The j5 REST API uses the conventions of the OpenAPI Specification (version 2.0) for parameters.
GET /restserver/25.0/industraform/logbook-query/{logbook}: Query a logbook table for data in associated IndustraForms
Produces: application/json text/csv
Parameters
Name |
In |
Description |
Type |
---|---|---|---|
logbook |
path |
The name of a logbook. e.g. general_logbook. |
string |
attribute_names |
query |
The list of IndustraForm element names to extract |
array of string (CSV) |
query_repeating |
query |
Set this to ‘true’ in order to query a repeating section in the matching forms. Multiple result rows may be returned for each matching form. This behaves in a similar way to an INNER JOIN SQL query, where there is a row for each repeat, and where elements that are outside of the repeating section are duplicated in to each row. |
boolean |
limit |
query |
Only include up to the specified maximum number of results. This defaults to 1000. Please consider doing multiple filtered queries, rather than making this limit higher, if possible. This can be done, for example, using from_date_time and to_date_time parameters. |
integer |
form_spec_name |
query |
Only include results with a particular form design (a fully-qualified Specification Name). If this parameter is not provided then forms for IndustraForm design will be included. You can query the ‘$Form.SpecificationName’ attribute to inspect the values that will be filtered. |
string |
area |
query |
Only include results that are associated with the specified area (including sub-areas). This parameter is a colon-separated string of area_hierarchy UUIDs (e.g. for a particular second level area location, and all of its children, the parameter may look like ‘3e880eb2-f50b-4c50-8c87-ab90672d4935:134c8eae-d616-49eb849e-e5ff113605cb’). You can query the ‘$Form.Area’ attribute to inspect the values that will be filtered. |
string |
from_date_time |
query |
Only include results on or after the specified date/time (inclusive). This filters on the logbook ‘primary_time_field’. Requires a date/time string as defined by RFC3339 - full-date. For example, "2017-0420T00:39:57Z", or "2017-05-19T16:39:57-08:00". You can query the ‘$Form.DateTime’ attribute to inspect the values that will be filtered. |
string |
to_date_time |
query |
Only include results before the specified date/time (exclusive). Like from_date_time, this uses the ‘primary_time_field’ and requires an RFC3339 full-date format. |
string |
default_element_attribute |
query |
Defines the default query attribute to request when IndustraForm element IDs are referenced in the attribute_names list without a specific dot-attribute. Must be one of Value, DisplayValue, IsDefined, IsValid, IsError or Error. |
string |
display_locale_name |
query |
Specify the locale to use for DisplayValue results. Use the two character language code and region code, for example ‘en-US’. If not specified, the current user’s locale is used. |
string |
display_timezone_name |
query |
Specify the timezone to use for DisplayValue date or date-time results. Use the Olson timezone name, for example ‘Asia/Tokyo’. If not specified, the current user’s timezone is used. |
string |
pretty |
query |
Pretty format returned JSON output |
boolean |