Creating an API filter query based on Workflow JSON input

Identity Security Cloud (ISC) ISC Discussion and Questions
, ,
1

Hi,

I am using the JSON input payload for an externally triggered SailPoint workflow:

{
    "input":
        {
        "name" : "ISC-DB-SB-Test",
         "contextArray": [
              { "key": "Country", "value": ["DE", "BG"] },
              { "key": "Store", "value": ["5"] }
             ]
	}
}

I would like to use Microsoft Graph API call to filter groups and form the following filter query:

startswith(displayName,'{{ $.trigger.input.name }}') and extension_c92077a3afa34e6186e3fcbe2fd6cbc4_ContextValues/any(s:s eq 'Country:[DE,BG]') and extension_c92077a3afa34e6186e3fcbe2fd6cbc4_ContextValues/any(s:s eq 'Store:[5]')

Any ideas on how can the json input parameter be used to construct the filter query will be great !

2

This may help you to look filter:

3

What you are proposing at least for the source seems like it should work according to the workflow external input documentation.

Are you asking if it’s possible to also extract the values Country:[DE,BG] and Store:[5] dynamically? Or will those values be static?

4

Thank you @mcheek for the response.
I am asking if the values can be extracted dynamically and used to construct a string query within the workflow.

5

Hi @HussainshaSyed001 , thank you for the response, I already looked into the docs, and am looking for a concrete example.