Looking to see if there’s any tool/parser out there that can format JSON output from API requests.
For instance, “/access-request-status?requested-for=1279xxxx”
Other than playing with jsonpath expressions, is there a way to view the output grouped by app and approval status (ie: show which app requests are in pending/executing state for the given identity)?
Hi @mario_rod,
They’re many online tools that can format, prettify, JSON like
: Best JSON Editor Online , vscode, postman.
but i don’t think if tool exist to manipulate json data, filter, manipulate etc…
One solution can be to programmaticaly retrieve thoses data, store in CSV files and then manipulate csv/excel file.
Hi @mario_rod,
You can refer to this API and use filter condition to just request based on some valid filter.
If the ask is just about JSON formatting, then you may use third-party tool.
Thanks
Hi @baoussounda
Yeah I’m familiar with some of those tools but haven’t found one where you can easily parse/format the json without having to use jsonpath expressions…
I think you want the command line utility called jq. I’ve used it to filter/parse JSON data.
This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.