Systematic Community

RESAM · Tuesday

New or updated group in Microsoft Entra ID

the trigger JSON output provides data on member@delta which I want to use in a next step, but the data is not visible in the datapill.

cheers, Jacques

rajeshjanapati · Tuesday

steps to follow:

1. first switch to formula mode of Document Filed

2. Map the step output pill, as shown in below image attached.

hope you got my point now??

View solution in original post

rajeshjanapati · Tuesday

Hi @RESAM ,

For that you need to do PARSE JSON by providing copy raw json data from step-1 output in sample document and in Document need to pass step-1 output pill.json (like below shown in image) then you can access each pill from Microsoft Entra ID.

RESAM · Tuesday

hi @rajeshjanapati , thanks for the reply

I will check it out right now!

cheers

RESAM · Tuesday

hi @rajeshjanapati

I found the action in app "JSON tools by Workato", but was unable to set the required sample document, do you have an example maybe?

rajeshjanapati · Tuesday

Hi @RESAM,

click on Copy raw JSON and paste it in the sample document box and in document map the step-1 output pill as i mentioned above image, in the logger if you check, you can access the data pills of each field, hope you got my point?