Statement Results

When reading Statement Result Summary data, the downloadStatement parameter returns Statement Results binary data in the _data property in base64 encoded format. In addition, the _fileName property contains the file name for the Statement Result binary data. When you do not use the DownloadStatement parameter in a Statement Result Summary request, the response contains the _downloadUrl property that you can use to download the Statement.

Use the $filter parameter to filter returned data Items in a manner similar to the Alliant User Applications column filter. This parameter uses the following format: {filterBy} {operator} {value}

• filterBy is the name of a property, the name of a Reference property specified as referenceProperty.property, or the name of Reference property for quality or inequality comparisons to null.

• operator – specify one of the following operators:

  Operator	Description	filterBy datatype
  contains	Contains	String/Text
  endswith	Ends with	String/Text
  startswith	Starts with	String/Text
  eq	Equals	String/Text, Integer, Small Integer, Flag/Boolean, Reference property eq null
  ne	Does not equal	String/Text, Integer, Small Integer, Flag/Boolean, Reference property ne null
  le	Less than or equal to	String/Text, Integer, Small Integer, Flag/Boolean, DateTime
  lt	Less than	String/Text, Integer, Small Integer, Flag/Boolean, DateTime
  ge	Greater than or equal to	String/Text, Integer, Small Integer, Flag/Boolean, DateTime
  gt	Greater than	String/Text, Integer, Small Integer, Flag/Boolean, DateTime

• value is the value to which the operator is applied. The value should be enclosed in single quotes unless the value is an Integer or Small Integer

You can use the and and or operators to combine multiple filter parameter criteria.

Use the $orderby parameter to specify the sort order of the returned data Items. You can specify a property or a property of a Reference property followed by asc or desc to sort returned data Items by a property in ascending or descending order.

Note: When this parameter is not specified, the returned data Items are sorted by Display Name in ascending order.

Use the $top parameter to specify the maximum number of Items to return. When you do not specify this parameter, 20 Items are returned by default. When you specify the verbose parameter, the maximum number of Items that you can request 100. When you specify the minimal or default parameters, the maximum number of Items that you can request 1000. This query parameter combined with $skip query parameter can be used to facilitate paging.

Use the $skip parameter to specify the number of Items to skip from the first result. This query parameter combined with the $top query parameter can be used to facilitate paging. For example, $skip=20&$top=20 returns the second page of 20 Items.

When you specify this Verbosity parameter, the _timestamp, _type, displayName, and guid properties are returned.

Use this Verbosity parameter option when you want Alliant API to return a response that includes all properties for the Item, including UD Fields. This is the default option that is used when no Verbosity parameter is provided.

Use this Verbosity parameter option when you want Alliant API to return UD Field Lookups, Adjustments on Tab, Child Collection, and Cross-Reference properties in addition to the properties from the default Verbosity level.

Note: Using this parameter may affect performance and should only be used when necessary.

Use this Verbosity parameter to specify the properties to include in the response, separated by commas. You can also specify that you want to include Statement Fields and Section Looping Fields in the response.

Note: When the values specified in the include parameter are not valid, the query parameter is ignored and a warning is added to warnings property of the Standard Response.

Use this Verbosity parameter to specify the properties to exclude from the response, separated by commas. You can also specify that you want to exclude Statement Fields and Section Looping Fields from the response.

Note: When the values specified in the exclude parameter are not valid, the query parameter is ignored and a warning is added to warnings property of the Standard Response.

Use this parameter to specify the properties with context replaced values in the response, separated by commas. You can also specify that you want to context replace values for all properties by specifying all.

Note: When the values specified in the contextReplace parameter are not valid, the query parameter is ignored.

When reading Statement Result Summary data, the downloadStatement parameter returns Statement Results binary data in the _data property in base64 encoded format. In addition, the _fileName property contains the file name for the Statement Result binary data. When you do not use the DownloadStatement parameter in a Statement Result Summary request, the response contains the _downloadUrl property that you can use to download the Statement.

When you specify this Verbosity parameter, the _timestamp, _type, displayName, and guid properties are returned.

Use this Verbosity parameter option when you want Alliant API to return a response that includes all properties for the Item, including UD Fields. This is the default option that is used when no Verbosity parameter is provided.

Use this Verbosity parameter option when you want Alliant API to return UD Field Lookups, Adjustments on Tab, Child Collection, and Cross-Reference properties in addition to the properties from the default Verbosity level.

Note: Using this parameter may affect performance and should only be used when necessary.

Use this Verbosity parameter to specify the properties to include in the response, separated by commas. You can also specify that you want to include Statement Fields and Section Looping Fields in the response.

Note: When the values specified in the include parameter are not valid, the query parameter is ignored and a warning is added to warnings property of the Standard Response.

Use this Verbosity parameter to specify the properties to exclude from the response, separated by commas. You can also specify that you want to exclude Statement Fields and Section Looping Fields from the response.

Note: When the values specified in the exclude parameter are not valid, the query parameter is ignored and a warning is added to warnings property of the Standard Response.

Use this parameter to specify the properties with context replaced values in the response, separated by commas. You can also specify that you want to context replace values for all properties by specifying all.

Note: When the values specified in the contextReplace parameter are not valid, the query parameter is ignored.

When you specify this parameter, warning validation messages are returned.