Share via

Expression error inside Foreach

Prapul Kumar Dongari 116 Reputation points
2023-11-16T06:20:06.74+00:00

Hi team i'm copying the sharepoint files using odata.id for this im reading file inside folder using web activity and passing output to foreach activity inside forach iam using @item().odata.id expression it is getting error

User's image

error message: The expression 'item().odata.id' cannot be evaluated because property 'odata' doesn't exist, available properties are 'odata.type, odata.id, odata.editLink, CheckInComment, CheckOutType, ContentTag, CustomizedPageStatus, ETag, Exists, ExistsAllowThrowForPolicyFailures, IrmEnabled, Length, Level, LinkingUri, LinkingUrl, MajorVersion, MinorVersion, Name, ServerRelativeUrl, TimeCreated, TimeLastModified, Title, UIVersion, UIVersionLabel, UniqueId'

please give me solution

Azure Data Lake Storage
Azure Data Lake Storage

An Azure service that provides an enterprise-wide hyper-scale repository for big data analytic workloads and is integrated with Azure Blob Storage.

Azure Synapse Analytics
Azure Synapse Analytics

An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.

Azure Data Factory
Azure Data Factory

An Azure service for ingesting, preparing, and transforming data at scale.

0 comments No comments

Answer accepted by question author

Amira Bedhiafi 42,936 Reputation points MVP Volunteer Moderator
2023-11-16T09:57:06.2133333+00:00

When you're using @item().odata.id, it seems that the property odata.id is not directly accessible in the way you're trying to reference it. The error message you received provides a list of available properties, and it includes odata.id, which is the one you're interested in.

Try the following :

{
    "variableName": "param",
    "value": "@item()['odata.id']"
}

Was this answer helpful?

2 people found this answer helpful.
0 comments No comments

0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.