Import json recommendation needed

Support
1

I need a recommendation on how to import this json file https://airc.nist.gov/docs/playbook.json

Can I use SMS2 or shall I develop a python ETL pipeline?

I don't see how to iterate over multiple json entities in SMS2 example at Importing JSON and CSV Files | Stardog Documentation Latest

Regards,
Radu

2

For a JSON file with an array as the top-level, outermost nesting, starting with a [, you would create a mapping that starts with an array:

FROM JSON {
  [
    {
        "type":"?type",
        "title":"?title",
        "category":"?category",
        ...
  ]
}
TO {
....

-Paul

3

Thanks @PaulJackson . That makes sense.

I am on Stardog free cloud version. Will I be able to have access to terminal to execute the SMS2 commands? Or is there any other non-terminal way to import json data?

Thanks,
Radu