topic How to parse JSON output from R80 Management API with JQ? in API / CLI Discussion

topic How to parse JSON output from R80 Management API with JQ? in API / CLI Discussion https://community.checkpoint.com/t5/API-CLI-Discussion/How-to-parse-JSON-output-from-R80-Management-API-with-JQ/m-p/14093#M983 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #000000;">JQ is a lightweight and flexible command-line JSON processor. Y<SPAN>ou can use it to slice and filter and map and transform structured data returned by R80 API commands and tools.</SPAN></SPAN></P><P></P><P><SPAN style="color: #000000;"><SPAN>Here is a list of some useful examples from this community, showing JQ magic:</SPAN></SPAN></P><P></P><P><SPAN style="color: #000000;"><SPAN><A href="https://community.checkpoint.com/thread/1083">Parsing the output of "mgmt_cli"</A> </SPAN></SPAN></P><P><SPAN style="color: #000000;"><SPAN><A _jive_internal="true" href="https://community.checkpoint.com/thread/6317-finding-main-ip-of-any-managed-gateway">https://community.checkpoint.com/thread/6317-finding-main-ip-of-any-managed-gateway</A></SPAN></SPAN></P><P><SPAN style="color: #000000;"><SPAN><A href="https://community.checkpoint.com/docs/DOC-1361">CLI API Example json to CSV Export for later use in batch add API commands</A> </SPAN></SPAN></P><P><SPAN style="color: #000000;"><SPAN><A href="https://community.checkpoint.com/thread/5341">What is the easiest way to get the number of objects for a specific type, e.g. hosts</A> </SPAN></SPAN></P><P><SPAN style="color: #000000;"><SPAN><A _jive_internal="true" class="link-titled" href="https://community.checkpoint.com/thread/4961-run-script-output?commentID=5745#comment" title="https://community.checkpoint.com/message/5745-re-run-script-output?commentID=5745#comment-5745">https://community.checkpoint.com/message/5745-re-run-script-output?commentID=5745#comment-5745</A> </SPAN></SPAN></P><P><SPAN style="color: #000000;"><SPAN><A href="https://community.checkpoint.com/thread/4983">How to list all uids with specific comment in rulebase</A> </SPAN></SPAN></P><P><SPAN style="color: #000000;"><SPAN><A _jive_internal="true" class="link-titled" href="https://community.checkpoint.com/thread/5448-how-to-check-if-policy-is-changed-but-not-installed?commentID=7630#comment" title="https://community.checkpoint.com/message/7630-re-how-to-check-if-policy-is-changed-but-not-installed?commentID=7630#comment-7630">https://community.checkpoint.com/message/7630-re-how-to-check-if-policy-is-changed-but-not-installed?commentID=7630#comm…</A> </SPAN></SPAN></P><P></P><P><SPAN style="color: #000000;"><SPAN>Also, here is a complete manual for JQ - </SPAN></SPAN></P><P><SPAN style="color: #000000;"><SPAN><A href="https://stedolan.github.io/jq/manual/">JQ Manual</A></SPAN></SPAN></P><P><SPAN style="color: #000000;"></SPAN></P><P><SPAN style="color: #000000;"><SPAN>Enjoy!</SPAN></SPAN></P></BODY></HTML> Sun, 26 Nov 2017 08:56:11 GMT Robert_Decker 2017-11-26T08:56:11Z How to parse JSON output from R80 Management API with JQ? https://community.checkpoint.com/t5/API-CLI-Discussion/How-to-parse-JSON-output-from-R80-Management-API-with-JQ/m-p/14093#M983 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #000000;">JQ is a lightweight and flexible command-line JSON processor. Y<SPAN>ou can use it to slice and filter and map and transform structured data returned by R80 API commands and tools.</SPAN></SPAN></P><P></P><P><SPAN style="color: #000000;"><SPAN>Here is a list of some useful examples from this community, showing JQ magic:</SPAN></SPAN></P><P></P><P><SPAN style="color: #000000;"><SPAN><A href="https://community.checkpoint.com/thread/1083">Parsing the output of "mgmt_cli"</A> </SPAN></SPAN></P><P><SPAN style="color: #000000;"><SPAN><A _jive_internal="true" href="https://community.checkpoint.com/thread/6317-finding-main-ip-of-any-managed-gateway">https://community.checkpoint.com/thread/6317-finding-main-ip-of-any-managed-gateway</A></SPAN></SPAN></P><P><SPAN style="color: #000000;"><SPAN><A href="https://community.checkpoint.com/docs/DOC-1361">CLI API Example json to CSV Export for later use in batch add API commands</A> </SPAN></SPAN></P><P><SPAN style="color: #000000;"><SPAN><A href="https://community.checkpoint.com/thread/5341">What is the easiest way to get the number of objects for a specific type, e.g. hosts</A> </SPAN></SPAN></P><P><SPAN style="color: #000000;"><SPAN><A _jive_internal="true" class="link-titled" href="https://community.checkpoint.com/thread/4961-run-script-output?commentID=5745#comment" title="https://community.checkpoint.com/message/5745-re-run-script-output?commentID=5745#comment-5745">https://community.checkpoint.com/message/5745-re-run-script-output?commentID=5745#comment-5745</A> </SPAN></SPAN></P><P><SPAN style="color: #000000;"><SPAN><A href="https://community.checkpoint.com/thread/4983">How to list all uids with specific comment in rulebase</A> </SPAN></SPAN></P><P><SPAN style="color: #000000;"><SPAN><A _jive_internal="true" class="link-titled" href="https://community.checkpoint.com/thread/5448-how-to-check-if-policy-is-changed-but-not-installed?commentID=7630#comment" title="https://community.checkpoint.com/message/7630-re-how-to-check-if-policy-is-changed-but-not-installed?commentID=7630#comment-7630">https://community.checkpoint.com/message/7630-re-how-to-check-if-policy-is-changed-but-not-installed?commentID=7630#comm…</A> </SPAN></SPAN></P><P></P><P><SPAN style="color: #000000;"><SPAN>Also, here is a complete manual for JQ - </SPAN></SPAN></P><P><SPAN style="color: #000000;"><SPAN><A href="https://stedolan.github.io/jq/manual/">JQ Manual</A></SPAN></SPAN></P><P><SPAN style="color: #000000;"></SPAN></P><P><SPAN style="color: #000000;"><SPAN>Enjoy!</SPAN></SPAN></P></BODY></HTML> Sun, 26 Nov 2017 08:56:11 GMT https://community.checkpoint.com/t5/API-CLI-Discussion/How-to-parse-JSON-output-from-R80-Management-API-with-JQ/m-p/14093#M983 Robert_Decker 2017-11-26T08:56:11Z Re: How to parse JSON output from R80 Management API with JQ? https://community.checkpoint.com/t5/API-CLI-Discussion/How-to-parse-JSON-output-from-R80-Management-API-with-JQ/m-p/14094#M984 <HTML><HEAD></HEAD><BODY><P>Useful tool, thanks for sharing!</P></BODY></HTML> Sun, 26 Nov 2017 18:32:20 GMT https://community.checkpoint.com/t5/API-CLI-Discussion/How-to-parse-JSON-output-from-R80-Management-API-with-JQ/m-p/14094#M984 PhoneBoy 2017-11-26T18:32:20Z