Microsoft AD Spoke - Look up Objects by Filter issue

[EricG2]

OK, I've been able to use the "Lookup Objects by Filter" action and pull the Contact object from AD.

This unfortunately doesn't return the AD Attributes like the Look up User action does.

All I have available is:

When i Test this Action, I'm able to get data in the response.

[{"DistinguishedName":"CN=User Name,OU=conpany1,OU=_GALsyncContacts,OU=xxx,DC=xxx,DC=Global","Name":"username","ObjectClass":"contact","PropertyNames":"DistinguishedName Name ObjectClass ObjectGUID","AddedProperties":"","RemovedProperties":"","ModifiedProperties":"","PropertyCount":4,"ObjectGUID":"6d1a4925-443c-4955-b1ad-bfdc88565301"}]

Anyone know how to the the DistinguishedName or other attributes out so they can be put into other places.

I've tried using the FX utilities and nothing seems to work. (tried Get Item from Array, Get item from Name/Values)

[EricG2 · Accepted solution]

Well, with a little work and searching on YouTube Videos, I finally figured out how to get the data out of the ObjectClass body.   I ended up creating a Custom Json Parser action.  Wow that was easy.  Now to see if it actually works.

Thanks to @Goran WitchDoc and his video on Episode 34 - Rest Step & JSON Parser in ServiceNow IntegrationHub.

I removed the reset step and viola - i have my data bullets to use in my integration hub.

Thanks