NameByNumber (Json function)

Get name of item in JSON object (Json class)

[Introduced in Model 204 7.6]

This function prints the name of a Jsob object item (property) based on the item number.

Syntax

%unicode = json:NameByNumber( number) Throws InvalidJsonType

Syntax terms

%unicode	The name of the specified item number in the object.
Json	Json object whose underlying object must be an object. If a null or other underlying type is used, an InvalidJsonType exception is thrown.
number	The item number whose name is to be returned.

Usage notes

• The item number must be between 1 and the number of items (inclusive) in the array or object (Count). An invalid item number results in request cancellation.
• For objects, the actual items can be retrieved by number using the ItemByNumber function.

Examples

The following example populates an object where each item is an array and then displays the name and value of each of the object items using NameByNumber and ItemByNumber:

b %json is object json %i is float %json = object %json('Packers') = array(1967, 1968, 1997, 2011) %json('Steelers') = array(1975, 1976, 1979, 1980, 2006, 2009) %json('Cowboys') = array(1972, 1978, 1993, 1994, 1996, 2009) %json('49ers') = array(1982, 1985, 1989, 1990, 1995) %json('Patriots') = array(2002, 2004, 2005, 2015) for %i from 1 to %json:count printText {%json:nameByNumber(%i)}: {%json:itemByNumber(%i)} end for end

This prints:

Packers: [1967,1968,1997,2011] Steelers: [1975,1976,1979,1980,2006,2009] Cowboys: [1972,1978,1993,1994,1996,2009] 49ers: [1982,1985,1989,1990,1995] Patriots: [2002,2004,2005,2015]

See also

Json class	List of Json methods	Json methods syntax
Notation conventions for methods