Expression error inside Foreach

Prapul Kumar Dongari 96 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.
1,200 questions
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.
3,826 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
8,523 questions
0 comments No comments
{count} votes

Accepted answer
  1. Amira Bedhiafi 8,716 Reputation points
    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']"
    }
    
    
    2 people found this answer helpful.
    0 comments No comments

0 additional answers

Sort by: Most helpful