topic Re: Json export not valid json in API / CLI Discussion

Json export not valid json

bhaizlett123 — Sun, 30 May 2021 18:08:59 GMT

Hello,

I just exported my whole rule base using sk120342 and I am now trying to write a python script to parse through rules json file, but for some reason it keeps erroring out saying its not a valid json file. I tried running this through a json validator and it keeps saying there are multiple root elements, so in order to fix that I just enclosed the entire thing into {json data} and that seemed to fix that issue. But now I am running into another issue which is this

json.decoder.JSONDecodeError: Expecting property name enclosed in double quotes:

does anyone know how to have that export utility export in a valid json format? Or is there a way to fix this issue so I can parse through this json file?

Any help is very much appreciated.

Re: Json export not valid json

PhoneBoy — Sun, 30 May 2021 20:03:49 GMT

To actually debug the issue, you’d have to provide the actual json file you got.
This might be better done as a TAC case.

The other option would be to query the API directly which should return the results in JSON format.
However, depending on the size/number of policy layers in the relevant policy package, this may require multiple calls.

Re: Json export not valid json

StuartGreen — Wed, 02 Jun 2021 09:23:11 GMT

A sample output would be really useful to help troubleshoot this (just make sure you've removed anything. It sounds familiar and I'm wondering if the output actually contains multiple JSON structures in a single file which is why the JSON validator tools are showing multiple roots.

Re: Json export not valid json

PhoneBoy — Wed, 02 Jun 2021 15:41:09 GMT

Given that it likely requires multiple API calls to generate said file, it wouldn’t surprise me if that file had…multiple JSON structures in it.

Re: Json export not valid json

WilltChambering — Tue, 19 Dec 2023 22:06:43 GMT

Can confirm, as of 2023: the JSON export is invalid insomuch, at the minimum, it is missing a root enclosing the subsequent JSON structures.

Re: Json export not valid json

StuartGreen — Wed, 20 Dec 2023 11:19:10 GMT

Have you tried running the JSON through a validator or through JQ? Having a root element as a list ( [] ) is valid JSON as far as I can tell (backed up here too https://www.json.org/json-en.html)