Query repeating sections - j5 - 30 - Reference - Hexagon

IndustraForm designs can contain repeating sections. If you would like to retrieve information from a repeating section, you must:

1. Include attribute names for elements in the repeating section.

2. Send the query_repeating parameter with a value of true.

In this case, a separate result row is sent back for each repeat. 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.

In addition, $Form and $Participant attributes are duplicated in to each row.

curl -X GET "https://[j5 Server URL]/restserver/30/industraform/logbook-query/linked_industraforms_eg

?attribute_names=$Form.UUID,ResponsiblePerson.DisplayValue,TankName,TankLevel,TankOk

&query_repeating=true" -H "accept: text/csv" -H "authorization: Basic [Base 64 encoded username and password]"

$Form.UUID,ResponsiblePerson.DisplayValue,TankName,TankLevel,TankOk

92ce3535-47d5-4d59-b32d-fbb9ee0e64cf,John Smith,T242,75.0,true

92ce3535-47d5-4d59-b32d-fbb9ee0e64cf,John Smith,T223,70.0,true

29249776-6b93-4abc-9ecc-2af1b4e11999,James Roland,T242,78.0,false

29249776-6b93-4abc-9ecc-2af1b4e11999,James Roland,T223,77.0,true

29249776-6b93-4abc-9ecc-2af1b4e11999,James Roland,T236,45.0,NOT_APPLICABLE

The limit parameter is applied to the total number of rows, so this may mean that only some of the repeats for a form are included.