nfOpenJson to create Cursor 1

[Sng1]

I have my json as

}]]

I want to create a cursor with fields as ->
I don't know what to write path expression for BOOK array for getting all records in a cursor.

For simple Json like

]

I write it as

 

[mplaza]

If you have nested arrays, you'll need a 2 step process.

nfOpenJson is good at flatten object structures, and I made it as an early "sql server syntax compatibilty" exercise.
But as I state in the provided samples, I realized it's much better to just simply create the desired cursors beforehand
and populate using a simple loop.

Anyway let's make it 1st flattening the objects using nfOpenJson, and then the desired way:

TEXT TO books noshow
[{
  "Library": "Books",
  "Shelf": 5,
  "version": "LIB3.1.2",
  "hash": "hash",
  "Book": [
    {
      "Name": "Ths Blooms",
      "Category": "Fiction"
    },
    {
      "Name": "Legends",
      "Category": "Drama"
    }
  ]
},
{
  "Library": "Books",
  "Shelf": 6,
  "version": "LIB3.1.3",
  "hash": "hash",
  "Book": [
    {
      "Name": "Those Blooms 2",
      "Category": "Another Fiction"
    },
    {
      "Name": "Legends 2",
      "Category": "Drama 2"
    }
  ]
}
]
ENDTEXT


* just for illustration purposes how to flatten objects using nfOpenJson

nfOpenJson( m.books,'$.array',';
- Library c(15) $.Library;
- Shelf n(6) $.Shelf;
- version1 c(10) $.version ;
- Book1Name c(40) $.Book(1).name;
- Book1category c(40) $.Book(1).Category;
- Book2Name c(40) $.Book(2).Name;
- Book2Category c(10) $.book(2).category;
')


Browse

* desired way:


Create Cursor Library ( Library c(15), shelf N(6), Version c(10), hash c(10), Name c(20), category c(20))

jLibrary = nfJsonRead(m.books)

For Each oLibrary In jLibrary.Array

	For Each book In oLibrary.book

		Append Blank
		Gather Name oLibrary
		Gather Name book

	Endfor

Endfor

Browse

Marco Plaza
@nfoxProject

https://www.github.com/nftools

 

[Sng1]

Thanks a lot Marco. You help is greatly appreciated and nfjson tool is also awesome.

 

[mplaza]

Thanks. Though I just realized it had an error.

I edited the original post to this ( please check ):

Create Cursor Library ( Library c(15), shelf N(6), Version c(10), hash c(10), Name c(20), category c(20))

jLibrary = nfJsonRead(m.books)

For Each oLibrary In jLibrary.Array

	For Each book In oLibrary.book
		Append Blank
		Gather Name oLibrary
		Gather Name book
	Endfor

Endfor

Browse

Marco Plaza
@nfoxProject

https://www.github.com/nftools

 

[MaryParks]

Thanks for sharing this information with us.

 

[MaryAdams]

It looks good to me.

.