REST Policy Data API - SQL Join Table Query

[erictse2]

I have a SQL for  policy store query

 

select
d.domainname AS domain
p.policyname AS POLICY
r.rulename AS rule,

from

smpolicylink4 pl,
smpolicy5 p,
smrules5 r,
smdomain5 d,

where
p.policyoid = pl.policyoid
AND pl.ruleoid = r.ruleoid
AND pl.domainoid = d.domainoid
AND d.domainname LIKE "search string"

 

 

If I am REST Policy Data API

How can I do that ???

What is the equivalent?

 

Can I us cuRL PHP to do this?

[SungHoon_Kim]

Any SM Gurus can help out erictse2 on this enquiry?

[Pashapour]

Yes just look at the rest api swagger interface. All calls are in curl. I would just do a call to get all SmDomains then do the search on the retuned json output.