In an array can be referred to using its zero-based position in the array Values can be referred to using JavaScript-like square bracket index operators. Outermost JSON value, which must be an object or an array, is always referred Selecting a value from the tree will populate the parameter with the appropriate query string to turn the selected values into features.Ī JSON query is a mechanism to refer to values inside JSON text. This parameter can be typed directly in the text box or, if reading JSON from a file or URL, by clicking the browse button that opens a dialog containing the structure of the JSON dataset in a tree form.
Referring to the JSON values which will become new FME features. The JSON Query parameter is the JSON query The size property, which can only be applied to an array, returns the number of elements in the array.Ī string literal expression is simply a quoted string value, such as "this is a string literal expression". For example, if the outermost JSON element is an array, and the first element of the array is a string, then the expression json.type would have a value of string. The type property returns the type of the JSON value referred to by the JSON structure expression. Currently, the only supported properties are type and size. For example, if the outermost JSON element is an array, then the expression json refers to every element in the array.Ī property expression is a structure expression as described above, followed by a. In order to refer to all of the values in an array or object, a wildcard index * can be used. For example, it the outermost JSON element is an object with a key and "address" whose value is an object containing keys "city" and "province", then these values can be referred to by the expressions json and json. Likewise, if the outermost JSON element is an object, with keys "name" and "address", then the values of these keys can be referred to by the expressions json and json respectively. For example, if the outermost element is an array, the first element of the array can be referred to by the expression json, the second element can be referred to by the expression json, and so on. The child elements can be referred to using JavaScript-like square bracket index operators. The outermost JSON element, which must be an array or an object, is always referred to by the term json, and this term must appear at the beginning of every JSON structure expression. There are three types of expressions: JSON structure expressions, JSON property expressions and string literal expressions.Ī JSON structure expression can refer to values in a JSON document. A query is made up of one or more expressions, which are separated by a + operator. Extracts portions of JSON (JavaScript Object Notation) formatted textĪ JSON query is a simple mechanism to refer to values within a JSON document.
0 kommentar(er)
