JsonToArray
JSON (JavaScript object notation) is a syntax for storing and exchanging data. Since the JSON format is text only, it can easily be sent to and from a server and used as a data format by any programming language. The JsonToArray() function converts a block of JSON formatted data to an array.
Syntax
JsonToArray(JsonInput, JsonMapping)
| JsonInput | The filepath/URL of the JSON data to be converted. |
| JsonMapping | The filepath of the TEXT file that contains the logic of how the array will be constructed. |
Examples
JSON Input:
{“employees”:[
{“name”:”Shyam”, “email”:”shyamjaiswal@gmail.com”},
{“name”:”Bob”, “email”:”bob32@gmail.com”},
{“name”:”Jai”, “email”:”jai87@gmail.com”}
]}