How make a List record from an JSON Array using ardoJSON ?

How make a List record from an JSON Array using ardoJSON ?

  

Hi, I am using ardoJSON module and it works fine for several use cases.

I am using a cv-json standard structure and I am using JSON_Select ... with Path works fine.

Also based on data I can generate correct JSON structured data using ToObject.

I am storing the entire JSON structure in one field in a Resume entity.

In the Resume detail view I would like to list the skills.

The sample provided JSON has sections with array of name values but populated with only one object.

I modified it to contain two entries below.

I am using a JSON_Select(jsondata,"") for the entire object.

There is a skills area in the JSON.

If I use JSON_Select(jsondata, "skills")

[{"name":"Web Development","level":"Master","keywords":["HTML","CSS","Javascript"]},{"name":"Integration Development","level":"Master","keywords":["XML","API","SOA"]}]

This is two Skills and I would like to convert it to a Lest record for showing in a list.


I have generated a lot of structures from the JSON.

I have tried using the entire CVRecord.Skills .... and also the "inner" skillsitem entity to get a structure for the elements. 


But how do I convert it to a list to view it in the Resume detail page and its List records element?







Providing a sample json

{
  "basics": {
    "name": "John Doe",
    "label": "Programmer",
    "picture": "",
    "email": "john@gmail.com",
    "phone": "(912) 555-4321",
    "website": "http://johndoe.com",
    "summary": "A summary of John Doe...",
    "location": {
      "address": "2712 Broadway St",
      "postalCode": "CA 94115",
      "city": "San Francisco",
      "countryCode": "US",
      "region": "California"
    },
    "profiles": [{
      "network": "Twitter",
      "username": "john",
      "url": "http://twitter.com/john"
    }]
  },
  "work": [{
    "company": "Company",
    "position": "President",
    "website": "http://company.com",
    "startDate": "2013-01-01",
    "endDate": "2014-01-01",
    "summary": "Description...",
    "highlights": [
      "Started the company"
    ]
  }],
  "volunteer": [{
    "organization": "Organization",
    "position": "Volunteer",
    "website": "http://organization.com/",
    "startDate": "2012-01-01",
    "endDate": "2013-01-01",
    "summary": "Description...",
    "highlights": [
      "Awarded 'Volunteer of the Month'"
    ]
  }],
  "education": [{
    "institution": "University",
    "area": "Software Development",
    "studyType": "Bachelor",
    "startDate": "2011-01-01",
    "endDate": "2013-01-01",
    "gpa": "4.0",
    "courses": [
      "DB1101 - Basic SQL"
    ]
  }],
  "awards": [{
    "title": "Award",
    "date": "2014-11-01",
    "awarder": "Company",
    "summary": "There is no spoon."
  }],
  "publications": [{
    "name": "Publication",
    "publisher": "Company",
    "releaseDate": "2014-10-01",
    "website": "http://publication.com",
    "summary": "Description..."
  }],
  "skills": [{
    "name": "Web Development",
    "level": "Master",
    "keywords": [
      "HTML",
      "CSS",
      "Javascript"
    ]
  },
  {
    "name": "Integration Development",
    "level": "Master",
    "keywords": [
      "SOA",
      "API",
      "WSDL"
    ]
  }],
  "languages": [{
    "name": "English",
    "level": "Native speaker"
  }],
  "interests": [{
    "name": "Wildlife",
    "keywords": [
      "Ferrets",
      "Unicorns"
    ]
  }],
  "references": [{
    "name": "Jane Doe",
    "reference": "Reference..."
  }]
}

Solution

Now it works fine !


I added a

JSON2RecordList
JSON = JSONSelect(GetResumeById.List.Current.Resume.jsondata,"skills")
RecordList = ToObject(ResumeObject.Skills)

Added ResumeObject.Skills as source record to the list 

and

Now it list:


Web Development
Integration Development



Solution