Web Reports Custom vs Query Problems

Does anyone know why this will work as a custom report but when I strip it out and try to use it as a query (curl and web) it just gives me “Requested resource does not exist.”

  <?relevance
        concatenations of (html "<tr><td>" & item 0 of it & html "</td><td>" & item 1 of it & html "</td></tr>") of (
            name of it, 
            concatenation ", " of unique values of (
                last 4 of (year of it as string) & "/" & (month of it as two digits)
            ) of (
                source release date of it | date "01 Jan 1970"
            ) of relevant fixlets whose (
                name of site of it contains "Patches for RHEL 9" and 
                category of it does not contain "Support" and 
                fixlet flag of it
            ) of it
        ) of bes computers whose (operating system of it as lowercase starts with "red hat enterprise linux 9")
        ?>

I tried encoding as well :frowning:

curl -k -u "OBFUSCATED:OBFUSCATED" "https://bigfix-.local:52311/api/query?relevance=concatenations%20of%20(item%200%20of%20it%20%26%20item%201%20of%20it)%20of%20(name%20of%20it,%20concatenation%20%22,%20%22%20of%20unique%20values%20of%20(last%204%20of%20(year%20of%20it%20as%20string)%20%26%20%22/%22%20%26%20(month%20of%20it%20as%20two%20digits))%20of%20(source%20release%20date%20of%20it%20%7C%20date%20%2201%20Jan%201970%22)%20of%20relevant%20fixlets%20whose%20(name%20of%20site%20of%20it%20contains%20%22Patches%20for%20RHEL%208%22%20and%20category%20of%20it%20does%20not%20contain%20%22Support%22%20and%20fixlet%20flag%20of%20it)%20of%20it)%20of%20bes%20computers%20whose%20(operating%20system%20of%20it%20as%20lowercase%20starts%20with%20%22red%20hat%20enterprise%20linux%208%22)"

Requested resource does not exist.

concatenations of (item 0 of it & " | " & item 1 of it) of (name of it, concatenation ", " of unique values of (last 4 of (year of it as string) & "/" & (month of it as two digits)) of (source release date of it | date "01 Jan 1970") of relevant fixlets whose (name of site of it contains "Patches for RHEL 9" and category of it does not contain "Support" and fixlet flag of it) of it) of bes computers

Its the / throwing it off. I saw the same error then replaced the / to %2F and it worked.

concatenations%20of%20(item%200%20of%20it%20%26%20item%201%20of%20it)%20of%20(name%20of%20it,%20concatenation%20%22,%20%22%20of%20unique%20values%20of%20(last%204%20of%20(year%20of%20it%20as%20string)%20%26%20%22%2f%22%20%26%20(month%20of%20it%20as%20two%20digits))%20of%20(source%20release%20date%20of%20it%20%7C%20date%20%2201%20Jan%201970%22)%20of%20relevant%20fixlets%20whose%20(name%20of%20site%20of%20it%20contains%20%22Patches%20for%20RHEL%208%22%20and%20category%20of%20it%20does%20not%20contain%20%22Support%22%20and%20fixlet%20flag%20of%20it)%20of%20it)%20of%20bes%20computers%20whose%20(operating%20system%20of%20it%20as%20lowercase%20starts%20with%20%22red%20hat%20enterprise%20linux%208%22)

1 Like

Well spotted! I have spent way too many hours debugging that today and getting no where :smiley:

Thanks so much Rob!

1 Like

That said - when I run it now - all I get is hostnames, no patching data :frowning:

It’s one of these days :frowning:

All working now :slight_smile: thanks again Rob