LINQ Reporting Engine - Access JSON by name index

Aspose.Words Product Family
,
1

I have a JSON file that looks something like this:

{
    "Parent":{
        "123":{
            "Name": "Paul"
        }
    }
}

I would normally would use "<<[Parent.123.Name]>>" which is fine, but how can I access 123 using a variable/ other elements in the JSON. Exampe `"<<[Parent[ChildId].Name]>>

3

@pphillipsbiz

To access members which names do not conform C# restrictions imposed on class/member names, double quotes should be used for escaping as shown in the following snippet:

JsonDataSource dataSource = ...

DocumentBuilder builder = new DocumentBuilder();
builder.Write("<<[Parent.\"123\".Name]>>");

ReportingEngine engine = new ReportingEngine();
engine.BuildReport(builder.Document, dataSource, "Parent");

To clarify, when creating a template manually rather than by code, its syntax should be as follows:

<<[Parent."123".Name]>>
4

Thanks.
I have a variable called ProductCode (stored in JSON), I want to reference this variable within the linq statement like Parent.[ProductCode].FieldValue. [ProductCode] = Json Element.

5

@pphillipsbiz

Could you please share the complete JSON file, so we could better understand the scenario?

6

Thank you, I have found a workaround to the problem.