question

KlausNrregaard-1904 avatar image
0 Votes"
KlausNrregaard-1904 asked ShaikMaheer-MSFT commented

Cant get hold of the array from a ForeEach activity

I get this error:

The expression 'length(activity('Copy Excel to Cache Sink').output.value)' cannot be evaluated because property 'value' doesn't exist, available properties are 'runStatus, effectiveIntegrationRuntime, billingReference, reportLineageToCatalog'.

I have a DataFlow. It output to activity

113411-b1.png
In my ForEach Activity in my Pipeline I try to do the following : @activity('Copy Excel to Cache Sink').output.value

BUT the error returns like this
113412-b2.png


azure-data-factory
b1.png (32.9 KiB)
b2.png (48.7 KiB)
· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Would suggest that your "Copy Excel" didn't have any data. Hover over the "Copy Excel to Cache Sink" in your Output window and click on the "Output" icon that appears, can you find your expected data within the output? If so, follow the path to where it resides

0 Votes 0 ·

Hi @KlausNrregaard-1904 ,

Could you please accept below provided answer. Accepting answer will help community too. Thank you.

0 Votes 0 ·

Hi @KlausNrregaard-1904 ,

Could you please accept below provided answer. Accepting answer will help community too. Thank you.
Please feel free to ask if any further queries. Thank you.

0 Votes 0 ·

1 Answer

VaibhavChaudhari avatar image
1 Vote"
VaibhavChaudhari answered ShaikMaheer-MSFT commented

If you are just trying to get excel data and feed it to ForEach activity, simply use Lookup activity in pipeline (instead of using Data flow)

Make sure you turn off "First row only" box


Please don't forget to Accept Answer and Up-vote if the response helped -- Vaibhav

· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi Vaibhav, Thanks for your response.

That was a great help...

Could you tell me whats wrong with my dynamic web request: https://maps.googleapis.com/maps/api/geocode/json?latlng='@item().Lat','@item().Long'&key=AIzasdOasdBbtc-AoBggduaMKasdV7av6Wow

(The key is not the correct key)

0 Votes 0 ·

Hi @KlausNrregaard-1904 ,

Could you please Accept Answer. Accepting answer helps community too. Thank you.

Regarding follow-up query, It seems your query string parameter "latlng" is not valid according to API. Kindly check with API owners to know correct parameter name and use the same. Thank you.

0 Votes 0 ·