Automic Workload Automation

Hi

I have an external JSON object. For example;
{ "firstname":"John", "lastname":"Carter", "age":30 }
Is there a possibilities to use this in a JOB or SCRIPT.

:SET &JSON_OBJECT#={ "firstname":"John", "lastname":"Carter", "age":30 }
:SET &FIRST# = GET_JSON_VAR(&JSON_OBJECT#,"firstname")
:SET &LAST# = GET_JSON_VAR(&JSON_OBJECT#,"lastname")
:SET &AGE# = GET_JSON_VAR(&JSON_OBJECT#,"age")

I know there isn't a function like GET_JSON_VAR
But is there another way to 'read' items within a JSON object

Thanks in advanced

Probably the simplest way would be to create a generic include "JSON reader" AE script that could have a JSON passed in, read (presumably by taking off the brackets and then splitting on commas), and then having variables generated based on the number of values read. 

It obviously matters how you want to use this data, but if you think this will be of constant use making a generic is a good idea. 

Out of the box there is no script function or similar for the JSON format.

As Michael suggested I am afraid too you should start createing a generic converter from scratch.

Another possibility that might work if you find a batch- usable converter tool and create a generic job for this task.

possibly this could help:
https://www.quora.com/Is-there-a-free-tool-I-can-use-to-convert-a-json-file-to-a-csv

Here's an example AE script to read in a value (in this example passed as a variable of the job itself):


(Apparently they changed how the Code block works, it reads in AE scripting weirdly and adds extra lines now, pasted as plaintext instead)

Given the format you provided, this should correctly parse your data, though in its current form the value name still contains quotations and the "age" is set as a String (though this can easily be converted to a number with a simple IS_NUMERIC check and then a CONVERT).  Bear in mind this example is fairly basic and may provide false positives if your data contains ', "'.

Result:

Hi,

Tnx for the comments (and sorry for the delayed reaction.)
But I think the example Michael is a good base to work this out for my situation.