FROMJSON to DataSet

[wjblack]

How can I turn the json array into a child dataset verses a SET?

Code: Select all

x := '{"childNames": ["Sasha Obama","Malia Obama"]}';

PersonRec := RECORD
   DATASET({UNICODE name}) childNames {xpath('childNames')};
END;

line := FROMJSON(PersonRec,x);

line;


[Allan]

Hi wjblack,

Divide and conquer:

Code: Select all

x := '{"childNames": [{"FN" : "Sasha"},{"FN":"Malia"}]}';

PERSONRec := RECORD
   STRING FN{xpath('FN')};
END;

PeopleRec := RECORD
   DATASET(PERSONRec) childNames {xpath('childNames')};
END;

FROMJSON(PeopleRec,x);


Yours
Allan

[Allan]

In addition, I always find it worth my while to search the Forum on say 'JSON'.
There are other posts that might have helped.

Yours
Allan

[wjblack]

Thanks for your help. I always do start with a search of the forum.