topic Re: Json Network Feed in Firewall and Security Management

Json Network Feed

AndreasSalv — Thu, 27 Feb 2025 16:19:20 GMT

Try to create a Network Feed parsing a JSON. Unfortunately Test Feed in SmartConsole always exit with error message:

"Object name contains special characters or whitespaces. Invalid character: 'space'"

Feed URL: https://www.gstatic.com/ipranges/goog.json

JSON Query: jq -r '.prefixes[].ipv4Prefix'

also tried with JSON Query: jq -r '.prefixes[] | select(.ipv4Prefix) | .ipv4Prefix'

Using the JQ Playground jq playground both of my queries work.

What's wrong with my input in JSON Query field?

Thx for support

Re: Json Network Feed

PhoneBoy — Fri, 28 Feb 2025 16:28:11 GMT

The JSON Query does not include jq -r, only the expression.

Re: Json Network Feed

the_rock — Fri, 28 Feb 2025 20:31:06 GMT

Phoneboy is right, I tested in the lab and it worked how he described it.

Andy

Re: Json Network Feed

AndreasSalv — Mon, 03 Mar 2025 08:53:36 GMT

Thanks for your answers - I also tried without the "jq" command but get same error message.

Can you post a screenshot of the "New Network Feed" window?

I assume I struggle with the quotation marks. I tried several ways but without success!

Re: Json Network Feed

the_rock — Mon, 03 Mar 2025 12:45:12 GMT

Hey @AndreasSalv

Please give me some time and I will test. I cant recall how I did it the other day, but will figure it out.

Andy

Re: Json Network Feed

the_rock — Mon, 03 Mar 2025 13:16:43 GMT

Below is 100% right, but now says no data found, so must be something wrong with the feed itself.

Andy

".prefixes[] | select(.ipv4Prefix) | .ipv4Prefix"

Re: Json Network Feed

AndreasSalv — Fri, 07 Mar 2025 08:11:25 GMT

Sorry fo the delay .... tested directly on cli and there I get data:

[Expert@nfw110:1]# curl_cli -k https://www.gstatic.com/ipranges/goog.json | jq -r ".prefixes[] | select(.ipv4Prefix) | .ipv4Prefix"

Tested on SmartConsole again:

Result:

and tested this way:

and got:

so difference is used fw appliance:

curl_cli uses vs1 on nfw110 (this is also the finally used one), SmartConsole uses nfw500 which is not the one I really want but I can't choose a VSX based fw...

Re: Json Network Feed

the_rock — Fri, 07 Mar 2025 13:35:39 GMT

Did you do it like I tried?

".prefixes[] | select(.ipv4Prefix) | .ipv4Prefix"

Andy

Re: Json Network Feed

AndreasSalv — Mon, 10 Mar 2025 07:43:23 GMT

Yes also tried without the -r Option of JQ

Re: Json Network Feed

marclopes — Thu, 08 May 2025 20:02:58 GMT

Hi, here it worked typing withou quotation marks

Re: Json Network Feed

the_rock — Thu, 08 May 2025 22:31:33 GMT

Good! Just tested it, works as well.

Andy