Error trying to copy Lookup activity value to an array variable

Question

Hello,

I am new to ADF and might have missed something simple here. I am trying to use a lookup activity to query data from an Oracle DB and passing the output of this activity to a set variable activity and a for-each activity. In both cases the input is @activity('LookupComponents').output.value

However when i debug, the set variable and for-each activity fail with the below error:

The expression 'length(activity('LookupComponents').output.value)' cannot be evaluated because property 'value' doesn't exist, available properties are 'firstRow, effectiveIntegrationRuntime, billingReference, durationInQueue'.

The lookup activity works fine and the output of it is:

{  
    "firstRow": {  
        "SEASON": 2020,  
        "BOOKING_NO": 100024,  
        "COMPONENT_NO": 500034,  
        "VERSION_NO": 9,  
        "TOTAL_GROSS_AMT": 7163.5,  
        "TOTAL_COMM_AMT": 0,  
        "TOTAL_NET_AMT": 7163.5,  
        "PAYMENT_AMT": 5.5,  
        "BALANCE_AMT": 7158,  
        "BALANCE_DATE": "2020-05-31T00:00:00Z",  
        "EX_GRATIA_AMT": 0,  
        "CREATED_BY": "lleung",  
        "CREATED_DATE": "2020-04-20T15:31:43Z",  
        "DISCOUNT_DATE": null,  
        "DISCOUNT_AMT": 0,  
        "COMPONENT_STATUS": "I",  
        "CREATION_CODE": null,  
        "TERMINATION_CODE": "T3"  
    },  
    "effectiveIntegrationRuntime": "SelfHostedOracle",  
    "billingReference": {  
        "activityType": "PipelineActivity",  
        "billableDuration": [  
            {  
                "meterType": "SelfhostedIR",  
                "duration": 0.016666666666666666,  
                "unit": "Hours"  
            }  
        ]  
    },  
    "durationInQueue": {  
        "integrationRuntimeQueue": 2  
    }  
}  

This is my pipeline:

And the outputs of the debug:

Could someone please guide me as to what i am doing incorrectly here? Thanks in advance.

Answer 1

I forgot to uncheck the "First row only" in the lookup activity and that resolved the issue.