Search in a array values from Script output

Question

Hello,

I have output from a script activity as below :

LookupBusinessDays:

output

{
    "resultSetCount": 1,
    "recordsAffected": 11,
    "resultSets": [
        {
            "rowCount": 11,
            "rows": [
                {
                    " OUTPUT_DAYS": "2023-07-10"
                },
                {
                    " OUTPUT_DAYS": "2023-07-11"
                },
                {
                    " OUTPUT_DAYS": "2023-07-12"
                },
                {
                    " OUTPUT_DAYS": "2023-07-13"
                },
                {
                    " OUTPUT_DAYS": "2023-07-14"
                },
                {
                    " OUTPUT_DAYS": "2023-07-17"
                },
                {
                    " OUTPUT_DAYS": "2023-07-18"
                },
                {
                    " OUTPUT_DAYS": "2023-07-19"
                },
                {
                    " OUTPUT_DAYS": "2023-07-20"
                },
                {
                    " OUTPUT_DAYS": "2023-07-21"
                },
                {
                    " OUTPUT_DAYS": "2023-07-24"
                }
            ]
        }
    ]
}

I have to check another variable value : PipelineDate ='2023-03-01' exists in above array or not.

I tried contains but it is not working.

Here is my simple pipeline: All I have to do is, check for the variable TriggerDate(output of Set PipelineTriggerDate : 2023-07-17) is within the output of Business days from theLookup activity.

• ConcatPipelineDate Output:

Code : @concat('"DATE":',variables('PipelineTriggerDate')) - However concat is adding additional forward slash as below.

• CheckPipelineDate output:

Code : @contains(activity('LkpBusinessDays').output.value,
concat('"DATE":',variables('PipelineTriggerDate')) )

Concat is adding a additional forward Slash. Or is there a better way to search the days from the array of values?

Answer 1

Hi Alekya Seemakurty, Sri ,

Welcome to Microsoft Q&A platform and thanks for raising your question here.

As per my understanding, you are trying to validate if the output of a variable is present in the list of items of array coming out of the script activity or not. Kindly let me know if my understanding is incorrect.

You need to convert the output of script activity into array instead of array of json i.e. :

{
                    " OUTPUT_DAYS": "2023-07-13"
                },
                {
                    " OUTPUT_DAYS": "2023-07-14"
                }

needs to be converted to ["2023-07-13","2023-07-14"]

Also, the set variable activityconcat pipeline dateis not needed if you try the following solution.

Please try the below approach and see if it helps:

• Create another variable say appendedvar with array datatype.

• After script activity, use a foreach activity and set the sequential option as true. Provide this expression in Items of Foreach:

@activity('Script1').output.resultSets[0].rows

• Inside foreach, use append variable activity , and provide this expression in value: @item().OUTPUT_DAYS
• Now, outside foreach , use the set variable activity to validate the presence of variable output in the appendedvariable array using this exp:

@contains(variables('appendvar'),variables('PipelineTriggerDate'))

Hope it helps. Kindly accept the answer if it's helpful. Thankyou

Answer 2

Did you try json function?

@contains(json(activity('LookupBusinessDays').output.resultsSets[0].rows), concat('{"OUTPUT_DAYS": "', variable('PipelineDate'), '"}'))