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.
1,500 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.
5,045 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,983 questions
0 comments No comments
{count} votes

Accepted answer
  1. Amira Bedhiafi 27,051 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

Your answer

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